{"id":450,"date":"2011-07-18T18:27:32","date_gmt":"2011-07-18T18:27:32","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?p=450"},"modified":"2011-07-18T18:29:30","modified_gmt":"2011-07-18T18:29:30","slug":"query-open-xml-spreadsheets-in-vb-net-using-linq","status":"publish","type":"post","link":"https:\/\/www.ericwhite.com\/blog\/2011\/07\/18\/query-open-xml-spreadsheets-in-vb-net-using-linq\/","title":{"rendered":"Query Open XML Spreadsheets in VB.NET using LINQ"},"content":{"rendered":"<p>I\u2019ve put together a screen-cast that shows how to query an Open XML spreadsheet using LINQ from VB.NET.\u00a0 If you are using VB, this is a super-easy way to extract data from SpreadsheetML.<\/p>\n<p>You can find the code at <a href=\"http:\/\/openxmldeveloper.org\/home2\/bm8qcmjy\/public_html\/blog\/b\/openxmldeveloper\/archive\/2011\/07\/18\/query-open-xml-spreadsheets-in-vb-net-using-linq.aspx\" target=\"_blank\">OpenXMLDeveloper.org<\/a>.<\/p>\n<div id=\"scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:a1c0e3a2-1903-4cb0-8edf-ea003c1a709a\" class=\"wlWriterEditableSmartContent\" style=\"margin: 0px; display: inline; float: none; padding: 0px;\">\n<div><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" width=\"727\" height=\"408\" codebase=\"http:\/\/download.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=6,0,40,0\"><param name=\"src\" value=\"http:\/\/www.youtube.com\/v\/rcaEAQROnVs?hl=en&amp;hd=1\" \/><embed type=\"application\/x-shockwave-flash\" width=\"727\" height=\"408\" src=\"http:\/\/www.youtube.com\/v\/rcaEAQROnVs?hl=en&amp;hd=1\"><\/embed><\/object><\/div>\n<div style=\"width: 727px; clear: both; font-size: .8em;\">Shows how to query an Open XML spreadsheet from VB.NET using LINQ<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Screen-cast that shows how to query an Open XML spreadsheet using VB.NET \/ LINQ.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_s2mail":"","footnotes":""},"categories":[3,11],"tags":[],"class_list":["post-450","post","type-post","status-publish","format-standard","hentry","category-open-xml","category-spreadsheetml"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=450"}],"version-history":[{"count":2,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/450\/revisions"}],"predecessor-version":[{"id":452,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/450\/revisions\/452"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/categories?post=450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/tags?post=450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}