jQuery in Action, 2nd edition*
The moose likes JSP and the fly likes Modifying and Saving Excel Sheets on a JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Modifying and Saving Excel Sheets on a JSP" Watch "Modifying and Saving Excel Sheets on a JSP" New topic
Author

Modifying and Saving Excel Sheets on a JSP

Satish Gopalakrishnan
Ranch Hand

Joined: Feb 13, 2001
Posts: 52
I would like to know the methodology to modify excel sheets and save them from a JSP where they are displayed .
I have a page with two frames. One in which an Excel sheet is displayed. I want to the user to have the ability to save the changes he made by pressing a Save Button in the other frame . What is the best way to go about doing this. Any suggestions?
Sachin Joshi
Ranch Hand

Joined: Mar 23, 2004
Posts: 43
Originally posted by Satish Gopalakrishnan:
I would like to know the methodology to modify excel sheets and save them from a JSP where they are displayed .
I have a page with two frames. One in which an Excel sheet is displayed. I want to the user to have the ability to save the changes he made by pressing a Save Button in the other frame . What is the best way to go about doing this. Any suggestions?




Hi Satish,

I do not know about your application requirements. But, usually we use Excel files for display and storage of application data. The modifications you can easily carry out using JSP pages. Later the modifications can be saved back to Excel.

To answer your query, there is a API on ( !! it is Jakarta Stuff !! No cost) Jakarta site that allows you to read and write Excel files. That jakarta project is Jakarta POI project.
Now you need to display the Excel file and save the changes done by the user. So, you can use this Jakarta API to read and display Excel file as well as to save the changes to the Excel file.

(I have not used this API much,so you need to diggin more if you need. )


Regards,
Sachin
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Modifying and Saving Excel Sheets on a JSP
 
Similar Threads
how to put the entire excel files with multiple sheets in the web via jsp
How To compare two excel sheets using java
Saving JSP output to a File with extension .xls
How to Export web page(jsp page) to excel using jsp or servlets
JSP Export to Excel with multiple pages