This project is read-only.

is DateUtil.IsCellDateFormatted() correctly working?

Jun 5, 2012 at 2:11 PM


I'm using the method DateUtil.IsCellDateFormatted() to determine if a cell contains a date or not.

if (DateUtil.IsCellDateFormatted(cell))
                        result = DateUtil.GetJavaDate(cell.NumericCellValue).ToShortDateString();

However, when a cell is not Date-formatted this method throw an InvalidOperationException.

Is this intended?

Jul 27, 2012 at 12:18 AM

There should not be a exception. What's your data in the cell?

Oct 24, 2012 at 2:47 PM
Edited Oct 24, 2012 at 2:52 PM

When you use DateUtil.IsCellDateFormatted() on a cell which contains text, this exception is raised.

Dec 4, 2012 at 9:31 AM

Any chance to have this updated?