{"id":421,"date":"2011-05-31T16:59:32","date_gmt":"2011-05-31T16:59:32","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?p=421"},"modified":"2011-05-31T17:02:11","modified_gmt":"2011-05-31T17:02:11","slug":"exploring-table-markup-in-open-xml-spreadsheetml","status":"publish","type":"post","link":"https:\/\/www.ericwhite.com\/blog\/2011\/05\/31\/exploring-table-markup-in-open-xml-spreadsheetml\/","title":{"rendered":"Exploring Table Markup in Open XML SpreadsheetML"},"content":{"rendered":"<p>I\u2019ve written a <a href=\"http:\/\/openxmldeveloper.org\/archive\/2011\/05\/31\/155543.aspx\" target=\"_blank\" class=\"broken_link\">blog post<\/a> and recorded a <a href=\"http:\/\/www.youtube.com\/watch?v=6B_8K9SHTbw\" target=\"_blank\">screen-cast<\/a> around table markup in SpreadsheetML.\u00a0 It is pretty easy to create a worksheet, populate cells in the worksheet, and then convert the cells to a table.\u00a0 Tables in Excel 2010, as you probably know, look like this:<\/p>\n<p><a href=\"https:\/\/www.ericwhite.com\/blog\/wp-content\/uploads\/2011\/05\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.ericwhite.com\/blog\/wp-content\/uploads\/2011\/05\/image_thumb.png\" border=\"0\" alt=\"image\" width=\"600\" height=\"329\" \/><\/a><\/p>\n<p>Here is the screen-cast that explains table markup, and walks through creation of a small Open XML SDK program that converts ordinary SpreadsheetML cells into a table:<\/p>\n<div id=\"scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:29ae16f2-6030-4504-ae30-2496b0c14bdf\" class=\"wlWriterEditableSmartContent\" style=\"margin: 0px; display: inline; float: none; padding: 0px;\">\n<div><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" width=\"448\" height=\"252\" 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\/6B_8K9SHTbw?hl=en&amp;hd=1\" \/><embed type=\"application\/x-shockwave-flash\" width=\"448\" height=\"252\" src=\"http:\/\/www.youtube.com\/v\/6B_8K9SHTbw?hl=en&amp;hd=1\"><\/embed><\/object><\/div>\n<div style=\"width: 448px; clear: both; font-size: .8em;\">Explores table markup, and walks through creating an Open XML SDK program to convert cells into a table.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Explores tables in Open XML SpreadsheetML, and walks through an example that converts some ordinary cells into a table.<\/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-421","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\/421","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=421"}],"version-history":[{"count":2,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/421\/revisions"}],"predecessor-version":[{"id":423,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/421\/revisions\/423"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/categories?post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/tags?post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}