Right. If the cell is blank, the data format could hint at the value it is designed to hold, but doesn't mean that's what will be written there.
You could try entering a date and format it as "#,##0.00". The value would probably be meaningless, but would still be valid as far as POI or Excel are concerned. On Jun 26, 2017 21:09, "Blake Watson" <blake.wat...@pnmac.com> wrote: >>Are you after the Cell's CellStyle's DataFormat? No, that would be the "#,##0.00", which I have. I want to get from the DataFormat to the type (numeric, string, etc.). I think I'll have to do it myself.