Library to generate Excel XML workbooks in .NET

I was looking at different ways to export and genrate Excel files for a specific project and I found this excellent free library written by Carlos Aguilar.

This library allows you to generate Excel Workbooks using XML, it is built 100% in C# and does not requires Excel installed at all to generate the files. It exposes a simple object model to generate the XML Workbooks.
It supports several features for generating Excel Workbooks including:

• Formatting
• Alignment
• Formulas
• Pivot Tables
• and more...

Note: This library is free, you can distribute it and use it at your own will and risk, it is not supported by any company including Microsoft or any other company, it does not belong to any company.

Read more...

Now even better Carlos has built a .Net code generator for Excel!

This is a tool that will generate the code in any .NET language to create Excel Xml Workbooks automatically for you. The reason I decided to do this application is because it gets really tricky to create complex Workbooks that support features like auto filter, sorting, etc. Especially if you are not familiar with the object model that I created for CarlosAg.ExcelXmlWriter. This tools solves that problem making it as easy as it gets to generate dynamic Excel worbooks that can be used from ASP.NET or any other .NET framework. Now adding to your application the ability to generate Excel workbooks is as easy as it gets.

Read more...