Question 1

How do I export a list of objects to CSV with CsvExport?

Accepted Answer

Use the AddRows method on a CsvExport instance with your List<T>. For example, create an export, call export.AddRows(yourList), then use export.Export() to get the CSV string. This automatically maps object properties to columns based on their names.

Question 2

Is CsvExport better than CsvHelper for performance?

Accepted Answer

Yes, CsvExport is significantly faster and more memory-efficient according to benchmarks, but CsvHelper offers more features like CSV reading and extensive customization. Choose CsvExport if speed is critical; otherwise, CsvHelper might be better for full-featured CSV processing.

Question 3

Can CsvExport handle large datasets without running out of memory?

Accepted Answer

Yes, its design emphasizes low memory usage, making it suitable for large exports. Benchmarks show it allocates less memory, but for extremely large datasets, consider incremental exports or streaming to further optimize performance.

Question 4

How does CsvExport ensure dates are exported correctly for different timezones?

Accepted Answer

It exports dates in a timezone-proof format, typically using a consistent ISO-like string, to avoid confusion when CSV files are shared across regions. This helps maintain data integrity without manual timezone adjustments.

Question 5

What .NET versions is CsvExport compatible with?

Accepted Answer

As a .NET Standard 2.0 library, it's compatible with .NET Core 2.0+, .NET Framework 4.6.1+, and modern .NET versions like .NET 5/6/7/8. This ensures broad support across different development environments.

Question 6

How to customize the CSV delimiter or separator in CsvExport?

Accepted Answer

Pass the columnSeparator parameter in the constructor, e.g., new CsvExport(columnSeparator: ";"). This allows you to use semicolons, tabs, or other characters as delimiters, with options to include a preamble for Excel compatibility.

CsvExport

What is CsvExport?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Open Source Alternative To

Frequently Asked Questions