how i can convert a Excel file to a CSV(or text) file using java code
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?
Re: how i can convert a Excel file to a CSV(or text) file using java code
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?
dries <firstname.lastname@example.org> wrote in message
> 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.
Input purposes, for one reason...
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.
Originally Posted by Paul Clapham
Maybe he's got 5000 excel files to convert....?
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......
apache commons poi
I've used the commons POI library several times to read/write excel files.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL