how to read the excel from 5th row bapi upload

[former_member663235]

hi, I am uploading the excel file the header contains 4 rows . the data is start from 5 th row. how to read the data from 5th row. while bapi uploading. I'm using text_convert_Excel_to_sap. fm please help me with the code. I tried

I'm able read it from first row. but I need to read the data from 5th row. plz doneedful

[pataselano]

In my blog Scripting: Uploading an Excel Spreadsheet on SAP GUI for windows 7.60, I created simple function module for read the excel file.

You can use that function module.

[raymond_giuseppi]

Why don't you delete or ignore the records related to first four lines of the internal table?

[former_member663235]

Hi raymond.giuseppi,

I have tried that, it's working with 5th row posted. but when I'm filling the header for first 4rows

it's not reading the file.

[raymond_giuseppi]

Did you look for some tools like

• For XLS and XLSX, OLE2
• For XLSX, look at tool ABAP2XLSX
• For XLSX, some standard class such as CL_XLSX_DOCUMENT