Excel Upload with Hidden Column

[Former Member]

Hi Gurus-

Can you upload Excel file with hidden column and get the function to read values in hidden column? If yes, could you please guide me how?

I am using ALSM_EXCEL_TO_INTERNAL_TABLE

Any help will be highly appreciated.

Thanks in advance!

[Former Member]

Hi Gurus-

Can you upload Excel file with hidden column and get the function to read values in hidden column? If yes, could you please guide me how?

I am using ALSM_EXCEL_TO_INTERNAL_TABLE

Any help will be highly appreciated.

Thanks in advance!

[gerd_rother]

Hi,

I never managed to upload those columns with the SAP function which do excel upload.

I did that by using an OLE connection with the excel-visual basic objects and then upload the data via the clipboard (which is not so easy but quite quick).

Regards, Gerd Rother

[Former Member]

Hi Gerd-

Thanks for your reply. It was helpful. Could u please guide me how u implemented the OLE with visual basic and clipboard upload?

Some sample code would be nice!

Thank you again!

[gerd_rother]

Hi,

Have a look at program RSDEMO01 (available in the controls examples of the workbench). It demonstrates an OLE connection to Excel.

To know which excel objects, methods and properties to use it is a good idea to use the excel macro recorder - just do what you want your program to do and then translate the resulting VB code to ABAP OLE.

For the import of the clipboard data you can use CL_GUI_FRONTEND_SERVICES=>CLIPBOARD_IMPORT. In the result table, iirc, there is one line for each imported line and within the line the cell values are separated by tab. So there is some work left - it might be a good idea t import the data column by column.

It has been some time when I did this for a former client of me - so unfortunately I do not have the code any more.

Regards, Gerd Rother

[Former Member]

Thanks, Gerd! Appreciate it very much! I'm gonna give it a try.

Any other ways to do that guys?

Thanks in advance!