EPPlus-Create advanced Excel spreadsheets on the server
Take a look to the ExcelReportGenerator.cs on Folder Reporting
or
see
http://epplus.codeplex.com/