Slow saving to 2007 format

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Slow saving to 2007 format

Postby gbanaitis » 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

Re: Slow saving to 2007 format

Postby Suvi.Wu » 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: 156
Joined: Thu Oct 20, 2011 2:53 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 1 guest

cron