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 JavaScript Promises Essentials this week in the JavaScript 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