Easy.ExportToExcel

A simple C# library to export data to an Excel file

Ever wanted to easily create a real Excel file in C#, from your DataSet, DataTable or List data ? Now you can.

To add this library to your project:

1. In Visual Studio, click on "Tools\NuGet Package Manager\Manage NuGet Packages for Solution.."
2. Search for "Easy.ExportToExcel"
3. Install the package
4. In your code, simply add call the CreateExcelDocument() function, telling it the name of the Excel file to create, and where your data is stored.

// Step 1: Create a DataSet, and put some sample data in it
DataSet ds = CreateSampleData();

// Step 2: Create the Excel .xlsx file
try
{
    string excelFilename = "C:\\Sample.xlsx";
    CreateExcelFile.CreateExcelDocument(ds, excelFilename);
}
catch (Exception ex)
{ 
    MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message);
    return;
}

You can read more about this project on my CodeProject article.

And you can follow my other work on my Mikes Knowledge Base website.

Mike Gledhill