I need to read an Excel file from the application server (it's already uploaded there) into my program. More specifically, I will need to read the contents of the Excel file from the application server to an internal table in my program. How may I do this (the open dataset can't seem to work properly)? A sample code might just be helpful too.
I have used ALSM_EXCEL_TO_INTERNAL_TABLE for reading an Excel file from the presentation server and this works just fine. But, if I'm not mistaken, I cannot use this same FM to read an Excel file from the application server, is that right?
Many thanks in advance.