Excel to itab

[Former Member]

Hello, is there any FM that allowed to read data from several tabs in excel file? I use ALSM_EXCEL_TO_INTERNAL_TABLE but.... I've got excel file that has 3 tabs, and I cannot find FM that will "see" those other tabs in excel file. Is there such FM?

[Former Member]

Hello, is there any FM that allowed to read data from several tabs in excel file? I use ALSM_EXCEL_TO_INTERNAL_TABLE but.... I've got excel file that has 3 tabs, and I cannot find FM that will "see" those other tabs in excel file. Is there such FM?

[Former Member]

refer:

[Former Member]

Check this weblog.

[Former Member]

hi

u use TEXT_CONVERT_XLS_TO_SAP...This s Fm for Convert Excel to sap.

Regards:

Prabu

[Former Member]

Hi,

You can use the function module 'text_convert_xls_to_sap' .

About its functio please check the below link.

https://forums.sdn.sap.com/click.jspa?searchID=15520645&messageID=3504572

All the best..

Ram.

[Former Member]

Use TEXT_CONVERT_XLS_TO_SAP.