I have got some reports which are to be exported to excel in a single workbook on multiple sheets.
This is the article where I got a sample.
It works fine. Now my qustion is how to make it work for multiple sheets having different formats and data tables.
I think this asks for some XSL expertise. I have basic knowledge of xsl but not detailed.
My environment is Win2K, .Net 1.0, IIS 5, Excel 2002 SP1. Database SQL Server 2000