{"id":1096,"date":"2014-01-19T23:34:57","date_gmt":"2014-01-20T06:34:57","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=1096"},"modified":"2023-02-24T21:48:35","modified_gmt":"2023-02-24T21:48:35","slug":"how-to-get-document-version-with-export-to-excel-from-sharepoint","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/","title":{"rendered":"How to get Document Version with \u201cExport to Excel\u201d from SharePoint"},"content":{"rendered":"<p>You may have come across the same disappointment as I did when trying to get the version of document while output it to Excel \u2013 i.e. the version column does not get exported.<\/p>\n<p>The post below goes through a technique for allowing you to capture the version history.<\/p>\n<p><a title=\"https:\/\/blogs.technet.com\/b\/fesiro\/archive\/2012\/12\/01\/how-to-include-retain-the-document-version-with-export-to-excel-spreadsheet.aspx\" href=\"https:\/\/blogs.technet.com\/b\/fesiro\/archive\/2012\/12\/01\/how-to-include-retain-the-document-version-with-export-to-excel-spreadsheet.aspx\">https:\/\/blogs.technet.com\/b\/fesiro\/archive\/2012\/12\/01\/how-to-include-retain-the-document-version-with-export-to-excel-spreadsheet.aspx<\/a><\/p>\n<p>This post has several gotcha\u2019s regarding pages of data.<\/p>\n<ul>\n<ul>\n<li>You can only export 1 page of data at a time.&nbsp; If your browser session has a view with the default (30 rows) of data, following the technique in the blog post above will get you 30 results, with the rest as N\/A\u2019s\n<li>You can create a new view with up to 200 rows, and get that many rows of data output\n<li>If you need more than 200 rows of data (say you have 1000 rows you need to get) you can edit this line in the attached code as follows. <\/li>\n<ul>\n<li>Original\n<pre>sGet = sListWeb &amp; \"\/owssvr.dll?Cmd=Display&amp;List=\" _<br>    &amp; sListGUID &amp; \"&amp;View=\" &amp; sViewGUID &amp; \"&amp;XMLDATA=TRUE&amp;dt=\" &amp; Now<\/pre>\n<li>Edited (example)\n<pre>sGet = sListWeb &amp; \"\/owssvr.dll?Cmd=Display&amp;List=\" _<br>    &amp; sListGUID &amp; \"&amp;View=\" &amp; sViewGUID &amp; \"<font style=\"background-color: #ffff00\" color=\"#ff0000\">&amp;Paged=TRUE<font color=\"#0000ff\">&amp;p_ID=3684<\/font>&amp;PageFirstRow=101<\/font>&amp;XMLDATA=TRUE&amp;dt=\" &amp; Now<\/pre>\n<li>Some combination of the above 3 URL attributes should begin to get you results for the 2nd, 3rd, etc. pages.&nbsp; Be aware, the p_ID attribute is unique for the first item of each new page, so this will have to change with each page (in other words, you\u2019ll have to get the results in the browser, and then rerun the VB script again for pages 2, 3, 4, etc.)<\/li>\n<\/ul>\n<li>Alternatively, you can follow the advice of one commenter and try this below.<\/li>\n<ul>\n<li>Either you parameter the number of rows displayed on the page via the &#8220;Items Limit&#8221; feature (when you create the view) or you force &amp;XMLDATA with the value &#8220;1&amp;RowLimit=0&#8221; in the query.<\/li>\n<\/ul>\n<\/ul>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>You may have come across the same disappointment as I did when trying to get the version of document while output it to Excel \u2013 i.e. the version column does not get exported. The post below goes through a technique for allowing you to capture the version history. https:\/\/blogs.technet.com\/b\/fesiro\/archive\/2012\/12\/01\/how-to-include-retain-the-document-version-with-export-to-excel-spreadsheet.aspx This post has several gotcha\u2019s regarding &hellip; <a href=\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/\"><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[26,7],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to get Document Version with \u201cExport to Excel\u201d from SharePoint - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get Document Version with \u201cExport to Excel\u201d from SharePoint - Archive\" \/>\n<meta property=\"og:description\" content=\"You may have come across the same disappointment as I did when trying to get the version of document while output it to Excel \u2013 i.e. the version column does not get exported. The post below goes through a technique for allowing you to capture the version history. https:\/\/blogs.technet.com\/b\/fesiro\/archive\/2012\/12\/01\/how-to-include-retain-the-document-version-with-export-to-excel-spreadsheet.aspx This post has several gotcha\u2019s regarding &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-20T06:34:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:48:35+00:00\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/\",\"name\":\"How to get Document Version with \u201cExport to Excel\u201d from SharePoint - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"datePublished\":\"2014-01-20T06:34:57+00:00\",\"dateModified\":\"2023-02-24T21:48:35+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get Document Version with \u201cExport to Excel\u201d from SharePoint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get Document Version with \u201cExport to Excel\u201d from SharePoint - Archive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/","og_locale":"en_US","og_type":"article","og_title":"How to get Document Version with \u201cExport to Excel\u201d from SharePoint - Archive","og_description":"You may have come across the same disappointment as I did when trying to get the version of document while output it to Excel \u2013 i.e. the version column does not get exported. The post below goes through a technique for allowing you to capture the version history. https:\/\/blogs.technet.com\/b\/fesiro\/archive\/2012\/12\/01\/how-to-include-retain-the-document-version-with-export-to-excel-spreadsheet.aspx This post has several gotcha\u2019s regarding &hellip;","og_url":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/","og_site_name":"Archive","article_published_time":"2014-01-20T06:34:57+00:00","article_modified_time":"2023-02-24T21:48:35+00:00","author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/","url":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/","name":"How to get Document Version with \u201cExport to Excel\u201d from SharePoint - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"datePublished":"2014-01-20T06:34:57+00:00","dateModified":"2023-02-24T21:48:35+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2014\/01\/19\/how-to-get-document-version-with-export-to-excel-from-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"How to get Document Version with \u201cExport to Excel\u201d from SharePoint"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1096"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=1096"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1096\/revisions"}],"predecessor-version":[{"id":1891,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1096\/revisions\/1891"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=1096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=1096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=1096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}