i have two tests:
- Code: Select all
[Test]
public void ExcelVersionSpeedTest()
{
var workbook1 = new Workbook();
workbook1.LoadFromFile(@"file.xlsx", ExcelVersion.Version2007);
var start = DateTime.Now;
workbook1.Worksheets[0].Range[100, 100].Value = "blabla";
workbook1.SaveToFile(@"file.xlsx");
Console.WriteLine("2007 save time:" + (DateTime.Now - start).TotalSeconds);
}
[Test]
public void ExcelVersionSpeedTest2003()
{
var workbook1 = new Workbook();
workbook1.LoadFromFile(@"file.xlsx", ExcelVersion.Version2007);
var start = DateTime.Now;
workbook1.Worksheets[0].Range[100, 100].Value = "blabla";
workbook1.SaveToFile(@"file.xls", ExcelVersion.Version97to2003);
Console.WriteLine("2003 save time:" + (DateTime.Now - start).TotalSeconds);
}
File is quite big (20mb, ~40000rows, 100+ columns), machine is quite decent (8Gb i7 SSD desktop)
2007 save time:537.4962625
2003 save time:2.5428045
We can't use 2003 format, as sometimes 65k rows is not enough, but 2007 save time is unacceptably long, is there anything cana be done, as excel natively saves file in matter of seconds.
Tested on 6.6 version, also on 5.8.7.4 and on subjective testing (pc was not completly idle) older version was faster (50+ seconds, again that is a quick test without isolating pc)?