Monday, September 28, 2015

Create Excel file in .net

I needed to create an excel file programmatically. These are open source routines, CreateExcel.vb, that handles this work. It utilize to Microsoft DocFormat.OpenXML library under the covers to create the actual file. So you have to add the appropriate dll to your references.

this codeproject has the code for this.
http://www.codeproject.com/Articles/692092/A-free-Export-to-Excel-Csharp-class-using-OpenXML

developers site:
http://mikesknowledgebase.azurewebsites.net/pages/CSharp/ExportToExcel.htm#

No comments:

Post a Comment