{"id":186,"date":"2021-10-13T14:45:48","date_gmt":"2021-10-13T06:45:48","guid":{"rendered":"https:\/\/www.lucas88.cn\/?p=186"},"modified":"2021-10-13T14:45:48","modified_gmt":"2021-10-13T06:45:48","slug":"excel%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e6%88%90html%e8%a1%a8%e6%a0%bc%e5%b7%a5%e5%85%b7","status":"publish","type":"post","link":"https:\/\/www.lucas88.cn\/?p=186","title":{"rendered":"EXCEL\u8868\u683c\u8f6c\u6362\u6210HTML\u8868\u683c\u5de5\u5177"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

\u539f\u8868\u683c\u4e2d\u7b7e\u540d\u4e3a\u8def\u5f84\u4fe1\u606f\uff0c\u65e0\u6cd5\u67e5\u770b\uff01<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u8f6c\u6362\u540e\u5c06\u56fe\u7247\u8def\u5f84\u89e3\u6790\u6210\u56fe\u7247\u663e\u793a\u51fa\u6765<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u901a\u8fc7ie\u6253\u5f00\u540e\u7528\u865a\u62df\u6253\u5370\u673a\u53ef\u4ee5\u5c06\u9875\u9762\u6253\u5370\u6210pdf\u6587\u6863<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u6e90\u7801\uff1a<\/h2>\n\n\n
\n#! python3\n# -*- coding: utf-8 -*-\nimport openpyxl,pprint,os\nimport PySimpleGUI as sg\ndef data_processing():\n    wb = openpyxl.load_workbook(values['-xz1-'])\n    sheet = wb[str(wb.sheetnames[0])]\n    f_5 = open(values['-xz2-']+'\/\u9879\u76ee\u6570\u636e\u8868.html','a')\n    f_5.write('<!DOCTYPE html>'+"\\n"+'<html>' +"\\n" + '<body>' +"\\n"+ '<table border="1">' +"\\n")\n    for i in range(1,sheet.max_row+1):\n        f_5.write('<tr>'+"\\n")\n        for c in range(1,sheet.max_column+1):\n            name = sheet.cell(i,c).value\n            if ".png" in  str(name):\n                f_5.write('<th><img src="https:\/\/ylwxsb.19wms.com' + str(name) + '" height="31" width="90"><\/th>' + "\\n")\n            else:\n                f_5.write('<th>' + str(name) + '<\/th>' +"\\n")\n        f_5.write('<\/tr>'+"\\n")\n    f_5.write('<\/table>' +"\\n" + '<\/body>' +"\\n"+ '<\/html>' +"\\n")\n    f_5.close()\nlayout = [\n[sg.T('\u8868\u683c\u8def\u5f84:',size=(8,1),key='-xm-'),sg.T(' ',size=(40,1),key='-bglj-'),sg.FileBrowse('\u9009\u62e9',key='-xz1-')],#sg.FileBrowse\u9009\u62e9\u6587\u4ef6\u8def\u5f84\uff0c\u548csg.T\u540c\u4e00\u884c\u4f1a\u81ea\u52a8\u4f20\u9012\u8def\u5f84\u4fe1\u606f\u5230sg.T\n[sg.T('\u4fdd\u5b58\u8def\u5f84:',size=(8,1),key='-xb-'),sg.T(' ',size=(40,1),key='-bclj-'),sg.FolderBrowse('\u9009\u62e9',key='-xz2-')],#sg.FolderBrowse\u9009\u62e9\u6587\u4ef6\u5939\u8def\u5f84\uff0c\u548csg.T\u540c\u4e00\u884c\u4f1a\u81ea\u52a8\u4f20\u9012\u8def\u5f84\u4fe1\u606f\u5230sg.T\n[sg.T(' ',size=(20,2)),sg.B('\u8f6c\u6362',size=(8,2),key='-zh-')]\n]\nwindow=sg.Window('Excel\u8f6c\u6362HTML\u8868\u683c',layout)\nwhile True:\n    event,values=window.read()\n    if event==None:\n        break\n    if event=='-zh-':\n        if values['-xz1-']=="" or values['-xz2-']=="":\n            sg.Popup('\u8bf7\u9009\u62e9\u8868\u683c\u548c\u8f6c\u6362\u540e\u7684\u4fdd\u5b58\u8def\u5f84!')\n        elif ".xlsx" not in values['-xz1-']:\n            sg.Popup('\u53ea\u652f\u6301\u8f6c\u6362xlsx\u4e3a\u540e\u7f00\u7684\u8868\u683c\u6587\u4ef6!')\n        else:\n            print("\u8f6c\u6362\u5f00\u59cb")\n            data_processing()\n            sg.Popup('\u5904\u7406\u5b8c\u6210')\nwindow.close()\n\n\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
\u539f\u8868\u683c\u4e2d\u7b7e\u540d\u4e3a\u8def\u5f84\u4fe1\u606f\uff0c\u65e0\u6cd5\u67e5\u770b\uff01 \u8f6c\u6362\u540e\u5c06\u56fe\u7247\u8def\u5f84\u89e3\u6790\u6210\u56fe\u7247\u663e\u793a\u51fa\u6765 \u901a\u8fc7ie\u6253\u5f00\u540e\u7528\u865a\u62df\u6253\u5370\u673a\u53ef\u4ee5\u5c06\u9875\u9762\u6253… <\/p>\n
\u9605\u8bfb\u66f4\u591a<\/i><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-186","post","type-post","status-publish","format-standard","hentry","category-python"],"_links":{"self":[{"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=186"}],"version-history":[{"count":1,"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=\/wp\/v2\/posts\/186\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lucas88.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}