Skip to Content

get number of records before uploading to SAP

Hi Guys!

I'm using TEXT_CONVERT_XLS_TO_SAP to upload an Excel file. In the context of an ABAP program, is there a way to know how many records are on the file before uploading to an internal table?

I've been checking a lot of posts but I haven't found an answer yet.

thanks in advance!

regards!

Emanuel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 07, 2017 at 04:07 PM

    It would be quite "complex" to do. TEXT_CONVERT_XLS_TO_SAP is based on DOI for Excel. You can develop your own DOI program with a macro to return the number of lines (there is a documentation for macros -> search the forum/SAP documentation for I_OI_SCRIPT_COLLECTION). That will start Excel, which will load the file at the frontend, but it should be quick because avoiding the transfer of the whole data to the application server.

    Add comment
    10|10000 characters needed characters exceeded