This project is read-only.

NetworkDays formula implementation

Oct 22, 2010 at 1:57 PM

Hi NPOI Team

 

I would like to know how one implements the NetworkDays formula (ATP)?

The following gives me an error;

..

..

HSSFCell cell = row.GetRow(0).GetCell(0);

cell.SetFormulaCell("NETWORKDAYS(L9,TODAY()), -1");

I get the following error:

FormulaParseException: Name 'NETWORKDAYS' Is completely unknown in the current workbook

 

 

Nov 9, 2010 at 12:01 AM

What's this function used for? Any detailed description.