{"id":114,"date":"2022-04-15T10:13:03","date_gmt":"2022-04-15T02:13:03","guid":{"rendered":"http:\/\/homeyk.com\/?p=114"},"modified":"2024-07-07T19:18:54","modified_gmt":"2024-07-07T11:18:54","slug":"%e6%9f%a5%e6%89%be%e5%85%b3%e9%94%ae%e5%ad%97%e7%9a%84%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"http:\/\/homeyk.com\/?p=114","title":{"rendered":"python | \u67e5\u627eexcel\u6587\u6863\u4e2d\u6307\u5b9a\u5173\u952e\u5b57\u7684\u4ee3\u7801"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import os\nimport xlrd\nimport xlwt\n\n\ndef w2p_add(files_root):\n    files_root = files_root.replace('\\\\', '\\\\\\\\')\n    return files_root\n\ndef search(kw, file, sheet):\n\n    # \u6253\u5f00xls\u6587\u6863\n    r = 0\n    for root, dir, file in os.walk(file):\n        for f in file:\n            add = os.path.join(root, f)\n            endswith=(\".xls\",\"xlsx\")\n            if f.endswith(endswith):\n                try:\n                    rdbook = xlrd.open_workbook(add)\n                    names = rdbook.sheet_names()\n                    # \u6253\u5f00xls\u4e2d\u7684\u5de5\u4f5c\u8868\uff0c\u5e76\u67e5\u627e\u5355\u5143\u683c\u7684\u503c\n                    for i in names:\n                        ws = rdbook.sheet_by_name(i)  # \u83b7\u53d6\u5de5\u4f5c\u8868\n                        for row in range(ws.nrows):\n                            value = ws.row_values(row)  # \u751f\u6210\u6bcf\u4e00\u884c\u7684\u503c \u5217\u8868\n                            for j in value:\n                                if kw in str(j):\n                                    print(add,\"found\")\n                                    sheet.write(r, 0, add)\n                                    sheet.write(r, 1, i)\n                                    sheet.write(r, 3, j)\n                                    sheet.write(r, 2, row)\n                                    sheet.write(r, 4, root.split(\"\\\\\")[-2])\n                                    sheet.write(r, 5, root.split(\"\\\\\")[-1])\n                                    #sheet.write(r, 6, root.split(\".\")[-2])\n                                    r += 1\n                                    break\n                except xlrd.biffh.XLRDError:\n                    continue\nfile = input((\"\u8981\u9501\u5b9a\u67e5\u627e\u7684\u76ee\u5f55\uff1a\"))\nw2p_add(file)\n\nkeyword = input(\"\u9700\u8981\u67e5\u627e\u7684\u503c\u662f\uff1a\")\n\n# \u67e5\u627e\u7684\u76ee\u6807\u6587\u4ef6\u5939\u3002\nwtbook = xlwt.Workbook()\nwtsheet = wtbook.add_sheet('result')\n\nsearch(keyword, file, wtsheet)\nwtbook.save(f\"{keyword}_found.xls\")<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[15,16],"_links":{"self":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts\/114"}],"collection":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=114"}],"version-history":[{"count":1,"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions"}],"predecessor-version":[{"id":157,"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions\/157"}],"wp:attachment":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}