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 ?