{"id":1311,"date":"2025-10-01T00:00:00","date_gmt":"2025-09-30T22:00:00","guid":{"rendered":"https:\/\/demo.sidekick.be\/itenium\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/"},"modified":"2025-11-28T13:31:40","modified_gmt":"2025-11-28T12:31:40","slug":"create-xlsx-excel-with-closedxml-csharp-miscellaneous","status":"publish","type":"post","link":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/","title":{"rendered":"Create Excels with C# and ClosedXML: Miscellaneous"},"content":{"rendered":"<pre><code class=\"language-c#\">\/\/ Set workbook properties like title, author, company, ...\nXLWorkbookProperties props = workbook.Properties;\n\n\/\/ Modify default settings for all new workbooks\nworkbook.RowHeight = 20; \/\/ &amp; ColumnWidth\n\/\/ DefaultShowGridLines, DefaultShowZeros, ...\n<\/code><\/pre>\n<h2 id=\"printing\">Printing<\/h2>\n<ul>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki#page-setup-print-options\">More advanced printing options<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki\/Paper-Size-Lookup-Table\">sheet.PageSetup.PaperSize options<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki\/Margins-Tab\">Margins options<\/a> with <code>sheet.PageSetup.Margins<\/code><\/li>\n<\/ul>\n<pre><code class=\"language-c#\">using var workbook = new XLWorkbook();\nvar sheet = workbook.Worksheets.Add(\"Printing\");\n\nsheet.PageSetup.Header.Center.AddText(\"YourTitle\", XLHFOccurrence.AllPages)\n  .SetFontSize(24)\n  .SetBold()\n  .SetUnderline();\nsheet.PageSetup.Header.Right.AddText(XLHFPredefinedText.Date, XLHFOccurrence.AllPages);\nsheet.PageSetup.Header.Left.AddText(XLHFPredefinedText.SheetName, XLHFOccurrence.AllPages);\n\nsheet.PageSetup.Footer.Right.AddText(\"Page \", XLHFOccurrence.AllPages);\nsheet.PageSetup.Footer.Right.AddText(XLHFPredefinedText.PageNumber, XLHFOccurrence.AllPages);\nsheet.PageSetup.Footer.Right.AddText(\" of \", XLHFOccurrence.AllPages);\nsheet.PageSetup.Footer.Right.AddText(XLHFPredefinedText.NumberOfPages, XLHFOccurrence.AllPages);\n\nsheet.PageSetup.SetRowsToRepeatAtTop(1, 2);\nsheet.PageSetup.SetColumnsToRepeatAtLeft(1, 7);\n\nsheet.SheetView.View = XLSheetViewOptions.PageLayout;\n<\/code><\/pre>\n<h2 id=\"comments\">Comments<\/h2>\n<pre><code class=\"language-c#\">using var workbook = new XLWorkbook();\nvar sheet = workbook.Worksheets.Add(\"Comments\");\n\nvar comment = sheet.Cell(\"D4\").CreateComment();\ncomment.Author = \"evil corp\";\ncomment.AddSignature(); \/\/ Makes Author visible\ncomment.AddText(\"Bold title:rn\").SetBold(); \/\/ or use .AddNewLine()\ncomment.AddText(\"Unbolded subtext\").SetBold(false);\n\nsheet.Cell(\"G4\").CreateComment().AddText(\"Orientation = Vertical\");\nsheet.Cell(\"G4\").GetComment().Style\n  .Alignment.SetOrientation(XLDrawingTextOrientation.Vertical)\n  .Alignment.SetAutomaticSize()\n  .Margins.SetAll(0.25)\n  .ColorsAndLines.SetFillColor(XLColor.RichCarmine)\n  .ColorsAndLines.SetFillTransparency(0.25);\n\n\/\/ Control positioning of the comment:\n\/\/ sheet.Cell(G4\").GetComment().Position\n\nforeach (var cell in sheet.CellsUsed(XLCellsUsedOptions.Comments, c =&gt; c.HasComment))\n{\n  cell.GetComment().SetVisible();\n}\n<\/code><\/pre>\n<h2 id=\"richtext\">RichText<\/h2>\n<pre><code class=\"language-c#\">using var wb = new XLWorkbook();\nvar ws = wb.Worksheets.Add(\"Rich Text\");\n\nvar cell1 = ws.Cell(1, 1).SetValue(\"The show must go on...\");\ncell1.Style.Font.FontColor = XLColor.Blue;\ncell1.CreateRichText().Substring(4, 4)\n  .SetFontColor(XLColor.Red)\n  .SetFontName(\"Broadway\");\n\nws.Cell(3, 1).CreateRichText()\n  .AddText(\"Hello\").SetFontColor(XLColor.Red)\n  .AddText(\" BIG \").SetFontColor(XLColor.Blue).SetBold()\n  .AddText(\"World\").SetFontColor(XLColor.Red);\n<\/code><\/pre>\n<h1 id=\"migrating-from-epplus\">Migrating from EPPlus<\/h1>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>EPPlus<\/th>\n<th>ClosedXML<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Basics<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>new ExcelPackage()<\/td>\n<td>new XLWorkbook()<\/td>\n<\/tr>\n<tr>\n<td>Workbook.Worksheets.Add(\u201cstr\u201d)<\/td>\n<td>AddWorksheet(\u201cstr\u201d)<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><strong>With Sheet<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Cells[1, 1]<\/td>\n<td>Cell(1, 1)<\/td>\n<\/tr>\n<tr>\n<td>Cell[\u201cA2\u201d]<\/td>\n<td>Cell(\u201cA2\u201d)<\/td>\n<\/tr>\n<tr>\n<td>Cells[\u201cA2:C5\u201d]<\/td>\n<td>Range(\u201cA2:C5\u201d)<\/td>\n<\/tr>\n<tr>\n<td>Cells[\u201cB2,D2\u201d]<\/td>\n<td>Cells(\u201cB2,D2\u201d) or Ranges(\u201cB2,D2\u201d)<\/td>\n<\/tr>\n<tr>\n<td>Dimension<\/td>\n<td>LastRowUsed() &amp; LastColumnUsed()<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Or RangeUsed()<\/td>\n<\/tr>\n<tr>\n<td>View.FreezePanes<\/td>\n<td>SheetView.Freeze<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>SheetView.FreezeRows &amp; FreezeColumns<\/td>\n<\/tr>\n<tr>\n<td>View.ShowGridLines<\/td>\n<td>ShowGridLines<\/td>\n<\/tr>\n<tr>\n<td>View.ShowHeaders<\/td>\n<td>ShowRowColHeaders<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><strong>With Cell(s)<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Address<\/td>\n<td>Address.ToString()<\/td>\n<\/tr>\n<tr>\n<td>Start.Column<\/td>\n<td>Address.ColumnNumber<\/td>\n<\/tr>\n<tr>\n<td>Formula<\/td>\n<td>FormulaA1<\/td>\n<\/tr>\n<tr>\n<td>Text<\/td>\n<td>GetString() &amp; GetFormattedString()<\/td>\n<\/tr>\n<tr>\n<td>Hyperlink = new Uri()<\/td>\n<td>SetHyperlink(new XLHyperlink())<\/td>\n<\/tr>\n<tr>\n<td>Merge = true<\/td>\n<td>Merge() \/ Unmerge()<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><strong>Styling with Cell.Style<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Font.Color.SetColor(Color.Ivory)<\/td>\n<td>Style.Font.SetFontColor(XLColor.Ivory)<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Style.Font.FontColor = XLColor.Ivory<\/td>\n<\/tr>\n<tr>\n<td>Fill.PatternType = ExcelFillStyle.Solid<\/td>\n<td>Fill.SetPatternType(XLFillPatternValues.Solid)<\/td>\n<\/tr>\n<tr>\n<td>Fill.BackgroundColor.SetColor(Color.Navy)<\/td>\n<td>Fill.SetBackgroundColor(XLColor.Navy)<\/td>\n<\/tr>\n<tr>\n<td>Border.BorderAround()<\/td>\n<td>Border.OutsideBorder<\/td>\n<\/tr>\n<tr>\n<td>ShrinkToFit = true<\/td>\n<td>Alignment.ShrinkToFit = true<\/td>\n<\/tr>\n<tr>\n<td>WrapText = true<\/td>\n<td>Alignment.WrapText = true<\/td>\n<\/tr>\n<tr>\n<td>HorizontalAlignment<\/td>\n<td>Alignment.Horizontal<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><strong>Formulas<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Formula<\/td>\n<td>FormulaA1<\/td>\n<\/tr>\n<tr>\n<td>Calculate()<\/td>\n<td>RecalculateAllFormulas()<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><strong>Misc<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>LoadFromCollection<\/td>\n<td>InsertTable \/ InsertData<\/td>\n<\/tr>\n<tr>\n<td>Cells.AutoFitColumns()<\/td>\n<td>ColumnsUsed().AdjustToContents()<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 id=\"other\">Other<\/h1>\n<p>Things not covered\u2026<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.closedxml.io\/en\/latest\/features\/protect.html\">Sheet Protection<\/a><\/li>\n<li><a href=\"https:\/\/docs.closedxml.io\/en\/latest\/features\/autofilter.html\">AutoFilter<\/a><\/li>\n<li><a href=\"https:\/\/docs.closedxml.io\/en\/latest\/features\/sort.html\">Sorting<\/a><\/li>\n<\/ul>\n<h2 id=\"tables\">Tables<\/h2>\n<p>ClosedXML has good functionality and examples for creating tables:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.closedxml.io\/en\/latest\/features\/tables.html\">In-depth info<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki\/Inserting-Tables\">Example Inserting Tables<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki\/Inserting-Data\">Example Inserting Data<\/a><\/li>\n<li><a href=\"https:\/\/docs.closedxml.io\/en\/latest\/features\/pivot-tables.html\">Pivot Tables<\/a>\n<ul>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki\/Transpose-Ranges\">Transpose Ranges<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1>Also in this series<\/h1>\n<ul>\n<li>Part 1: <a href=\"\/dotnet\/create-xlsx-excel-with-closedxml-csharp\/\">Create Excels with C# and ClosedXML: A tutorial<\/a><\/li>\n<li>Part 2: <a href=\"\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/\">Create Excels with C# and ClosedXML: Formulas &#038; DataValidation<\/a><\/li>\n<li>This Part: Create Excels with C# and ClosedXML: Miscellaneous<\/li>\n<li>Part 4: <a href=\"\/dotnet\/excel-formulas-cheat-sheet-closedxml\/\">Excel formulas cheat sheet<\/a><\/li>\n<\/ul>\n<h1>Extras<\/h1>\n<p><b>Stuff that came into being during the making of this post<\/b><\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/itenium-be\/ClosedXMLTutorial\">More extensive ClosedXML examples in the Github repo<\/a><\/li>\n<\/ul>\n<h1> Package Versions <i class=\"fa fa-info-circle\" style=\"float: right; color: cornflowerblue; font-size: 28px\" title=\"Package versions used for this post and in the accompanying code on Github\"><\/i><\/h1>\n<div><a href=\"https:\/\/github.com\/ClosedXML\/ClosedXML\" class=\"github\"><img decoding=\"async\" src=\"https:\/\/img.shields.io\/github\/stars\/ClosedXML\/ClosedXML.svg?style=social&#038;label=Star\" \/><\/a><a href=\"https:\/\/github.com\/ClosedXML\/ClosedXML\">ClosedXML\/ClosedXML<\/a>: v0.105.0 <\/div>\n","protected":false},"excerpt":{"rendered":"<h1 class=\"hide-from-excerpt\" id=\"miscellaneous-features\">Miscellaneous features<\/h1>\n<p>ClosedXML can do a whole lot more for you. This post covers some interesting stuff that didn\u2019t really fit anywhere else.<\/p>\n","protected":false},"author":1,"featured_media":1941,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[11],"tags":[12,6],"class_list":["post-1311","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dotnet","tag-excel","tag-tutorial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create Excels with C# and ClosedXML: Miscellaneous - Itenium<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Excels with C# and ClosedXML: Miscellaneous - Itenium\" \/>\n<meta property=\"og:description\" content=\"Miscellaneous featuresClosedXML can do a whole lot more for you. This post covers some interesting stuff that didn\u2019t really fit anywhere else.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/\" \/>\n<meta property=\"og:site_name\" content=\"Itenium\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-30T22:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-28T12:31:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Usdevelop\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Usdevelop\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/\",\"name\":\"Create Excels with C# and ClosedXML: Miscellaneous - Itenium\",\"isPartOf\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png\",\"datePublished\":\"2025-09-30T22:00:00+00:00\",\"dateModified\":\"2025-11-28T12:31:40+00:00\",\"author\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022\"},\"breadcrumb\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#primaryimage\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png\",\"contentUrl\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png\",\"width\":360,\"height\":300,\"caption\":\"spreadsheet cells with colorful speech bubbles hovering above them, playful vector illustration, modern flat design --ar 6:5\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/demo.sidekick.be\/itenium\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create Excels with C# and ClosedXML: Miscellaneous\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#website\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/\",\"name\":\"Itenium\",\"description\":\"We build software. We build careers.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/demo.sidekick.be\/itenium\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022\",\"name\":\"Usdevelop\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g\",\"caption\":\"Usdevelop\"},\"sameAs\":[\"https:\/\/demo.sidekick.be\/itenium\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Excels with C# and ClosedXML: Miscellaneous - Itenium","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Create Excels with C# and ClosedXML: Miscellaneous - Itenium","og_description":"Miscellaneous featuresClosedXML can do a whole lot more for you. This post covers some interesting stuff that didn\u2019t really fit anywhere else.","og_url":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/","og_site_name":"Itenium","article_published_time":"2025-09-30T22:00:00+00:00","article_modified_time":"2025-11-28T12:31:40+00:00","og_image":[{"width":360,"height":300,"url":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png","type":"image\/png"}],"author":"Usdevelop","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Usdevelop","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/","url":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/","name":"Create Excels with C# and ClosedXML: Miscellaneous - Itenium","isPartOf":{"@id":"https:\/\/demo.sidekick.be\/itenium\/#website"},"primaryImageOfPage":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#primaryimage"},"image":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#primaryimage"},"thumbnailUrl":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png","datePublished":"2025-09-30T22:00:00+00:00","dateModified":"2025-11-28T12:31:40+00:00","author":{"@id":"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022"},"breadcrumb":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#primaryimage","url":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png","contentUrl":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-misc.png","width":360,"height":300,"caption":"spreadsheet cells with colorful speech bubbles hovering above them, playful vector illustration, modern flat design --ar 6:5"},{"@type":"BreadcrumbList","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/demo.sidekick.be\/itenium\/"},{"@type":"ListItem","position":2,"name":"Create Excels with C# and ClosedXML: Miscellaneous"}]},{"@type":"WebSite","@id":"https:\/\/demo.sidekick.be\/itenium\/#website","url":"https:\/\/demo.sidekick.be\/itenium\/","name":"Itenium","description":"We build software. We build careers.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/demo.sidekick.be\/itenium\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022","name":"Usdevelop","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g","caption":"Usdevelop"},"sameAs":["https:\/\/demo.sidekick.be\/itenium"]}]}},"_links":{"self":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/comments?post=1311"}],"version-history":[{"count":2,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1311\/revisions"}],"predecessor-version":[{"id":2135,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1311\/revisions\/2135"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/media\/1941"}],"wp:attachment":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/media?parent=1311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/categories?post=1311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/tags?post=1311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}