reading numeric cell values as Strings

[Albert Wang]

Hi all,

I found variations of my question in the mailing list archives, so I apologize if this is redundant, but I couldn't find the exact answer I was looking for:

I'm trying to read in an Excel spreadsheet (created outside of HSSF), and I'd like all cells to be read as Strings, exactly as they are displayed, including numbers. In the spreadsheet, I have set the format of all cells to be Text. I assumed HSSF would then determine the cell type of all cells to be String, but apparently that's not the case: if the cell contains only numeric characters, HSSF seems to decide it's Numeric. Am I doing something wrong? Is there some way to accomplish what I'm looking for?

Thanks,
-Al

--



--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>