Multiple sheets upload in excel

[Former Member]

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%20i...

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

[Sandra_Rossi]

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.

[Former Member]

@ 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

[former_member194669]

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®

[Former Member]

This message was moderated.