search

svn2github / npoi

This is a clone of an SVN repository at http://npoi.googlecode.com/svn/trunk/. It had been cloned by http://svn2github.com/ , but the service was since closed. Please read a closing note on my blog post: http://piotr.gabryjeluk.pl/blog:closing-svn2github . If you want to continue synchronizing this repo, look at https://github.com/gabrys/svn2github
Other
59 stars 50 forks source link

Formula Evaluation of =TODAY() not working #38

Open wcdeich4 opened 5 years ago

wcdeich4 commented 5 years ago

Hi. I"m trying to read in a spreadsheet that includes cells with the formula "=TODAY()" and nothing I do works.

I tried:

XSSFFormulaEvaluator.EvaluateAllFormulaCells(workbook);

and also

var evaluator = new XSSFFormulaEvaluator(workbook); evaluator.EvaluateFormulaCell(cell);

and also

workbookEvaluator = new WorkbookEvaluator(XSSFEvaluationWorkbook.Create(workbook), null, null); workbookEvaluator.Evaluate(new XSSFEvaluationCell(cell)).ToString();