Ok, I'm at least going to experiment with this. I've taken that event listener skeleton and I've started to add in all the other events that are hit in processing my spreadsheet, just for more information.
What I have to figure out eventually, is how I can get to the point where I can do the same thing as my "usermodel" application, where given a specific row and cell, what the value is in the cell. The cell could be a formula that refers to another cell, so that all has to work. In my usermodel app, I have a "getCellValue(HSSFRow row, HSSFCell cell)" method. It checks the cell type, and handles each cell type. If it's a formula, it uses the formula evaluator to get the cell value. > -----Original Message----- > From: Steve Widmar [mailto:[EMAIL PROTECTED] > Sent: Monday, August 06, 2007 7:37 PM > To: POI Users List > Subject: RE: Still struggling with "Coding Error: Expected > ExpPtg to be converted from Shared to Non-Shared Formula" > > > I'm guessing the difference between the usermodel and the eventmodel > is similar to DOM and SAX for XML? > > Similar, I agree. I've only played with eventmodel. > > I dug out some old code based on an online example, it > probably looks a lot like > http://poi.apache.org/hssf/how-to.html#event_api > > With that, I was able to see all of the 256 column cells and > their values in all of the columns (A-IV) in the one row that > I put formulas. > > So it looks like the eventmodel (or eventusermodel) has a > chance of being helpful for wide sheets; at least it doesn't > stop at some arbitrary column. > > You may have some refactoring ahead if you go this route, hehe. > > Cheers, > Widmar > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
