Easy.ExportToExcel 1.0.6

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. By default, this package works "out of the box" for C# WinForms applications.

There are two lines commented-out at the top of the "CreateExcelFile.cs" file. If your application is an ASP.Net Core application, please uncomment the first line. If your application is a regular ASP.Net application, please uncomment the second line.

//  #define USING_ASP_NET_CORE       //  Uncomment this line, if you're using ASP.NET Core 2+
//  #define USING_ASP_NET            //  Uncomment this line, if you're using regular ASP.NET

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