Skip to Content
0
Former Member
Oct 20, 2011 at 12:50 PM

Copy to clipboard - export to excel

920 Views

Hello everybody,

I'm trying to export data to multiple sheets in excel. To do this I use FM 'CLPB_EXPORT' where I give table with single column wchich contains eg:

CellA1#CellB1#CellC1#...

And when I paste clipboard to excel I get data in separated columns. The problem is when table cointains strings with left zeroes, it means:

0000321#00000021334#....

Then when I paste clipboard to excel I get:

321 21334 ....

I need to have all strings, but this function module deletes left zeroes. Is there any solution for this problem?

Thanks for any answer.