Skip to Content
author's profile photo
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


no_flush = ''

all = ''

* updating = -1

* rangesdef =


contents = i_data

error = iref_error

* retcode =


ranges = i_ranges



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on 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.



    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.