Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question