Function Module ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Hi all!

It is mandetory to provide rows and columns details to Function like start and end of each. Can it be flexible? any other function?

Because program will run automatically and it will pick up the data runtime. So columns and rows cannt be defined.

Please help.

Thanks in advance,

[Former Member]

ya u can use gui_download for download exel sheet.

[Former Member]

Hi prax,

1. U may give 1 to 999999 as the limit.

regards,

amit m.

[Former Member]

Try to use the function module GUI_UPLOAD. Your internal table and excel file have to be of the same structure to use this function module.

[Former Member]

Yes, it is mandatory to give start and end of columns & rows.

[former_member508729]

HI ,

YOu can use FM TEXT_CONVERT_XLS_TO_SAP.

regards

Ashutosh

PS: reward points if helpful

[jayanthi_jayaraman]

Hi,

give the end of row as 99999(some large no).

[Former Member]

How to go to second sheet of same excel file?

Thanks in advance.

[jayanthi_jayaraman]

Hi,

I think you need to OLE if you want to get data from multiple sheets.

Check these links.

http://www.sapgenie.com/abap/ole.htm

http://help.sap.com/saphelp_46c/helpdata/en/59/ae3f2e488f11d189490000e829fbbd/frameset.htm