Excel generation performance problem

[Former Member]

Hi,

I use the Proxy Excel Spreadsheet interface to generate the Excel file on the custom container.

Unfortunately I have different rows with different formatting, and it is like hundreds of rows.

I use methos spreadsheet->cell_format to format whole Excel sheet, but it takes long time to generate,

for example 500 rows gets generated in more than 10s which is not acceptable.

Is there another way to put the formatting to the Excel cells to get it faster?

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Sep 11, 2009 9:22 AM

[former_member194669]

Another possible approach will be

1. Create Excel using XML tags with all format you want

https://wiki.sdn.sap.com/wiki/display/Snippets/XML%20TAGS%20simplifies%20Excel%20Download

2. Then use class

use global interface I_OI_DOCUMENT_VIEWER to view XML file in a container

a®