On Sun, 4 Nov 2012, Chris Bamford wrote:
I have tried this ReadMsOfficeFiles<http://codezrule.wordpress.com/2012/01/05/extract-text-from-ms-office-2007-files-docx-pptx-xlsx/> program and I think I may have found the cause of my particular issue i.e. text extraction of doubles gives very large scary looking numbers ("9.2999999999999999E-2" instead of "0.093").
If you want numbers that look like they do in Excel, you'll likely want to use DataFormatter to format the double values based on their formatting rules. Otherwise, you'll get the closest floating point representation of the number, which isn't always exactly the same...
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
