954,600 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Creating multisheet excel

Is is possible to create excel file with multiple workseets using response.setContentType.?

babbu
Posting Whiz in Training
208 posts since Jun 2009
Reputation Points: -1
Solved Threads: 23
 

Why wouldn't it be possible to send one? Of course, you have to "create it" beforehand and then simply send it to the ouput stream after setting the content type.

As far as creating it, Google "Apache POI HSSF" (or "Apache POI XSSF" for Office 2007 or later).

masijade
Industrious Poster
Moderator
4,253 posts since Feb 2006
Reputation Points: 1,471
Solved Threads: 494
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You