poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hill, Steve" <steve.h...@timesys.com>
Subject RE: Can POI create a CSV file?
Date Thu, 03 Jul 2003 19:32:03 GMT
Just figured I would chime in here seeing I have done such things in the
past.  Please remember you will need to either replace comma's in the
document with another character or else escape them if you do not want
to run into problems.

I personally quote the entire field if there is a comma in the field and
then escape the quote's if need be.  This is also the way Microsoft
exports to CSV so it is great for compatibility.


"Winston, you are drunk." - Lady Astor
"Yes my dear, but you are ugly, and in the morning I shall be sober" -
Winston Churchill

-----Original Message-----
From: Knepp, Ethan [mailto:eKnepp@c-cor.net] 
Sent: Thursday, July 03, 2003 3:26 PM
To: 'POI Users List'
Subject: RE: Can POI create a CSV file?

Ya, I didn't know if there was a utility api that would take a WorkBook
its worksheets and create multiple csv files.  Just thought I would ask.

I will just resort to a solution similart to your suggestion Nate


-----Original Message-----
From: Nate [mailto:nmcminn@charter.net]
Sent: Thursday, July 03, 2003 3:27 PM
To: POI Users List
Subject: Re: Can POI create a CSV file?

I don't think that POI can do this, but it begs the question: Why bother
with the extra overhead?  Just build a StringBuffer and append a row to
for each row in the resultset.  Very fast, very easy.

--Nathan McMinn

----- Original Message -----
From: "Knepp, Ethan" <eKnepp@c-cor.net>
To: "POI User List (E-mail)" <poi-user@jakarta.apache.org>
Sent: Thursday, July 03, 2003 2:17 PM
Subject: Can POI create a CSV file?

> I currently am using the POI's HSSF to write the entire results from
> queries Result Set into a Excel Spreadsheet.  This was easy and it
> great.
> I recently got a request from a customer to modify the utility to
> the result set to be written to a Comma Separated Value(CSV) file.
> have any utility methods/APIs to write to CSV files?
> Thanks,
> Ethan

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

View raw message