Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon May 14, 2012 8:46 am

Hi,
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)?

gbanaitis
 
Posts: 1
Joined: Mon May 14, 2012 8:20 am

Mon May 14, 2012 9:52 am

Hi ,

Thanks for evaluating spire.xls.

We have created a research on the issue you talked, and we will do our best to reduce the time. However, I cannot provide you any reliable estimateregarding its complexity. If we have any progress, we will inform you ASAP.

Thanks for your understanding.

Have a great day.

BR
Suvi
e-iceblue support
User avatar

Suvi.Wu
 
Posts: 154
Joined: Thu Oct 20, 2011 2:53 am

Return to Spire.XLS