{"id":834,"date":"2022-09-18T00:22:12","date_gmt":"2022-09-17T16:22:12","guid":{"rendered":"http:\/\/viplao.com\/?p=834"},"modified":"2022-09-18T22:26:07","modified_gmt":"2022-09-18T14:26:07","slug":"%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-%e5%bc%82%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%ef%bc%8c%e6%89%b9%e9%87%8f%e7%94%9f%e6%88%90%e7%bb%9f%e8%ae%a1%e6%b8%85%e5%8d%95","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2022\/09\/18\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-%e5%bc%82%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%ef%bc%8c%e6%89%b9%e9%87%8f%e7%94%9f%e6%88%90%e7%bb%9f%e8%ae%a1%e6%b8%85%e5%8d%95\/","title":{"rendered":"\u8fd0\u7ef4\u5de5\u5177 \u2013 \u5f02\u5e38\u6570\u636e\u5206\u6790\u5b9e\u8df5\uff0c\u6279\u91cf\u751f\u6210\u7edf\u8ba1\u6e05\u5355"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\npip install openpyxl==3.0.5\n\nfrom openpyxl import load_workbook\r\nworkbook = load_workbook('\\\u7edf\u8ba1\u8868.xlsx')\r\nworksheet = workbook&#91;'Sheet1']\r\ndata = {}\r\nfor row in range(2, worksheet.max_row + 1):\r\n    date = worksheet&#91;'B' + str(row)].value.date()\r\n    customer = worksheet&#91;'C' + str(row)].value\r\n    product = worksheet&#91;'D' + str(row)].value\r\n    number = worksheet&#91;'E' + str(row)].value\r\n    model = worksheet&#91;'G' + str(row)].value\r\n    info_list = &#91;customer, product, number, model]\r\n    data.setdefault(date, &#91;])\r\n    data&#91;date].append(info_list)\r\n\r\n\r\nfor key, value in data.items():\r\n    print(key, value)\r\nworkbook_day = load_workbook('\\\u6e05\u5355\u6a21\u677f.xlsx')\r\nworksheet_day = workbook_day&#91;'\u6e05\u5355\u6a21\u677f']\r\n\r\nfor date in data.keys():\r\n    worksheet_new = workbook_day.copy_worksheet(worksheet_day)\r\n    worksheet_new.title = str(date)&#91;-5:]\r\n    worksheet_new.cell(row=2, column=5).value = date\r\n    i = 4\r\n    for product in data&#91;date]:\r\n        worksheet_new.cell(row=i, column=2).value = product&#91;0]\r\n        worksheet_new.cell(row=i, column=3).value = product&#91;1]\r\n        worksheet_new.cell(row=i, column=4).value = product&#91;2]\r\n        worksheet_new.cell(row=i, column=5).value = product&#91;3]\r\n        i += 1\r\n\r\nworkbook_day.save('\u76ee\u6807\u6e05\u5355.xlsx')<\/code><\/pre>\n\n\n\n<p>\u6e05\u5355\u6a21\u677f<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"933\" height=\"494\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-361.png\" alt=\"\" class=\"wp-image-835\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-361.png 933w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-361-300x159.png 300w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-361-768x407.png 768w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-361-567x300.png 567w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u7edf\u8ba1\u8868\u5185\u5bb9\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"214\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-362-1024x214.png\" alt=\"\" class=\"wp-image-836\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-362-1024x214.png 1024w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-362-300x63.png 300w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-362-768x160.png 768w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-362-850x177.png 850w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-362.png 1217w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u7ed3\u679c \uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"891\" height=\"1015\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-363.png\" alt=\"\" class=\"wp-image-837\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-363.png 891w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-363-263x300.png 263w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/09\/image-363-768x875.png 768w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u6e05\u5355\u6a21\u677f \u7edf\u8ba1\u8868\u5185\u5bb9\uff1a \u7ed3\u679c \uff1a<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"views":674,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/834"}],"collection":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/comments?post=834"}],"version-history":[{"count":2,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/834\/revisions"}],"predecessor-version":[{"id":846,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/834\/revisions\/846"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}