Hi
I have a way of saving the output generated from a
JSp file into to a excel file by modifiying the Headers. The code looks like this
String fname=abc.xls
response.setContentType("file_content_type);
response.setHeader("Content-disposition","attachment;filename="+fname)
The output is saved to a Excel file abc.xls
IT THERE A WAY TO SAVE THE OUTPUT IN DIFFERENT TABS IN THE EXCEL FILE.
For example : Output1 - to be saved in abx.xls on excel tab TAB1
Output2 - to be saved in abc.xls on excel tab TAB2
and so on
Please help me