04-14-2009 2:45 PM
Hi,
How can i load data from Excel Worksheets to internal table from ABAP in background mode.
I load it from a job.
Thanks,
04-14-2009 2:54 PM
Hi
easiest way:
1. the user should save the xls as CSV file ( seperated by ; ( semicolon ) )
2. open dataset > read dataset > close dataset
bestreg Robert
04-14-2009 3:31 PM
The problem is that there are multiple Worksheets in the excel file.
With the sentences OPEN DATASET, how do I open a particular Worksheet?
Thanks,
04-14-2009 4:15 PM
You can't use excel functions in background.
You can read a excel file in background but SAP can't understand it .
04-14-2009 2:56 PM
04-14-2009 7:15 PM
Working in background with excel and application server is not possible i guess.
Regards,
Lalit Mohan Gupta.