Skip to Content
0
Former Member
May 12, 2010 at 10:18 PM

How to read mutiple excel columns from clipboard and populate table control

49 Views

Hi All,

I have a requirement to populate two columns in table control from excel using clipboard. (Copy two columns from excel and then, click on a button on the screen and table control's two columns should be filled).

I am using FM CLPB_IMPORT to get clipboard values.

eg: I am getting clipboard values as val1#val2

val3#val4

where each row is a row in excel and # indicates the columns.

The problem here is that I am not able to split val1 and val2 using the SPLIT statement using # character.

Any ideas will be appreciated.

Regards,

Arun Mohan