upload sheet

[Former Member]

Hi

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

[Former Member]

Hi

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]

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

delete itab index 1.

Regards,

Rich Heilman

[Former Member]

thanks a lot rich

[Former Member]

Hi,

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

Thanks,

Naren