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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: "POI User List (E-mail)" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
