Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Uploading and Retrieving Excel file on Server and Client?  RSS feed

Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everyone.
I am new to this Forum and new to Web System as well.
I have 2 questions regarding my current work. I will use Servlet and JSP on server side.
The User needs to select a excel file from the local computer in the browser, then click the UPLOAD button to submit the request to the server. The server will copy the excel file from the client to the server, then update the database according to the records in the excel file.
How to achieve this? Do I use MultipartParser class? Can Servlet/JSP extract data easily from Excel files?
The user needs to view the whole table data from a database on the client computer, in Excel.
How to do this? I use JDBC to extract all data from the database, then format the data in Html page on the server side?
How to let Excel show all the columns listed just like the real database?
Any suggestion is welcome. Thanks.

Sun Certified Programmer for Java Platform
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!