id: 9c14e24704644bcfaf35f5a3bc82f78a
parent_id: 
item_type: 1
item_id: e7b5b011019d493a8d9fe97ce2c7b351
item_updated_time: 1764345473767
title_diff: "[{\"diffs\":[[1,\"讓 Python 為你的 Excel 添加翅膀 - Pyradise - Medium\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":43}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>讓 Python 為你的 Excel 添加翅膀 - Pyradise - Medium</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"6868\\\"></a>\\\r\\\n<h1>讓 Python 為你的 Excel 添加翅膀 - Pyradise - Medium</h1>\\\r\\\n\\\r\\\n<div><span>\\\n  <div style=\\\"--en-clipped-content:article\\\">\\\n<div><br/></div><div style=\\\"font-size: 16px; display:block; min-width: 100%; position: relative;\\\"> <div style=\\\"box-sizing:inherit;\\\"><div style=\\\"box-sizing:inherit;text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;color:rgba(0, 0, 0, 0.8);\\\"><div style=\\\"box-sizing:inherit;\\\"><div style=\\\"box-sizing:inherit;font-family:medium-content-sans-serif-font, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen, Ubuntu, Cantarell, &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif;font-weight:400;background-color:rgb(255, 255, 255);\\\"><div style=\\\"box-sizing:inherit;\\\"><div style=\\\"box-sizing:inherit;\\\"><div style=\\\"box-sizing:inherit;left:0px;pointer-events:none;position:absolute;top:calc(100vh + 100px);bottom:calc(100vh + 100px);width:10px;\\\"></div><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><div style=\\\"box-sizing:inherit;\\\"><div style=\\\"box-sizing:inherit;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.23;letter-spacing:0px;font-family:medium-content-title-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-size:40px;margin-bottom:-0.27em;margin-top:0.39em;\\\"><h1 style=\\\"box-sizing:inherit;margin:0px;font-weight:400;color:rgba(0, 0, 0, 0.84);font-family:medium-content-title-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-size:40px;line-height:48px;\\\">讓 Python 為你的 Excel 添加翅膀</h1></div><div style=\\\"box-sizing:inherit;margin-top:32px;\\\"><div style=\\\"box-sizing:inherit;display:flex;align-items:center;\\\"><div style=\\\"box-sizing:inherit;\\\"><a href=\\\"https://medium.com/@yuyueugene84\\\" style=\\\"box-sizing:inherit;color:inherit;text-decoration:none;-webkit-tap-highlight-color:transparent;\\\"><img src=\\\":/6a6473a167a649519cfd89ea337f1fb5\\\" type=\\\"image/png\\\" data-filename=\\\"1Ei_cz0_ep1dLjZpcwE_2hg.png\\\" height=\\\"48\\\" style=\\\"box-sizing:inherit;vertical-align:middle;display:block;border-radius:50%;height:48px;width:48px;\\\" width=\\\"48\\\"/></a></div><div style=\\\"box-sizing:inherit;display:block;width:100%;margin-left:12px;\\\"><div style=\\\"box-sizing:inherit;display:flex;\\\"><div style=\\\"box-sizing:inherit;flex:1;\\\"><span style=\\\"box-sizing:inherit;font-weight:400;display:block;fill:rgba(0, 0, 0, 0.84);font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;line-height:20px;font-size:15.8px;letter-spacing:0px;color:rgba(0, 0, 0, 0.84);\\\"><div style=\\\"box-sizing:inherit;display:flex;align-items:center;margin-bottom:0px;\\\"><span style=\\\"box-sizing:inherit;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;line-height:20px;overflow:hidden;font-weight:300;color:rgba(0, 0, 0, 0.84);font-size:16px;text-overflow:ellipsis;display:-webkit-box;-webkit-box-orient:vertical;max-height:20px;-webkit-line-clamp:1;\\\"><a href=\\\"https://medium.com/@yuyueugene84\\\" style=\\\"box-sizing:inherit;text-decoration:none;-webkit-tap-highlight-color:transparent;font-size:inherit;border:inherit;font-family:inherit;letter-spacing:inherit;font-weight:inherit;padding:0px;margin:0px;color:inherit;fill:inherit;\\\">Eugene Chang (張有勁)</a></span><div style=\\\"box-sizing:inherit;display:none;flex:0 0 auto;margin-left:8px;\\\"></div></div></span></div></div><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;line-height:20px;font-size:15.8px;letter-spacing:0px;color:rgba(0, 0, 0, 0.54);fill:rgba(0, 0, 0, 0.54);\\\"><span style=\\\"box-sizing:inherit;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;line-height:20px;color:rgba(0, 0, 0, 0.54);overflow:hidden;font-weight:300;font-size:16px;text-overflow:ellipsis;display:-webkit-box;-webkit-box-orient:vertical;max-height:20px;-webkit-line-clamp:1;\\\"><div style=\\\"box-sizing:inherit;\\\"><a href=\\\"https://medium.com/pyradise/%E7%95%B6%E5%A4%A7%E8%9F%92%E8%9B%87%E8%AA%9E%E8%A8%80%E9%81%87%E4%B8%8A%E8%80%81%E7%89%8C%E8%A9%A6%E7%AE%97%E8%A1%A8%E8%BB%9F%E9%AB%94-2-2e1e825b31fe\\\" style=\\\"box-sizing:inherit;text-decoration:none;-webkit-tap-highlight-color:transparent;font-size:inherit;border:inherit;font-family:inherit;letter-spacing:inherit;font-weight:inherit;padding:0px;margin:0px;color:inherit;fill:inherit;\\\">May 18, 2018</a> · 6 min read</div></span></span></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">淺談 Python 與 Excel 的最佳串接套件 xlwings</p><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">摘要</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">感謝大家對上一篇文章的支持，這邊容許筆者繼續為各位提供一些在整合 Python 與 Excel 這個議題上實用的知識。在上一篇文章裡提到，了解 Python 與 Excel 的串接與整合是一個我們遲早需要克服的挑戰，也是一個值得花時間研究的議題，而身為一個同時在臺大系統訓練班開設 Excel 與 Python 課程的講師，筆者希望能用一系列的文章與大家分享一些在這個議題上的一些經驗與洞見。</p></div><span style=\\\"display:block;clear:both;\\\"></span></div><hr style=\\\"box-sizing:inherit;font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;border:none;margin-top:30px;\\\"/><span style=\\\"font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, Times New Roman, Times, serif;letter-spacing:0.6em;text-indent:0.6em;font-style:italic;line-height:1.4;\\\">...</span><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">openpyxl 的侷限</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">如同在<a href=\\\"https://medium.com/pyradise/%E7%95%B6%E5%A4%A7%E8%9F%92%E8%9B%87%E8%AA%9E%E8%A8%80%E9%81%87%E4%B8%8A%E8%80%81%E7%89%8C%E8%A9%A6%E7%AE%97%E8%A1%A8%E8%BB%9F%E9%AB%94-fc7947792000\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\">上一篇文章</a>提到的，一個 .xlsx 檔案若是被 Excel或是其他應用程式開啟時，openpyxl 是無法把資料寫入該 .xlsx 檔案的；所以今天若每一次需要用 Python寫入資料到，就需要將 Excel 關掉一次、執行 Python 程式、再重新開啟，這樣的工作流程讓利用 openpyxl 做開發的使用者體驗變得非常糟糕。而用 VBA 語言為 Excel 寫程式的最大好處，就是程式執行完的結果會馬上呈現在 Excel 試算表上，<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">這種所見即所得 (WYSIWYG) 的方式會大幅增加開發者的效率。</strong>從這點來看，<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">Python 若不能夠做到讓開發者有同樣的開發流程，只靠 openpyxl 套件現有的功能，要完全取代 VBA 語言的功能是很困難的。</strong></p><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">xlwings 套件</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">這邊就來為各位介紹 <a href=\\\"https://www.xlwings.org/\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\">xlwings</a>，是筆者認為目前串接 Excel 最好用的 Python 套件：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-left:auto;margin-right:auto;clear:both;max-width:960px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;background-color:rgba(0, 0, 0, 0.05);\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:35%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;will-change:transform;width:100%;overflow:hidden;opacity:0;height:100%;position:absolute;transition:opacity 100ms ease 400ms;transform:translateZ(0px);\\\"><img src=\\\":/1b95b17c185849b1b9e0a9b84351845d\\\" type=\\\"image/png\\\" data-filename=\\\"1lrvrYUI54ecGIcQephE0kg.png\\\" height=\\\"245\\\" style=\\\"box-sizing:inherit;vertical-align:middle;top:0px;left:0px;width:100%;height:100%;position:absolute;filter:blur(20px);transform:scale(1.1);\\\" width=\\\"700\\\"/></div><img src=\\\":/a038f37cc4014360946c011ed7ee5616\\\" type=\\\"image/png\\\" data-filename=\\\"1lrvrYUI54ecGIcQephE0kg.png\\\" height=\\\"245\\\" style=\\\"box-sizing:inherit;vertical-align:middle;top:0px;left:0px;width:100%;height:100%;position:absolute;opacity:1;transition:opacity 400ms ease 0ms;\\\" width=\\\"700\\\"/></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">至於這個套件為何好用？與其用文字和各位解釋，我們直接透過實作來體驗比較快。</p></div><span style=\\\"display:block;clear:both;\\\"></span></div><hr style=\\\"box-sizing:inherit;font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;border:none;margin-top:30px;\\\"/><span style=\\\"font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, Times New Roman, Times, serif;letter-spacing:0.6em;text-indent:0.6em;font-style:italic;line-height:1.4;\\\">...</span><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">安裝 xlwings</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">若你是使用 Anaconda, 而且 Python 版本為 3.5 或 3.5 以上，那恭喜你，xlwings 已經是 Anaconda 内建的 Python 套件之一，無須另外安裝！</p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">Python 的安裝我就不在這篇文章裡多做解釋，這邊若你是使用 Python 3，請在指令列執行：</p><pre style=\\\"box-sizing:inherit;margin:0px;overflow-x:auto;background:rgba(0, 0, 0, 0.05);padding:20px;margin-top:40px;\\\"><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-style:normal;color:rgba(0, 0, 0, 0.84);font-size:16px;line-height:1.18;letter-spacing:-0.022em;font-family:Menlo, Monaco, &quot;Courier New&quot;, Courier, monospace;margin-top:-0.09em;margin-bottom:-0.09em;white-space:pre-wrap;\\\">pip install xlwings</span></pre><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">若你是使用 Anaconda 的，請在指令列執行：</p><pre style=\\\"box-sizing:inherit;margin:0px;overflow-x:auto;background:rgba(0, 0, 0, 0.05);padding:20px;margin-top:40px;\\\"><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-style:normal;color:rgba(0, 0, 0, 0.84);font-size:16px;line-height:1.18;letter-spacing:-0.022em;font-family:Menlo, Monaco, &quot;Courier New&quot;, Courier, monospace;margin-top:-0.09em;margin-bottom:-0.09em;white-space:pre-wrap;\\\">conda install xlwings</span></pre><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">OK 環境安裝好了！</p></div><span style=\\\"display:block;clear:both;\\\"></span></div><hr style=\\\"box-sizing:inherit;font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;border:none;margin-top:30px;\\\"/><span style=\\\"font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, Times New Roman, Times, serif;letter-spacing:0.6em;text-indent:0.6em;font-style:italic;line-height:1.4;\\\">...</span><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">在我們繼續下去之前…</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">容許筆者先跟各位講解一點用 VBA 為 Excel 寫程式所需要的知識。當需要用 VBA 選擇單一個儲存格進行操作時，通常都是以 Cells 函數進行，舉個簡單的例子，今天我若想用 VBA 把 “Hello World!” 字串寫入儲存格 A1，在實作上通常是使用一個叫做 Cells 的函數：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:24.5588%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:167px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">Sub</span> <span style=\\\"color:rgb(36, 41, 46);\\\">CellsExample()</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">  <span style=\\\"color:rgb(106, 115, 125);\\\">'用法是 Cells(row的數值, column的數值)</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">  <span style=\\\"color:rgb(106, 115, 125);\\\">'column (欄) 一般在 Excel 的表達方式是字母，若要轉成數字，就是看該欄是從左邊數起的第幾欄</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">  <span style=\\\"color:rgb(106, 115, 125);\\\">'例： 若我今天需要將 A1 儲存格的值設定成 &quot;Hello World!&quot;</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">5</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">  <span style=\\\"color:rgb(36, 41, 46);\\\">Cells(</span><span style=\\\"color:rgb(3, 47, 98);\\\">1</span><span style=\\\"color:rgb(36, 41, 46);\\\">,</span> <span style=\\\"color:rgb(3, 47, 98);\\\">1</span><span style=\\\"color:rgb(36, 41, 46);\\\">).Value</span> <span style=\\\"color:rgb(36, 41, 46);\\\">=</span> <span style=\\\"color:rgb(3, 47, 98);\\\">&quot;Hello World!&quot;</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">6</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">End</span> <span style=\\\"color:rgb(215, 58, 73);\\\">Sub</span></td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/e5d450e615880d228d1d2461221c8c64/raw/5b60c9e1a4699b5fa46f6a393ae4eb56d291778d/cells_example.vb\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/e5d450e615880d228d1d2461221c8c64#file-cells_example-vb\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">cells_example.vb</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">但是我們一般在表達 Excel 的儲存格時，都是以英文字母來表示欄，所以 Cells 函數也支援以下寫法：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:18.3824%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:125px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">Sub</span> <span style=\\\"color:rgb(36, 41, 46);\\\">CellsExample()</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">  <span style=\\\"color:rgb(106, 115, 125);\\\">'直接以字串 &quot;A&quot; 表示想選擇的欄，相對直覺狠多</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">  <span style=\\\"color:rgb(36, 41, 46);\\\">Cells(</span><span style=\\\"color:rgb(3, 47, 98);\\\">1</span><span style=\\\"color:rgb(36, 41, 46);\\\">,</span> <span style=\\\"color:rgb(3, 47, 98);\\\">&quot;A&quot;</span><span style=\\\"color:rgb(36, 41, 46);\\\">).Value</span> <span style=\\\"color:rgb(36, 41, 46);\\\">=</span> <span style=\\\"color:rgb(3, 47, 98);\\\">&quot;Hello World!&quot;</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">End</span> <span style=\\\"color:rgb(215, 58, 73);\\\">Sub</span></td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/260ba203356f60678e3cc3c850f9d75e/raw/771f05b441d9bf12438902f692f66c4c8f49ab8c/cells_example_str.vb\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/260ba203356f60678e3cc3c850f9d75e#file-cells_example_str-vb\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">cells_example_str.vb</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">瞭解了 Cells() 函數後，接下來我們就比較能理解 xlwings 的厲害之處。</p></div><span style=\\\"display:block;clear:both;\\\"></span></div><hr style=\\\"box-sizing:inherit;font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;border:none;margin-top:30px;\\\"/><span style=\\\"font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, Times New Roman, Times, serif;letter-spacing:0.6em;text-indent:0.6em;font-style:italic;line-height:1.4;\\\">...</span><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">來實戰吧</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">接下來我們就來用 Python 與 xlwings 寫一個簡單的 Hello World 程式，這次我們<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">不需要一個現有的 Excel 檔案，直接執行以下程式碼即可</strong>：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:21.4706%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:146px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 匯入 xlwings 套件</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">import</span> xlwings <span style=\\\"color:rgb(215, 58, 73);\\\">as</span> xw</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 讓 xlwings 動態開啟一個新的 Excel 檔案，並將該檔案存入 workbook 變數</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">workbook <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> xw.Book()</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">5</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 若你沒有開啟你的 Excel, 這行可能會跑的慢一點，請耐心等待，讓子彈飛一會兒～</span></td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/09e415a1df90b488e6aa29c877dac199/raw/c9c03bf92dbf22d48ae333b73fa1105d590fb6b6/create_new_xlsx.py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/09e415a1df90b488e6aa29c877dac199#file-create_new_xlsx-py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">create_new_xlsx.py</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div></div><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:75%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:640px;height:480px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;vertical-align:baseline;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;color:rgb(68, 68, 68);box-sizing:border-box;vertical-align:baseline;font:inherit;font-family:&quot;Helvetica Neue&quot;, Helvetica, Helvetica, Arial, sans-serif;overflow:hidden;\\\">\\\n\\\n<div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"box-sizing:border-box;margin:0px;padding:0px;border:0px;outline:0px;font-size:100%;vertical-align:baseline;background:transparent;font:inherit;width:640px;height:360px;position:relative;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"overflow:hidden;\\\"><div dir=\\\"ltr\\\" style=\\\"font:12px Roboto, Arial, sans-serif;background-color:rgb(0, 0, 0);color:rgb(255, 255, 255);overflow:hidden;\\\">\\\n<a href=\\\"https://www.youtube.com/watch?v=4vBtodpW_Q0\\\" style=\\\"width:100%;height:100%;display:inline-block;position:absolute;top:0;background-image:url(https://img.youtube.com/vi/4vBtodpW_Q0/hqdefault.jpg);background-position:center;background-size:100% auto;background-repeat:no-repeat;\\\" target=\\\"_blank\\\"></a>  \\\n</div></div></div></div></div></div></div></div></div></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">如你所見的，xlwings 會自動開啟一個新的 Excel 檔案，這邊先提一下，在使用 xlwings 做開發時，xlwings 是假設開發者的 .xlsx檔是被 Excel 應用程式開起來的，所以<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">請先確保你的電腦已經安裝了 Excel 應用程式</strong>。</p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">接下來我們就來實作 Hello World 吧，請你加入以下程式碼：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:18.3824%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:125px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 到 workbook 代表的 excel 檔案下，開啓名爲 '工作表1' 的試算表</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">sheet <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> workbook.sheets[<span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>工作表1<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>]</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 將該試算表裏面的 A1 儲存格的值設定成 &quot;Hello World!&quot;</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">sheet.cells(<span style=\\\"color:rgb(0, 92, 197);\\\">1</span>, <span style=\\\"color:rgb(0, 92, 197);\\\">1</span>).value <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span>Hello World!<span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span></span></td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/b18816fa83d7a76bf4bbe578f9ceb1f6/raw/3110630b8f2cfef2aec3e3e4b6d6a084ba4e0d3f/hello_world_xlwings.py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/b18816fa83d7a76bf4bbe578f9ceb1f6#file-hello_world_xlwings-py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">hello_world_xlwings.py</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">注意<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">上面的寫法幾乎和 VBA 的 Cells() 函數一樣</strong>，對熟悉 VBA 的開發著來説，看到這種寫法真的是令人大呼過癮，因爲<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">這樣大幅降低了從 VBA 語言切換到 Python 的開發門檻！</strong></p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">但是 xlwings 的好處不光是在語法上，<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">現在請你試試不要關掉 Excel, 直接執行這支程式</strong>：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-left:auto;margin-right:auto;clear:both;max-width:2282px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;background-color:rgba(0, 0, 0, 0.05);\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:72.6556%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;will-change:transform;width:100%;overflow:hidden;opacity:0;height:100%;position:absolute;transition:opacity 100ms ease 400ms;transform:translateZ(0px);\\\"><img src=\\\":/de0e3abeed0744c4a85db6bf87a868f5\\\" type=\\\"image/png\\\" data-filename=\\\"1A4jDJsDInE5dT7oOU4LH2w.png\\\" height=\\\"509\\\" style=\\\"box-sizing:inherit;vertical-align:middle;top:0px;left:0px;width:100%;height:100%;position:absolute;filter:blur(20px);transform:scale(1.1);\\\" width=\\\"700\\\"/></div><img src=\\\":/f36f5e54d05e4a8d887a3fca5a22e1f9\\\" type=\\\"image/png\\\" data-filename=\\\"1A4jDJsDInE5dT7oOU4LH2w.png\\\" height=\\\"509\\\" style=\\\"box-sizing:inherit;vertical-align:middle;top:0px;left:0px;width:100%;height:100%;position:absolute;opacity:1;transition:opacity 400ms ease 0ms;\\\" width=\\\"700\\\"/></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">不同於之前 openpyxl，<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">即使我沒有關掉 Excel 檔案，透過 xlwings ，我依然可以將值寫入到 Excel，這種能夠即時把程式執行的結果顯示在 Excel 試算表的功能，可以大幅的提升我們的開發效率 ！</strong></p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">另外，xlwings 的 cells 函數也支援以英文字母來表示欄的寫法，所以你若覺得上面的程式碼不夠直覺，可以試試以下寫法：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:18.3824%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:125px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 到 workbook 代表的 excel 檔案下，開啓名爲 '工作表1' 的試算表</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">sheet <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> workbook.sheets[<span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>工作表1<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>]</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 和 VBA 的 Cells() 函數一樣，xlings 支援可以用英文字母指定欄！</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">sheet.cells(<span style=\\\"color:rgb(0, 92, 197);\\\">1</span>, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span>A<span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span></span>).value <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span>Hello World!<span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span></span></td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/5fc40fb9d33e888c7da0ef46920b8ce4/raw/6839bbf1e6b3fbf1d431970f622b93c5671da5aa/hello_world_xlwings_string.py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/5fc40fb9d33e888c7da0ef46920b8ce4#file-hello_world_xlwings_string-py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">hello_world_xlwings_string.py</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div><div style=\\\"box-sizing:inherit;margin-left:auto;margin-right:auto;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;color:rgba(0, 0, 0, 0.54);font-weight:300;max-width:728px;font-size:16px;line-height:1.4;margin-top:10px;text-align:center;\\\"><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">備註：若你是用 Mac 電腦，很遺憾的，目前 xlwings 在 Mac 上不支援這個寫法</strong></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\"><strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">*備注：若你的電腦是 Mac，由於在 Mac 上 xlwings 的 cells 不支援以英文字母的方式表達欄，所以在實作上會有些微的差異，請注意這點，至於要如何用數字指定那一欄? 其實就是該欄是從最左邊數起的第幾欄，因此，A 欄相對應的數字為 1，B 欄為 2，C 欄為 3，以此類推。</strong></p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">若你在上述的實作中有遇到任何困難，可以參考以下影片：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:75%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:640px;height:480px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;vertical-align:baseline;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;color:rgb(68, 68, 68);box-sizing:border-box;vertical-align:baseline;font:inherit;font-family:&quot;Helvetica Neue&quot;, Helvetica, Helvetica, Arial, sans-serif;overflow:hidden;\\\">\\\n\\\n<div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"box-sizing:border-box;margin:0px;padding:0px;border:0px;outline:0px;font-size:100%;vertical-align:baseline;background:transparent;font:inherit;width:640px;height:360px;position:relative;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"overflow:hidden;\\\"><div dir=\\\"ltr\\\" style=\\\"font:12px Roboto, Arial, sans-serif;background-color:rgb(0, 0, 0);color:rgb(255, 255, 255);overflow:hidden;\\\">\\\n<a href=\\\"https://www.youtube.com/watch?v=h4q1__1fe_Q\\\" style=\\\"width:100%;height:100%;display:inline-block;position:absolute;top:0;background-image:url(https://img.youtube.com/vi/h4q1__1fe_Q/hqdefault.jpg);background-position:center;background-size:100% auto;background-repeat:no-repeat;\\\" target=\\\"_blank\\\"></a>  \\\n</div></div></div></div></div></div></div></div></div></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">恭喜你完成了你的第一個 xlwings 程式！</p></div><span style=\\\"display:block;clear:both;\\\"></span></div><hr style=\\\"box-sizing:inherit;font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;border:none;margin-top:30px;\\\"/><span style=\\\"font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, Times New Roman, Times, serif;letter-spacing:0.6em;text-indent:0.6em;font-style:italic;line-height:1.4;\\\">...</span><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">用 xlwings 來實作上一篇文章的日報酬率</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">接下來我們就用 xlwings 來實作出計算所有日報酬率的效果，這篇文章我們會繼續沿用上一篇文章的<a href=\\\"https://www.dropbox.com/s/fq9rce0spp1y8ry/stock_price_data.xlsx?dl=1\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\">範例 Excel 檔</a>：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:49.7059%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:338px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 打開你的 stock_price_data.xlsx 檔案</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">wb <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> xw.Book(<span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">r</span><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>在這裏輸入你放置 Excel 檔案的位置<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>)</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 從 檔案裡找出名為 2330 的試算表，存入 tsmc_sheet 這個變數裏</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">tsmc_sheet <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> wb.sheets[<span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>2330<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>]</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">5</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 算出所有的報酬率</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">6</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">for</span> i <span style=\\\"color:rgb(215, 58, 73);\\\">in</span> <span style=\\\"color:rgb(0, 92, 197);\\\">range</span>(<span style=\\\"color:rgb(0, 92, 197);\\\">3</span>, <span style=\\\"color:rgb(0, 92, 197);\\\">100</span>):</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">7</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 到 B 欄截取今日收盤價</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">8</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    price_today <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> tsmc_sheet.cells(i, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span>B<span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span></span>).value</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">9</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 到 B 欄截取迭代到的上一個 row, 也就是昨日收盤價</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">10</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    price_yesterday <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> tsmc_sheet.cells(i<span style=\\\"color:rgb(215, 58, 73);\\\">-</span><span style=\\\"color:rgb(0, 92, 197);\\\">1</span>, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span>B<span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span></span>).value</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">11</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 算出該筆資料的日報酬率了</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">12</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    daily_return <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> (price_today <span style=\\\"color:rgb(215, 58, 73);\\\">-</span> price_yesterday) <span style=\\\"color:rgb(215, 58, 73);\\\">/</span> price_yesterday</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">13</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 最後再將算出的日報酬率寫入同一列，欄為 C 的儲存格</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">14</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    tsmc_sheet.cells(i, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span>C<span style=\\\"color:rgb(3, 47, 98);\\\">&quot;</span></span>).value <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> daily_return</td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/96e0d1f21ede90bf04a29cde7caa3bd9/raw/d7f930b997f898d5b1a5b40188e46d94a11b358a/calculate_daily_return_xlwings.py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/96e0d1f21ede90bf04a29cde7caa3bd9#file-calculate_daily_return_xlwings-py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">calculate_daily_return_xlwings.py</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div><div style=\\\"box-sizing:inherit;margin-left:auto;margin-right:auto;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;color:rgba(0, 0, 0, 0.54);font-weight:300;max-width:728px;font-size:16px;line-height:1.4;margin-top:10px;text-align:center;\\\"><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">備註：若你是用 Mac 電腦，請點擊</strong><a href=\\\"https://gist.github.com/yuyueugene84/c1397fb1e85979ef19a26ae20cf19216\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\"><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">這個連結</strong></a><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">觀看 Mac 版程式碼</strong></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">雖然我們已經成功地算出所有的報酬率了，但是要用數字觀察臺積電股價的漲跌還是有些困難，因此我們就增加一個新的功能：若當天該股票是上漲(報酬率是大於0)，就把底色換成紅色；相對的，若當天該股票是下跌(報酬率是小於0)，就把底色換成綠色，這個用一個簡單的迴圈與判斷式即可完成：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:43.3824%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:295px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div><div style=\\\"text-rendering:optimizelegibility;-webkit-font-smoothing:antialiased;font-family:ff-tisa-web-pro, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:400;color:rgb(51, 51, 50);font-size:18px;line-height:1.4;background-color:white;overflow:hidden;\\\"><div style=\\\"text-rendering:auto;color:rgb(51, 51, 51);direction:ltr;font-size:16px;text-align:left;\\\">\\\n    <div style=\\\"border-width:1px;border-style:solid;border-image:initial;border-color:rgb(221, 221, 221) rgb(221, 221, 221) rgb(204, 204, 204);border-radius:3px;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;margin-bottom:0px;\\\">\\\n      <div style=\\\"background-color:rgb(255, 255, 255);border-bottom:1px solid rgb(221, 221, 221);border-radius:2px 2px 0px 0px;overflow:auto;overflow-wrap:normal;\\\">\\\n        <div>\\\n  <div>\\\n    \\\n\\\n  <div style=\\\"overflow:auto hidden;\\\">\\\n      \\\n<table style=\\\"font-style:inherit;font-variant:inherit;font-size:12px;font-weight:400;background:rgb(255, 255, 255);border:0px;color:rgb(51, 51, 51);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;line-height:1.4;margin:0px;padding:0px;border-collapse:collapse;\\\">\\\n      <tbody><tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">1</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding-top:4px;padding:1px 10px;\\\"><span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 用顔色標記漲跌</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">2</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\"><span style=\\\"color:rgb(215, 58, 73);\\\">for</span> i <span style=\\\"color:rgb(215, 58, 73);\\\">in</span> <span style=\\\"color:rgb(0, 92, 197);\\\">range</span>(<span style=\\\"color:rgb(0, 92, 197);\\\">3</span>, <span style=\\\"color:rgb(0, 92, 197);\\\">100</span>):</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">3</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    daily_return <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> tsmc_sheet.cells(i, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>C<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>).value</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">4</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 若該筆資料的日報酬率是上漲的 (大於 0)</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">5</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(215, 58, 73);\\\">if</span> daily_return <span style=\\\"color:rgb(215, 58, 73);\\\">&gt;</span> <span style=\\\"color:rgb(0, 92, 197);\\\">0</span>:</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">6</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">        <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 就把該儲存格的底色換成紅色</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">7</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">        <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> (255, 0, 0) 三個數字是代表 RGB, 也就是紅、綠、藍三種顔色的强度</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">8</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">        tsmc_sheet.cells(i, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>C<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>).color <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> (<span style=\\\"color:rgb(0, 92, 197);\\\">255</span>, <span style=\\\"color:rgb(0, 92, 197);\\\">0</span>, <span style=\\\"color:rgb(0, 92, 197);\\\">0</span>)</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">9</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 若該筆資料的日報酬率是下跌的 (小於 0)</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">10</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">    <span style=\\\"color:rgb(215, 58, 73);\\\">elif</span> daily_return <span style=\\\"color:rgb(215, 58, 73);\\\">&lt;</span> <span style=\\\"color:rgb(0, 92, 197);\\\">0</span>:</td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">11</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">        <span style=\\\"color:rgb(106, 115, 125);\\\"><span style=\\\"color:rgb(106, 115, 125);\\\">#</span> 就把該儲存格的底色換成綠色</span></td>\\\n      </tr>\\\n      <tr>\\\n        <td style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;user-select:none;vertical-align:top;white-space:nowrap;width:1%;min-width:inherit;background:transparent;padding:1px 10px;\\\"><span style=\\\"color:rgba(27, 31, 35, 0.3);cursor:pointer;font-family:SFMono-Regular, Consolas, Liberation Mono, Menlo, Courier, monospace;font-size:12px;line-height:20px;text-align:right;white-space:nowrap;\\\">12</span></td>\\\n        <td style=\\\"line-height:20px;position:relative;vertical-align:top;color:rgb(36, 41, 46);font-family:SFMono-Regular, Consolas, &quot;Liberation Mono&quot;, Menlo, Courier, monospace;font-size:12px;overflow:visible;white-space:pre;overflow-wrap:normal;background:transparent;border:0px;text-align:left;padding:1px 10px;\\\">        tsmc_sheet.cells(i, <span style=\\\"color:rgb(3, 47, 98);\\\"><span style=\\\"color:rgb(3, 47, 98);\\\">'</span>C<span style=\\\"color:rgb(3, 47, 98);\\\">'</span></span>).color <span style=\\\"color:rgb(215, 58, 73);\\\">=</span> (<span style=\\\"color:rgb(0, 92, 197);\\\">0</span>, <span style=\\\"color:rgb(0, 92, 197);\\\">255</span> , <span style=\\\"color:rgb(0, 92, 197);\\\">0</span>)</td>\\\n      </tr>\\\n</tbody></table>\\\n\\\n\\\n  </div>\\\n\\\n  </div>\\\n</div>\\\n\\\n      </div>\\\n      <div style=\\\"background-color:rgb(247, 247, 247);border-radius:0px 0px 2px 2px;color:rgb(88, 96, 105);font:12px -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Helvetica, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;;overflow:hidden;padding:10px;\\\">\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/9de5670d86cd69aa080484ad8be85d28/raw/29bfcd68bbda2f9a3ec01228bd6c6b70502d596c/xlwings_set_color.py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;float:right;\\\">view raw</a>\\\n        <a href=\\\"https://gist.github.com/yuyueugene84/9de5670d86cd69aa080484ad8be85d28#file-xlwings_set_color-py\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">xlwings_set_color.py</a>\\\n        hosted with ❤ by <a href=\\\"https://github.com/\\\" style=\\\"border:0px;color:rgb(102, 102, 102);font-weight:600;text-decoration:none;\\\">GitHub</a>\\\n      </div>\\\n    </div>\\\n</div>\\\n</div></div></div></div></div></div><div style=\\\"box-sizing:inherit;margin-left:auto;margin-right:auto;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;color:rgba(0, 0, 0, 0.54);font-weight:300;max-width:728px;font-size:16px;line-height:1.4;margin-top:10px;text-align:center;\\\"><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">備註：若你是用 Mac 電腦，請點擊</strong><a href=\\\"https://gist.github.com/yuyueugene84/59ad7b94158ab057dfef9d53c80057b5\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\"><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">這個連結</strong></a><strong style=\\\"box-sizing:inherit;font-weight:inherit;\\\">觀看 Mac 版程式碼</strong></div></div><div style=\\\"box-sizing:inherit;margin:0px;margin-left:auto;margin-right:auto;clear:both;max-width:1529px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;background-color:rgba(0, 0, 0, 0.05);\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:77.0438%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;will-change:transform;width:100%;overflow:hidden;height:100%;position:absolute;transform:translateZ(0px);opacity:1;transition:opacity 400ms ease 0ms;\\\"><img src=\\\":/e508897e861e473885ae5f4e0069a35a\\\" type=\\\"image/png\\\" data-filename=\\\"1p-AG9_hqg-VGW62O-RkPKQ.png\\\" height=\\\"539\\\" style=\\\"box-sizing:inherit;vertical-align:middle;top:0px;left:0px;width:100%;height:100%;position:absolute;filter:blur(20px);transform:scale(1.1);\\\" width=\\\"700\\\"/></div><img height=\\\"539\\\" style=\\\"box-sizing:inherit;vertical-align:middle;top:0px;left:0px;width:100%;opacity:0;height:100%;position:absolute;transition:opacity 100ms ease 400ms;\\\" width=\\\"700\\\"></img></div></div><div style=\\\"box-sizing:inherit;margin-left:auto;margin-right:auto;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;color:rgba(0, 0, 0, 0.54);font-weight:300;max-width:728px;font-size:16px;line-height:1.4;margin-top:10px;text-align:center;\\\">最後執行出來的結果</div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">若你不知道如何執行本文的 Python 程式碼，可以參考以下影片：</p><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:75%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:640px;height:480px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;vertical-align:baseline;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;color:rgb(68, 68, 68);box-sizing:border-box;vertical-align:baseline;font:inherit;font-family:&quot;Helvetica Neue&quot;, Helvetica, Helvetica, Arial, sans-serif;overflow:hidden;\\\">\\\n\\\n<div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"box-sizing:border-box;margin:0px;padding:0px;border:0px;outline:0px;font-size:100%;vertical-align:baseline;background:transparent;font:inherit;width:640px;height:360px;position:relative;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"overflow:hidden;\\\"><div dir=\\\"ltr\\\" style=\\\"font:12px Roboto, Arial, sans-serif;background-color:rgb(0, 0, 0);color:rgb(255, 255, 255);overflow:hidden;\\\">\\\n<a href=\\\"https://www.youtube.com/watch?v=xDztsNqNaq4\\\" style=\\\"width:100%;height:100%;display:inline-block;position:absolute;top:0;background-image:url(https://img.youtube.com/vi/xDztsNqNaq4/hqdefault.jpg);background-position:center;background-size:100% auto;background-repeat:no-repeat;\\\" target=\\\"_blank\\\"></a>  \\\n</div></div></div></div></div></div></div></div></div></div></div></div></div><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">大功告成！</p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">希望這幾個簡單的範例能對需要整合 Python 與 Excel 的你有幫助和啟發！另外，若你對這篇的內容有任何疑問，或是對我在未來的文章能提供的題材有任何的建議，都歡迎你在 Medium 的留言區告訴我，謝謝！</p><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:1.56em;\\\">在接下來的文章裡，我會繼續和大家分享 Python 與 Excel 還有哪一些好用的整合方案以及應用場景，敬請期待！</p></div><span style=\\\"display:block;clear:both;\\\"></span></div><hr style=\\\"box-sizing:inherit;font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;border:none;margin-top:30px;\\\"/><span style=\\\"font-weight:300;font-size:28px;text-align:center;font-family:medium-content-slab-serif-font, Georgia, Cambria, Times New Roman, Times, serif;letter-spacing:0.6em;text-indent:0.6em;font-style:italic;line-height:1.4;\\\">...</span><div style=\\\"box-sizing:inherit;word-break:break-word;overflow-wrap:break-word;\\\"><div style=\\\"padding-left:24px;padding-right:24px;width:100%;box-sizing:border-box;max-width:728px;margin:0px auto;\\\"><h2 style=\\\"box-sizing:inherit;margin:0px;font-family:medium-content-sans-serif-font, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, &quot;Lucida Sans&quot;, Geneva, Arial, sans-serif;font-style:normal;font-weight:600;color:rgba(0, 0, 0, 0.84);line-height:1.18;letter-spacing:-0.022em;margin-bottom:-0.31em;font-size:24px;margin-top:1.23em;\\\">小結</h2><p style=\\\"box-sizing:inherit;margin:0px;font-weight:400;font-style:normal;color:rgba(0, 0, 0, 0.84);line-height:1.58;letter-spacing:-0.004em;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;margin-bottom:-0.46em;font-size:18px;margin-top:0.67em;\\\">在這篇文章裡我們見識到 openpyxl 套件有個限制，<strong style=\\\"box-sizing:inherit;font-family:medium-content-serif-font, Georgia, Cambria, &quot;Times New Roman&quot;, Times, serif;font-weight:700;\\\">就是無法寫入資料到一個正在被其他應用程式開啟的 Excel 檔。</strong>而我們也認識了 xlwings 這個強大的套件，它不但沒有上述 openpyxl 的限制，同時在函數的界面上非常接近 VBA，一方面不會對 Python 的開發者帶來負擔，另一方面大幅降低VBA 開發者切換至 Python 語言的成本，可説是個真正有在用心做的套件。當然，xlwings 也有它的侷限：那就是它需要 Excel 應用程式才能運作，不過由於 Excel 的普及，這個相對是個小問題，若你的電腦沒有安裝 Excel，建議你買個正版的 Office 來使用，想想 Excel 能為你帶來的便利以及節省的時間，絕對是一個值得的投資。</p><pre style=\\\"box-sizing:inherit;margin:0px;overflow-x:auto;background:rgba(0, 0, 0, 0.05);padding:20px;margin-top:40px;\\\"><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-style:normal;color:rgba(0, 0, 0, 0.84);font-size:16px;line-height:1.18;letter-spacing:-0.022em;font-family:Menlo, Monaco, &quot;Courier New&quot;, Courier, monospace;margin-top:-0.09em;margin-bottom:-0.09em;white-space:pre-wrap;\\\">如果您喜歡這篇文章，請多按下方的「拍手」圖像幾次、分享到社群網站以及訂閱 <a href=\\\"https://medium.com/pyradise\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\">Pyradise</a>！</span><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-style:normal;color:rgba(0, 0, 0, 0.84);font-size:16px;line-height:1.18;letter-spacing:-0.022em;font-family:Menlo, Monaco, &quot;Courier New&quot;, Courier, monospace;margin-bottom:-0.09em;white-space:pre-wrap;margin-top:1.41em;\\\">追蹤更多 Python 資訊，請關注 <a href=\\\"https://www.facebook.com/pyradise.geek/\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\">Pyradise 的臉書粉絲專頁</a>！</span><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-style:normal;color:rgba(0, 0, 0, 0.84);font-size:16px;line-height:1.18;letter-spacing:-0.022em;font-family:Menlo, Monaco, &quot;Courier New&quot;, Courier, monospace;margin-bottom:-0.09em;white-space:pre-wrap;margin-top:1.41em;\\\">想看影音教學？<br style=\\\"box-sizing:inherit;\\\"/>我們將在 Pyradise 的 <a href=\\\"https://www.youtube.com/channel/UCNxrkh1iD-tXfErHf5MkAjw?view_as=subscriber\\\" style=\\\"box-sizing:inherit;-webkit-tap-highlight-color:transparent;text-decoration:none;color:inherit;background-repeat:repeat-x;background-image:url(&quot;data:image/svg+xml;background-size:1px 1px;background-position:0px calc(1em + 1px);\\\">Youtube 頻道</a>，定期跟大家直播分享相關心得！</span><span style=\\\"box-sizing:inherit;font-weight:400;display:block;font-style:normal;color:rgba(0, 0, 0, 0.84);font-size:16px;line-height:1.18;letter-spacing:-0.022em;font-family:Menlo, Monaco, &quot;Courier New&quot;, Courier, monospace;margin-bottom:-0.09em;white-space:pre-wrap;margin-top:1.41em;\\\">訂閱我們！</span></pre><div style=\\\"box-sizing:inherit;margin:0px;margin-top:40px;\\\"><div style=\\\"box-sizing:inherit;display:block;position:relative;margin:auto;\\\"><div style=\\\"box-sizing:inherit;display:block;padding-bottom:74.2647%;\\\"><div style=\\\"box-sizing:inherit;top:0px;left:0px;width:680px;height:505px;position:absolute;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;vertical-align:baseline;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;color:rgb(68, 68, 68);box-sizing:border-box;vertical-align:baseline;font:inherit;font-family:&quot;Helvetica Neue&quot;, Helvetica, Helvetica, Arial, sans-serif;overflow:hidden;\\\">\\\n\\\n<div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"outline:0px;font-size:100%;background:transparent;font:inherit;box-sizing:border-box;margin:0px;padding:0px;border:0px;vertical-align:baseline;width:100%;height:100%;\\\"><div style=\\\"box-sizing:border-box;margin:0px;padding:0px;border:0px;outline:0px;font-size:100%;vertical-align:baseline;background:transparent;font:inherit;width:100%;height:100%;position:relative;\\\"><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"box-sizing:border-box;\\\"><div style=\\\"box-sizing:border-box;\\\">\\\n<div style=\\\"box-sizing:border-box;font-family:-apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;Calibri Light&quot;, Roboto, sans-serif;font-size:14px;line-height:1.42857;color:rgb(51, 51, 51);-webkit-tap-highlight-color:transparent;text-size-adjust:100%;display:flex;width:100%;height:100%;min-height:100%;-webkit-box-align:center;align-items:center;\\\">\\\n<div style=\\\"box-sizing:border-box;position:absolute;z-index:0;top:0px;left:0px;width:100%;height:100%;background-repeat:no-repeat;background-position:50% center;background-size:cover;background-color:rgb(255, 255, 255);\\\"></div>\\\n<div style=\\\"box-sizing:border-box;z-index:1;width:100%;max-width:580px;margin:0px auto;padding:40px;-webkit-box-align:stretch;align-items:stretch;-webkit-box-pack:center;justify-content:center;display:flex;-webkit-box-orient:vertical;-webkit-box-direction:normal;flex-direction:column;text-align:center;\\\">\\\n<div style=\\\"box-sizing:border-box;display:flex;-webkit-box-orient:vertical;-webkit-box-direction:normal;flex-direction:column;\\\">\\\n<div style=\\\"box-sizing:border-box;\\\">\\\n\\\n\\\n<div style=\\\"box-sizing:border-box;position:relative;padding-right:0px;padding-left:0px;\\\">\\\n\\\n<div style=\\\"box-sizing:border-box;width:100%;\\\">\\\n<div style=\\\"box-sizing:border-box;transition:border 0.5s ease 0s, box-shadow 0.5s ease 0s, background-color 0.5s ease 0s, -webkit-box-shadow 0.5s ease 0s;margin-bottom:15px;position:relative;opacity:1;\\\">\\\n<h1 style=\\\"box-sizing:border-box;font-size:27px;font-weight:600;line-height:1.3em;margin:0px 0px 15px;text-transform:none;\\\">\\\n訂閱 Pyradise\\\n</h1>\\\n</div>\\\n<div style=\\\"box-sizing:border-box;transition:border 0.5s ease 0s, box-shadow 0.5s ease 0s, background-color 0.5s ease 0s, -webkit-box-shadow 0.5s ease 0s;margin-bottom:15px;position:relative;opacity:1;\\\">\\\n<div style=\\\"box-sizing:border-box;line-height:1.5em;margin-bottom:20px;color:rgb(95, 95, 95);font-weight:400;\\\">\\\n在 Py 樂園輕鬆學習 Python\\\n</div>\\\n</div>\\\n<div style=\\\"box-sizing:border-box;transition:border 0.5s ease 0s, box-shadow 0.5s ease 0s, background-color 0.5s ease 0s, -webkit-box-shadow 0.5s ease 0s;margin-bottom:15px;position:relative;opacity:1;\\\">\\\n\\\n<span style=\\\"box-sizing:border-box;font-size:14px;line-height:1.5;position:absolute;z-index:10;top:0px;left:10px;display:flex;width:auto;height:48px;transition:all 0.1s ease-in-out 0s;color:rgb(170, 170, 170);border:1px solid transparent;-webkit-box-align:center;align-items:center;margin-bottom:0px;\\\">\\\nEmail\\\n</span>\\\n</div>\\\n<div style=\\\"box-sizing:border-box;font-size:17px;border-radius:6px;transition:border 0.5s ease 0s, box-shadow 0.5s ease 0s, background-color 0.5s ease 0s, -webkit-box-shadow 0.5s ease 0s;margin-bottom:15px;position:relative;opacity:1;\\\">\\\n<a href=\\\"#\\\" style=\\\"box-sizing:border-box;font-weight:500;line-height:48px;position:relative;min-width:120px;height:48px;padding:0px 1rem;white-space:nowrap;text-decoration:none;text-transform:none;background:rgb(255, 69, 0);box-shadow:rgba(50, 50, 93, 0.1) 0px 0px 0px 1px inset, rgba(50, 50, 93, 0.1) 0px 2px 5px 0px, rgba(0, 0, 0, 0.07) 0px 1px 1px 0px;display:block;text-align:center;border:none;border-radius:6px;color:rgb(255, 255, 255);\\\" target=\\\"_blank\\\">Sign up</a>\\\n</div>\\\n<div style=\\\"box-sizing:border-box;\\\">\\\n<div style=\\\"box-sizing:border-box;margin-bottom:15px;position:relative;width:100%;\\\">\\\n\\\n<span style=\\\"box-sizing:border-box;font-size:14px;position:relative;z-index:20;display:block;padding-left:35px;text-align:left;color:rgb(95, 95, 95);border-radius:3.2px;margin-bottom:0px;\\\"><span style=\\\"font-size:14px;text-align:left;color:rgb(95, 95, 95);position:absolute;top:0px;left:0px;display:block;width:20px;height:20px;border-radius:0.2rem;\\\"></span>I agree to leave and submit this information, which will be collected and used according to <a href=\\\"https://upscri.be/privacy\\\" style=\\\"box-sizing:border-box;color:rgb(170, 170, 170);\\\" target=\\\"_blank\\\">Upscribe's privacy policy</a>.<span style=\\\"font-size:14px;text-align:left;color:rgb(95, 95, 95);position:absolute;top:0px;left:0px;display:block;width:20px;height:20px;border-radius:0.2rem;border:2px solid rgb(255, 69, 0);background-repeat:no-repeat;background-position:50% center;background-size:50% 50%;\\\"></span></span>\\\n</div>\\\n</div>\\\n</div>\\\n</div>\\\n</div>\\\n\\\n</div>\\\n</div>\\\n\\\n</div>\\\n\\\n\\\n\\\n</div></div></div></div></div></div></div></div></div></div></div></div></div></div><span style=\\\"display:block;clear:both;\\\"></span></div></div></div></div></div></div></div></div>\\\n</div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":118793}]"
metadata_diff: {"new":{"id":"e7b5b011019d493a8d9fe97ce2c7b351","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345890534,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:20:27.371Z
created_time: 2025-11-28T16:20:27.371Z
type_: 13