I'm looking for a way to load an Excel file (.xls) from a specific WORKBOOK in a SAP R/3 internal table. Do you have an idea of how to make this happen, so that it will also work in batch mode?
You could use OLE - see transaction OLE for example. You can do this in batch mode, as long as the applications server can see the excel file. In batch mode, there is no presentation layer, so no access to the presentation server.
Dig Deeper on SAP workflow development
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.