Code Examples
From zero to spreadsheet in minutes.
using OfficeOpenXml;
using System.IO;
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using var package = new ExcelPackage();
var sheet = package.Workbook.Worksheets.Add("Sales");
// Headers
sheet.Cells[1, 1].Value = "Product";
sheet.Cells[1, 2].Value = "Q1";
sheet.Cells[1, 3].Value = "Q2";
sheet.Cells[1, 4].Value = "Total";
// Data + formula
sheet.Cells[2, 1].Value = "Widget A";
sheet.Cells[2, 2].Value = 1200;
sheet.Cells[2, 3].Value = 1500;
sheet.Cells[2, 4].Formula = "B2+C2";
sheet.Cells.AutoFitColumns();
package.SaveAs(new FileInfo("sales.xlsx"));
using OfficeOpenXml;
using System.IO;
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using var package = new ExcelPackage(new FileInfo("sales.xlsx"));
var sheet = package.Workbook.Worksheets[0];
int rows = sheet.Dimension.Rows;
int cols = sheet.Dimension.Columns;
for (int r = 1; r <= rows; r++)
{
for (int c = 1; c <= cols; c++)
Console.Write($"{sheet.Cells[r, c].Value,-15}");
Console.WriteLine();
}
using OfficeOpenXml;
using OfficeOpenXml.Drawing.Chart;
// ... setup sheet with data first ...
var chart = sheet.Drawings.AddChart("Revenue", eChartType.ColumnClustered);
chart.Title.Text = "Quarterly Revenue";
chart.SetPosition(6, 0, 1, 0);
chart.SetSize(600, 350);
var series = chart.Series.Add(
sheet.Cells["B2:C4"], // values
sheet.Cells["A2:A4"] // categories
);
series.Header = "Revenue ($)";
public record Order(int Id, string Product, decimal Amount, DateTime Date);
var orders = new List<Order>
{
new(1, "Widget A", 120.50m, DateTime.Today),
new(2, "Widget B", 89.99m, DateTime.Today.AddDays(-1)),
new(3, "Gadget X", 340.00m, DateTime.Today.AddDays(-2)),
};
// Load the list — EPPlus maps property names to column headers automatically
sheet.Cells["A1"].LoadFromCollection(orders, printHeaders: true);
// Apply a date format to the Date column
sheet.Column(4).Style.Numberformat.Format = "yyyy-mm-dd";
sheet.Cells.AutoFitColumns();
using OfficeOpenXml.Style;
using System.Drawing;
// Bold green header row
using (var header = sheet.Cells[1, 1, 1, 4])
{
header.Style.Font.Bold = true;
header.Style.Font.Color.SetColor(Color.White);
header.Style.Fill.PatternType = ExcelFillStyle.Solid;
header.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(0x1D, 0x6F, 0x42));
}
// Currency format on column D
sheet.Column(4).Style.Numberformat.Format = "$#,##0.00";
// Thin border around data range
using (var data = sheet.Cells[1, 1, 5, 4])
{
data.Style.Border.Top.Style = ExcelBorderStyle.Thin;
data.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
data.Style.Border.Left.Style = ExcelBorderStyle.Thin;
data.Style.Border.Right.Style = ExcelBorderStyle.Thin;
}
