0

I am using Apache POI 3.9 for parsing excel file. In one of the cell which I am trying to read 'Name' has been used in the formula specified for this cell (formula is sum of value at name cell + value of current cell). These names have been defined in 'Name manager' of excel. When I am trying to read this value via POI I am getting 'circular`ref'. Can anyone please advise me on how to read the value of the formula cell where 'name' is used?

Thanks

Johnny000
  • 2,058
  • 5
  • 30
  • 59
user1230038
  • 1
  • 2
  • Go through http://stackoverflow.com/a/17706504/624003. This will help you to understand how to read name ranges and update that. – Sankumarsingh Sep 03 '13 at 05:06
  • Thank you for quick response.This link was useful.I want to read the value for the name as defined in Name manager – user1230038 Sep 03 '13 at 06:41
  • 1
    What exactly you want? the formula that the name is defined to refer to or anything else. – Sankumarsingh Sep 03 '13 at 08:18
  • when you click on Name Manager in the excel, we can see Name,value,Refers To,Scope and comment for each Name which is defined.I want to retrieve the value for the name which is defined in this name manager. Hope I was able to convey what I need. – user1230038 Sep 03 '13 at 10:36

0 Answers0