Hi, What I'm wanting to do is pretty basic... a) convert an Excel file into XML (same as, say, opening in it Gnumeric and saving it in gnumeric format) b) convert an Excel file into CSV (sam as, say, opening it in Excel and saving it as a CSV) but in an automated way....hence I've arrived at POI.
It took me a matter of minutes to write something that is almost what i want but then I got to thinking that I must be re-inventing the wheel, people have probably already done this many times and more robust. Is there utility/tool within the API to already do this? I tried looking at the docs, the FAQ, the mailing list but couldn't find the answer. I also came across the nice & promising article at OnJava, http://www.onjava.com/pub/a/onjava/2003/04/16/poi_excel.html, and this says the following: <quote> Appendix 1 contains a complete example of using HSSF to create and return a workbook from a servlet. Example 1 reads in an Excel spreadsheet and converts it to comma-separated values. </quote> ..so 'Example 1' is exactly what I was looking for..... Unfortunately 'Appendix 1' *is* 'Example 1' ... and is the HSSF example. (the article also refers to a non-existent 'Example 3' as well!!!!) Before I start to re-invent the wheel and start coding, can someone point me to an equivalent of Example 1? and/or info about how to get Excel into the standard XML format used by HSSF, Gnumeric, etc.... Thanks Chris __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
