PutValue works very slow


#1

I use Aspose.Excel 2.7.4.0.
I maked a several tests and got the followings results :

test 1:

Excel excel = new Excel();
Worksheet wrks = excel.Worksheets[0];

for ( int i = 0; i < 10000; i++ )
{
for ( byte j = 0; j < 10; j++ )
{
wrks.Cells[i,j].PutValue( "data" + i + "," + j );
}

}

excel.Save(@"c:\rem1.xls");

it works 4 seconds 546 milliseconds


test 2:

Excel excel = new Excel();
Worksheet wrks = excel.Worksheets[0];

for ( int i = 0; i < 10000; i++ )
{
for ( byte j = 0; j < 10; j++ )
{
wrks.Cells[i,j].PutValue( "data" );
}

}

excel.Save(@"c:\rem1.xls");

it works 47 seconds 234 miliseconds


Can I have the same time in the the second test ? What I have to do ?


#2

Thanks for your report.

We will optimize our component for the second case.


#3

Please download v2.8 and have a try.