To export the dynamic contents into Microsoft Excel’s multiple sheets.
JSP:
Through JSP the data could be added to the xls by setting the content type as “vnd.ms-excel” as below
response.setContentType("application/vnd.ms-excel");
But the data could only be appended to single sheet of the spreadsheet. Formatting of data will be difficult
JavaScript:
Java script dose not have any ready to access objects [...]

Continue reading about How to Export Data to Multiple sheets of Microsoft Excel Using VBScript