Hi, I am working on a XSSF excel sheet, whose values are to be read and displayed on the UI. The cells in the sheet are evaluated using formulas and they also use "table names" in them. POI is unable to evaluate the formulas where there occurs a table name and am getting the below error:
Formula is : IF(ValidationCheck=FALSE,IF(HAOption="Yes",Table28[[#This Row],[/ DAG]]*calcNumDAGs,TotDBDiskSpaceReq*numMBXServers),"--") Error is: Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException: Specified named range 'Table28' does not exist in the current workbook. Any help would be greatly appreciated. Thanks in advance, Saritha -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-not-able-to-evaluate-table-names-in-the-Excel-Sheet-tp5710583.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
