Excel generation performance problem

Former Member — Fri, 11 Sep 2009 12:38:58 GMT

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

Re: Excel generation performance problem

former_member194669 — Fri, 11 Sep 2009 13:01:01 GMT

Another possible approach will be

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

2. Then use class

use global interface I_OI_DOCUMENT_VIEWER to view XML file in a container

a®