• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Modifying and Saving Excel Sheets on a JSP

 
Satish Gopalakrishnan
Ranch Hand
Posts: 52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 43
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic