topic Re: Read Sheet from Excel in Application Development and Automation Discussions

Read Sheet from Excel

Former Member — Mon, 12 Mar 2007 14:11:23 GMT

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..

Re: Read Sheet from Excel

former_member188829 — Mon, 12 Mar 2007 14:13:21 GMT

use FM:ALSM_EXCEL_TO_INTERNAL_TABLE

Re: Read Sheet from Excel

Former Member — Mon, 12 Mar 2007 14:15:41 GMT

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

Re: Read Sheet from Excel

Former Member — Mon, 12 Mar 2007 15:48:42 GMT

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

Regards

Re: Read Sheet from Excel

Former Member — Mon, 12 Mar 2007 15:56:00 GMT

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.

Re: Read Sheet from Excel

Former Member — Mon, 12 Mar 2007 16:01:12 GMT

Hi Sajan,

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

Regards