slow Microsoft.interop.excel object

Question

0.00/5 (No votes)

See more:

Hi,

i am using Microsoft.interop.excel application object for performing statistical calculation.
But for large calculations it takes longer time to perform calculations.
how can i improve calculation performance?
is there any alternative for excel object?

Thanks
Rhishi.

Posted 6-Dec-13 0:18am

RhishikeshLathe

Add a Solution

Comments

Sergey Vaselenko 6-Dec-13 7:06am

The most slowest operations is COM (Excel) function calls from VSTO.

You may try to reduce amount of such operations.
For example, cache data loaded from Excel to avoid the same calls.

Can you use Visual Studio Profiler?
It is the simplest way to find slow codes.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Adam Zgagacz · Accepted Answer · 2013-12-06T03:11:00

Solution 1

Do not use Excel to do any significant work in it.
InterOp is slow. There is no way around it.

As suggested by Sergey in the comment bring data to your app, do whatever math is needed and then save it back in Excel format.

If you are using new excel spreadsheet saved in xlsx/xlsm data format, fastest way to read/write data will by using OpenXML.

Posted 6-Dec-13 3:11am

Adam Zgagacz

Comments

RhishikeshLathe 7-Dec-13 0:37am

thanks sir,
but i am totaly dependent on excel calculation enging,
i am using solver add-in of excel for calculation.

agent_kruger 7-Dec-13 7:04am

what kind of calculation you are doing?