{"id":4902,"date":"2020-09-11T10:59:17","date_gmt":"2020-09-11T01:59:17","guid":{"rendered":"http:\/\/kats-eye.net\/info\/?p=4902"},"modified":"2020-09-12T16:15:47","modified_gmt":"2020-09-12T07:15:47","slug":"python-get-browser-info","status":"publish","type":"post","link":"https:\/\/kats-eye.net\/info\/2020\/09\/11\/python-get-browser-info\/","title":{"rendered":"PYTHON\u3067WEB\u691c\u7d22(Beautiful Soup 4)"},"content":{"rendered":"\n

\u6982\u8981<\/h2>\n\n\n\n

\u3000\u5148\u56de\u306f\u30a8\u30af\u30bb\u30ebVBA\u304b\u3089\u3001IE \uff08\u30a4\u30f3\u30bf\u30cd\u30c3\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\uff09\u3092\u64cd\u4f5c\u3057\u3001\u7c21\u5358\u306a\u30c7\u30fc\u30bf\u691c\u7d22\u3092\u884c\u3044\u307e\u3057\u305f\u3002
\u3000\u4eca\u56de\u306f\u3001python \u3068 Beautiful Soup 4<\/a>\u3068\u3044\u3046\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f7f\u3063\u3066 \u5148\u56de\u884c\u3063\u305f\u306e\u3068\u540c\u3058\u82f1\u5358\u8a9e\u691c\u7d22\u3092\u8a66\u307f\u307e\u3057\u305f\u3002 IE\u306e\u958b\u767a\u306f\u7d42\u4e86\u3057\u3001\u30b5\u30dd\u30fc\u30c8\u3082\u7e2e\u5c0f\u3057\u3064\u3064\u3042\u308b\u3068\u306e\u3053\u3068\u3067\u3059\u306e\u3067\u3001\u5177\u4f53\u7684\u5229\u7528\u3082\u60f3\u5b9a\u3057\u3001\u4ed6\u306e\u65b9\u6cd5\u3082\u8abf\u3079\u3066\u307f\u3088\u3046\u3068\u601d\u3063\u305f\u306e\u304c\u767a\u7aef\u3067\u3059\u3002
\u3000\u6700\u8fd1\u3001\u5c11\u3057 python \u306b\u3082\u89e6\u308c\u3001\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u5145\u5b9f\u3057\u3066\u3044\u308b\u306e\u3067\u9762\u767d\u3044\u3068\u611f\u3058\u3066\u3044\u307e\u3059\u304c\u3001\u4ed6\u306e\u4eba\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u914d\u5e03\u3059\u308b\u306e\u304c\u8ab2\u984c\u3060\u3068\u611f\u3058\u3066\u3044\u307e\u3057\u305f\u3002\u3068\u3053\u308d\u304c\u3001python \u30d7\u30ed\u30b0\u30e9\u30e0\u306e \u201cEXE\u5316\u201d \u306b\u3064\u3044\u3066\u306e\u8a18\u4e8b\u3092\u898b\u3064\u3051\u307e\u3057\u305f\u306e\u3067\u78ba\u8a8d\u3057\u305f\u5185\u5bb9\u3082\u5831\u544a\u3057\u307e\u3059\u3002
<\/p>\n\n\n\n

\u30e9\u30a4\u30d6\u30e9\u30ea\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n\n\n\n

\u3000\u201crequests\u201d\u3068\u201cbeautifulsoup4\u201d \u3068\u3044\u3046\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002requests \u3092\u4f7f\u3063\u3066Web\u30b5\u30a4\u30c8\u306eHTML\u3084\u753b\u50cf\u306a\u3069\u306e\u60c5\u5831\u3092\u53ce\u96c6\u3057\u3001 beautifulsoup4 \u3067\u6b32\u3057\u3044\u90e8\u5206\u3092\u89e3\u6790\u30fb\u62bd\u51fa\u3059\u308b\u3068\u3044\u3046\u4f7f\u3044\u65b9\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\uff08\uff11\uff09 requests \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n\n\n\n

\"\"
python -m pip install requests<\/strong><\/figcaption><\/figure>\n\n\n\n

\uff08\uff12\uff09 beautifulsoup4 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n\n\n\n

\"\"
python -m pip install beautifulsoup4<\/strong>
\u3000\u3000<\/figcaption><\/figure>\n\n\n\n

Python WEB\u691c\u7d22 \u30c6\u30b9\u30c8\u30d7\u30ed\u30b0\u30e9\u30e0<\/h2>\n\n\n\n

\u3000\u306f\u3058\u3081\u306b\u3001 requests \uff0c Beautiful Soup 4<\/a> \u306e\u4f7f\u3044\u65b9\u304c\u5224\u308a\u307e\u305b\u3093\u306e\u3067\u3001\u4e0b\u8a18\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u306a\u304c\u3089\u4f7f\u3044\u65b9\u3092\u5b66\u3073\u307e\u3057\u305f\u3002
\u3000 \u201crequests\u201d \u3067WEB\u30da\u30fc\u30b8\u306eHTML\u3092\u53d6\u5f97\u3057\u3001Beautiful Soup 4<\/a> \u3092\u4f7f\u3063\u3066\u3001\u30bf\u30b0\uff0c\u30af\u30e9\u30b9\uff0cID\u7b49\u304b\u3089\u3001\u5fc5\u8981\u60c5\u5831\u3092\u53ce\u96c6\u3057\u307e\u3059\u3002<\/p>\n\n\n

import os\nimport urllib.error\nimport urllib.request\nimport requests\nfrom bs4 import BeautifulSoup\nimport tkinter as tk\nfrom tkinter import messagebox\n\n# \u753b\u50cf\u30d5\u30a1\u30a4\u30eb\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\ndef download_file( url , dst_path ):\n    try:\n        with urllib.request.urlopen(url) as web_file:\n            data = web_file.read()\n\n            with open(dst_path , mode=\"wb\") as local_file:\n                local_file.write(data)\n                \n    except urllib.error.URLError as e:\n        print(e)\n\n\n        \n\nroot = tk.Tk()\nroot.withdraw()\n\ns_word = \"apprentice\"                                   # \u691c\u7d22\u5358\u8a9e\n\nhtml_text = requests.get(\"https:\/\/[\u7701\u7565]\/content\/\" +s_word).text\nsoup = BeautifulSoup(html_text, 'html.parser')          # BeautifulSoup\u521d\u671f\u5316\n\n# print(soup.prettify())                                # \u30a4\u30f3\u30c7\u30f3\u30c8\u51e6\u7406                  \n\n# \u30bf\u30a4\u30c8\u30eb\u53d6\u5f97\ntitle_text = soup.find('title').get_text()              # \u30bf\u30a4\u30c8\u30eb\nprint(\"\u3010TITLE\u3011\" + title_text)\nprint(\"\")\n\n# \u5358\u8a9e\u30fb\u610f\u5473\u53d6\u5f97\nchk_way=\"find\"                                          # \u691c\u7d22\u65b9\u6cd5\u9078\u629e\nif chk_way==\"find\" :\n    w_find = soup.find(\"span\", id=\"[\u7701\u7565]\").text\n    w_mean = soup.find(\"td\", class_=\"[\u7701\u7565]\").text    \nelse: \n    w_find = soup.select_one(\"[\u7701\u7565]\").text\n    w_mean = soup.select_one(\"[class='[\u7701\u7565]']\").text\n\nprint(\"\u3010\"+ w_find +\"\u3011\" + w_mean)\nprint(\"\")\n\n\n# \u97f3\u58f0\u30d5\u30a1\u30a4\u30eb\uff35\uff32\uff2c\u53d6\u5f97\nSND_URL = soup.find(\"audio\", class_=\"[\u7701\u7565]\").find(\"source\")['src']\nprint(\"\u3010AUDIO FILE\u3011\" , end = \"\")\nprint(SND_URL)\nprint(\"\")\n\nroot , ext = os.path.splitext(SND_URL)                  # \u62e1\u5f35\u5b50\u53d6\u5f97\nDST_F = os.path.join(os.getcwd() ,\"snd\" , s_word+ext)   # \u4fdd\u5b58\uff8c\uff67\uff72\uff99\u540d\u53d6\u5f97\n\n#print(DST_F)                                           # \u4fdd\u5b58\uff8c\uff67\uff72\uff99\u540d\n#print(os.getcwd())                                     # \uff8c\uff9f\uff9b\uff78\uff9e\uff97\uff91\uff8c\uff6b\uff99\uff80\uff9e\n#print(__file__)                                        # \uff8c\uff67\uff72\uff99\uff8a\uff9f\uff7d\n\ntry:\n    download_file( SND_URL , DST_F )\n    jdg_dl = \"\u3007\"\nexcept:\n    jdg_dl = \"\u00d7\"\n\n#print(\"\u3010DOWNLOAD\u3011  \" + jdg_dl )\n    \nmessagebox.showinfo( w_find , w_mean )\n<\/pre>\n
<\/p>\n\n\n
\u3000\u6b21\u306e\u56f3\u306e\u901a\u308a\u3001WEB\u30da\u30fc\u30b8\u30bf\u30a4\u30c8\u30eb\uff0c\u5358\u8a9e\u306e\u610f\u5473\uff0c\u97f3\u58f0\u30d5\u30a1\u30a4\u30ebURL\u3092\u53d6\u5f97\u3057\u51fa\u529b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"

\u3000\u3000<\/figcaption><\/figure>\n\n\n\n
VBA\u5bfe\u5fdc\u306e\u6539\u9020\uff08\u9023\u7d9a\u51e6\u7406\uff09<\/h2>\n\n\n\n
\u3000\u5148\u56de\uff36\uff22\uff21\u304b\u3089\u306e\uff29\uff25\u64cd\u4f5c\u306b\u3088\u308b\u82f1\u5358\u8a9e\u691c\u7d22\u540c\u69d8\u306b\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u4e0a\u306e\u5358\u8a9e\u3092\u9023\u7d9a\u3057\u3066\u691c\u7d22\u3067\u304d\u308b\u69d8\u306b\u6539\u9020\u3057\u307e\u3059\u3002\u4e0b\u56f3\u306e\u901a\u308a\u30b7\u30fc\u30c8\u5916\u89b3\u306f\u5148\u56de\u3068\u307b\u3068\u3093\u3069\u540c\u3058\u3067\u3059\u3002
\u3000\u65b9\u6cd5\u306f\u30a8\u30af\u30bb\u30eb\uff36\uff22\uff21\u304b\u3089\u3001WshShell \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u5229\u7528\u3057\u3001\u30b7\u30fc\u30c8\u306e\u5358\u8a9e\u3092\uff11\u8a9e\u3065\u3064\u5f15\u6570\u6e21\u3057\u3057\u30d7\u30ed\u30b0\u30e9\u30e0\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
 \u3000\u5148\u56de\u306b\u6bd4\u3079\u3001\u4eca\u56de\u306f\u30d6\u30e9\u30a6\u30b6\u30fc\u8d77\u52d5\u3057\u306a\u3044\u3053\u3068\u3082\u3042\u308a\u3001\u4e0b\u8868\u306e\u901a\u308a\u691c\u7d22\u6642\u9593\u3092\u5927\u304d\u304f\u77ed\u7e2e\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3057\u305f\u3002\u4f46\u3057\u3001VBA-IE\u64cd\u4f5c \u306e\u5834\u5408\u3067\u3082\u30d6\u30e9\u30a6\u30b6\u30fc\u3092\u975e\u8868\u793a\u306b\u3057\u3066\u691c\u7d22\u6642\u9593\u3092\u77ed\u7e2e\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u306a\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n
\u65b9\u6cd5<\/td>\u691c\u7d22\u6642\u9593
(\u79d2\/19\u8a9e)<\/td>		\u691c\u7d22\u6642\u9593
(\u79d2\/\u8a9e)<\/td><\/tr>
 VBA-\uff29\uff25\u64cd\u4f5c <\/td>171<\/td>9<\/td><\/tr>
 Python \uff0b
BeautifulSoup4 <\/td>		27<\/td>1.42<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\u25a0 WEB\u691c\u7d22 Python \u30d7\u30ed\u30b0\u30e9\u30e0\u6539\u9020<\/h4>\n\n\n\n
\u3000\u691c\u7d22\u3092\u884c\u3046Python\u5074\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u3001VBA\u304b\u3089\u5916\u90e8\u8d77\u52d5\u3055\u308c\u305f\u6642\u306b\u5f15\u6570\u3068\u3057\u3066\u82f1\u5358\u8a9e\u3092\u53d7\u3051\u53d6\u308a\u3001\u30c6\u30b9\u30c8\u30d7\u30ed\u30b0\u30e9\u30e0\u540c\u69d8\u306bWEB\u691c\u7d22\u5f8c\u3001\u7d50\u679c\u3092\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n\n\n
import os\nimport sys\nimport urllib.error\nimport urllib.request\nimport requests\nfrom bs4 import BeautifulSoup\nimport tkinter as tk\nfrom tkinter import messagebox\n\n\n\ndef download_file( url , dst_path ):\n    try:\n        with urllib.request.urlopen(url) as web_file:\n            data = web_file.read()\n\n            with open(dst_path , mode=\"wb\") as local_file:\n                local_file.write(data)\n                \n    except urllib.error.URLError as e:\n        print(e)\n\n\ndef search_e_word(e_wrd):\n    \n    s_word = e_wrd\n    dirPth = \"C:\/Users\/[\u7701\u7565]\/snd\/\"\n    html_text = requests.get(\"https:\/\/[\u7701\u7565]\/content\/\" +s_word).text\n    soup = BeautifulSoup(html_text, 'html.parser')                              # BeautifulSoup\u521d\u671f\u5316\n\n    w_mean = soup.find(\"td\", class_=\"[\u7701\u7565]\").text              # \u5358\u8a9e\u610f\u5473\u53d6\u5f97\n\n    try:\n        SND_URL = soup.find(\"audio\", class_=\"[\u7701\u7565]\").find(\"source\")['src']   # \u97f3\u58f0\u30d5\u30a1\u30a4\u30eb\uff35\uff32\uff2c\u53d6\u5f97\n\n        root , ext = os.path.splitext(SND_URL)                                      # \u62e1\u5f35\u5b50\u53d6\u5f97\n        DST_F = dirPth + s_word + ext                    # \u97f3\u58f0\uff8c\uff67\uff72\uff99\u4fdd\u5b58\u540d\u53d6\u5f97\n\n        # \u97f3\u58f0\u30d5\u30a1\u30a4\u30eb\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\n        download_file( SND_URL , DST_F )\n        jdg_dl = \"1\"\n    except:\n        jdg_dl = \"0\"    \n\n    rslt = w_mean + \"###\" + jdg_dl\n\n    DST_T = dirPth + s_word + \".txt\"  \n\n    fileobj = open(DST_T , \"w\")\n    fileobj.write(rslt)\n    fileobj.close()\n\n    return rslt\n\n\n\nif __name__ == \"__main__\" :\n\n    argv = sys.argv\n    \n    try:\n        eng_wrd = argv[1]\n    except:\n        eng_wrd = \"gastrointestine\"\n        \n    root = tk.Tk()\n    root.withdraw()\n   \n    rslt = search_e_word(eng_wrd)\n\n    print(rslt)<\/pre>\n
<\/p>\n\n\n
\u25a0 VBA\u30d7\u30ed\u30b0\u30e9\u30e0\u4f5c\u6210<\/h4>\n\n\n\n
 \u3000VBA\u5074\u306f WshShell \u30aa\u30d6\u30b8\u30a7\u30af\u30c8 Run\u30e1\u30bd\u30c3\u30c9\u3067Python\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u7d42\u4e86\u5f85\u3061\u3057\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u7d42\u4e86\u5f8c\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u4e0a\u306b\u8868\u793a\u3057\u307e\u3059\u3002 <\/p>\n\n\n
Option Explicit\n\n'\u53c2\u7167\u8a2d\u5b9a\n'Windows Script Host Object Model\n\nPrivate Sub CommandButton1_Click()\n    Dim wsh As WshShell\n    Dim cmd_str As String\n    Dim ret\n\n    Dim sht, wrd\n    Dim cnt\n    Dim rtn_m As Variant\n    \n    \n    Set wsh = CreateObject(\"WScript.Shell\")\n    sht = ActiveSheet.Name\n    cnt = 0\n    \n     Worksheets(sht).Cells(1, 1).Value = Now\n    \n    Do\n        wrd = Trim(Worksheets(sht).Cells(5 + cnt, 1).Value)\n        If wrd = \"\" Then Exit Do\n        \n        wrd = StrConv(StrConv(wrd, 8), 2)\n        \n        cmd_str = \"python C:\\Users\\[\u7701\u7565]\\bs4_03.py \" + wrd\n        \n        ret = wsh.Run(cmd_str, 0, True) '\u30d1\u30b9\uff0c\u30a6\u30a3\u30f3\u30c9\u30a6\u30b9\u30bf\u30a4\u30eb\uff0c\u7d42\u4e86\u5f85\u3061\n\n        rtn_m = Split(text_Open(wrd), \"###\")\n        \n        Worksheets(sht).Cells(5 + cnt, 2).Value = Replace(rtn_m(0), vbCrLf, \"\")\n        Worksheets(sht).Cells(5 + cnt, 3).Value = rtn_m(1)\n        \n        DoEvents\n        cnt = cnt + 1\n    Loop\n    \n    Worksheets(sht).Cells(2, 1).Value = Now\nEnd Sub\n\n\n\u2019\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\nPublic Function text_Open(wrd)\n \n    Dim FileName As String\n    Dim FileNum As Integer\n    Dim buf, str\n    \n    FileName = \"C:\\Users\\pana-win10\\k\uff70data\\20200910_python_beutifulsoup_01\\snd\\\" + wrd + \".txt\"\n    FileNum = FreeFile  '\u30d5\u30a1\u30a4\u30eb\u756a\u53f7\u3092\u53d6\u5f97\n    \n    '\u30d5\u30a1\u30a4\u30eb\u3092\u30b7\u30fc\u30b1\u30f3\u30b7\u30e3\u30eb\u5165\u529b\u30e2\u30fc\u30c9\u3067\u958b\u304f\n    Open FileName For Input As #FileNum\n    \n        '\u30d5\u30a1\u30a4\u30eb\u306e\u672b\u5c3e\u307e\u3067\u7e70\u308a\u8fd4\u3059\n        Do Until EOF(FileNum)\n                        \n            '\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb 1 \u884c\u5206\u3092\u5909\u6570 buf \u306b\u683c\u7d0d\u3059\u308b\n            Line Input #FileNum, buf\n            str = str & vbCrLf & buf\n        \n        Loop\n        \n    '\u30d5\u30a1\u30a4\u30eb\u3092\u9589\u3058\u308b\n    Close #FileNum\n    \n    text_Open = str\n \nEnd Function<\/pre>\n
<\/p>\n\n\n
 \u3000\u5c1a\u3001 WshShell \u30aa\u30d6\u30b8\u30a7\u30af\u30c8 \u5229\u7528\u306e\u70ba\u3001\u4e0b\u56f3\u306e\u201cWindows Script Host Object Model\u201d  \u3092\u53c2\u7167\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"
\u3000\u3000
\u3000\u3000<\/figcaption><\/figure>\n\n\n\n
python\u30d7\u30ed\u30b0\u30e9\u30e0\u306e EXE \u5316<\/h2>\n\n\n\n
 \u3000pyinstaller  \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002
 \u3000[  python -m pip install pyinstaller   ] <\/p>\n\n\n\n
\"\"
 python -m pip install pyinstaller 
\u3000\u3000<\/figcaption><\/figure>\n\n\n\n
\u3000\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30c8\u3067\u3001\u5909\u63db\u5bfe\u8c61 python \u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u3042\u308b\u30d5\u30a9\u30eb\u30c0\u30fc\u306b\u79fb\u52d5\u3057\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067  exe \u30d5\u30a1\u30a4\u30eb\u306b\u5909\u63db\u3057\u307e\u3059\u3002
\u3000[  pyinstaller bs4_02.py –onefile  ]
\u3000\u30aa\u30d7\u30b7\u30e7\u30f3\u306e \u2018\u2013onefile\u2019 \u306f\u95a2\u9023\u30d5\u30a1\u30a4\u30eb\u30921\u3064\u306b\u307e\u3068\u3081\u3066exe\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001\u2018\u2013noconsole\u2019 \u306f\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u8868\u793a\u3057\u306a\u3044\u69d8\u306b\u3059\u308b\u69d8\u3067\u3059\u3002\u3002<\/p>\n\n\n\n
\"\"
 pyinstaller bs4_02.py –onefile <\/figcaption><\/figure>\n\n\n\n
\u3000 \u4e0b\u56f3  \u5143\u306e \u2018bs4_02.py\u2019 \u30d5\u30a1\u30a4\u30eb\u4ee5\u5916\u306e\u30d5\u30a9\u30eb\u30c0\uff0c\u30d5\u30a1\u30a4\u30eb\u306f\u5909\u63db\u51e6\u7406\u306b\u3088\u3063\u3066\u751f\u6210\u3055\u308c\u305f\u3082\u306e\u3067\u3059\u3002\u30d5\u30a9\u30eb\u30c0  [ dist ] \u306e\u4e2d\u306bexe \u30d5\u30a1\u30a4\u30eb\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002 <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u3000\u4e0b\u8a18\u306e\u901a\u308a\u52d5\u4f5c\u78ba\u8a8d\u51fa\u6765\u307e\u3057\u305f\u304c\u3001\u5c11\u3057\u3001\u9045\u304f\u306a\u3063\u305f\u69d8\u306a\u6c17\u304c\u3057\u307e\u3059\u3002 \u3000\u4ed6\u74b0\u5883\u3067\u306e\u691c\u8a3c\u306f\u5225\u9014\u5fc5\u8981\u3067\u3057\u3087\u3046\u3002   \u2018\u2013noconsole\u2019  \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u80cc\u666f\u306b\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"
\u3000\u3000
\u3000<\/figcaption><\/figure>\n\n\n\n
\u307e\u3068\u3081<\/h2>\n\n\n\n
\u3000python \u30d7\u30ed\u30b0\u30e9\u30e0\u3092  exe \u30d5\u30a1\u30a4\u30eb\u306b\u5909\u63db\u51fa\u6765\u308b\u3053\u3068\u3092\u77e5\u3063\u305f\u306e\u306f\u5927\u304d\u306a\u53ce\u7a6b\u3067\u3059\u3002\u5229\u7528\u7bc4\u56f2\u3082\u62e1\u304c\u308b\u3068\u601d\u3044\u307e\u3059\u3002
\u3000\u4ed6\u306b\u3082 \u201cxlwings\u201d \uff0c” OpenPyXL ” \u306a\u3069\u306e\u4ed5\u7d44\u3082\u3042\u308b\u69d8\u3067\u3059\u306e\u3067\u3001\u6a5f\u4f1a\u304c\u3042\u308c\u3070\u78ba\u8a8d\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002


<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6982\u8981 \u3000\u5148\u56de\u306f\u30a8\u30af\u30bb\u30ebVBA\u304b\u3089\u3001IE \uff08\u30a4\u30f3\u30bf\u30cd\u30c3\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\uff09\u3092\u64cd\u4f5c\u3057\u3001\u7c21\u5358\u306a\u30c7\u30fc\u30bf\u691c\u7d22\u3092\u884c\u3044\u307e\u3057\u305f\u3002\u3000\u4eca\u56de\u306f\u3001python \u3068 Beautiful Soup 4\u3068\u3044\u3046\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f7f\u3063\u3066 \u5148\u56de\u884c\u3063\u305f\u306e\u3068\u540c\u3058\u82f1\u5358 … \u7d9a\u304d\u3092\u8aad\u3080 PYTHON\u3067WEB\u691c\u7d22(Beautiful Soup 4)<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":4976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[75,98],"tags":[139,116,141,96],"_links":{"self":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/4902"}],"collection":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/comments?post=4902"}],"version-history":[{"count":70,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/4902\/revisions"}],"predecessor-version":[{"id":4993,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/4902\/revisions\/4993"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media\/4976"}],"wp:attachment":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media?parent=4902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/categories?post=4902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/tags?post=4902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}