Excel Formula Evaluator in C# code

Question

0.00/5 (No votes)

See more:

Hi,

This is the improved version of my requirement.
I am having more Excel formulae stored in DB. So retrieving them I need to calculate the values by writing logic for that formula dynamically.
For Ex:
Excel Formula :

VB

IF(A>B,1,2)
A=4 and B=5

Code to be generated:

VB

IF(A>B)
{
Value = 1
}
Else
{
Value = 2
}

Hi,

I would like to get the coding for Evaluation of Excel formula in run time using C#. Could anyone help me to attain this target.

Thanks
Mathi

Posted 3-Apr-13 21:14pm

Mathi2code

Updated 24-Apr-13 21:54pm

Kenneth Haugland

v3

Add a Solution

Comments

Maciej Los 4-Apr-13 3:18am

Yes, we can help you to attain this target, but...
Please, be more specific and provide more details.
What have you done till now?

Mathi2code 5-Apr-13 2:01am

Hi Maciej,

Thanks for the response. I have updated my requirement clearly. Please help me in this. Also have an example like that you can have 'n' Excel formulae like Roundup,IsBlank,recursive IF condition etc.

With Regards,
Mathi

4 solutions

Solution 1

Hi,

Automate Microsoft Excel from Microsoft Visual C#.NET

You will need to automate excel usage from c#.

Posted 4-Apr-13 0:49am

José Amílcar Casimiro

Comments

Kenneth Haugland 4-Apr-13 7:12am

5'ed.

Solution 2

in addition to
http://support.microsoft.com/kb/302084

You gennerally get the formula of the cell by Cell.Value and you get the underlying formula by writing Cell.Formula.

Posted 4-Apr-13 1:12am

Kenneth Haugland

Comments

Mathi2code 5-Apr-13 1:59am

Hi Jose and Kenneth,

Thanks for the response. I think my Question was not clear earlier, now I have updated it in a clear Please help me in this.

With Regards,
Mathi

Kenneth Haugland 25-Apr-13 3:58am

With the information you provided here, you might just load a new excel sheet and make it do the calculations. That would be te easiest, using Interop.

Mathi2code 29-Apr-13 1:29am

Interop is easiest way but for that we require the excel to installed in our local machine. Also Each and every time when a user uses a session of excel will be opened which is another drawback which I consider. Hence I go for the link which I have added to this post. Please check that.

Regards,
Mathi

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)

Mathi2code · Accepted Answer · 2013-04-19T02:50:00

Solution 3

Hi All the below link worked... Which was really helpful...

A Tiny Expression Evaluator[^]

I appreciate your help

Thanks & Regards,
Mathi

Posted 19-Apr-13 2:50am

Mathi2code

Mathi2code · Accepted Answer · 2013-04-24T21:32:00

Solution 4

A Tiny Expression Evaluator[^]A Tiny Expression Evaluator[^]

Posted 24-Apr-13 21:32pm

Mathi2code

Updated 24-Apr-13 21:33pm

v2