Upload excel file

Hi All,

I have a upload of data scenario whereby i will be using a bapi program to upload the data in the excel sheet to the SAP system.

This is the scenario:-

The excel sheet has 30,000 lines. I am supposed to upload in batches of 30 lines per document number.

How do code the program to read in batches of 30 lines? Which means, i upload the whole file of 30,000 lines and allow the program to upload accordingly.

Appreciate any help. Thanks.