Thanks Karel but Luke and I have been doing a bit of work on this - http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java.
Lately, there is a pluggable version of the same where you simply create a customised subclass of a handler to convert the Excel into CSV in the specific format that you require. Currently, we have an Excel handler, one that conforms to UNIX specifications and another to the RFC4180 document that lays out the spec for CSV files whose MIME type is 'text/csv'. One I get a few loose ends tied up, that will be uploaded as an example. The code works for both binary and OOXML based workbook files but, as it uses the usermodel for both, it will be somewaht slower, if used to process large SpreadsheelML files, than Nick's XLS2CSV as that uses the eventmodel. Yours Mark B Karel Vanroye wrote: > > I know it is to XSL to XML and using perl, but it looks easier as the java > code shown below.... > http://www.perlmonks.org/?node_id=635459 > > > > Luke_Devon wrote: >> >> Hi >> >> I wanted to convert some XLS files into CSV. I found that apache.poi is >> the most perfect tool. Since I'm a beginner , i have no idea how to do >> that . Can some body help me please ? Do you have sample code for convert >> xls into csv ? >> >> Thanks in Advance >> Luke >> >> >> >> Get your preferred Email name! >> Now you can @ymail.com and @rocketmail.com. >> http://mail.promotions.yahoo.com/newdomains/aa/ >> > > -- View this message in context: http://old.nabble.com/Convert-XLS-into-CSV-tp28175999p28494283.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
