{"id":1219,"date":"2022-07-12T11:24:44","date_gmt":"2022-07-12T03:24:44","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1219"},"modified":"2022-07-12T11:24:44","modified_gmt":"2022-07-12T03:24:44","slug":"%e5%a4%84%e7%90%86excel%e7%99%be%e5%88%86%e5%8f%b7%e5%ad%97%e7%ac%a6","status":"publish","type":"post","link":"\/?p=1219","title":{"rendered":"\u5904\u7406excel\u767e\u5206\u53f7\u5b57\u7b26"},"content":{"rendered":"<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>&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\u4ece1\u5f00\u59cb\u8ba1\u6570) \u6240\u6709\u8868\u3001sheet\u9700\u8981   \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":[83,82,16],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1219"}],"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=1219"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":1220,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions\/1220"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}