slaguila
02-07-2008, 02:08 AM
I have my report that sends all data into a spreadsheet in excell. Now the workbook only have one worksheet but the user wants to have more than one sheet.
I am using this for the workbook creation:
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition","attachment; filename=myexcelfile.xls");
response.setHeader("Cache-Control","private");
response.setHeader("pragma", "");
response.setHeader("Expires", "0");
How can I create more than one worksheet to put the data?
Thank You!
I am using this for the workbook creation:
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition","attachment; filename=myexcelfile.xls");
response.setHeader("Cache-Control","private");
response.setHeader("pragma", "");
response.setHeader("Expires", "0");
How can I create more than one worksheet to put the data?
Thank You!