1. Messages
  2. Copy - Paste From Spreadsheet Cells to Magic XPA program

Re: Copy - Paste From Spreadsheet Cells to Magic XPA program #ria #xpa

Steven Blank
 

Darren,

Regarding the copy part, use invoke OLE or dotNet to obtain a reference the Excel object model's Range object. The Range object returns the equivalent of a Magic Vector, so you would need to parse this, cell by cell, using VecGet functions and copy the data into a data table, then display the content of the data table in a table control.

HTH.

Steve Blank

On 4/26/2020 10:47 PM, Darren wrote:

Hello Everyone,

Is there any way that could possibly able to copy cells and directly paste them onto a XPA table populating the exact same way they look on the spreadsheet?
Example:

Excel Spreadsheet                                    XPA table
      column
r    data1-data1-data1-data1                data1-data1-data1-data1                  
o   data2-data2-data2-data2                data2-data2-data2-data2
w  data3-data3-data3-data3                data3-data3-data3-data3

 

Best Regards,
Darren
Join main@magicu-l.groups.io to automatically receive all group messages.