topic Re: Upload excel file in Application Development and Automation Discussions

Upload excel file

Former Member — Wed, 29 Aug 2007 13:35:21 GMT

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.

Re: Upload excel file

Former Member — Wed, 29 Aug 2007 13:39:07 GMT

Hi!

Use ALSM_EXCEL_TO_INTERNAL_TABLE fm, and its BEGIN_ROW and END_ROW parameters.

Increment them by 30 for a new segment to read.

Regards

Tamá

Re: Upload excel file

Former Member — Wed, 29 Aug 2007 13:41:15 GMT

Hi Charlene..

You can use the below logic.. If your table has the records already sorted so that u just need to break them in chunks of 30..

1) Load the complete file in an internal table say itab1.

2) Declare another table itab2 similar to itab1.

2) WHILE itab1[] IS NOT INITIAL.

APPEND LINES OF itab1 TO itab2 FROM 1 TO 30.

**Do ur processing on the 30 line**

DELETE itab1 FROM 1 TO 30.

ENDWHILE.

Thanks and Best Regards,

Vikas Bittera.

**Points for useful answers**

Re: Upload excel file

Former Member — Wed, 29 Aug 2007 13:44:15 GMT

Hi Charlene..

Sorry the syntax for APPEND LINES.. is:

APPEND LINES OF itab1 FROM 1 TO 30 TO itab2.

Make sure you load the file in one shot, do not try to load it from the workstation in chunks.. this will make very bad impact on the performance.

Thanks and Best Regards,

Vikas Bittera.

**Points for useful answers**

Re: Upload excel file

Former Member — Wed, 29 Aug 2007 15:48:05 GMT

Thanks to Tamás for giving your suggestion solution.

Also, thanks to Vikas Bittera for helping me solve the problem.

Have a good day!