Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 97365 invoked from network); 14 Mar 2006 22:35:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 14 Mar 2006 22:35:52 -0000 Received: (qmail 91313 invoked by uid 500); 14 Mar 2006 22:35:50 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 91289 invoked by uid 500); 14 Mar 2006 22:35:50 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 91278 invoked by uid 99); 14 Mar 2006 22:35:49 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Mar 2006 14:35:49 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [66.199.228.234] (HELO mail.javanet.info) (66.199.228.234) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 14 Mar 2006 14:35:49 -0800 Received: (qmail 31557 invoked from network); 14 Mar 2006 22:35:24 -0000 Received: from unknown (HELO ?84.222.107.246?) (84.222.107.246) by javanet.info with SMTP; 14 Mar 2006 22:35:24 -0000 Message-ID: <4417449D.3030001@javanet.info> Date: Tue, 14 Mar 2006 23:33:01 +0100 From: Eli Spizzichino User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: POI Users List Subject: Re: Create Excel worksheet from CSV automatically References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 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/