{"id":3982,"date":"2018-11-15T16:59:38","date_gmt":"2018-11-15T21:59:38","guid":{"rendered":"https:\/\/blogs.mathworks.com\/videos\/?p=3982"},"modified":"2018-11-15T16:59:38","modified_gmt":"2018-11-15T21:59:38","slug":"creating-a-function-to-format-a-spreadsheet","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/videos\/2018\/11\/15\/creating-a-function-to-format-a-spreadsheet\/","title":{"rendered":"Creating a Function to Format a Spreadsheet"},"content":{"rendered":"<p>I often export to Excel to share results with others. In doing so I control the format of the output with a template with column widths and heading colors that I have talked about in previous videos (<a href=\"https:\/\/blogs.mathworks.com\/videos\/2016\/03\/28\/saving-data-from-matlab-to-excel-using-a-template\/\">saving to a template<\/a>, <a href=\"https:\/\/blogs.mathworks.com\/videos\/2017\/07\/12\/developing-a-function-that-replicates-an-excel-worksheet-template\/\">replicating a worksheet template<\/a>). However, if I change the number of columns in my data, I need to change the template, which is annoying.<\/p>\n<p>So here I try to make a function, where I can specify the column widths and colors as parameters, and therefore change it dynamically to match the columns in my table. It requires interacting with Excel&#8217;s object model, which I find difficult and I need to frequently refer to VBA (Visual Basic for Applications ) documentation online.<\/p>\n<p>Features covered in this <a href=\"https:\/\/blogs.mathworks.com\/videos\/2015\/10\/29\/matlab-code-along-videos\/\">code-along<\/a> style video include:<\/p>\n<ul>\n<li><tt><a href=\"https:\/\/www.mathworks.com\/help\/matlab\/ref\/actxserver.html\">actxserver<\/a><\/tt><\/li>\n<\/ul>\n<p><div class=\"row\"><div class=\"col-xs-12 containing-block\"><div class=\"bc-outer-container add_margin_20\"><videoplayer><div class=\"video-js-container\"><video data-video-id=\"5967582891001\" data-video-category=\"blog\" data-autostart=\"false\" data-account=\"62009828001\" data-omniture-account=\"mathwgbl\" data-player=\"rJ9XCz2Sx\" data-embed=\"default\" id=\"mathworks-brightcove-player\" class=\"video-js\" controls><\/video><script src=\"\/\/players.brightcove.net\/62009828001\/rJ9XCz2Sx_default\/index.min.js\"><\/script><script>if (typeof(playerLoaded) === 'undefined') {var playerLoaded = false;}(function isVideojsDefined() {if (typeof(videojs) !== 'undefined') {videojs(\"mathworks-brightcove-player\").on('loadedmetadata', function() {playerLoaded = true;});} else {setTimeout(isVideojsDefined, 10);}})();<\/script><\/div><\/videoplayer><\/div><\/div><\/div><\/p>\n<p>Play the video in full screen mode for a better viewing experience.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"thumbnail thumbnail_asset asset_overlay video\"><a href=\"https:\/\/blogs.mathworks.com\/videos\/2018\/11\/15\/creating-a-function-to-format-a-spreadsheet\/?dir=autoplay\"><img decoding=\"async\" src=\"https:\/\/cf-images.us-east-1.prod.boltdns.net\/v1\/static\/62009828001\/cf626a14-ada6-42ce-9c76-955f3955295a\/e5aec21e-e6db-42bf-b39b-079717f3859e\/1280x720\/match\/image.jpg\" onError=\"this.style.display ='none';\"\/><\/p>\n<div class=\"overlay_container\">\n      <span class=\"icon-video icon_color_null\"><time class=\"video_length\">33:35<\/time><\/span>\n      <\/div>\n<p>      <\/a><\/div>\n<p>I often export to Excel to share results with others. In doing so I control the format of the output with a template with column widths and heading colors that I have talked about in previous videos&#8230; <a class=\"read-more\" href=\"https:\/\/blogs.mathworks.com\/videos\/2018\/11\/15\/creating-a-function-to-format-a-spreadsheet\/\">read more >><\/a><\/p>\n","protected":false},"author":133,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[27,4],"tags":[],"_links":{"self":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/3982"}],"collection":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/comments?post=3982"}],"version-history":[{"count":2,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/3982\/revisions"}],"predecessor-version":[{"id":3988,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/3982\/revisions\/3988"}],"wp:attachment":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/media?parent=3982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/categories?post=3982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/tags?post=3982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}