On Tue, 7 Aug 2007, Karr, David wrote:
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.
You'd need to code quite a bit of that up yourself. For starters, you'd need to track the cells, and store them somewhere so you can reference them
One example of event usermodel code that tracks what cells it has seen is the XLS 2 CSV code (that's also missing record aware):
http://svn.apache.org/repos/asf/poi/trunk/src/scratchpad/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java That might prove a helpful starting point for you. Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
