evaluation of formula cell value in xls poi

[ganesh b pol]

currently i am facing problem in formula evaluation

while searching the net i got following code from

http://poi.apache.org/spreadsheet/eval.html

as

FileInputStream fis = new FileInputStream("/somepath/test.xls");
Workbook wb = new HSSFWorkbook(fis); //or new XSSFWorkbook("/somepath/test.xls")
Sheet sheet = wb.getSheetAt(0);
FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
 
// suppose your formula is in B3
CellReference cellReference = new CellReference("B3"); 
Row row = sheet.getRow(cellReference.getRow());
Cell cell = row.getCell(cellReference.getCol()); 
 
if (cell!=null) {
    switch (evaluator.evaluateFormulaCell(cell)) {
        case Cell.CELL_TYPE_BOOLEAN:
            System.out.println(cell.getBooleanCellValue());
            break;
        case Cell.CELL_TYPE_NUMERIC:
            System.out.println(cell.getNumericCellValue());
            break;
        case Cell.CELL_TYPE_STRING:
            System.out.println(cell.getStringCellValue());
            break;
        case Cell.CELL_TYPE_BLANK:
            break;
        case Cell.CELL_TYPE_ERROR:
            System.out.println(cell.getErrorCellValue());
            break;
 
        // CELL_TYPE_FORMULA will never occur
        case Cell.CELL_TYPE_FORMULA: 
            break;
    }
}

here developer evaluating formula from some hardcoded B3 cell
can any one tell me way to identify this B3 cell value dynamically
[ December 11, 2008: Message edited by: ganesh b pol ]

[Martijn Verburg]

What is your actual problem?

[ganesh b pol]

kindly provide response to this thread

[Ulf Dittmer]

The question is not very clear, that's why Martijn asked for clarification. If we knew better what you're trying to achieve we might be able to help.

[Martijn Verburg]

To clarify, what do you mean by get the B3 cell dynamically? Do you just want to pass in the Cell reference as a variable? Do you want to 'search through the sheet' and find the cell?