• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Modifying and Saving Excel Sheets on a JSP

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
The knights of nee want a shrubbery. And a tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic