{"id":2741,"date":"2016-03-18T12:57:47","date_gmt":"2016-03-18T12:57:47","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=2741"},"modified":"2016-03-18T12:57:47","modified_gmt":"2016-03-18T12:57:47","slug":"creating-pivot-tables-part-3","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/creating-pivot-tables-part-3\/","title":{"rendered":"Creating Pivot Tables, Part 3"},"content":{"rendered":"<p>This third part of the series is a screencast that explains the Open XML elements needed for a pivot table and how to create the parts and elements needed. <a href=\"https:\/\/www.ericwhite.com\/blog\/creating-pivot-tables-part-1\/\">Part 1<\/a> showed how to create a pivot table using an existing spreadsheet. <a href=\"https:\/\/www.ericwhite.com\/blog\/creating-pivot-tables-part-2\/\">Part 2<\/a> showed the example code for creating a pivot table from scratch.<\/p>\n<p><iframe loading=\"lazy\" title=\"Open XML Code to Create Pivot Tables\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/VdI76DgUrfs?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<p>The next step would be to add rows, columns, filters, and data values. If you are interested in code for that, please comment. The code involves a number of steps, but I would be happy to work through it, if there is interest.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This third part of the series is a screencast that explains the Open XML elements needed for a pivot table and how to create the parts and elements needed. Part 1 showed how to create a pivot table using an existing spreadsheet. Part 2 showed the example code for creating a pivot table from scratch. [&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-2741","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2741","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=2741"}],"version-history":[{"count":1,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2741\/revisions"}],"predecessor-version":[{"id":2746,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2741\/revisions\/2746"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=2741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}