Zeyt.ExcelDocument is a powerful and easy-to-use C# library designed for generating Excel documents from object lists. The library allows you to map object properties to Excel columns with custom names, widths, and even default values for fields with missing data. It also provides an easy way to export this data to .xlsx
format.
- Customizable Mappings: Easily map object properties to Excel columns.
- Fluent API: Set column names, widths, and default values for null fields.
- Quick Export: Convert object lists into Excel files in just a few lines of code.
- Null Field Handling: Define default values for fields with missing data.
You can install the package via NuGet Package Manager:
Install-Package Zeyt.ExcelDocument
Or via .NET CLI:
dotnet add package Zeyt.ExcelDocument
Here is a basic example of how to use the Zeyt.ExcelDocument library:
using Zeyt.ExcelDocument;
var customerList = new List<Customer>
{
new Customer { FirstName = "James", LastName = "Butt", Age = 23, Email = "james@james.com" },
new Customer { FirstName = "Art", LastName = "Venere", Age = 33, Email = "art@venere.com" },
new Customer { FirstName = "Sage", LastName = "Wieser", Age = 57, Email = null },
new Customer { FirstName = "Minna", LastName = "Amigon", Age = 45, Email = "minna@amigon.com" },
new Customer { FirstName = "Blair", LastName = "Malet", Age = 66, Email = null },
};
// Map customer data to Excel and export it to a file
var customerExcelData = new ExcelDocumentWriter<Customer, CustomerExcelMap>("Customer Information").Write(customerList);
File.WriteAllBytes(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Customer.xlsx"), customerExcelData);
The mapping is done using a separate ExcelDocumentMap<T>
class. In this example, we create a custom mapping for the Customer
class:
public class CustomerExcelMap : ExcelDocumentMap<Customer>
{
public CustomerExcelMap()
{
Map(x => x.FirstName).Name("Full Name").Width(30).WriteUsing(x => $"{x.FirstName} {x.LastName}");
Map(x => x.Age).Name("Age").Width(10);
Map(x => x.Email).Name("Email").Width(50).Default("EMPTY");
}
}
This is the class we are mapping to Excel columns:
public class Customer
{
public string? FirstName { get; set; }
public string? LastName { get; set; }
public int? Age { get; set; } = 0;
public string? Email { get; set; }
}
This project is licensed under the MIT License - see the LICENSE file for details.