poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Intended Cell Type
Date Mon, 26 Jun 2017 23:34:04 GMT
Hi, guys--

I'm struggling with figuring out how to determine what type a cell SHOULD
be. If I use CellType, what I get is the contents of the cell as they
currently are. For example, an empty cell which is formatted as "#,##0"
will have a type of "blank" but I'd like to be able to get that it's meant
to be a number.

This came up because my users were creating Excel spreadsheets with a
10-digit ID number like and defining it as "a number between 1000000000 and
9999999999". The problem being this would end up as a double, and (at
export time) come out as something like "1.23456789E9".

So I sez to 'em, I sez, "Hey, it's not a number, it's a numeral. Format it
as text in your Excel, and I'll know to treat it as a string." That seems
sensible to me: If it's a numeral, don't pretend it's a number. It's just a
string that happens to look like a number.

But then I realized that blanks all come out as, well, blank (or
CellType/BLANK rather). Do I have to suss the type from the format manually
to get the type they mean? Is there any way for them to specify in Excel
that something is a particular type that POI can tell me what they mean?

*Blake Watson*

Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
www.PennyMacUSA.com <http://www.pennymacusa.com/>

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message