{"id":1703,"date":"2023-05-27T09:13:30","date_gmt":"2023-05-27T01:13:30","guid":{"rendered":"http:\/\/viplao.com\/?p=1703"},"modified":"2023-05-27T09:13:32","modified_gmt":"2023-05-27T01:13:32","slug":"%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-%e6%8c%89%e6%a8%a1%e7%89%88%e8%be%93%e5%87%ba%e7%bb%9f%e4%b8%80%e6%b8%85%e5%8d%95","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2023\/05\/27\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-%e6%8c%89%e6%a8%a1%e7%89%88%e8%be%93%e5%87%ba%e7%bb%9f%e4%b8%80%e6%b8%85%e5%8d%95\/","title":{"rendered":"\u8fd0\u7ef4\u5de5\u5177 \u2013 PYTHON \u65e5\u5e38\u6570\u636e\u5206\u6790 \u2013 \u6309\u6a21\u7248\u8f93\u51fa\u7edf\u4e00\u6e05\u5355"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>from openpyxl import load_workbook\r\nworkbook = load_workbook('file.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\nfor key, value in data.items():\r\n    print(key, value)\r\nworkbook_day = load_workbook('\u6a21\u677f.xlsx')\r\nworksheet_day = workbook_day&#91;'\u51fa\u8d27\u6e05\u5355\u6a21\u677f']\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\nworkbook_day.save('fileout.xlsx')<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[14,28],"views":572,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1703"}],"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=1703"}],"version-history":[{"count":1,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1703\/revisions"}],"predecessor-version":[{"id":1704,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1703\/revisions\/1704"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=1703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=1703"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=1703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}