This is an old revision of the document!
POI Javascript Wrapper Functions
These functions can be used to retrieve values from an Excel file using the Java POI library.
Note: For more information on the POI Java library, see http://poi.apache.org///
<code>
function getNumericValue(sheet,row, col) {
Row = sheet.getRow(row);
if (Row != null) {
Cell = Row.getCell(col);
if (Cell != null) {
return(Cell.getNumericCellValue());
}
}
return “”;
}
function getStringValue(sheet,row, col) {
Row = sheet.getRow(row);
Cell = Row.getCell(col);
if (Cell != null) {
if (Cell.getCellType() == Cell.CELL_TYPE_STRING) {
return Cell.getStringCellValue();
}
}
return “”;
}
function getDateValue(sheet,row, col) {
Row = sheet.getRow(row);
Cell = Row.getCell(col);
if (Cell != null) {
if 1) {
return Cell.getDateCellValue();
}
}
return “”;
}
/* taken vom http://trephine.org/t/index.php?
title=Extracting_Excel_data_with_Apache_POI_and_Rhino */
function cellValue(sheet, CellRow, CellCol) {
row = sheet.getRow(CellRow);
if (row != null) {
cell = row.getCell(CellCol);
if (cell != null) {
var t = cell.cellType;
if (t == Cell.CELL_TYPE_NUMERIC) {
if (DateUtil.isCellDateFormatted(cell)) return new
Date(cell.dateCellValue.time);
else return cell.numericCellValue + 0.0;
}
if (t == Cell.CELL_TYPE_STRING) return cell.stringCellValue + ;
if (t == Cell.CELL_TYPE_FORMULA) {
try {
if (DateUtil.isCellDateFormatted(cell)) return new
Date(cell.dateCellValue.time);
else return cell.numericCellValue + 0.0;
} catch(err) { }
try { return cell.stringCellValue +
; } catch(err) { }
try { return cell.numericCellValue + 0.0; } catch(err) { }
try { return !!cell.booleanCellValue; } catch(err) { }
try { return cell.errorCellValue + 0; } catch(err) { }
return ;
}
if (t == Cell.CELL_TYPE_BLANK) return
;
if (t == Cell.CELL_TYPE_BOOLEAN) return !!cell.booleanCellValue;
if (t == Cell.CELL_TYPE_ERROR) return cell.errorCellValue + 0;
}
}
return null;
}
function isCellEmpty(sheet,row, col) {
Row = sheet.getRow(row);
if (Row != null) {
Cell = Row.getCell(col);
if (Cell != null) {
if (Cell.getCellType() != Cell.CELL_TYPE_BLANK) {
return false;
}
}
}
return true;
}
</code>