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.

HTH's,
Steve.

-- 
"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
and
its worksheets and create multiple csv files.  Just thought I would ask.

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

Thanks!


-----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
it
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
an
SQL
> queries Result Set into a Excel Spreadsheet.  This was easy and it
works
> great.
>
> I recently got a request from a customer to modify the utility to
allow
for
> the result set to be written to a Comma Separated Value(CSV) file.
Does
POI
> 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

Mime
View raw message