{"id":1498,"date":"2023-02-16T11:42:39","date_gmt":"2023-02-16T03:42:39","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1498"},"modified":"2023-02-16T11:42:39","modified_gmt":"2023-02-16T03:42:39","slug":"excel%e6%89%b9%e9%87%8f%e5%a4%84%e7%90%86xlsx%e6%96%87%e4%bb%b6%ef%bc%8c%e6%9b%b4%e6%94%b9%e6%9f%90%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"\/?p=1498","title":{"rendered":"excel:\u6279\u91cf\u5904\u7406xlsx\u6587\u4ef6\uff0c\u66f4\u6539\u67d0\u6570\u636e"},"content":{"rendered":"<p>\u54ea\u6b21\u5e2e\u8c01\u5199\u7684\u5c0f\u811a\u672c,\u8bb0\u5f55\u4e00\u4e0b...<\/p>\n<pre><code class=\"language-python\">&quot;&quot;&quot;\n\u8bfb\u53d6\u5f53\u524d\u76ee\u5f55\u4e0b\u6240\u6709xlsx\u6587\u4ef6\uff0c\n\u8f93\u5165\u6240\u9700\u5904\u7406\u6570\u636e\u6240\u5728\u5217(\u5747\u4ece1\u5f00\u59cb\u8ba1\u6570)\n\u6240\u6709\u8868\u3001sheet\u9700\u8981\u7edf\u4e00\u767e\u5206\u53f7\u6240\u5728\u7684\u5217\n\u6700\u540e\u4fdd\u5b58\u66f4\u6539\npip install openpyxl==3.0.9\n&quot;&quot;&quot;\nimport os\nimport openpyxl\nCOLUMN_NUM = 1\n\ndef get_file_name():\n    files = os.listdir(&#039;.\/&#039;)\n    file_list = []\n    for f in files:\n        if f.endswith(&#039;.xlsx&#039;):\n            file_name = f\n            file_name = &#039;.\/&#039; + file_name\n            file_list.append(file_name)\n    if not file_list:\n        raise NameError(&#039;\u8bf7\u68c0\u67e5\u6587\u4ef6\u5939\uff0c\u5f53\u524d\u65e0xlsx\u6587\u4ef6\uff01&#039;)\n    return file_list\n\ndef run():\n    file_list = get_file_name()\n    column_num = COLUMN_NUM\n    for file_name in file_list:\n        print(&#039;\u5f53\u524d\u6b63\u5728\u5904\u7406--&#039;+file_name)\n        book = openpyxl.load_workbook(file_name)\n        for sheet in book.worksheets:\n            len_row = sheet.max_row\n            for row in range(len_row):\n                cell = sheet.cell(row+1, column_num)\n                if type(cell.value) == float:\n                    if cell.style == &#039;\u767e\u5206\u6bd4&#039;:\n                        sheet.cell(row+1, column_num+1).value = cell.value * 100\n                        sheet.cell(row + 1, column_num).style = &#039;\u5e38\u89c4&#039;\n            book.save(filename=file_name)\n        book.close()\n        print(&#039;\u5904\u7406\u7ed3\u675f--&#039;+file_name)\n\nif __name__ == &#039;__main__&#039;:\n    run()<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u54ea\u6b21\u5e2e\u8c01\u5199\u7684\u5c0f\u811a\u672c,\u8bb0\u5f55\u4e00\u4e0b&#8230; &quot;&quot;&quot; \u8bfb\u53d6\u5f53\u524d\u76ee\u5f55\u4e0b\u6240\u6709xlsx\u6587\u4ef6\uff0c \u8f93\u5165\u6240\u9700\u5904\u7406\u6570\u636e\u6240\u5728\u5217(\u5747\u4ece   \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[48],"tags":[],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1498"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1498"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions"}],"predecessor-version":[{"id":1499,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions\/1499"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1498"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}