I'm using POI HSSF, and I need to dump Excel file into XML. I've wrote most of it, but still have one problem unresolved: I'm looking for a way to get numeric cells' content as a string, formatted exactly as they would be displayed by Excel itself. I mean, date 38629 in "DD.MM.YYYY" should yield "04.10.2005", and 2.25 in "# ?/?" should yield "2 1/4".
I haven't found a way to do that, and googling redirects me into HSSFDataFormat which is unrelated, I fail to form a relevant query. Is there a way do get that string representation? Is it already stored in Excel files with possibility to retrieve? Or maybe there's a formatter somewhere which I've overlooked? A converter from HSSF format to Java's NumberFormat and DateFormat (even if not universal)? Maybe any third-party solutions? I guess this problem should be pretty popular. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
