Re: Upload excel file using JSP and update the data into Oracle 9i database

From: Christophe Vanfleteren (c.v4nfl3t3r3n_at_pandora.be)
Date: 10/24/03


Date: Fri, 24 Oct 2003 20:34:41 GMT

sunflowergal wrote:

> Originally posted by Cin
>
>> hi,
>
>>
>
>> My office is using JSP, Weblogic and Oracle 9i.
>
>>
>
>> I was told to come out with a way to allow user to download an Excel
>
>> spreadsheet file. The Excel spreadsheet file was predefined
>> with column header. After user has completed/fill up the Excel file, they
>> are supposed to upload back to server and somehow it should be smart to
>> read what was the content in the Excel file and get the data and update
>> into Oracle 9i database.
>> Can anyone tell me is it possible to do it? And how should I do it?
>>
>> Thanks,
>
>>
>
> Cindy
>
>
> Hai cindy,
>
> I also have a situation like this. Did you resolve how to do that. If
> yes can u pls tell me how u did that. Thanks in advance.
>

Look at POI ( http://jakarta.apache.org/poi ). That library allows you to
read/write excel files.
You can use the Commons FileUpload to handle the uploading of the modified
excel file ( http://jakarta.apache.org/commons/fileupload/ )

-- 
Regards,
Christophe Vanfleteren


Relevant Pages