{"id":1013,"date":"2020-10-05T16:43:55","date_gmt":"2020-10-05T08:43:55","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1013"},"modified":"2020-10-07T00:35:37","modified_gmt":"2020-10-06T16:35:37","slug":"using-the-newer-excel-format-xlsx-in-your-exports","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/10\/05\/using-the-newer-excel-format-xlsx-in-your-exports\/","title":{"rendered":"Using the newer Excel format (xlsx) in your exports"},"content":{"rendered":"<p>When <a href=\"https:\/\/www.yohz.com\/siv8_details.htm\">SQL Image Viewer<\/a> first supported exporting your result sets to Excel spreadsheets, it only supported the older .xls format.<\/p>\n<p>Since version 9.7 (released in December 2019), the newer Excel format (.xlsx) is now supported.\u00a0 However, because SQL Image Viewer uses your last export settings when you choose the Excel file name, you may still be using the older .xls format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1014\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx.png\" alt=\"\" width=\"704\" height=\"295\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx.png 704w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx-300x126.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx-624x261.png 624w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/p>\n<p>To export your data and images to the new Excel format, simply change the file extension from <strong>xls<\/strong> to <strong>xlsx<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1015\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx2.png\" alt=\"\" width=\"714\" height=\"276\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx2.png 714w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx2-300x116.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/siv_xlsx2-624x241.png 624w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/p>\n<p>For new users, and users who have never exported to Excel previously, the default extension used is <strong>xlsx<\/strong>,\u00a0 so no action is required on your part to use the new Excel format.<\/p>\n<p>The main advantage in using the xlsx format is that the maximum number of rows in your worksheet increases to 1,048,576 from 65,536 rows.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/10\/05\/using-the-newer-excel-format-xlsx-in-your-exports\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2020\/10\/05\/using-the-newer-excel-format-xlsx-in-your-exports\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>When SQL Image Viewer first supported exporting your result sets to Excel spreadsheets, it only supported the older .xls format. Since version 9.7 (released in December 2019), the newer Excel format (.xlsx) is now supported.\u00a0 However, because SQL Image Viewer uses your last export settings when you choose the Excel file name, you may still [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,11],"tags":[12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1013"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1013"}],"version-history":[{"count":4,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1013\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1013\/revisions\/1019"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}