We are currently using release jakarta-poi-1.5.1-final-20020615.
I have an interesting problem that I guess someone has come up against
before (I hope).I use the following code to retrieve cell values (code
snippet).
POIFSFileSystem fs = new POIFSFileSystem(new
FileInputStream(fileName));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(i);
String svalue;
if (row == null) {
svalue = "0";
} else {
HSSFCell cell = row.getCell((short) j);
String tvalue;
if (cell == null) {
svalue = "0";
} else {
switch (cell.getCellType()) {
case
HSSFCell.CELL_TYPE_NUMERIC :
case
HSSFCell.CELL_TYPE_FORMULA :
int cellType =
cell.getCellType();
When a cell contains =200 as a value, the statement HSSFCell cell =
row.getCell((short) j) returns null. I have tried this with 1.10.0-dev and
it works fine, as this is not a final release we are against moving to this.
Could anybody give me any ideas on how I could handle what is essentially a
formula.
Thanks in advance for any help
Tony Mundy
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
