Re: Common interface for DOM and SAX in poi

Did you take a look at the SAX-based reading interface, e.g. the related sample app https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java shows how to use XSSFReader and SheetContentsHandler to parse an XSLX file in a streaming fashion with

Re: Common interface for DOM and SAX in poi

Yes i did, The thing i, it is a basic xml interface which lacks many of the poi DOM functionality - you need to check for certain tags to find out types of cells etc ... -- View this message in context:

Formula Parsing and XSSFEvaluationWorkbook

I'm trying to provide a tracing/debugging feature and need to be able to say what cells a particular formula-cell depends on. POI makes this rather challenging, or so it seems. The methods in XSSFEvaluationWorkbook seem provide the function, but it also seems that you're not supposed to use this.

Re: Formula Parsing and XSSFEvaluationWorkbook

Thanks, Dominik! On Wed, Dec 9, 2015 at 12:15 PM, Dominik Stadler wrote: > I don't think there is something fully ready-made as no-one seems to > have needed this yet. > > I would probably start with an EvaluationWorkbook and retrieve the > list of Ptgs via the

Re: Formula Parsing and XSSFEvaluationWorkbook

I don't think there is something fully ready-made as no-one seems to have needed this yet. I would probably start with an EvaluationWorkbook and retrieve the list of Ptgs via the FormulaParser, then you'll need to look through these and handle any Ref-type-Ptg to find out which Cell(s) it