How to get Range value when using formulas?

Nov 17, 2011 at 8:41 AM

Hi is it possible to get the value for a formula for a range?

workSheet.Cells[1,1].Value returns blank ("") when the cell has a formula i.e. a reference to another cell.

Is it possible to get the value of the formula?



Nov 18, 2011 at 2:09 PM

No, there is no calculation engine in EPPlus. You have to open the workbook in Excel to get the value.

Nov 18, 2011 at 3:45 PM

Thanks Jan for the reply.

If others have the same question:

Open the workbook. Select the cells. Copy and paste values (not normal paste).