wood burning stoves 2.0*
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 Spring in Action this week in the Spring 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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Streaming an xcel file using servlets