On Sun, 7 Oct 2007, vedgunjan wrote:
The Problem is, the cell which are of type HSSFCell.CELL_TYPE_FORMULA, on reading the value of the cell,using cell.getCellFormula(), am getting the formula as string, but actually I want the value which is present in that cell.
IIRC, calling getNumericCellValue() on a formula cell ought to return the result of the formula, but only if the formula has been evaluated. If nothing has evaluated the formula, the answer will be blank.
Opening the file in excel and saving it again ought to sort it, as would using the formula parser code in the scratchpad to calculate it yourself
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
