Results 1 to 6 of 6
  1. #1
    saritha suram is offline Member
    Join Date
    Aug 2012
    Posts
    4
    Rep Power
    0

    Default Apache POI not able to evaluate table names in the Excel Sheet

    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

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Apache POI not able to evaluate table names in the Excel Sheet

    Does that formula work in Excel for that same sheet?
    (Should be easy enough to test).

    If so then it could simply be a limitation of POI.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #3
    saritha suram is offline Member
    Join Date
    Aug 2012
    Posts
    4
    Rep Power
    0

    Default Re: Apache POI not able to evaluate table names in the Excel Sheet

    Quote Originally Posted by saritha suram View Post
    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
    The formulas are working in the excel sheet.

  4. #4
    saritha suram is offline Member
    Join Date
    Aug 2012
    Posts
    4
    Rep Power
    0

    Default Re: Apache POI not able to evaluate table names in the Excel Sheet

    Hi,

    Then is there any other work around in POI to get the cell value directly, without evaluating the formula from the excel sheet?

    Thanks,
    Saritha

  5. #5
    saritha suram is offline Member
    Join Date
    Aug 2012
    Posts
    4
    Rep Power
    0

    Default Re: Apache POI not able to evaluate table names in the Excel Sheet

    Hi,

    If POI does not support the evaluation of table names, then as a work around, is there any way to convert or replace the table name reference in the formula to [ row, column] combination and then evaluate the formula??

    Thanks,
    Saritha

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Apache POI not able to evaluate table names in the Excel Sheet

    It's been ages since I've done anything vaguely complex with Excel formulae, so I've no idea how you would replace that lot.
    Here's the Apache page covering the sort of thing they support and don't support at the moment, by the way.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. excel sheet
    By sam.jj12 in forum NetBeans
    Replies: 1
    Last Post: 02-15-2012, 06:01 PM
  2. How to create excel sheet?
    By kishan in forum Advanced Java
    Replies: 3
    Last Post: 07-13-2010, 02:15 PM
  3. How to read EXCEL Sheet using XML
    By raju.i in forum New To Java
    Replies: 1
    Last Post: 04-19-2010, 01:39 AM
  4. Export Html table to excel sheet by JS
    By roby_joshua in forum New To Java
    Replies: 1
    Last Post: 08-27-2008, 07:25 PM
  5. Replies: 0
    Last Post: 03-11-2008, 03:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •