I had an requirement in which i need to generate an excel file with multiple sheet in the presentation server.
I can succssfully create the excel file through the program using OLE concept. But now i am facing an issue,
if the number of worksheets is excel is set as '2' and my program is generating '4' sheets, in excel it is showing only '2'.
Is there anyway this can be controlled through ABAP program?
For eg. if there is 5 worksheet to be generatedand the setting in the worksheet is to show only 2 worksheet, then also my program need to
generate an excel with five sheets.