Howdy all, Minor issue I'm looking for practical hints on: Using: POI 3.7 beta1
Code is heavily based on the XLSX2CSV example program in the Apache examples svn. Modified to output to a file and in flat file format (not CSV). This is the event driven side, not the user side. Ie... I don't have any POI Excel Cell objects to work against...just the text and attributes read using the SAX parser. Everything works beautifully except for some number handling. Excel prefers to store some numbers in scientific notation. I need to output that to the flat file as an actual number (1E-2 converted to .01 or 0.01). In all of these generic number cases there are no format strings from Excel. The default handling in the above example code is to output the text as found. Option A: Simply test for the 'E' and convert as necessary. Some goofiness around precision I have to be careful of but doable. My question/concern: This feels clunky and I'm somewhat expecting it to miss other Excel peculiarities I haven't encountered yet. Has anyone else tried to handle this and run into any unforeseen problems?
