{"id":1675,"date":"2017-05-02T00:00:00","date_gmt":"2017-05-01T22:00:00","guid":{"rendered":"https:\/\/demo.sidekick.be\/itenium\/create-xlsx-excel-with-epplus-csharp-miscellaneous\/"},"modified":"2025-11-28T13:31:46","modified_gmt":"2025-11-28T12:31:46","slug":"create-xlsx-excel-with-epplus-csharp-miscellaneous","status":"publish","type":"post","link":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-epplus-csharp-miscellaneous\/","title":{"rendered":"Create Excels with C# and EPPlus: Miscellaneous"},"content":{"rendered":"

<\/p>\n

\n

<\/p>\n

Miscellaneous features<\/h1>\n

EPPlus can do a whole lot more for you. This post covers some interesting stuff that didn\u2019t really fit anywhere else.<\/p>\n

\/\/ Set workbook properties like title, author, company, ...\nOfficeProperties props = package.Workbook.Properties;\n\n\/\/ Modify column props: AutoFit(), Hidden, ...\nvar colE = package.Workbook.Worksheets.First().Column(5);\n<\/code><\/pre>\n
Printing<\/h2>\n
using (var package = new ExcelPackage())\n{\n\tvar sheet = package.Workbook.Worksheets.Add(\"Printing\");\n\tsheet.Cells[\"A1\"].Value = \"Check the print preview (Ctrl+P)\";\n\n\tvar header = sheet.HeaderFooter.OddHeader;\n\t\/\/ &24: Font size\n\t\/\/ &U: Underlined\n\t\/\/ &\"\": Font name\n\theader.CenteredText = \"&24&U&\"Arial,Regular Bold\" YourTitle\";\n\theader.RightAlignedText = ExcelHeaderFooter.CurrentDate;\n\theader.LeftAlignedText = ExcelHeaderFooter.SheetName;\n\n\tExcelHeaderFooterText footer = sheet.HeaderFooter.OddFooter;\n\tfooter.RightAlignedText = $\"Page {ExcelHeaderFooter.PageNumber} of {ExcelHeaderFooter.NumberOfPages}\";\n\tfooter.CenteredText = ExcelHeaderFooter.SheetName;\n\tfooter.LeftAlignedText = ExcelHeaderFooter.FilePath + ExcelHeaderFooter.FileName;\n\n\tsheet.PrinterSettings.RepeatRows = sheet.Cells[\"1:2\"];\n\tsheet.PrinterSettings.RepeatColumns = sheet.Cells[\"A:G\"];\n\n\tsheet.View.PageLayoutView = true;\n\n\tpackage.SaveAs(new FileInfo(@\"\"));\n}\n<\/code><\/pre>\n
Comments & RichText<\/h2>\n
Each RichText.Add() returns a new object that takes over all styling from the textobject is was invoked on and can then be styled separately.<\/p>\n
using (var package = new ExcelPackage())\n{\n\tvar sheet = package.Workbook.Worksheets.Add(\"Rich Comments\");\n\n\tExcelComment comment = sheet.Cells[\"A1\"].AddComment(\"Bold title:rn\", \"evil corp\");\n\tcomment.Font.Bold = true;\n\tcomment.AutoFit = true;\n\n\tExcelRichText rt = comment.RichText.Add(\"Unbolded subtext\");\n\trt.Bold = false;\n\t\/\/ Also rt.Color, FontName, Size, ...\n\n\t\/\/ A more extensive example can be found in Sample6.cs::AddComments of the official examples project\n\t\/\/ https:\/\/github.com\/JanKallman\/EPPlus\/blob\/master\/SampleApp\/Sample6.cs\n\n\tpackage.SaveAs(new FileInfo(@\"\"));\n}\n<\/code><\/pre>\n
Converting indexes and ranges<\/h2>\n
[Test]\npublic void ConvertingIndexesAndAddresses()\n{\n\tAssert.That(ExcelCellBase.GetAddress(1, 1), Is.EqualTo(\"A1\"));\n\tAssert.That(ExcelCellBase.IsValidCellAddress(\"A5\"), Is.True);\n\n\tAssert.That(ExcelCellBase.GetFullAddress(\"MySheet\", \"A1:A3\"), Is.EqualTo(\"'MySheet'!A1:A3\"));\n\n\tAssert.That(ExcelCellBase.TranslateToR1C1(\"AB23\", 0, 0), Is.EqualTo(\"R[23]C[28]\"));\n\tAssert.That(ExcelCellBase.TranslateFromR1C1(\"R23C28\", 0, 0), Is.EqualTo(\"$AB$23\"));\n}\n<\/code><\/pre>\n
The project code<\/a> also contains additional examples with<\/p>\n