Performance "OpenExcel"-Method

Posted by: karsten-heimer on 8 September 2017, 3:22 pm EST

  • Posted 8 September 2017, 3:22 pm EST


    i'm using "Spread Studio V7" with Version "7.35.20132.1". I've noticed, that the "OpenExcel"-Method from the Class "SheetView" ist slow.

    Are there any changes in this Method in newer Versions?

    Greetings, Karsten Heimer.
  • Replied 8 September 2017, 3:22 pm EST


    You could try using this open flag and see if it helps:

    DoNotRecalculateAfterLoad [1024] Avoids recalculation after loading the Excel file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate().

    The current version is V9 so it would probably be faster. You could download a trial and test it with your file.

  • Replied 8 September 2017, 3:22 pm EST

    Hello Gina,

    thank you für your answer.

    Preventing recalculation after loading is not a Solution for my Problem, because i need the Results from my Formulas. What i do in my program is following: I load a empty Excelsheet - empty, but filled with formulas - and then i fill the cells with values from my program. Now i can read the results of my formulas.

    How is the upgradepath vom Version 7 to 9? What would it cost? Is V9 "probably faster" or "faster"?

    Greetings, Karsten.
  • Marked as Answer

    Replied 8 September 2017, 3:22 pm EST


    They made a lot of performance enhancements so it should be a lot faster; however, you could test your specific Excel file with the trial if you wish.

    You can set AutoCalculation back to true. This option can be useful if the formulas are slowing down the load time.

    fpSpread1.ActiveSheet.AutoCalculation = true;

    Sales will give you information about prices.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels