This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes Java in General and the fly likes Converting .xls to csv Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Converting .xls to csv" Watch "Converting .xls to csv" New topic

Converting .xls to csv

Andrew Mcmurray
Ranch Hand

Joined: Sep 24, 2005
Posts: 188
Hi all

Ok so I can read a .xls file using HSSF, but now I need to convert it to a .csv file so another process can use it. Is there an easy way to do that using POI other then manually rebuilding the file?


Ulf Dittmer

Joined: Mar 22, 2005
Posts: 39578
POI doesn't support CSV, but the Ostermiller Utils do.

Ping & DNS - updated with new look and Ping home screen widget
Andrew Mcmurray
Ranch Hand

Joined: Sep 24, 2005
Posts: 188
Thanks Ulf

I agree. Here's the link:
subject: Converting .xls to csv
Similar Threads
conversion of .xls file into .csv
create csv file
Downloading the jsp as .csv file.
Create .csv from .xls
How to validate a file is a CSV file, or at least a text file?