C#: Reading values from Excel formulas

Question

I've been using Closed XML to generate my Excel reports automatically. So far so good, but however I need to save certain formula-generated values back into the database.

The formula would be something like this: =SUM(Day1, Day2, Day3), so simply an Excel formula parser would not fit my bill--I need something that can interact with it!

I don't mind having to save the spreadsheet and then re-opening it. So long as it's fast and efficient, I'm up for anything. Thanks a bunch. :)

Arion · Accepted Answer · 2012-04-27 07:39:37Z

2

You can use

Range("D1").value

for getting the value of the formula

edited Apr 27, 2012 at 7:39

Arion

31.3k10 gold badges74 silver badges89 bronze badges

answered Apr 27, 2012 at 7:34

Sandeep

6877 silver badges25 bronze badges

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

3 Comments

matt Over a year ago

What if, I can only get the cell from a row-col (int, int) reference?

Sid Holland Over a year ago

@matt Have a look here for a way to convert your integer column number to an Excel column name (remember to account for your possibly-zero based number).

matt Over a year ago

IXLWorksheet's Range().Value does not have a get accessor... says the code

Yahya Hussein · Accepted Answer · 2018-02-13 14:07:08Z

1

You can use something like:

if(ws.Cell(i, j).HasFormula) 
       VAL = ws.Cell(i, j).ValueCached
else
       VAL = ws.Cell(i, j).Value.ToString()

edited Feb 13, 2018 at 14:07

Yahya Hussein

9,16717 gold badges73 silver badges119 bronze badges

answered Feb 13, 2018 at 13:25

Tadeusz Krzyżanowski

111 bronze badge

1 Comment

Mittal Patel Over a year ago

Code only answers are discouraged on StackOverflow. Please try to elaborate a little as to why this is a correct answer..

Collectives™ on Stack Overflow

C#: Reading values from Excel formulas

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related