Question:
Hi All,
I want to upload multiple Excel worksheets to an internal table or I want to be able to read the worksheet's name of an Excel file. How can I do so?!? Is there a Function Module I can use?!? Is there an ABAP example anywhere?!? So far, I can upload data from Excel only if the worksheet I want to work with is active/saved before exiting Excel. Instead of re-saving the Excel file and activating the other worksheets, I thought there's a way to read the worksheet's name.
I greatly appreciate your help.
Thank you very much.
Answer:
Hi All,
I want to upload multiple Excel worksheets to an internal table or I want to be able to read the worksheet's name of an Excel file. How can I do so?!? Is there a Function Module I can use?!? Is there an ABAP example anywhere?!? So far, I can upload data from Excel only if the worksheet I want to work with is active/saved before exiting Excel. Instead of re-saving the Excel file and activating the other worksheets, I thought there's a way to read the worksheet's name.
I greatly appreciate your help.
Thank you very much.
The only way to access multiple sheets within a workbook in Excel is via OLE which you will need to code yourself. Examples of OLE automation are available on this forum, in the Knowledge Corner and through the Development Class SOLE.
Good luck.
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru
Answer:
Further to what Rosie says, here's a good start.
_________________
Regards
R
Abap KC
SFMDR