prob with TEXT_CONVERT_XLS_TO_SAP

[Former Member]

Hello,

I am uploading a xls file into internal table using TEXT_CONVERT_XLS_TO_SAP.

The file strusture is as below.

Row1: customer city

Row2: 2000001 ABD

My requirement is to skip the first row details, as they are just the field titles and i need not consider the first row.

I should pick the data from second row onwards which is actual data.

I have to use this TEXT_CONVERT_XLS_TO_SAP FM only.

Please help.

Points are assured.

Thanks

Aafaque Husain

[Former Member]

Hi,

Just delete first row from your internal table using delete satatement.

Example:

DELETE table itab index 1.

[Former Member]

keep I_LINE_HEADER = X.

then it will read from second row onwards

try this

[Former Member]

Hi Madhavi,

I have similar problem iam having two headers if i want to skip the two headers what i have to do.......because the option X will skip only one header , how to skip the second header . Pls let me know as i am struck with this .

regards

ravi