I'm using HSSF to populate table models in an interactive xls cleaner at the front end of a data acquisition system. I add a worksheet with some meta data on it to the workbook and then write it back to the xls file. Subsequent data normalization processes use the meta data.
I'd like to gen an event when an HSSFCell in the workbook gets a new value from my app. Then my table models could automatically update, in a WYSIWYG manner, showing the user the metadata before it goes back into the xls file. Things are working acceptably now, i.e. the meta data does show up in the file, and can be displayed by reading it back but that seems a little klunky in the swing world. I had a look at the event model, but but it seems to focus on generating events to build the workbook (or some other model) as an xls stream is parsed. Have I missed something, or do I have to add cell-update events if I want them ? Bill.
