Thanks, Nick. I would love to read the cached value. However, I could not find a method in HSSFCell that exposes the cached value. http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html
The best method I could find is convertCellValueToString, but it's private. I'm not seeing a public way to get at a FormulaRecord's value. On Wed, Jun 19, 2013 at 10:02 AM, Nick Burch <[email protected]> wrote: > On Wed, 19 Jun 2013, Andrej Czapszys wrote: > >> I've been trying to use POI as a method of converting xls and xlsx >> documents to CSV. Unfortunately, I've hit a brick wall with formula >> evaluation. I'm getting errors like "Could not resolve external workbook >> name", because an example document references a document that I don't have. >> > > As long as your files are coming from excel, and not some other system (eg > not from some of the report generation software out there), just read the > cached formula values and skip evaluation > > > Ideally, I would like to turn formula evaluation off and just use the >> cached value in all instances. What are my options? >> > > Don't do it? Just get the cached formula evaluated cell type, and read out > the cached value that way. IIRC, all the examples in the POI source tree > for excel -> csv do that very thing > > Nick > > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > [email protected].**org<[email protected]> > For additional commands, e-mail: [email protected] > >
