topic Re: Multiple sheets upload in excel in Application Development and Automation Discussions

Multiple sheets upload in excel

Former Member — Wed, 02 Sep 2009 17:52:59 GMT

Hi,

I am trying to upload multiple sheets in excel file to an internal table using the below code

https://wiki.sdn.sap.com/wiki/display/Snippets/Read%20multiple%20sheets%20of%20an%20Excel%20file%20into%20SAP%20through%20ABAP

It is taking long time when i give the number of rows as 10000

Let me know if anyine has any better solution than this for uploading more than 10,000 rows

I am working in SRM system

Thanks

Chandra

Re: Multiple sheets upload in excel

Sandra_Rossi — Wed, 02 Sep 2009 18:12:17 GMT

Reading data from presentation server is slow, and using OLE (underlying technology) is even more. I think you can't get a better result.

As it seems you have a high volume of data, you may transform the excel into flat file, and upload it as usually (gui_upload). If the users really don't want to change the format of their file, you may create a macro in the excel which transforms automatically the data into a flat file.

Re: Multiple sheets upload in excel

former_member194669 — Wed, 02 Sep 2009 18:28:05 GMT

For single sheet excels you can also use


    call function 'TEXT_CONVERT_XLS_TO_SAP'
      exporting
        i_tab_raw_data       = wa_raw
        i_filename           = p_filename
      tables
        i_tab_converted_data = i_etab[]
      exceptions
        conversion_failed    = 1
        others               = 2.

a®

Re: Multiple sheets upload in excel

Former Member — Wed, 02 Sep 2009 18:39:47 GMT

@ Sandra , thanks for the reply , I have no idea on macros, for now i had limited the selection to 5000 entries till i get a better solution

@ a@s , The Function module does not exist in SRM system

Thanks a lot for your answers

Re: Multiple sheets upload in excel

Former Member — Thu, 03 Sep 2009 04:52:27 GMT

This message was moderated.