topic Re: Excel file generation in Application Development and Automation Discussions

Excel file generation

Former Member — Wed, 04 Nov 2009 07:16:36 GMT

Hi,

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.

Thanks,

Arun.

Former Member — Wed, 04 Nov 2009 09:08:11 GMT

Hi Arun,

How is the setting -- to show only 2 worksheet in the worksheet, done ?

You should keep calling ADD WORKSHEET ,and give a name to worksheet, and paste data.

I couldnt understand how it is restricting you for only 2 sheets.

Thanks,

Nisha Vengal.

Former Member — Wed, 04 Nov 2009 09:37:45 GMT

Setting is not done in the program,but in excel,path is tools-options-general-Sheets in new workbook.

If we put here 2 only 2 worksheet will display.

Anyway thanks for your time i managed to solve it out by including the following code.

SET PROPERTY OF APPLICATION 'SheetsInNewWorkbook' = 10.