locked
C# .net Microsoft.Office.Interop.Excel v15 (2013) very slow RRS feed

  • Question

  • I am working on an application that needs to edit an excel file performing various actions like:

    • Copy paste sections from worksheet to worksheet
    • Add/Edit values
    • Formulas and macros run in the background

    This is an application initially developed with Excel 2007 but I now have to use Excel 2013. Unfortunately, I noticed that it is almost 10x times slower when running in a machine that has Excel 2013 installed rather than Excel 2007.

    Therefore, I created a very simple benchmarking application that randomly generates numbers and writes them in 1000 (rows) * 15 (columns) = 15000 cells.

    The results are disappointing as it takes around 670 milliseconds to run in Excel 2007 and around 3257 milliseconds to run in Excel 2013. (this is 5x times slower)

    Have you had any similar issues with Excel 2013? Do you know if there is anything that I can try to optimise Excel 2013?

    Thanks for your help!

    Thursday, June 25, 2015 10:29 AM

All replies