Extremely long time to Save file

Aspose.Cells Product Family
1

Hi,

I am generating an Excel file with 5 sheets in it.

In average it takes around 4 seconds to generate the Excel file from scratch with the Aspose.Excel component.

However when I save the file on my disk it takes around 45 seconds!

The command I use to save is the following :

excel.Save( FullPathFileName, FileFormatType.Excel2003 );

Any idea what is the problem ?

thank you,


Fred

2

Hi Fred,

Please zip your project and generated file, then post them here. I will check how to optimize it.

3

By the way, do you use the latest version? We optimized save performance since v3.4.2.

4

I found the problem.

The formatting was the part that was taking too long.

I placed the formatting in a template instead and now it is fast!

5

You can also check

Creating Style objects and assign them to cells with same formattings can also speed up the program.