FileExporter

FileExporter is a lightweight C# library that simplifies file export operations in .NET applications. With support for exporting data to CSV, Excel (XLSX), and PDF formats, FileExporter provides an intuitive interface for developers to quickly generate and download files.

Features

Easy Exporting: Simply call ToCsv(), ToXlsx(), or ToPdf() on your data collection to export to the desired format. Automatic Splitting: Handles large datasets by automatically splitting files if the maximum line count or file size is exceeded, then zipping them for easy download. Flexible Configuration: Customize export settings such as column headers, delimiter, and more to suit your needs. Effortless Integration: Seamlessly integrate FileExporter into your existing .NET projects with minimal setup. Helper Extension Methods: Use ToFileFormat(ExportType.Excel) as an alternative to directly calling ToCsv(), ToXlsx(), or ToPdf().

Installation

You can install FileExporter via NuGet Package Manager by running the following command:

Install-Package FileExporter

Usage

Here's a quick example of how to use FileExporter to export data to a CSV file with old way which is still supported:

using FileExporter; // Define your data var data = new List<MyDataClass> { new MyDataClass { Name = "John Doe", Age = 30, Email = "john@example.com" }, new MyDataClass { Name = "Jane Smith", Age = 25, Email = "jane@example.com" } }; // Export data to CSV var exportedFile = data.ToCsv().ToFile(); // Return the exported file to the caller return exportedFile;

Starting from release 3.3.0, FileExporter supports exporting data using fluent rules.

Fluent Rules Example

First, create an ExportRule for your model. In the constructor, call GenerateRules() to automatically create default rules based on the model. To customize the setup, use the RuleFor() method to configure specific rules for your model's properties. Here's a quick demonstration:

Model Example:

public class FileData { public long Id { get; set; } public string Name { get; set; } public string Description { get; set; } public DateTime CreatedAt { get; set; } public string? Comment { get; set; } }