File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes Streaming an xcel file using servlets 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 » Products » Other Open Source Projects
Bookmark "Streaming an xcel file using servlets" Watch "Streaming an xcel file using servlets" New topic
Author

Streaming an xcel file using servlets

sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
How do I read an excel file using servlets. I have done it using poi. But I want to avoid using poi libraries.
Any way out?
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Read it and do what? If you just want someone to upload an Excel file and save it then use a file upload library.
sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
I would like to be able to open the file in excel format n the browser.
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Then just stream it to the client; if their browser is set up correctly they'll be asked to open or save it.
sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
In order for a servlet to open it I have to set the content type correct? Not sure what else I have to do.
But how do I set the content type;
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

See the ServletResponse docs.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Streaming an xcel file using servlets
 
Similar Threads
How to read excel2007 file or both .xls and .xlsx files using apache poi
how to insert a file object in excel sheet using java
xml to ms word
Excel Generation using POI
Excel tab focus issue