Excel formular to C# code

Question

I'd like to convert an excel spreadsheet to a component of c# code. To get it goin' I like to get all cells of a sheet containing fomulars into c# via interop. In the c# module I'd like to solve the defined fomulars with different values replacing the cell references in the fomular. Is there a framework where I can for example convert a "SUM($C3 : $C5)" from excel to a "var sum = c3 + c4 + c5;" or semilar formulars?

regards gordon

Govert · Accepted Answer · 2011-03-22 19:20:00Z

6

I think you are looking for an expression evaluator in C#.

Google found a few that I think you should look at:

The Fast Lightweight Expression Evaluator on Codeplex.
ILCalc on CodePlex - "This project was inspired by the FLEE project, but written in different, much easier way."
NCalc is another one on CodePlex - evaluates custom functions and works with Unicode, which might be important for you. There is a related CodeProject article.
There's this C# Expression Evaluator article by Jonathan Wood.
There's one in the Spring.net Framework.
A CodeProject article by Pascal Ganaye.
Or you can work on your own starting with the DynCalc example by Bart de Smet.

You might also need implementations of all those built-in Excel functions. There's a library with all the financial functions re-implemented in F# by Luca Bolognese - find it on MSDN.

edited Mar 22, 2011 at 19:20

answered Mar 22, 2011 at 19:05

Govert

17k4 gold badges62 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dgorissen · Accepted Answer · 2011-10-19 16:52:13Z

1

More power than what you need, but with some luck only a thin interface wrapper is needed to pump data out of execl into formula engine:

FormulaEngine is a .NET assembly that enables you to add formula support to your application. It takes care of parsing and evaluating formulas, tracking their dependencies, and recalculating in natural order. The formula syntax and much of the engine's functionality are direct replicas of Excel ensuring a low learning curve for users.

Link: FormulaEngine

Update: I recently started a similar python library: pycel

edited Oct 19, 2011 at 16:52

answered Jun 13, 2011 at 9:36

dgorissen

6,3253 gold badges48 silver badges55 bronze badges

Comments

Dmitri Nesteruk · Accepted Answer · 2022-03-21 17:58:44Z

1

Check out ActiveMesa X2C, which does precisely that. (Disclaimer: I'm the author of said product.)

edited Mar 21, 2022 at 17:58

answered Apr 15, 2017 at 9:11

Dmitri Nesteruk

23.9k23 gold badges107 silver badges169 bronze badges

2 Comments

Dmitri Nesteruk Over a year ago

Fixed the URL..

Dan Parsonson Over a year ago

Thanks - updated link appears fine; deleted my earlier comment and removed my downvote.

n8wrl · Accepted Answer · 2011-03-22 15:33:11Z

0

Is this something you'll do repeatedly or just one time?

We're using www.spreadsheetgear.com to manipulate Excel spreadsheets from C# and it works wonderfully. Our needs are different, so you should study the API to see if it gives you access to the text of the forumulas, but I think it might.

No affiliation - just a satisfied customer.

answered Mar 22, 2011 at 15:33

n8wrl

19.8k4 gold badges70 silver badges106 bronze badges

2 Comments

Martin Hudasch Over a year ago

Getting the formular out of the spreadsheet is not the problem. This is already accomplished via office-interop. The result is the fomular in string format. I want to replace references like "C22" with another value and then solve the formular without excel. Since I'm already in c# code I'd like to solve the formular there.

Martin Hudasch Over a year ago

Oh I see it can evaluate calculations given to it. This might be a solution but since it's not free I think I could not use it. But it gets the solved.

Collectives™ on Stack Overflow

Excel formular to C# code

4 Answers 4

Comments

Comments

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related