Nick I have a lot of fairly large Excel read only spreadsheets to process and the EventHSSF model appears to be recommended to do this. I do not have complex formulas to deal with and most of them are row by row and that is why I selected this model.
Problem is the XLS2CSV does not appear to work with String formulas like CONCATENATE, LEFT, RIGHT, etc. I would appreaciate if someone in the community could help me out with this debug and maybe suggest a change in code for the XLS2CSV. It seems that it would benefit everybody. Alternatively if someone has already encountered this issue and fixed it, if they can let me know? ------------------ ok, so I did a bit of debugging with Eclipse and found that AFTER the formula sid is processed the HSSFRecordStream and MissingRecordAwareListerner classes have the correct value of the formula, namely "AB" contained in the lastRec and rec variables. I have read the mailing lists and seen reference to the fact that in order to get the value of the string formula you need to process the record after the formula. If this is the case, then how do I get to do this in XLS2CSVmra? Once it is passed back to the listener, the value is lost. I have attached some debug screens showing the point in code. 2008/12/9 Nick Burch <[EMAIL PROTECTED]> > On Tue, 9 Dec 2008, Des Hartman wrote: > >> I am using XLS2CSVmra to parse a very simple XLS file, but I am getting >> some weird results. It seems the FormulaRecord case is not recognising >> string formulas. >> > > Unless you have very specific needs, I'd suggest you try the hssf usermodel > instead. XLS2CSVmra opperates at a very low level, on the records, and is > exposed to lots of excel oddities. The hssf usermodel hides that sort of > thing from you > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Thanks Des Hartman
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
