how i can convert a Excel file to a CSV(or text) file using java code

[dries]

Help!!!!

ik need some java code: how i can convert a Excel file (spreadsheets) to
a CSV(or text file) file using java code.
is that possible?

thanks!!! dries.

[Paul Clapham]

Why would you want to go to all the trouble of using Java when you can just
do "Save As..." from Excel and change the file type to CSV?

PC2

dries <chdries@hotmail.com> wrote in message
news:3a82b7f2$1@news.devx.com...
>
> Help!!!!
>
> ik need some java code: how i can convert a Excel file (spreadsheets) to
> a CSV(or text file) file using java code.
> is that possible?
>
> thanks!!! dries.
>

[pMcGinty]

If Java can be used to convert the data on an excel file to a plain text file, then it would be as simple as using a buffered reader to input the data from said text file into an application. Personally, this would help immensely with a program I am making that takes an excel file or a text file, extracts the data, allows the data to be manipulated, then outputs it to an excel or a text file. Of course, it is more complicated to deal with excel files, but much more imperative since the data involves tabs and it looks much better if the data is in an excel file than an ordinary text file. Thanks for any help.

[masher]

Why would you want to go to all the trouble of using Java when you can just
do "Save As..." from Excel and change the file type to CSV?

PC2

Maybe he's got 5000 excel files to convert....?

[nspils]

You can use JDBC to ODBC connection:

http://forum.java.sun.com/thread.jspa?threadID=181725

http://saloon.javaranch.com/cgi-bin/...c&f=3&t=000342

http://www.javaworld.com/javaworld/j...629-excel.html

[webr]

Ya u can use jxl API to read the content from EXCEL sheet & and use File class of java to create text file with the retrieved content......

[shale]

I've used the commons POI library several times to read/write excel files.

[xeel]

http://poi.apache.org/apidocs/org/ap...LS2CSVmra.html
or
http://poi.apache.org/apidocs/org/ap...Extractor.html

depends on what exactly you want...

edit: sry shale didn't see you

[liqdok]

You can try this one:
http://www.smartxls.com/indexj.htm