Skip to Content
avatar image
Former Member

Cannot we upload more than 10K records from excel multiple sheets to internal table in sap abap

Hi Experts,

Read multiple sheets of an Excel file into SAP through ABAP - Code Gallery - SCN Wiki

Please check above link, i have written logic based on above link for uploading data from multiple excel sheets to internal table. But the problem is the below internal table(I_DATA-ROW) row length is 4-Char. so the excel file sheet data is uploading only 9999 records to internal table (I_DATA). But as per my Excel per sheet more than 40K-Records has to upload to internal table. So anybody help me on this which is best way to achieve this functionality.

CALL METHOD iref_spreadsheet->get_ranges_data

EXPORTING

no_flush = ''

all = ''

* updating = -1

* rangesdef =

IMPORTING

contents = i_data

error = iref_error

* retcode =

CHANGING

ranges = i_ranges

Thanks

surender

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 18, 2016 at 12:35 PM

    Kindly do a search on SCN. There are various posts and methods, other than the one you have provided, on how to read excel sheets successfully.

    Thanks,

    Juwin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Juwin

      Thanks for your response, I already gone through the many blogs, this is the one link suitable for my requirement to read multiple sheets data from excel to internal table. So could you please provide if you have found anything.

      Thanks

      suri