Today, EPPlus is mature, powerful, and actively maintained. It handles everything from simple DataTable exports to complex financial models with formulas and styling. However, it is no longer free for commercial use (starting with version 5). If your budget allows for the license, it is arguably the best experience you will find in the .NET ecosystem.
// Add a worksheet var worksheet = package.Workbook.Worksheets.Add("Sheet1");
var worksheet = package.Workbook.Worksheets.Add("Sheet1"); worksheet.Cells["A1"].Value = "Hello World"; worksheet.Cells["A1"].Style.Font.Bold = true; epplus
using (var package = new ExcelPackage())
// Set cell data worksheet.Cells["A1"].Value = "Hello, World!"; Today, EPPlus is mature, powerful, and actively maintained
EPPlus is incredibly fast. It does not require Excel to be installed on the server (a massive advantage over Interop), and it is optimized for memory management.
using OfficeOpenXml;
But Arjun knew.
EPPlus, he remembered from the documentation, wasn’t just a writer. It maintained a full object model of the spreadsheet in RAM: styles, formulas, comments, hidden rows. Every cell you touched became a ExcelRangeBase object, a tiny ghost in memory. After three years of patches and feature creep, his app was loading the entire source template—all forty-two sheets, all conditional formatting, all pivot caches—just to write a single new column of data. If your budget allows for the license, it
: Support for spreadsheet protection and encryption. Getting Started with EPPlus
“You’re not writing Excel,” he muttered. “You’re resurrecting a corpse every time.”