Create Excel worksheet from CSV automatically

[sue yi]

Hello,

Right now I have a java program that generates csv files, but I want it to
generate Excel files. Is there a utility function in HSSF that can just take
as input a CSV file and delimiter, and automatically generate the Excel? I
just want something with about the same functionality as when you import a
csv file normally into Excel.

Thanks ... please let me know if it's out there ... otherwise I probably
have to write it.

-sue yi

[Eli Spizzichino]

Hi sue yi,
First, if your code already write csv file with few line modification
can write directly xls files with POI.
Second I didn't saw an already made utility function for this.
You can read the csv file line by line, StringTokenize it and make a
simple iteration over the result tokens to populate the HSSFCell value.
If you need to manage them in some way I advice you use an already made
CSV (and other) parser like sourceforge.net/projects/pzfilereader to
not reinvent the ...

regards
Eli

Post by sue yi
Hello,
Right now I have a java program that generates csv files, but I want it to
generate Excel files. Is there a utility function in HSSF that can just take
as input a CSV file and delimiter, and automatically generate the Excel? I
just want something with about the same functionality as when you import a
csv file normally into Excel.
Thanks ... please let me know if it's out there ... otherwise I probably
have to write it.
-sue yi

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-***@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/