{"id":1687,"date":"2023-03-09T22:00:00","date_gmt":"2023-03-09T21:00:00","guid":{"rendered":"https:\/\/demo.sidekick.be\/itenium\/create-xlsx-excel-with-epplus-csharp\/"},"modified":"2025-11-28T13:31:47","modified_gmt":"2025-11-28T12:31:47","slug":"create-xlsx-excel-with-epplus-csharp","status":"publish","type":"post","link":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-epplus-csharp\/","title":{"rendered":"Create Excels with C# and EPPlus: A tutorial"},"content":{"rendered":"

<\/p>\n

\n

<\/p>\n

That\u2019s fine!<\/h1>\n

Quick tutorial about creating xlsx Excels with C# and the EPPlus nuget package<\/a>.<\/p>\n

\n

EPPlus Excel addresses are not zero based: The first column is column 1!<\/p>\n<\/blockquote>\n

Also, before writing any loops, you might want to check out the LoadFromXXX<\/code> methods. They are explained in depth in part 3 Import.<\/p>\n

The blog posts will only cover the most important functionality. More extensive code examples<\/a> can be found in the GitHub project.<\/p>\n

Quickstart<\/h1>\n

Without license<\/h2>\n

<\/a>JanKallman\/EPPlus<\/a>: The free one<\/p>\n

Install-Package EPPlus -Version 4.5.3.3\n<\/code><\/pre>\n
With license<\/h2>\n
<\/a>EPPlusSoftware\/EPPlus<\/a>: The not so free one<\/p>\n
Install-Package EPPlus\n<\/code><\/pre>\n
\u2026and ACTIVATE!<\/strong><\/p>\n
ExcelPackage.LicenseContext = LicenseContext.Commercial;\nExcelPackage.LicenseContext = LicenseContext.NonCommercial;\n<\/code><\/pre>\n
Key stored in EPPlus:ExcelPackage.LicenseContext<\/code>.<\/p>\n
Usage<\/h2>\n
using OfficeOpenXml;\n\nusing (var package = new ExcelPackage())\n{\n\tExcelWorksheet sheet = package.Workbook.Worksheets.Add(\"MySheet\");\n\n\t\/\/ Setting & getting values\n\tExcelRange firstCell = sheet.Cells[1, 1];\n\tfirstCell.Value = \"will it work?\";\n\tsheet.Cells[\"A2\"].Formula = \"CONCATENATE(A1,\" ... Of course it will!\")\";\n\tAssert.That(firstCell.Text, Is.EqualTo(\"will it work?\"));\n\n\t\/\/ Numbers\n\tvar moneyCell = sheet.Cells[\"A3\"];\n\tmoneyCell.Style.Numberformat.Format = \"$#,##0.00\";\n\tmoneyCell.Value = 15.25M;\n\n\t\/\/ Easily write any Enumerable to a sheet\n\t\/\/ In this case: All Excel functions implemented by EPPlus\n\tvar funcs = package.Workbook.FormulaParserManager.GetImplementedFunctions()\n\t\t.Select(x => new {FunctionName = x.Key, TypeName = x.Value.GetType().FullName});\n\tsheet.Cells[\"A4\"].LoadFromCollection(funcs, true);\n\n\t\/\/ Styling cells\n\tvar someCells = sheet.Cells[\"A1,A4:B4\"];\n\tsomeCells.Style.Font.Bold = true;\n\tsomeCells.Style.Font.Color.SetColor(Color.Ivory);\n\tsomeCells.Style.Fill.PatternType = ExcelFillStyle.Solid;\n\tsomeCells.Style.Fill.BackgroundColor.SetColor(Color.Navy);\n\n\tsheet.Cells.AutoFitColumns();\n\tpackage.SaveAs(new FileInfo(@\"basicUsage.xslx\"));\n}\n<\/code><\/pre>\n
Did you know:<\/strong> It is a successor to ExcelPackage, hence the name.<\/p>\n
Boring text ahead<\/strong>:<\/p>\n
While it\u2019s often not easy to find EPPlus examples online, the official source code<\/a> does contain a whole bunch of extensive examples. Be sure to check them out.<\/p>\n
Everything covered works with LibreOffice 5.0. EPPlus covers things that LibreOffice doesn\u2019t seem to know how to handle. For example:<\/p>\n