|   Contact  

Library to Generate Excel XML Workbooks in .NET

Excel Xml Writer 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.

There are many commercial tools to generate Excel workbooks, including SoftArtisans ExcelWriter.
My tool has nothing to do with any of those.
This tool was written entirely in C# by me.


Download

I'm constantly making updates to the ExcelXmlWriter library fixing bugs and adding features, so if you want to know when a new release is dropped, send an email to updates@carlosag.net and I will send you an email when a new update is ready.

Click the link to start downloading the DLL you need: "NON-STRONGLY NAMED" (30 kb) | "STRONGLY NAMED VERSION" (30 kb)

Number of Downloads: <%= string.Format("{0}", Globals.Downloads["ExcelWriter.zip"]) %>
If you are unsure of which version, use the "NON-STRONGLY NAMED".

Click Here to Start Downloading the Help file (zip) (180 kb)

Number of Downloads: <%= string.Format("{0}", Globals.Downloads["ExcelWriter.chm"]) %>

Some useful information


This is a MUST SEE!!!

NEW!!! Code Generator (CarlosAg.ExcelXmlWriter.Generator)

FAQ (Frequently Asked Questions) | Sample | Code Samples

History:

v1.0.0.6 Released: 08/27/2005
  • Fixed a problem with Named Ranges in WorkSheet's
  • Changed the Prefix for SpreadSheet Namespace to be just 's', this makes the size much smaller
  • Now all prefixes are declared in the root element and re-used the way it should be
  • Again a lot of new properties including support for Links and References in external books
v1.0.0.4 Released: 02/20/2005
  • There are tons of new properties now supported, including AutoFilter, NamedCell's and NamedRange's.
  • New!!! I have uploaded the new Code Generator (CarlosAg.ExcelXmlWriter.Generator, that will automatically generate the code for you.
  • Added Support for DateTime
v1.0.0.3 Released: 11/09/2004
  • There are tons of new properties now supported.
  • New!!! Now you can Load an Xml Workbook back in the OM
  • Fix for the NumberFormat problem in previous version
v1.0.0.1 Released: 06/02/2004
  • The name of the library has changed to CarlosAg.ExcelXmlLibrary for legal reasons.
v1.0.0.1 Released: 03/08/2004
  • New Excel Xml Writer Library released.


Please send any comments, questions or features you would like to see to me@carlosag.net
The most important class is CarlosAg.ExcelXmlWriter.Workbook.
For example, the following code generates a simple Excel worksheet with one cell:
using CarlosAg.ExcelXmlWriter;

class TestApp {
    static void Main(string[] args) {
        Workbook book = new Workbook();
        Worksheet sheet = book.Worksheets.Add("Sample");
        WorksheetRow row =  sheet.Table.Rows.Add();
        row.Cells.Add("Hello World");
        book.Save(@"c:\test.xls");
    }
}

Carlos Aguilar Mares © 2011