Zep, I agree with Mike. Your solution will require * Excel installed on each client pc * Users must (temporarily) save the file on there PC * File will need to be uploaded.
You may find browser security issues when trying to do local-save and upload behind the scenes (without user noticing temporary file save step). Unless you are writing a small tool to be used by a select few users, the approach won't take you far. For more sophisticated control you may want to explore other alternatives. In one of our commercial product, we provided a swing based worksheet editor (using JTable) that stored the data in a internal form. This internal form would then be converted into excel workbook using POI (on demand). Also there are tools that use AJAX techniques to create a spreadsheet editor within the browser (see google spreadsheet for example). Regards, Tahir > -----Original Message----- > From: Donahue, Michael [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 8:53 PM > To: POI Users List > Subject: RE: Read Excel sheet after editing it inside the browser > > Zep - > > I'm pretty sure you are going to have to save the file locally and then > upload the file back to the server as a regular file upload. Not the > prettiest solution, unless you want to write your own web based GUI or > plug-in for Excel files. > > Good luck... > > - Mike > > --- > Michael J. Donahue > Vangent, Inc. > 845 Capitol Drive SW. (CRW - 500) > Cedar Rapids, IA 52404 > office: 319-841-4941 > fax: 319-841-4985 > email & IM: [EMAIL PROTECTED] > --- > That's when I made up my mind to keep one foot in the Ideal Plane and > the other in the real world. --Father Mulcahy M*A*S*H > > -----Original Message----- > From: Zep [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 7:56 AM > To: [email protected] > Subject: Read Excel sheet after editing it inside the brower > > > Hi everyone! > > I've successfully opened an Excel file inside the browser, but now after > editing the sheet, I'm needing to submit the file to read it from a > Servlet. > > In other words I need this: > step 1: display an Excel sheet inside the browser (successfully done). > step 2: edit the sheet (successfully done). > step 3: send the sheet data to a Servlet to read it. > > - Im using IE 6 > > Anyone could help me? > Thanks a lot!!! > -- > View this message in context: > http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe > r-tf3369115.html#a9374164 > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > ************************************************************************** > ** > This email may contain confidential material. > If you were not an intended recipient, > Please notify the sender and delete all copies. > We may monitor email to and from our network. > ************************************************************************** > ** > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
