File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes Uploading and Retrieving Excel file on Server and Client? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » Servlets
Reply Bookmark "Uploading and Retrieving Excel file on Server and Client? " Watch "Uploading and Retrieving Excel file on Server and Client? " New topic
Author

Uploading and Retrieving Excel file on Server and Client?

Stephen Wei
Ranch Hand

Joined: Oct 09, 2001
Posts: 73
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.
1:
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?
2:
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


Sun Certified Programmer for Java Platform
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Uploading and Retrieving Excel file on Server and Client?
 
Similar Threads
JSP/Servlet With MS Excel?
display output table in excel file format
Export to excel question
How to store a table's data from oracle database into an excel file?
Architecture of FBN