topic Re: Uploading Excel File having multiple tabs/sheets in Application Development and Automation Discussions

Uploading Excel File having multiple tabs/sheets

Former Member — Thu, 29 Jul 2010 07:36:27 GMT

Hi all,

I have a requirement of uploading an excel file into R/3. This excel will have multiple sheets/tabs.

Please let me know if this is feasible.

Regards

Sandeep

Re: Uploading Excel File having multiple tabs/sheets

Former Member — Thu, 29 Jul 2010 07:42:50 GMT

Hi Sandeep,

Check the blog below.[/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap]

Re: Uploading Excel File having multiple tabs/sheets

Former Member — Thu, 29 Jul 2010 08:25:44 GMT

Hello,

the FM ALSM_EXCEL_TO_INTERNAL_TABLE allows you to upload from excel to a internal table (only one sheet).

You can check the code and create a own function to do it.

Regards,

Pedro Santos