topic Re: upload sheet in Application Development and Automation Discussions

upload sheet

Former Member — Wed, 20 Sep 2006 17:14:04 GMT

I need to upload an excel sheet into a ztable,but I wanted to give heading in the excel sheet like material no,plant, sales org etc.

How can I avoid the heading row alone from being uploaded? please let me know.

Thanks in advance.

Rinky

RichHeilman — Wed, 20 Sep 2006 17:15:23 GMT

Upload all the data into internal table, then simply delete the first line of it.

delete itab index 1.

Regards,

Rich Heilman

Former Member — Wed, 20 Sep 2006 17:17:45 GMT

thanks a lot rich

Former Member — Wed, 20 Sep 2006 17:49:49 GMT

Hi,

If you using the function module TEXT_CONVERT_XLS_TO_SAP pass in the parameter I_LINE_HEADER as 'X'.

Thanks,

Naren