{"id":87,"date":"2014-03-21T12:25:01","date_gmt":"2014-03-21T11:25:01","guid":{"rendered":"http:\/\/www.vosseburcht.com\/?p=87"},"modified":"2014-03-21T12:25:01","modified_gmt":"2014-03-21T11:25:01","slug":"closedxml-exception-when-opening-an-excel-sheet","status":"publish","type":"post","link":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/2014\/03\/21\/closedxml-exception-when-opening-an-excel-sheet\/","title":{"rendered":"ClosedXml exception when opening an Excel sheet."},"content":{"rendered":"<p>We handle may Excel sheets in our automated systems and we use the great\u00a0ClosedXml opensource library (<a href=\"https:\/\/closedxml.codeplex.com\/\">https:\/\/closedxml.codeplex.com\/<\/a>). However today we stumbled upon a sheet that crashed one of our applications.<\/p>\n<blockquote><p>InvalidOperationException: Sequence contains no matching elements.<\/p><\/blockquote>\n<p>After downloading the ClosedXml source I found out the sheet had a rogue comment. Somehow this comment did not have the shapetype that ClosedXml expected. After removing it everything ran smoothly again.<\/p>\n<p>It seems I am, for the first time, going to make a bugfix contribution to an opensource project&#8230;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We handle may Excel sheets in our automated systems and we use the great\u00a0ClosedXml opensource library (https:\/\/closedxml.codeplex.com\/). However today we stumbled upon a sheet that crashed one of our applications. InvalidOperationException: Sequence contains no matching elements. After downloading the ClosedXml source I found out the sheet had a rogue comment. Somehow this comment did not [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/posts\/87"}],"collection":[{"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/comments?post=87"}],"version-history":[{"count":0,"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/posts\/87\/revisions"}],"wp:attachment":[{"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/media?parent=87"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/categories?post=87"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vosseburchttechblog.azurewebsites.net\/index.php\/wp-json\/wp\/v2\/tags?post=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}