Thanks for the information. That does explain a lot.
For my users, I might have to have them take more responsibility for
what is in the Excel file and making sure the data is correct.
Or, is there a way to use POI to programmatically convert the xls file
to a csv file?
Then everything would be text, and I already have the code to read in a
csv file as well.
Nick Burch wrote:
On Mon, 28 Apr 2008, Tom Holmes Jr. wrote:
However, columns like zip code and phone numbers are coming back with a
numeric value as a double.
This indicates that excel is really storing them as a number, and not as a
string. If you want to force excel to store them as a number, prefix them
with a ' when entering them
If you have stored them as numbers, you'll need to format them back to
strings if that's what you want. As the cell style for the data format
string, and that'll tell you how excel thinks it should be formatted
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
