Skip to Content
0

get number of records before uploading to SAP

Nov 07, 2017 at 02:41 PM

57

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!

regards!

Emanuel

10 |10000 characters needed characters left characters exceeded

Why do you need this?

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

1 Answer

Best Answer
Sandra Rossi Nov 07, 2017 at 04:07 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded