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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 9 of 9

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

  1. #1
    dries Guest

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


    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.


  2. #2
    Paul Clapham Guest

    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?

    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.
    >




  3. #3
    Join Date
    Jun 2007
    Posts
    1

    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.


  4. #4
    Join Date
    Jul 2005
    Posts
    78
    Quote Originally Posted by 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

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

  5. #5
    Join Date
    Dec 2004
    Location
    San Bernardino County, California
    Posts
    1,468

  6. #6
    Join Date
    Jul 2007
    Posts
    3
    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......

  7. #7
    Join Date
    Nov 2008
    Posts
    1

    apache commons poi

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

  8. #8
    Join Date
    Nov 2008
    Posts
    8
    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

  9. #9
    Join Date
    Nov 2007
    Posts
    3
    You can try this one:
    http://www.smartxls.com/indexj.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center