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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.