This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action 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