This project has moved and is read-only. For the latest updates, please go here.

Get columnType as a date from worksheet cell

Jul 12, 2016 at 3:26 PM
I've noticed that for Date cells the Text Value will be "07/02/2016" but the Value will be a number "377002". I assume this is because Excel stores dates internally as a number masked to a date. Is there a way to reliably detect if a cell is a "date"? That way I can use the textValue (for everything else I think I just want value).

So far my only guess is to try and parse the format (looking for "dd", "mm", etc.) but I'd love something a little more reliable.