Skip to Content

get number of records before uploading to SAP

Nov 07, 2017 at 02:41 PM


avatar image

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!



10 |10000 characters needed characters left characters exceeded

Why do you need this?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Sandra Rossi 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.

10 |10000 characters needed characters left characters exceeded