Skip to Content
Former Member
Nov 04, 2009 at 07:16 AM

Excel file generation



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.