{"id":222,"date":"2023-11-15T20:28:56","date_gmt":"2023-11-15T20:28:56","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=222"},"modified":"2023-11-18T07:49:18","modified_gmt":"2023-11-18T07:49:18","slug":"wat-is-het-verschil-tussen-text-value-en-value2","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/what-is-the-difference-between-text-value-and-value2\/","title":{"rendered":"What is the difference between .Text, .Value and .Value2"},"content":{"rendered":"<p>There are three ways to read the value from a cell with VBA in Excel using the Range object. This can be done with the properties <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.value\">.Value<\/a>, <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.value2\">.Value2<\/a> and <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.text\">.Text<\/a>. However, there are some differences between these properties, each with their own advantages and disadvantages.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-range-value\">Range.Value<\/h2>\n\n\n\n<p>The property<code> .Value<\/code> is the default property of the function <code>Range<\/code>. So if you don&#039;t put a property after the function, it defaults to the property <code>.Value<\/code> applied. <br>In short: <code>Range(&quot;A1&quot;).Value = Range(&quot;B1&quot;).Value<\/code> is the same as <code>Range(&quot;A1&quot;) = Range(&quot;B1&quot;)<\/code>.<\/p>\n\n\n\n<p>Using <code>Range.Value<\/code> you can generally retrieve the original value from a cell. When a cell is formatted as <code>Currencies<\/code> a rounding off takes place. This is because the data type <code>Currencies<\/code> has a range from -922,337,203,685,477.5808 to 922,337,203,685,477.5807. As you can see, this data type has an accuracy of 4 decimal places. <\/p>\n\n\n\n<p>Suppose: In cell A1 we have the value 1.23456789 with the Number format \u201cCurrency\u201d. If we with <code>Range.Value<\/code> retrieve the original value from the relevant cell, it is converted to a Currency value. The original value of 1.23456789 is rounded to 1.2346. When we work with this, rounding errors may occur.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\"><pre class=\"brush: vb; title: ; notranslate\" title=\"\">\nSub Value() Dim varCurrency As Currency varCurrency = Range(&quot;A1&quot;).Value Debug.Print &quot;A1: &quot; &amp; Range(&quot;A1&quot;).Value Debug.Print &quot;Double precesion: &quot; &amp; CDbl(Range(&quot;A1&quot; ).Value) varCurrency = CCur(varCurrency) Debug.Print &quot;Currency: &quot; &amp; varCurrency Range(&quot;B1&quot;).Value = varCurrency Debug.Print &quot;B1: &quot; &amp; Range(&quot;B1&quot;).Value End Sub\n<\/pre><\/div>\n\n\n<p>The above code gives the following result:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nA1: 123.4568 Double precision: 123.4568 Currency: 123.4568 B1: 123.46\n<\/pre><\/div>\n\n\n<p>As you can see, the original value is rounded off when using Range.Value.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Range.Text<\/h2>\n\n\n\n<p>Unlike Range.Value, Range.Text returns the exact text value of a cell, regardless of cell formatting. This means that if you use Range.Text to retrieve the value from cell A1, you will get the original unchanged value of \u201c1.23456789\u201d, without rounding.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\"><pre class=\"brush: vb; title: ; notranslate\" title=\"\">\nSub Text() Dim cellText As String cellText = Range(&quot;A1&quot;).Text Debug.Print &quot;A1 Text: &quot; &amp; cellText End Sub\n<\/pre><\/div>\n\n\n<p>The above VBA code gives the following result:<\/p>\n\n\n\n<p>A1 Text: 1.23456789<\/p>\n\n\n\n<p>Using Range.Text is useful when you need the exact text value of a cell without any formatting or conversion operations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Range.Value2<\/h2>\n\n\n\n<p>Range.Value2 is similar to Range.Value, but it has an important difference. Range.Value2 does not care about cell formatting and always returns the raw numeric value of a cell, without rounding. It&#039;s faster than Range.Value and is recommended if your precision is important and you don&#039;t want to see formatting changes.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\"><pre class=\"brush: vb; title: ; notranslate\" title=\"\">\nSub Value2() Dim value2 As Variant value2 = Range(&quot;A1&quot;).Value2 Debug.Print &quot;A1 Value2: &quot; &amp; value2 End Sub\n<\/pre><\/div>\n\n\n<p>The above VBA code gives the following result:<\/p>\n\n\n\n<p>A1 Value2: 1.23456789<\/p>\n\n\n\n<p>Range.Value2 is a good choice when you&#039;re manipulating data and precision is essential.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Choosing between .Value, .Value2, and .Text in VBA for Excel depends on your specific needs. If you want the raw numeric value, without formatting or rounding, Range.Value2 is the best option. If you need the exact text value, without formatting, use Range.Text. But be careful with Range.Value, as it can contain cell formatting and rounding.<\/p>\n\n\n\n<p>Understanding these properties and when to apply them will help you handle Excel data more effectively in your VBA projects. Choose the feature that best suits your specific situation and requirements.<\/p>","protected":false},"excerpt":{"rendered":"<p>There are three ways to use VBA in Excel to extract the value from a cell using the Range object\u2026 <a class=\"read-more\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/what-is-the-difference-between-text-value-and-value2\/\">Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":71,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,45],"tags":[142,140,141,149,143,17,147,34,22,146],"class_list":["post-222","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-vba","tag-text","tag-value","tag-value2","tag-afrondingsfouten","tag-celwaarde","tag-excel","tag-excel-programmering","tag-macro","tag-vba","tag-vba-eigenschappen"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wat is het verschil tussen .Text, .Value en .Value2 - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"Dit artikel verkent de verschillen tussen .Value, .Value2 en .Text in VBA Excel-celgegevens en hun voor- en nadelen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/what-is-the-difference-between-text-value-and-value2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wat is het verschil tussen .Text, .Value en .Value2\" \/>\n<meta property=\"og:description\" content=\"Er zijn drie manieren om met VBA in Excel om met het object Range de waarde uit een cel uit te lezen. Dit kan met de eigenschappen .Value, .Value2 en\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/what-is-the-difference-between-text-value-and-value2\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-15T20:28:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-18T07:49:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"Wat is het verschil tussen .Text, .Value en .Value2\",\"datePublished\":\"2023-11-15T20:28:56+00:00\",\"dateModified\":\"2023-11-18T07:49:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/\"},\"wordCount\":453,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"keywords\":[\".text\",\".value\",\".value2\",\"afrondingsfouten\",\"celwaarde'\",\"excel\",\"Excel-programmering\",\"Macro\",\"vba\",\"VBA eigenschappen\"],\"articleSection\":[\"Excel\",\"VBA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/\",\"name\":\"Wat is het verschil tussen .Text, .Value en .Value2 - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"datePublished\":\"2023-11-15T20:28:56+00:00\",\"dateModified\":\"2023-11-18T07:49:18+00:00\",\"description\":\"Dit artikel verkent de verschillen tussen .Value, .Value2 en .Text in VBA Excel-celgegevens en hun voor- en nadelen.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"width\":300,\"height\":300,\"caption\":\"Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wat is het verschil tussen .Text, .Value en .Value2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Wat is het verschil tussen .Text, .Value en .Value2 - Bj\u00f6rn Meijer","description":"Dit artikel verkent de verschillen tussen .Value, .Value2 en .Text in VBA Excel-celgegevens en hun voor- en nadelen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/what-is-the-difference-between-text-value-and-value2\/","og_locale":"en_US","og_type":"article","og_title":"Wat is het verschil tussen .Text, .Value en .Value2","og_description":"Er zijn drie manieren om met VBA in Excel om met het object Range de waarde uit een cel uit te lezen. Dit kan met de eigenschappen .Value, .Value2 en","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/what-is-the-difference-between-text-value-and-value2\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2023-11-15T20:28:56+00:00","article_modified_time":"2023-11-18T07:49:18+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","type":"image\/png"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"Wat is het verschil tussen .Text, .Value en .Value2","datePublished":"2023-11-15T20:28:56+00:00","dateModified":"2023-11-18T07:49:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/"},"wordCount":453,"commentCount":0,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","keywords":[".text",".value",".value2","afrondingsfouten","celwaarde'","excel","Excel-programmering","Macro","vba","VBA eigenschappen"],"articleSection":["Excel","VBA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/","url":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/","name":"Wat is het verschil tussen .Text, .Value en .Value2 - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","datePublished":"2023-11-15T20:28:56+00:00","dateModified":"2023-11-18T07:49:18+00:00","description":"Dit artikel verkent de verschillen tussen .Value, .Value2 en .Text in VBA Excel-celgegevens en hun voor- en nadelen.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","width":300,"height":300,"caption":"Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/en\/2023\/11\/15\/wat-is-het-verschil-tussen-text-value-en-value2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"Wat is het verschil tussen .Text, .Value en .Value2"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=222"}],"version-history":[{"count":7,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"predecessor-version":[{"id":2627,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/222\/revisions\/2627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/71"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}