Hi all,
I've just started using HSSF, and I can tell that it's going to be very
helpful to me - I work with Excel files frequently, and automating tasks
through Java will be much easier if I can access the data directly from
.xls files, as opposed to manually collecting and formatting data before
processing it (which is still faster than doing the whole thing
manually, but less...faster). So I appreciate that this product exists.
However, I've run into a stumbling block that I haven't found the answer
for in the How-to, the Quick Guide, or the Javadocs. I'm hoping this is
the right groups to be in, and that you can help me out.
In the file I'm currently working with, one of the columns contains a
series of alpha-numeric codes, most of which are all numerals. And the
trouble I'm having is that when I print these codes out, those which are
all numerals get treated as large numbers and printed in scientific
notation (i.e. 9.9152516E7). I need to look at them as just a series of
digits, since they are not, in the traditional sense, numbers.
I have tried using HSSFCellStyle with the following code:
HSSFCellStyle style = wb.createCellStyle();
style.setDataFormat(wb.createDataFormat().getFormat("@"));
and calling curCell.setCellStyle(style); when I iterate over the codes,
just before I print them.
And I've used "0", "#,##0", and "General" in place of "@", but none of
those have worked. Is there a DataFormat that will do what I need it to
do, or are then other steps necessary?
Many thanks in advance,
Andrew Fallows
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
