{"id":5237,"date":"2022-04-02T18:35:22","date_gmt":"2022-04-02T10:35:22","guid":{"rendered":"https:\/\/egonlin.com\/?p=5237"},"modified":"2022-04-02T18:35:22","modified_gmt":"2022-04-02T10:35:22","slug":"01-%e7%ae%80%e4%bb%8b","status":"publish","type":"post","link":"https:\/\/egonlin.com\/?p=5237","title":{"rendered":"01 \u7b80\u4ecb"},"content":{"rendered":"

1\u3001\u5bfc\u8bed<\/h1>\n

\u200b \u968f\u7740python\u73b0\u5728\u7684\u751f\u6001\u73af\u5883\u9010\u6e10\u6210\u719f\uff0c\u5b83\u7684\u529f\u80fd\u4e5f\u65e5\u76ca\u5b8c\u5584\uff0c\u9010\u6e10\u8d70\u8fdb\u4e86\u4e2a\u5404\u884c\u5404\u4e1a\u7684\u65e5\u5e38\u4f7f\u7528\u3002\u5176\u4e2d\u4e00\u4e2a\u6bd4\u8f83\u5e38\u7528\u7684\u6280\u80fd\u5c31\u662f\u901a\u8fc7python\u64cd\u4f5cexcel\u3002\u800c\u4e14python \u7684\u5b66\u4e60\u5bf9\u4e8e\u65b0\u624b\u5c0f\u767d\u6765\u8bf4\u8fd8\u662f\u975e\u5e38\u7684\u53cb\u597d\uff0c\u4ed6\u4e0d\u9700\u8981\u4f60\u82b1\u5f88\u5927\u7684\u529b\u6c14\u628a python\u6240\u6709\u7684\u57fa\u7840\u77e5\u8bc6\u90fd\u5b66\u5b8c\u624d\u80fd\u5b8c\u6210excel\u8868\u683c\u7684\u64cd\u4f5c\uff0c\u53ea\u9700\u8981\u5355\u72ec\u5b66\u4e60\u67d0\u4e00\u4e2a\u5de5\u5177\u5305\u5373\u53ef\u3002<\/p>\n

\"\"<\/div><\/p>\n

2\u3001\u5b89\u88c5\u5de5\u5177<\/h1>\n

\u64cd\u4f5cexcel\u8868\u683c\u6700\u91cd\u8981\u7684\u4e24\u4e2a\u6b65\u9aa4\uff1a\u4e00\u662f\u5c06\u6570\u636e\u8bfb\u51fa\u6765\uff1b\u4e8c\u662f\u5c06\u6570\u636e\u5199\u8fdb\u53bb<\/p>\n

pip install xlrd  # \u8bfb\u53d6 Excel \u6587\u4ef6\n\npip install xlwt  # \u5199\u5165 Excel \u6587\u4ef6\n\npip install xlutils  # \u64cd\u4f5c Excel \u6587\u4ef6\u7684\u5b9e\u7528\u5de5\u5177\uff0c\u5982\u590d\u5236\u3001\u5206\u5272\u3001\u7b5b\u9009\u7b49<\/code><\/pre>\n
3\u3001\u5de5\u5177\u4ecb\u7ecd<\/h1>\n
\u4ee5\u4e0bexcel\u5e93\u662f\u76ee\u524d\u4f7f\u7528\u6700\u591a\u7684\u5de5\u5177\u5305\uff0c\u4f46\u662f\u8fd8\u662f\u6709\u4e00\u4e9b\u7f3a\u9677\uff0c\u5c31\u662fxlwt\u4e0d\u652f\u6301xlsx\uff0c\u5982\u679c\u5bf9\u8fd9\u4e2a\u683c\u5f0f\u7684\u6587\u4ef6\u6709\u9700\u6c42\uff0c\u53ef\u4ee5\u4e86\u89e3\u4e00\u4e0bopenpyxl\u548cxlsxwriter\u3002\u4f46\u662f\u672c\u7cfb\u5217\u4e3b\u8981\u4ecb\u7ecd\u7684\u4ee5\u4e0b\u4e09\u4e2a\uff1a<\/p>\n
3.1\u3001xlrd\u6a21\u5757\u4ecb\u7ecd<\/h2>\n
    \n
  • xlrd\u80fd\u591f\u8bfb\u53d6excel\u8868\u683c\u6570\u636e<\/li>\n
  • \u652f\u6301xlsx\u548cxls\u683c\u5f0f\u7684excel\u8868\u683c<\/li>\n
  • xlrd\u6240\u8bfb\u53d6\u7684excel\u6570\u636e\u53ef\u80fd\u7684\u683c\u5f0f\u6709\u4ee5\u4e0b7\u79cd\uff1a\n
      \n
    • empty\uff08\u7a7a\uff09<\/li>\n
    • text\uff08string\uff09<\/li>\n
    • number<\/li>\n
    • date<\/li>\n
    • boolean<\/li>\n
    • error<\/li>\n
    • blank\uff08\u7a7a\u767d\u8868\u683c\uff09<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      3.2\u3001xlwt\u6a21\u5757\u4ecb\u7ecd<\/h2>\n
        \n
      • xlwt\u80fd\u591f\u5199\u5165excel\u8868\u683c\u6570\u636e<\/li>\n
      • \u652f\u6301xls\u683c\u5f0f\u7684excel\u8868\u683c\uff08\u4e0d\u53ef\u5199xlsx\uff09<\/li>\n<\/ul>\n
        3.3\u3001xlutils\u6a21\u5757\u4ecb\u7ecd<\/h2>\n
          \n
        • \n
          \u7528\u4e8e\u64cd\u4f5c\u3001\u4fee\u6539excel\u6587<\/p>\n<\/li>\n
        • \n
          xlrd\u548cxlwt\u4e4b\u95f4\u7684\u4e00\u5ea7\u6865\u6881<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
          1\u3001\u5bfc\u8bed \u200b \u968f\u7740python\u73b0\u5728\u7684\u751f\u6001\u73af\u5883\u9010\u6e10\u6210\u719f\uff0c\u5b83\u7684\u529f\u80fd\u4e5f\u65e5\u76ca\u5b8c\u5584\uff0c\u9010\u6e10\u8d70\u8fdb\u4e86\u4e2a\u5404\u884c\u5404\u4e1a\u7684\u65e5\u5e38\u4f7f\u7528\u3002\u5176\u4e2d […]<\/p>\n","protected":false},"author":3,"featured_media":5238,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[371,379],"tags":[],"_links":{"self":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/5237"}],"collection":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5237"}],"version-history":[{"count":0,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/5237\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/media\/5238"}],"wp:attachment":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}