{"id":1315,"date":"2025-09-30T00:00:00","date_gmt":"2025-09-29T22:00:00","guid":{"rendered":"https:\/\/demo.sidekick.be\/itenium\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/"},"modified":"2025-11-28T13:31:40","modified_gmt":"2025-11-28T12:31:40","slug":"create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation","status":"publish","type":"post","link":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/","title":{"rendered":"Create Excels with C# and ClosedXML: Formulas &#038; DataValidation"},"content":{"rendered":"<h1 id=\"formulas\">Formulas<\/h1>\n<p><a href=\"https:\/\/github.com\/itenium-be\/ClosedXMLTutorial\">The project code<\/a> creates an Excel like this:<\/p>\n<table class=\"table-excel\">\n<thead>\n<tr>\n<th><\/th>\n<th>A<\/th>\n<th>B<\/th>\n<th>C<\/th>\n<th>D<\/th>\n<th>E<\/th>\n<th>F<\/th>\n<th>G<\/th>\n<th>H<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Name<\/td>\n<td>Quantity<\/td>\n<td>Price<\/td>\n<td>Base total<\/td>\n<td>Discount<\/td>\n<td>Total<\/td>\n<td>Special<\/td>\n<td>Payup<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Nails<\/td>\n<td>37<\/td>\n<td>\u20ac3.99<\/td>\n<td>=B2*C2<\/td>\n<td><\/td>\n<td>=D2<\/td>\n<td><\/td>\n<td>=F2 * 0.8<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Hammer<\/td>\n<td>5<\/td>\n<td>\u20ac12.10<\/td>\n<td>=B3*C3<\/td>\n<td>10%<\/td>\n<td>=D3 * 0.9<\/td>\n<td><\/td>\n<td>=F3 * 0.8<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Saw<\/td>\n<td>12<\/td>\n<td>\u20ac15.37<\/td>\n<td>=B4*C4<\/td>\n<td><\/td>\n<td>=D4<\/td>\n<td><\/td>\n<td>=F4 * 0.8<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>#COUNT<\/td>\n<td><\/td>\n<td><\/td>\n<td>#SUBTOTAL<\/td>\n<td><\/td>\n<td>#SUBTOTAL<\/td>\n<td>20%<\/td>\n<td>#TOTAL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The formulas below show how to set the #FORMULAS.<\/p>\n<p>When setting a range with <code>FormulaA1<\/code>, it will not adjust columns\/rows accordingly, you have to use <code>FormulaR1C1<\/code>.<\/p>\n<pre><code class=\"language-c#\">using var workbook = new XLWorkbook();\nvar sheet = workbook.Worksheets.Add(\"Formula\");\n\n\/\/ Starting = is optional\nsheet.Cell(\"A5\").FormulaA1 = \"=COUNTA(A2:A4)\";\n\n\/\/ Total column\nsheet.Range(\"D2:D4\").FormulaR1C1 = \"RC[-2]*RC[-1]\";\nAssert.That(sheet.Cell(\"D2\").FormulaR1C1, Is.EqualTo(\"RC[-2]*RC[-1]\"));\nAssert.That(sheet.Cell(\"D4\").FormulaR1C1, Is.EqualTo(\"RC[-2]*RC[-1]\"));\n\n\/\/ Total - discount column\n\/\/ Calculate formulas before they are available in the sheet\n\/\/ (Opening an Excel with Office will do this automatically)\n\/\/ Cell.Value has a performance hit because it will calculate formulas.\nsheet.Range(\"F2:F4\").FormulaR1C1 = \"IF(ISBLANK(RC[-1]),RC[-2],RC[-2]*(1-RC[-1]))\";\nAssert.That(sheet.Cell(\"F2\").CachedValue.ToString(), Is.Empty);\nworkbook.RecalculateAllFormulas();\nAssert.That(sheet.Cell(\"F2\").CachedValue.ToString(), Is.Not.Empty);\n\n\/\/ Total row\nsheet.Cell(\"D5\").FormulaR1C1 = \"SUBTOTAL(9,R[-3]C:R[-1]C)\"; \/\/ total\nAssert.That(sheet.Cell(\"D5\").FormulaA1, Is.EqualTo(\"SUBTOTAL(9,D2:D4)\"));\nsheet.Cell(\"F5\").FormulaR1C1 = \"SUBTOTAL(9,R[-3]C:R[-1]C)\"; \/\/ total - discount\nAssert.That(sheet.Cell(\"F5\").FormulaA1, Is.EqualTo(\"SUBTOTAL(9,F2:F4)\"));\n\nworkbook.RecalculateAllFormulas();\nsheet.Range(\"H2:H5\").FormulaR1C1 = \"RC[-2]*(1-R5C7)\"; \/\/ R5C7 is G5\n\n\/\/ Recalculate all dirty formulas before saving\nworkbook.SaveAs(\"file.xlsx\", new SaveOptions() {EvaluateFormulasBeforeSaving = true});\n<\/code><\/pre>\n<h2 id=\"support\">Support<\/h2>\n<ul>\n<li><a href=\"https:\/\/github.com\/closedxml\/closedxml\/wiki\/Evaluating-Formulas#supported-functions\">Supported Functions<\/a><\/li>\n<li><a href=\"https:\/\/docs.closedxml.io\/en\/latest\/concepts\/function-evaluation.html#id1\">Graphical representation of function evaluation<\/a><\/li>\n<\/ul>\n<h2 id=\"subtotal\">SUBTOTAL<\/h2>\n<p>SUBTOTAL(9,\u2026), as opposed to using SUM directly, will not include other subtotals in their calculation.<\/p>\n<pre><code class=\"language-vba\">SUBTOTAL(FUNC_NUM,ref1,[ref2],...)\n<\/code><\/pre>\n<p>Add 100 to FUNC_NUM to ignore manually hidden rows. Filtered-out rows are always excluded.<\/p>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>FUNC_NUM<\/th>\n<th>Function name<\/th>\n<th>Desc<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>AVERAGE<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>COUNT<\/td>\n<td>Counts how many numbers<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>COUNTA<\/td>\n<td>Counts how many values<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>MAX<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>MIN<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>PRODUCT<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>STDEV<\/td>\n<td>Estimates standard deviation based on a sample<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>STDEVP<\/td>\n<td>Calculates standard deviation based on the entire population<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>SUM<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>VAR<\/td>\n<td>Estimates variance based on a sample<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 id=\"datavalidation\">DataValidation<\/h1>\n<h2 id=\"dropdownlists\">Dropdownlists<\/h2>\n<pre><code class=\"language-c#\">using var workbook = new XLWorkbook();\nvar sheet = workbook.Worksheets.Add(\"Validation\");\n\nvar validation = sheet.Cell(\"C7\").CreateDataValidation();\n\/\/ ATTN: The list must start and end with a double quote!\nvalidation.List(\"\"Apples,Oranges,Lemons\"\");\n\n\/\/ Also possible to load from another sheet:\nvalidation.List(\"OtherSheet!A1:A4\");\n\nvalidation.ErrorStyle = XLErrorStyle.Stop;\nvalidation.ErrorTitle = \"Invalid Selection\";\nvalidation.ErrorMessage = \"We only have those available :(\";\nvalidation.ShowErrorMessage = true;\n\nvalidation.InputTitle = \"Choose your juice\";\nvalidation.InputMessage = \"Apples, oranges or lemons?\";\nvalidation.ShowInputMessage = true;\n\nvalidation.IgnoreBlanks = true;\n<\/code><\/pre>\n<h2 id=\"number--datetime-validation\">Number &amp; DateTime validation<\/h2>\n<pre><code class=\"language-c#\">using var workbook = new XLWorkbook();\nvar sheet = workbook.Worksheets.Add(\"intsAndSuch\");\n\n\/\/ Integer\/Decimal validation\nvar validation = sheet.Cell(\"A2\").CreateDataValidation();\nvalidation.WholeNumber.Between(1, 5);\n\/\/ validation.Decimal.Between(1, 5);\n\n\/\/ DateTime validation\nvar dateTimeValidation = sheet.Cell(\"B2\").CreateDataValidation();\ndateTimeValidation.Date.GreaterThan(DateTime.Now.Date);\n\n\/\/ ATTN: While CreateDataValidation().Time does exist,\n\/\/       it was crashing for me when opening the Excel\n<\/code><\/pre>\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>This Part: Create Excels with C# and ClosedXML: Formulas &#038; DataValidation<\/li>\n<li>Part 3: <a href=\"\/dotnet\/create-xlsx-excel-with-closedxml-csharp-miscellaneous\/\">Create Excels with C# and ClosedXML: Miscellaneous<\/a><\/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<p><b>Other interesting reads<\/b><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188\">Alphabetical list of Excel functions<\/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":"<p>In case your users want to continue working with the Excels after generation.<\/p>\n<p>Not a problem for ClosedXML. Instead of calculating values and writing them to an excel, leverage the power of Excel formulas.<\/p>\n","protected":false},"author":1,"featured_media":1943,"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-1315","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: Formulas &amp; DataValidation - 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: Formulas &amp; DataValidation - Itenium\" \/>\n<meta property=\"og:description\" content=\"In case your users want to continue working with the Excels after generation.Not a problem for ClosedXML. Instead of calculating values and writing them to an excel, leverage the power of Excel formulas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/\" \/>\n<meta property=\"og:site_name\" content=\"Itenium\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-29T22: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-formulas.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=\"3 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-formulas-and-datavalidation\/\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/\",\"name\":\"Create Excels with C# and ClosedXML: Formulas & DataValidation - Itenium\",\"isPartOf\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-formulas.png\",\"datePublished\":\"2025-09-29T22: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-formulas-and-datavalidation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#primaryimage\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-formulas.png\",\"contentUrl\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-formulas.png\",\"width\":360,\"height\":300,\"caption\":\"a glowing formula etched into glass, surrounded by checkmarks and red crosses symbolizing validation, modern minimalistic style, high contrast, elegant illustration\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#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: Formulas &#038; DataValidation\"}]},{\"@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: Formulas & DataValidation - 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: Formulas & DataValidation - Itenium","og_description":"In case your users want to continue working with the Excels after generation.Not a problem for ClosedXML. Instead of calculating values and writing them to an excel, leverage the power of Excel formulas.","og_url":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/","og_site_name":"Itenium","article_published_time":"2025-09-29T22: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-formulas.png","type":"image\/png"}],"author":"Usdevelop","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Usdevelop","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/","url":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/","name":"Create Excels with C# and ClosedXML: Formulas & DataValidation - Itenium","isPartOf":{"@id":"https:\/\/demo.sidekick.be\/itenium\/#website"},"primaryImageOfPage":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#primaryimage"},"image":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#primaryimage"},"thumbnailUrl":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-formulas.png","datePublished":"2025-09-29T22: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-formulas-and-datavalidation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#primaryimage","url":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-formulas.png","contentUrl":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/closedxml-formulas.png","width":360,"height":300,"caption":"a glowing formula etched into glass, surrounded by checkmarks and red crosses symbolizing validation, modern minimalistic style, high contrast, elegant illustration"},{"@type":"BreadcrumbList","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/create-xlsx-excel-with-closedxml-csharp-formulas-and-datavalidation\/#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: Formulas &#038; DataValidation"}]},{"@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\/1315","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=1315"}],"version-history":[{"count":2,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1315\/revisions"}],"predecessor-version":[{"id":2136,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1315\/revisions\/2136"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/media\/1943"}],"wp:attachment":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/media?parent=1315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/categories?post=1315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/tags?post=1315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}