poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eli Spizzichino ...@javanet.info>
Subject Re: Create Excel worksheet from CSV automatically
Date Tue, 14 Mar 2006 22:33:01 GMT
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 ...


sue yi wrote:
> 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-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

View raw message