Read Sheet from Excel

[Former Member]

Hi Experts,

Can I upload an Excel Sheet other than the first sheet into an internal table? Please do guide me as to how this can be achieved.

Regards

Abdullah..

[former_member188829]

use FM:ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Hi ismail,

in the sense u have three sheets for example in excel and u dont wanna

upload the first sheet...only the second one..jus try the following...

click on the second sheet..save it again(jus ctrl s) and close..

try opening it again..it opens as sheet2 which is ready for upload...

in the sense xcel when closed and saved as a second sheet open..however

wud process the contents of second sheet only...

hope this helps u a bit,

all the best,

regards,

sampath

• mark helpful answers

[Former Member]

If I use tab delimited file can I have a heading for the users to understand the columns.

Regards

[Former Member]

hi Abdullah,

sure, you can maintain the column headings in the upload file. But, in the program, immediately after the function module execution, you need to delete the first row from the resulting internal table.

delete itab index 1.

This will delete the row with junk information( the column headings will not be properly uploaded due to the differences in the field size).

Hope this helps,

Sajan Joseph.

[Former Member]

Hi Sajan,

I meant to have a heading in the tab delimited file before uploading. Is that possible?

Regards