DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

7
shouts

Shout it

Web 2.0 | Did you know.. How to generate Excel 2007 file in C#?

published 714 days, 1 hour, 51 minutes ago posted by

farooqkaiser 715 days, 23 hours, 58 minutes ago

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 =...