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] For additional commands, e-mail: [email protected]
