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

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).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.