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


Darren
 

Hi Luuk,

I see. I will try this.
If it is not too much for you and you can spare a little time, can you provide a very simple XML for this on XPA 3.x?

Best Regards,
Darren


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
data3-data3-data3-data3                data3-data3-data3-data3

 

Best Regards,
Darren


 

A, very simple, 3-column way:

In this subtask 'Write' the three values can be written to any DataSource.


Darren
 

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
data3-data3-data3-data3                data3-data3-data3-data3

 

Best Regards,
Darren