Epplus 4.5.3.2 ❲Ultimate • 2025❳

var worksheet = package.Workbook.Worksheets[0]; // First sheet var value = worksheet.Cells["A1"].Value?.ToString(); var number = worksheet.Cells["B1"].GetValue<double>(); Console.WriteLine($"A1: value, B1: number"); using OfficeOpenXml.Style; var ws = package.Workbook.Worksheets.Add("Styled");

// Add data worksheet.Cells["A1"].Value = "Hello EPPlus 4.5.3.2"; worksheet.Cells["B1"].Value = 123.45; // Auto-fit column worksheet.Cells["A:B"].AutoFitColumns(); // Save to file var file = new FileInfo(@"C:\temp\sample.xlsx"); package.SaveAs(file);

// Header style using (var range = ws.Cells["A1:C1"])

dotnet add package EPPlus --version 4.5.3.2 Compatible with .NET Framework 4.0+ and .NET Core 2.0+. 1. Creating an Excel File using OfficeOpenXml; using System.IO; class Program epplus 4.5.3.2

using (var package = new ExcelPackage(new FileInfo(@"C:\temp\sample.xlsx")))

var worksheet = package.Workbook.Worksheets.Add("Sheet1");

static void Main()

range.Style.Font.Bold = true; range.Style.Font.Color.SetColor(System.Drawing.Color.White); range.Style.Fill.PatternType = ExcelFillStyle.Solid; range.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.DarkBlue); range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

// Date ws.Cells["C2"].Value = DateTime.Now; ws.Cells["C2"].Style.Numberformat.Format = "yyyy-mm-dd hh:mm:ss"; ws.Cells["A2"].Value = 10; ws.Cells["A3"].Value = 20; ws.Cells["A4"].Formula = "SUM(A2:A3)"; // Result: 30 // Excel will calculate when opened, or you can force: ws.Calculate(); 5. Working with Ranges // Load data from a list var data = new List<dynamic>

: Always check your project’s license compatibility before deploying EPPlus 4.5.3.2 in production. Last updated: 2025 var worksheet = package

Install-Package EPPlus -Version 4.5.3.2 Or using .NET CLI:

new Name = "Alice", Score = 95 , new Name = "Bob", Score = 87 ; ws.Cells["A1"].LoadFromCollection(data, true); // true = headers

using (var package = new ExcelPackage()) Working with Ranges // Load data from a

// Number formatting ws.Cells["B2"].Value = 0.12345; ws.Cells["B2"].Style.Numberformat.Format = "0.00%"; // 12.35%