fairnet.com — You can do it using ExcelPackagethat provides server-side generation of Excel 2007 spreadsheets. You can download it from codeplex. Here is sample code to generate XLSX file using ExcelPackage. 1: FileInfo XLSXFile = new FileInfo(XLSXFileName); 2:using (ExcelPackage xlPackage = new ExcelPackage(XLSXFile)) 3: { 4: ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("Sheet1"); 5: 6:int row = 1; 7:foreach (DataRow dr in dataTable.Rows) 8: { 9:int col =...
original link