{"id":2610,"date":"2016-03-18T07:43:59","date_gmt":"2016-03-18T07:43:59","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=2610"},"modified":"2016-03-18T07:46:41","modified_gmt":"2016-03-18T07:46:41","slug":"smldataretriever-better-approach-for-retrieving-spreadsheet-data","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/smldataretriever-better-approach-for-retrieving-spreadsheet-data\/","title":{"rendered":"SmlDataRetriever: Better Approach for Retrieving Spreadsheet Data"},"content":{"rendered":"<p><span class=\"Back\"><a class=\"Back\" href=\"https:\/\/www.ericwhite.com\/blog\/introduction-to-spreadsheetml-series\/\">Return to the SpreadsheetML Screen-Cast Series<\/a><\/span>The new release of <a href=\"https:\/\/github.com\/OfficeDev\/Open-Xml-PowerTools\">Open-Xml-PowerTools<\/a> includes two new modules:<\/p>\n<ul>\n<li>SmlDataRetriever &#8211; Retrieves a specified table or sheet\/range in a simpler XML form<\/li>\n<li>SmlCellFormatter &#8211; Produces formatted text given the raw value from the cell markup, and the SpreadsheetML formatCode<\/li>\n<\/ul>\n<p>I have developed this module as an interim step in the process of converting SpreadsheetML to HTML\/CSS. &nbsp;However, it is useful in its own right, so am releasing this before I&#39;ve written the rest of the SmlToHtmlConverter module.<\/p>\n<p>The following screen-cast discusses the issues involved, and demos the module:<\/p>\n<p><iframe loading=\"lazy\" title=\"SmlDataRetriever\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/wKEXvyPTmV8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Return to the SpreadsheetML Screen-Cast SeriesThe new release of Open-Xml-PowerTools includes two new modules: SmlDataRetriever &#8211; Retrieves a specified table or sheet\/range in a simpler XML form SmlCellFormatter &#8211; Produces formatted text given the raw value from the cell markup, and the SpreadsheetML formatCode I have developed this module as an interim step in the [&hellip;]<\/p>\n","protected":false},"author":10567,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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":""},"class_list":["post-2610","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/10567"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=2610"}],"version-history":[{"count":3,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2610\/revisions"}],"predecessor-version":[{"id":2614,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2610\/revisions\/2614"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=2610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}