iT邦幫忙

1

初學者 利用python爬蟲網站表格值 顯示空值 找不到問題

python python系列文章 python爬蟲 網路爬蟲 表格爬蟲
cgc0800 2021-07-07 03:25:44 ‧ 3071 瀏覽 
import requests
from bs4 import BeautifulSoup

url = 'http://price.naif.org.tw/Query/Query_now.aspx'

headers = {'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'}

resp = requests.get(url, headers=headers)

# 設定編碼為 utf-8 避免中文亂碼問題
resp.encoding = 'utf-8'

# 根據 HTTP header 的編碼解碼後的內容資料（ex. UTF-8），若該網站沒設定可能會有中文亂碼問題。所以通常會使用 resp.encoding 設定
raw_html = resp.text

# 將 HTML 轉成 BeautifulSoup 物件
soup = BeautifulSoup(raw_html, 'html.parser')

print(soup.select('html > body > #form1 > div.wrap > div.contant > div:nth-child(7) > div > #ContentPlaceHolder_content_GridView_data > tbody > tr:nth-child(4) > td:nth-child(2)'))

上方是我的程式碼，
我要爬蟲的網站：http://price.naif.org.tw/Query/Query_now.aspx
我要爬蟲該表格的值，
https://ithelp.ithome.com.tw/upload/images/20210707/201365797yOZ34S8os.png
但我利用上方的程式碼print出來的值顯示「[]」空值，
嘗試過許多方法結果都一樣，
不知道我是不是缺少什麼，
謝謝！

不明 檢舉
它那個是要用POST請求
你可以用F12去看它需要哪些參數
japhenchen iT邦超人 1 級 ‧ 2021-07-07 10:25:01 檢舉
應該是POST請求，你的URL裡並無查詢用的參數什麼的資料，所以結果空白
登入發表討論
圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

3 個回答

1
shijung
iT邦新手 4 級 ‧ 2021-07-08 09:04:30
最佳解答

F12 -> NetWork -> Name欄位下找出按查詢的請求 xxx.aspx => 右邊點選Headers=>你會看到Request Type 是 Post 然後找Form Data 把參數丟上去

import requests
from bs4  import BeautifulSoup
payload = {
    '__EVENTTARGET':'',
    '__EVENTARGUMENT':'',
    '__LASTFOCUS':'',
    '_VIEWSTATEGENERATOR': '02BC70F4',
    '__SCROLLPOSITIONX': 0,
    '__SCROLLPOSITIONY': 800,
    '__VIEWSTATE': '/wEPDwUKMTU5MDY1ODkxMw9kFgJmD2QWAgIDD2QWAgIDD2QWEAIDDxBkDxYDZgIBAgIWAxAFA+ihqAUBMGcQBQnntbHoqIjlnJYFATFnEAUN6KGoK+e1seioiOWclgUBMmdkZAIHD2QWHAIBDxBkDxYaZgIBAgICAwIEAgUCBgIHAggCCQIKAgsCDAINAg4CDwIQAhECEgITAhQCFQIWAhcCGAIZFhoQBQQxOTk2BQQxOTk2ZxAFBDE5OTcFBDE5OTdnEAUEMTk5OAUEMTk5OGcQBQQxOTk5BQQxOTk5ZxAFBDIwMDAFBDIwMDBnEAUEMjAwMQUEMjAwMWcQBQQyMDAyBQQyMDAyZxAFBDIwMDMFBDIwMDNnEAUEMjAwNAUEMjAwNGcQBQQyMDA1BQQyMDA1ZxAFBDIwMDYFBDIwMDZnEAUEMjAwNwUEMjAwN2cQBQQyMDA4BQQyMDA4ZxAFBDIwMDkFBDIwMDlnEAUEMjAxMAUEMjAxMGcQBQQyMDExBQQyMDExZxAFBDIwMTIFBDIwMTJnEAUEMjAxMwUEMjAxM2cQBQQyMDE0BQQyMDE0ZxAFBDIwMTUFBDIwMTVnEAUEMjAxNgUEMjAxNmcQBQQyMDE3BQQyMDE3ZxAFBDIwMTgFBDIwMThnEAUEMjAxOQUEMjAxOWcQBQQyMDIwBQQyMDIwZxAFBDIwMjEFBDIwMjFnZGQCAw8QZA8WGmYCAQICAgMCBAIFAgYCBwIIAgkCCgILAgwCDQIOAg8CEAIRAhICEwIUAhUCFgIXAhgCGRYaEAUEMTk5NgUEMTk5NmcQBQQxOTk3BQQxOTk3ZxAFBDE5OTgFBDE5OThnEAUEMTk5OQUEMTk5OWcQBQQyMDAwBQQyMDAwZxAFBDIwMDEFBDIwMDFnEAUEMjAwMgUEMjAwMmcQBQQyMDAzBQQyMDAzZxAFBDIwMDQFBDIwMDRnEAUEMjAwNQUEMjAwNWcQBQQyMDA2BQQyMDA2ZxAFBDIwMDcFBDIwMDdnEAUEMjAwOAUEMjAwOGcQBQQyMDA5BQQyMDA5ZxAFBDIwMTAFBDIwMTBnEAUEMjAxMQUEMjAxMWcQBQQyMDEyBQQyMDEyZxAFBDIwMTMFBDIwMTNnEAUEMjAxNAUEMjAxNGcQBQQyMDE1BQQyMDE1ZxAFBDIwMTYFBDIwMTZnEAUEMjAxNwUEMjAxN2cQBQQyMDE4BQQyMDE4ZxAFBDIwMTkFBDIwMTlnEAUEMjAyMAUEMjAyMGcQBQQyMDIxBQQyMDIxZ2RkAgcPEGQPFhpmAgECAgIDAgQCBQIGAgcCCAIJAgoCCwIMAg0CDgIPAhACEQISAhMCFAIVAhYCFwIYAhkWGhAFBDE5OTYFBDE5OTZnEAUEMTk5NwUEMTk5N2cQBQQxOTk4BQQxOTk4ZxAFBDE5OTkFBDE5OTlnEAUEMjAwMAUEMjAwMGcQBQQyMDAxBQQyMDAxZxAFBDIwMDIFBDIwMDJnEAUEMjAwMwUEMjAwM2cQBQQyMDA0BQQyMDA0ZxAFBDIwMDUFBDIwMDVnEAUEMjAwNgUEMjAwNmcQBQQyMDA3BQQyMDA3ZxAFBDIwMDgFBDIwMDhnEAUEMjAwOQUEMjAwOWcQBQQyMDEwBQQyMDEwZxAFBDIwMTEFBDIwMTFnEAUEMjAxMgUEMjAxMmcQBQQyMDEzBQQyMDEzZxAFBDIwMTQFBDIwMTRnEAUEMjAxNQUEMjAxNWcQBQQyMDE2BQQyMDE2ZxAFBDIwMTcFBDIwMTdnEAUEMjAxOAUEMjAxOGcQBQQyMDE5BQQyMDE5ZxAFBDIwMjAFBDIwMjBnEAUEMjAyMQUEMjAyMWdkZAIIDxBkDxYMZgIBAgICAwIEAgUCBgIHAggCCQIKAgsWDBAFATEFATFnEAUBMgUBMmcQBQEzBQEzZxAFATQFATRnEAUBNQUBNWcQBQE2BQE2ZxAFATcFATdnEAUBOAUBOGcQBQE5BQE5ZxAFAjEwBQIxMGcQBQIxMQUCMTFnEAUCMTIFAjEyZ2RkAgoPEGQPFhpmAgECAgIDAgQCBQIGAgcCCAIJAgoCCwIMAg0CDgIPAhACEQISAhMCFAIVAhYCFwIYAhkWGhAFBDE5OTYFBDE5OTZnEAUEMTk5NwUEMTk5N2cQBQQxOTk4BQQxOTk4ZxAFBDE5OTkFBDE5OTlnEAUEMjAwMAUEMjAwMGcQBQQyMDAxBQQyMDAxZxAFBDIwMDIFBDIwMDJnEAUEMjAwMwUEMjAwM2cQBQQyMDA0BQQyMDA0ZxAFBDIwMDUFBDIwMDVnEAUEMjAwNgUEMjAwNmcQBQQyMDA3BQQyMDA3ZxAFBDIwMDgFBDIwMDhnEAUEMjAwOQUEMjAwOWcQBQQyMDEwBQQyMDEwZxAFBDIwMTEFBDIwMTFnEAUEMjAxMgUEMjAxMmcQBQQyMDEzBQQyMDEzZxAFBDIwMTQFBDIwMTRnEAUEMjAxNQUEMjAxNWcQBQQyMDE2BQQyMDE2ZxAFBDIwMTcFBDIwMTdnEAUEMjAxOAUEMjAxOGcQBQQyMDE5BQQyMDE5ZxAFBDIwMjAFBDIwMjBnEAUEMjAyMQUEMjAyMWdkZAILDxBkDxYMZgIBAgICAwIEAgUCBgIHAggCCQIKAgsWDBAFATEFATFnEAUBMgUBMmcQBQEzBQEzZxAFATQFATRnEAUBNQUBNWcQBQE2BQE2ZxAFATcFATdnEAUBOAUBOGcQBQE5BQE5ZxAFAjEwBQIxMGcQBQIxMQUCMTFnEAUCMTIFAjEyZ2RkAg4PEA8WAh4HVmlzaWJsZWhkZGRkAg8PEA8WAh8AaGQPFhpmAgECAgIDAgQCBQIGAgcCCAIJAgoCCwIMAg0CDgIPAhACEQISAhMCFAIVAhYCFwIYAhkWGhAFBDE5OTYFBDE5OTZnEAUEMTk5NwUEMTk5N2cQBQQxOTk4BQQxOTk4ZxAFBDE5OTkFBDE5OTlnEAUEMjAwMAUEMjAwMGcQBQQyMDAxBQQyMDAxZxAFBDIwMDIFBDIwMDJnEAUEMjAwMwUEMjAwM2cQBQQyMDA0BQQyMDA0ZxAFBDIwMDUFBDIwMDVnEAUEMjAwNgUEMjAwNmcQBQQyMDA3BQQyMDA3ZxAFBDIwMDgFBDIwMDhnEAUEMjAwOQUEMjAwOWcQBQQyMDEwBQQyMDEwZxAFBDIwMTEFBDIwMTFnEAUEMjAxMgUEMjAxMmcQBQQyMDEzBQQyMDEzZxAFBDIwMTQFBDIwMTRnEAUEMjAxNQUEMjAxNWcQBQQyMDE2BQQyMDE2ZxAFBDIwMTcFBDIwMTdnEAUEMjAxOAUEMjAxOGcQBQQyMDE5BQQyMDE5ZxAFBDIwMjAFBDIwMjBnEAUEMjAyMQUEMjAyMWcWAQIZZAIQDxAPFgIfAGhkDxYMZgIBAgICAwIEAgUCBgIHAggCCQIKAgsWDBAFATEFATFnEAUBMgUBMmcQBQEzBQEzZxAFATQFATRnEAUBNQUBNWcQBQE2BQE2ZxAFATcFATdnEAUBOAUBOGcQBQE5BQE5ZxAFAjEwBQIxMGcQBQIxMQUCMTFnEAUCMTIFAjEyZxYBZmQCEQ8QDxYCHwBoZA8WA2YCAQICFgMQBQbkuIrml6wFATFnEAUG5Lit5pesBQIxMWcQBQbkuIvml6wFAjIxZxYBZmQCEg8PFgIfAGhkZAITDxAPFgIfAGhkDxYaZgIBAgICAwIEAgUCBgIHAggCCQIKAgsCDAINAg4CDwIQAhECEgITAhQCFQIWAhcCGAIZFhoQBQQxOTk2BQQxOTk2ZxAFBDE5OTcFBDE5OTdnEAUEMTk5OAUEMTk5OGcQBQQxOTk5BQQxOTk5ZxAFBDIwMDAFBDIwMDBnEAUEMjAwMQUEMjAwMWcQBQQyMDAyBQQyMDAyZxAFBDIwMDMFBDIwMDNnEAUEMjAwNAUEMjAwNGcQBQQyMDA1BQQyMDA1ZxAFBDIwMDYFBDIwMDZnEAUEMjAwNwUEMjAwN2cQBQQyMDA4BQQyMDA4ZxAFBDIwMDkFBDIwMDlnEAUEMjAxMAUEMjAxMGcQBQQyMDExBQQyMDExZxAFBDIwMTIFBDIwMTJnEAUEMjAxMwUEMjAxM2cQBQQyMDE0BQQyMDE0ZxAFBDIwMTUFBDIwMTVnEAUEMjAxNgUEMjAxNmcQBQQyMDE3BQQyMDE3ZxAFBDIwMTgFBDIwMThnEAUEMjAxOQUEMjAxOWcQBQQyMDIwBQQyMDIwZxAFBDIwMjEFBDIwMjFnFgECGWQCFA8QDxYCHwBoZA8WDGYCAQICAgMCBAIFAgYCBwIIAgkCCgILFgwQBQExBQExZxAFATIFATJnEAUBMwUBM2cQBQE0BQE0ZxAFATUFATVnEAUBNgUBNmcQBQE3BQE3ZxAFATgFAThnEAUBOQUBOWcQBQIxMAUCMTBnEAUCMTEFAjExZxAFAjEyBQIxMmcWAWZkAhUPEA8WAh8AaGQPFgNmAgECAhYDEAUG5LiK5pesBQExZxAFBuS4reaXrAUCMTFnEAUG5LiL5pesBQIyMWcWAWZkAgkPZBYEAgEPEGQQFQMS55Si5Zyw6L6y5aC05YO55qC8EuW4guWgtOaLjeizo+WDueagvAzpm7bllK7lg7nmoLwVAwExATYBMxQrAwNnZ2cWAWZkAgUPDxYCHgRUZXh0BVZDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMF8wLENoZWNrQm94TGlzdF9wcm9kdWN0TGlzdF8xXzAsQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzJfMGRkAhEPDxYCHwBnZGQCEw8PFgIfAGdkZAIVDw8WAh8AZ2RkAhkPDxYCHwEFxgY8ZGl2Pg0KCTx0YWJsZSBjbGFzcz0icXVlcnlCb3hOZXciIGNlbGxzcGFjaW5nPSIwIiBhbGlnbj0iQ2VudGVyIiBydWxlcz0iYWxsIiBib3JkZXI9IjEiIGlkPSJDb250ZW50UGxhY2VIb2xkZXJfY29udGVudF9HcmlkVmlld19kYXRhIiBzdHlsZT0id2lkdGg6MTAwJTtib3JkZXItY29sbGFwc2U6Y29sbGFwc2U7Ij4NCgkJPHRyPg0KCQkJPHRoIHJvd3NwYW49IjMiPjxkaXYgc3R5bGU9J21heC13aWR0aDoxNDBweDttaW4td2lkdGg6MTAwJTsnPuaZgumWkzwvZGl2PjwvdGg+PHRoIGNvbHNwYW49IjMiPueUouWcsOi+suWgtOWDueagvDwvdGg+DQoJCTwvdHI+PHRyPg0KCQkJPHRoIGNvbHNwYW49IjMiPuWutueVnOmhnjwvdGg+DQoJCTwvdHI+PHRyPg0KCQkJPHRoPjxkaXYgc3R5bGU9J21heC13aWR0aDoxMjBweDttaW4td2lkdGg6MTAwJTsnPuiCpeiCsuiCieeUqOavjeeJmzxicj7vvIjmtLvpq5TvvIk8L2Rpdj48L3RoPjx0aD48ZGl2IHN0eWxlPSdtYXgtd2lkdGg6MTIwcHg7bWluLXdpZHRoOjEwMCU7Jz7niZvkubMo5pS26LO85Y+D6ICD5YO5KTxicj7vvIjkuK3ntJrvvIk8L2Rpdj48L3RoPjx0aD48ZGl2IHN0eWxlPSdtYXgtd2lkdGg6MTIwcHg7bWluLXdpZHRoOjEwMCU7Jz7pm5znqK7niZs8YnI+77yI5rS76auU77yJPC9kaXY+PC90aD4NCgkJPC90cj48dHI+DQoJCQk8dGQ+MjAyMOW5tDwvdGQ+PHRkPjEzNS41NjwvdGQ+PHRkPjI2LjE3PC90ZD48dGQ+MTEyLjY5PC90ZD4NCgkJPC90cj48dHI+DQoJCQk8dGQ+MjAyMeW5tDwvdGQ+PHRkPjEzMi4xMzwvdGQ+PHRkPjI0LjA0PC90ZD48dGQ+MTE1LjcyPC90ZD4NCgkJPC90cj4NCgk8L3RhYmxlPg0KPC9kaXY+ZGQCHQ8PFgIfAQXiAuWCmeiou++8mjxicj4xLiDogqXogrLogonnlKjmr43niZso5rS76auUKe+8muiHqjEwNuW5tDHmnIgx5pel6LW377yM6LOH5paZ5L6G5rqQ5pS55o6h5Lul5Y2U5pyD5aCx5bCO5YO55qC85Lim5pOa5Lul5Zue5rqv5L+u5q2j44CCPGJyPjIuIOeJm+S5syjmlLbos7zlj4PogIPlg7kpKOS4ree0minvvJroh6oxMDblubQx5pyIMeaXpei1t++8jOizh+aWmeS+hua6kOaUueaOoeS7peeUn+S5s+aUtuizvOWPg+iAg+WDueagvOS4puaTmuS7peWbnua6r+S/ruato+OAgjxicj4zLiDpm5znqK7niZso5rS76auUKe+8muiHqjEwNOW5tDHmnIgx5pel6LW377yM6Kq/5pW055Si5Zyw6L6y5aC05YO55qC85p+l5aCx6bue44CCPGJyPmRkGAIFHl9fQ29udHJvbHNSZXF1aXJlUG9zdEJhY2tLZXlfXxYuBTRjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCRDaGVja0JveF9pc1Nob3daZXJvBUJjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y190aW1lU2VsZWN0b3IkUmFkaW9uQnV0dG9uX3llYXIFQmN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3RpbWVTZWxlY3RvciRSYWRpb0J1dHRvbl9tb250aAVCY3RsMDAkQ29udGVudFBsYWNlSG9sZGVyX2NvbnRlbnQkdWNfdGltZVNlbGVjdG9yJFJhZGlvQnV0dG9uX21vbnRoBU9jdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3ByaWNlVHlwZSQwBU9jdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3ByaWNlVHlwZSQxBU9jdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3ByaWNlVHlwZSQyBU9jdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3ByaWNlVHlwZSQyBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQwBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQxBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQyBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQzBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQ0BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQ1BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQ2BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzBfMCQ2BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQwBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQxBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQyBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQzBVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQ0BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQ1BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQ2BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQ3BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQ4BVVjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQ5BVZjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzFfMCQxMAVWY3RsMDAkQ29udGVudFBsYWNlSG9sZGVyX2NvbnRlbnQkdWNfcHJvZHVjdExpc3RfbWl4VmVyJENoZWNrQm94TGlzdF9wcm9kdWN0TGlzdF8xXzAkMTAFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDAFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDEFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDIFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDMFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDQFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDUFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDYFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDcFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDgFVWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDkFVmN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDEwBVZjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzJfMCQxMQVWY3RsMDAkQ29udGVudFBsYWNlSG9sZGVyX2NvbnRlbnQkdWNfcHJvZHVjdExpc3RfbWl4VmVyJENoZWNrQm94TGlzdF9wcm9kdWN0TGlzdF8yXzAkMTIFVmN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDEzBVZjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzJfMCQxNAVWY3RsMDAkQ29udGVudFBsYWNlSG9sZGVyX2NvbnRlbnQkdWNfcHJvZHVjdExpc3RfbWl4VmVyJENoZWNrQm94TGlzdF9wcm9kdWN0TGlzdF8yXzAkMTUFVmN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcl9jb250ZW50JHVjX3Byb2R1Y3RMaXN0X21peFZlciRDaGVja0JveExpc3RfcHJvZHVjdExpc3RfMl8wJDE2BVZjdGwwMCRDb250ZW50UGxhY2VIb2xkZXJfY29udGVudCR1Y19wcm9kdWN0TGlzdF9taXhWZXIkQ2hlY2tCb3hMaXN0X3Byb2R1Y3RMaXN0XzJfMCQxNgUuY3RsMDAkQ29udGVudFBsYWNlSG9sZGVyX2NvbnRlbnQkR3JpZFZpZXdfZGF0YQ88KwAMAQgCAWTNNCEJ/XSCxVK1oosFURCDx9uFr1bkl3kHVheDsGTyFA==',
    '__EVENTVALIDATION': '/wEdALQBsZE/RtnN1AOLw5his09cocuqrlOvjGbeK3Kejm0PYRJOfSuEl5g7yXUwS6ZETTwgotu/Y3EykpHi+8YB7qZnzHoMd6I/WrX7g+80YsNS+q7Juy4ZedNRfWYgfV8n1mAdhHofKVSmLmaSynodQaHwL8YXdmWyOHJ/ZtDM9ox/c0o5Fw8t2KHuNKN+kcpoVOCK9oH4cJyS5tK7cGqEEugICDYRtft9xqdIWoyx8uguGe4r1BHwTpmbd03lgvTAEkRSdOO2gIxp9XYzJdDx28Mrs+R4nbiIxhANJoBc4/D96g+sulvF5uuYwcUN6yskSUU99bJkmKy3m+dqkYOzCOWPXtn/mvqHLFRXlUsIq5do0H0/D9wTf10afzG7XCzRMxcJLDhMt5sFqro97xh0IQVfLu7fs0c5VglWvBBVh669xXlinqluy/89i66mZXuiLvCFvbrFAPpmVEJetG0XteF0Wug4dixyofLqf39nu9wCtvgVjDiRAyjQmspkvPusGAU2bS7Fge7IOpaeSeaM/gr2X+OcWQNHg0lupenQKr2Tsr0h2aJE45WwYzXNx8y9x3euNnDXrkuI5ae9uY5lo4PnLhuDB4CJWh6Jk4Dihu3tnkAyNGYBpfEW+B5fSjR7YppFlsfjOu5n0yV/C0f4ajU9jK2Iiooq8fcAig9XauhJA+EL9ZN70chL6XQGJDUfJf/tp9aYKOMxpgYovMNS7Qo8WmHMh+jyvuPzJO+2Ta/Jcr/MOtdh4j/2q4wlijhNwfnLpGoYav3soFpXGV+S183UjCjcAvSdecOS1I37DGfJG8/qJWj+IE+3iFTQVK+3qR9Jsl27w6VRotCagC8CBG7jPmztIMC5OT0gjmA9X0CpwS382KrToRiGuHyRXk7wlKCL0aK/XGLm5yAKxu5tRRhNJufGoWfUalVEYJ3pLvJpKB5Vbd2ubW9fdxglMqBHo/OkpWKtrzr9cy+5+2ZMg8HLKzcAkLTYSw945J/G/YlLY4Dw4Dd5vql86U8ehX02aRm5dxghBsVsuESiTbQRZZyBKHvuE2yljg8K1tJV/kiCickWtc4r/rSp85rsxpHecA/MPzYHVEhq9I8ALemP8TNbrgxwzzmX+apShlDEmgiQ5J27hTgoN40NIKAVTYOVg9KYrTCLDL8DnJqsbZcCC4y6z5FR4cS4WC0Ylb/Q/41i0Hukvcmc1I5kT/eGhRM21Wpeq76XfojAhj3UDEug32RHTbrmdYyFBd8xKy+Ko8pb7G7SjvZED5OlxRAcSZ0OGNTIH7dCVm8nhk9dCegtiIGmEnkq1rDPWg9DbL3krlTtmdrg/D+y8MbBnDuOY9v5eLB9FF1JqPD8XNYbk+KD2mDMhdYlsvX/dBSGzlXCGVs0Dh3/V+qiRAGcRADQvfZbWt36CpomechNH1GSFUIyTY9+LutvzNLQPxQnvBEo9A0jgCwpfIr/K7lW/POJAEUbJD1FZ5YR6ki6fgW+kwZ+lJInoWE3FCnaDXHvu6JKr+uIk52lA4vHX0WTyEC3IMoxY0XXhxLgrL+sfZfjILSWh/YHgL+gDJU+hzZTySgRORjNxaMhtJma84p2Y2qn7CHvuirInDDboR9mAfBEseoxcFtyywjULQfZFoe1aj+eMLRLS+fCw69DSeAv4QzEkyXwnEfixzBjm5bQ+WRO1A9AlKe1jYn5q11biUhoUqAeFaVzBUeB0vRAd33xm1vmn8HD8CYIFCr00yN9YsB1ILDXjkQ8haZp6T4u5c6bo1ylvqeWyAdqsGHs0eVsNY/lnMWBxPnY5+IIWQSIATzfFrL5cU7m3HvSCjBTPwIVsDkUWd8GkLWnQnyd+BxImJS0BIpeon4XDgERAkHzF2+h+qgtudjfTDllAqsdka+gvQXE27VZYs2iFvPZSwFpBz2ydnw4D90uwQZ4w28t4w7FGgTn7bptTzBw5XjME294Ne8wBHPr4aRrsu15+TP8vql1+Jp1A69JcQJDfpx6MFYOe2NlGpOtT+pC9uZ4VUAsLnXcxHvyzeA08jGUPd7TyHhpbbVrvIlWdqq6yttGJazRTSzXqZ2OetGohNvCPEQ9l3OYGGqWnR3jqNVeUOmh0tvcaRNBI88W/bS1JivJmDJjhX7Dt5lX6Iu6FTKulhwwn7G/JrsDYypC1FNLG7FQu1F5AI+5ba34qy2fCcz8SX+tyx4mo11ov3SfNkRBHEC7wKleJKNPggFx/Kp4SoBWNPq4eagX+A6xe5ECwLz/YtdxsmG8eowTqTFORynbHub1LXuiIid8kzxO5bwJAM83cHPqGHDVxgTpIo5VDfy2Fhq4Xj9Re8SUDPUxmEij38jo1kbNMuqjbWuGiZVKBJT41DM8N0y/KrRq0/Hl3GYsYjXfKpE9k5tGyB8D0ykpMJ0xSKvaOuIvPKaDP1Qt4KBQWI0DVax6MTc8E/r9/0WoEDsPGeWyjKo5EWLa52z5YC4I+ltRcgFD2QL/+oraejyTWU3wqHdgFvoovWhZu4GQPlpRQSXflCqWQMtn8z0oiNlKA109ajEUXlOMwWOWo13avtQQQ+bZQA6UM+07oUG/mBdhfoKWB9eOKEP/qar/3FIo9yKotTwlAAGTVlFL5bZE6eMTfUpxQhDC/NLDGPIOO6Gha67a+DKiliI87kehaxe08KLz6LOSFo4fI+JaADllF9OwObePPmawX0yl6sxMlZn5p36Iwxvaz8Mez+KRa0lkJsEIgir96W9gf2n4ihv/hL7DcD4LtfyEnUNEBTg/s8w/uPai9vQDODfRZQGwc14KYW5sZJ7sqOi0l7/Oq0trGBMVL+bixQOQUBEXJA2ChAEsR8QUkkRCaMdPWV9L12TUWZDk1PsXSmZcX3o8boeEPOUrlwlVPBPH0D1zDVVy/eNRdMI94HO1Fxf6DObXjxk1nJAxpW6+go9ltSPcEHjTYnc6Z5f+L4dZL32o8eMLWtTfkSNAeQ+fWeeYWh5smw1CT2cbTOzqE4+qMCj4k6oh0Z72sTeJATMzjEneWV4g/255TG4F1hqF9Pdgl2CR7DhOv0m/iDDDyMEQl0womhnETTsBiS4LoJbGzp/VR9PLbHUKjdkddTafr4Yd2tDu4QXw42VyAqNyboI4GkON+gIRoQSUEE6U3lSs0HU3PeCrxRqoNJdFroFoZblO6TS1O8ObYydjpRVdFhCgRKoFkXxgvHrX3z+NmC8Cu8bNaJFRTlDHnc3q9jlx1fbAt5qk9sdeBdXKDZ2gfgaAqv+r8fcSCW+sKOegHMkRBuyUu7Z1u5DB49zqRnSxL1RWrNLS1pNq1J0Kzkd7e5QrzkSANtaECxM5GS0A5MvpX1MKHYinXh3xoSSXRGHXeevlfhi6G0AqErGdp2iDPa/4+HvxQJyNeo4pa2rfqZ+TijV1KhPZ9t112+wKWgCgUx+90LoKanCA5KPcWQfAgoH6KepdFYaEkToqLP8vQk/5Mt1SgLU+UhCEm5dtO/aqHvneN02hRfoErusn7owDi/6EaUR99VWuBLGMeIbAuquA5IigBbI17Rxp7yuFkFI50Mb+9p3THIrOa9ncmClF8noovKG4awSV383ucXO68AYV4R/NAp0Mf1jseZzrICE+kAHE9RDztg5LWrPrAa0v4eW005XcLM4j/U5VK680L6vSj5qzN4MKPJeqofGOT3sknP5NH0RZEqt5a5rKR0Bz9DwotEEVtmE6nxaUjAgbDxxfUOMDkHeZxX3/MLwlCTvwl8r714CO5OwwWsO0xXcjVkWJGCLkFZo/JPVuewb9aXnZN9w6Xmoa1oyZxp76oo1zVd0R0DZfoB3UmUNamD3HRNVx5kgBfsihEKYxpG3AhNbXjSpP/z6HYaLfUNatHlXngJvmXEbz2selvdR6ofLw2q4=',
    'ctl00$ContentPlaceHolder_content$RadioButtonList_resultType':0,
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$time':'RadionButton_year',
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$DropDownList_startYear':2020,
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$DropDownList_endYear':2021,
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$DropDownList_month_startYear':2021,
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$DropDownList_month_startMonth':1,
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$DropDownList_month_endYear':2021,
    'ctl00$ContentPlaceHolder_content$uc_timeSelector$DropDownList_month_endMonth':1,
    'ctl00$ContentPlaceHolder_content$uc_productList_mixVer$CheckBoxList_priceType$0':1,
    'ctl00$ContentPlaceHolder_content$uc_productList_mixVer$CheckBoxList_productList_0_0$0':9,
    'ctl00$ContentPlaceHolder_content$uc_productList_mixVer$CheckBoxList_productList_0_0$2':15,
    'ctl00$ContentPlaceHolder_content$uc_productList_mixVer$CheckBoxList_productList_0_0$4':44011,
    'ctl00$ContentPlaceHolder_content$uc_productList_mixVer$CheckBoxList_productList_0_0$6':48090,
    'ctl00$ContentPlaceHolder_content$Button_query':'查詢'
}

url = 'http://price.naif.org.tw/Query/Query_now.aspx'

headers = {'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'}

resp = requests.post(url, data = payload)
soup = BeautifulSoup(resp.text, 'html.parser')

print(soup.find("table", {'id': 'ContentPlaceHolder_content_GridView_data'}))
登入發表回應
0
uobik
iT邦新手 4 級 ‧ 2021-07-07 19:12:52

推個selenium

import time
from selenium import webdriver
from selenium.webdriver.support.select import Select

opt = webdriver.ChromeOptions()
opt.add_argument('--headless')  # 背景執行
driver = webdriver.Chrome(options=opt, executable_path='chromedriver.exe')  # path改成你的chromedriver.exe路徑

driver.get('http://price.naif.org.tw/Query/Query_now.aspx')
driver.find_element_by_id('ContentPlaceHolder_content_uc_timeSelector_RadioButton_month').click()
time.sleep(1)

startYear = driver.find_element_by_id('ContentPlaceHolder_content_uc_timeSelector_DropDownList_month_startYear')
selStartYear = Select(startYear)
selStartYear.select_by_value('2018')

startMonth = driver.find_element_by_id('ContentPlaceHolder_content_uc_timeSelector_DropDownList_month_startMonth')
selStartMonth = Select(startMonth)
selStartMonth.select_by_value('1')
time.sleep(1)

endYear = driver.find_element_by_id('ContentPlaceHolder_content_uc_timeSelector_DropDownList_month_endYear')
selEndYear = Select(endYear)
selEndYear.select_by_value('2019')

endMonth = driver.find_element_by_id('ContentPlaceHolder_content_uc_timeSelector_DropDownList_month_endMonth')
selEndMonth = Select(endMonth)
selEndMonth.select_by_value('10')
time.sleep(1)

driver.find_element_by_id('ContentPlaceHolder_content_uc_productList_mixVer_CheckBoxList_priceType_0').click()  # 產品農地價格
time.sleep(1)
driver.find_element_by_id('ContentPlaceHolder_content_uc_productList_mixVer_CheckBoxList_productList_1_0_8').click()  # 雞蛋
time.sleep(1)

driver.find_element_by_id('ContentPlaceHolder_content_Button_query').click()
time.sleep(2)

print(driver.page_source)
driver.quit()

https://ithelp.ithome.com.tw/upload/images/20210707/20138982vSYckNCsdW.png

登入發表回應
0
blanksoul12
iT邦研究生 5 級 ‧ 2021-07-08 14:44:16

來個 excel vba

Sub get_egg()

With CreateObject("MSXML2.XMLHTTP.6.0")
    .Open "GET", "http://price.naif.org.tw/Query/Query_now.aspx", False '進入網頁
    .SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    .Send
    strText = .responsetext
    VIEWSTATE = encodeURI(CStr(Split(Split(strText, "__VIEWSTATE"" value=""")(1), """ />")(0))) 'VIEWSTATE
    VIEWSTATEGENERATOR = encodeURI(CStr(Split(Split(strText, "__VIEWSTATEGENERATOR"" value=""")(1), """ />")(0))) 'VIEWSTATEGENERATOR
    EVENTVALIDATION = encodeURI(CStr(Split(Split(strText, "__EVENTVALIDATION"" value=""")(1), """ />")(0))) 'EVENTVALIDATION
    
    .Open "POST", "http://price.naif.org.tw/Query/Query_now.aspx", False    '選產地農場價格
    .SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    msg = "__EVENTTARGET=ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_priceType%240" '最尾的 0 = 產地農場價格, 1 = 市場拍賣價格, 2 = 零售價格
    msg = msg & "&__EVENTARGUMENT="
    msg = msg & "&__LASTFOCUS="
    msg = msg & "&__VIEWSTATE=" & VIEWSTATE
    msg = msg & "&__VIEWSTATEGENERATOR" & VIEWSTATEGENERATOR
    msg = msg & "&__SCROLLPOSITIONX=0"
    msg = msg & "&__SCROLLPOSITIONY=0"
    msg = msg & "&__EVENTVALIDATION=" & EVENTVALIDATION
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24RadioButtonList_resultType=0"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24time=RadionButton_year"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_startYear=1996"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_endYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_startYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_startMonth=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_endYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_endMonth=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_priceType%240=1" '如說其他,最的的 1 也要變的
    
    .Send msg
    strText = .responsetext
    CopyToClipbox (strText)
    
    VIEWSTATE = encodeURI(CStr(Split(Split(strText, "__VIEWSTATE"" value=""")(1), """ />")(0))) 'VIEWSTATE
    VIEWSTATEGENERATOR = encodeURI(CStr(Split(Split(strText, "__VIEWSTATEGENERATOR"" value=""")(1), """ />")(0))) 'VIEWSTATEGENERATOR
    EVENTVALIDATION = encodeURI(CStr(Split(Split(strText, "__EVENTVALIDATION"" value=""")(1), """ />")(0))) 'EVENTVALIDATION
    
    .Open "POST", "http://price.naif.org.tw/Query/Query_now.aspx", False '選家禽類 雞蛋
    .SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    msg = "__EVENTTARGET=ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_productList_1_0%248" 'productList_1 的 1 = 家禽類, 0 = 家畜類, 2 = 飼料 / 最尾的 8 = 雞蛋, 0 = 白肉雞(活體), 6 = 鴨(番鴨)(活體)
    msg = msg & "&__EVENTARGUMENT="
    msg = msg & "&__LASTFOCUS="
    msg = msg & "&__VIEWSTATE=" & VIEWSTATE
    msg = msg & "&__VIEWSTATEGENERATOR=" & VIEWSTATEGENERATOR
    msg = msg & "&__SCROLLPOSITIONX=0"
    msg = msg & "&__SCROLLPOSITIONY=563"
    msg = msg & "&__EVENTVALIDATION=" & EVENTVALIDATION
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24RadioButtonList_resultType=0"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24time=RadionButton_year"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_startYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_endYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_startYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_startMonth=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_endYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_endMonth=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_priceType%240=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_productList_1_0%248=13" '如說其他,最尾的 productList_1_0%248=13 也要變的
    
    .Send msg
    strText = .responsetext
    CopyToClipbox (strText)
    VIEWSTATE = encodeURI(CStr(Split(Split(strText, "__VIEWSTATE"" value=""")(1), """ />")(0))) 'VIEWSTATE
    VIEWSTATEGENERATOR = encodeURI(CStr(Split(Split(strText, "__VIEWSTATEGENERATOR"" value=""")(1), """ />")(0))) 'VIEWSTATEGENERATOR
    EVENTVALIDATION = encodeURI(CStr(Split(Split(strText, "__EVENTVALIDATION"" value=""")(1), """ />")(0))) 'EVENTVALIDATION
    
    .Open "POST", "http://price.naif.org.tw/Query/Query_now.aspx", False '發出要求
    .SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    msg = "__EVENTTARGET="
    msg = msg & "&__EVENTARGUMENT="
    msg = msg & "&__LASTFOCUS="
    msg = msg & "&__VIEWSTATE=" & VIEWSTATE
    msg = msg & "&__VIEWSTATEGENERATOR=" & VIEWSTATEGENERATOR
    msg = msg & "&__SCROLLPOSITIONX=0"
    msg = msg & "&__SCROLLPOSITIONY=0"
    msg = msg & "&__EVENTVALIDATION=" & EVENTVALIDATION
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24RadioButtonList_resultType=0"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24time=RadionButton_year"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_startYear=1996"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_endYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_startYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_startMonth=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_endYear=2021"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_timeSelector%24DropDownList_month_endMonth=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_priceType%240=1"
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24uc_productList_mixVer%24CheckBoxList_productList_1_0%248=13" '跟上面
    msg = msg & "&ctl00%24ContentPlaceHolder_content%24Button_query=%E6%9F%A5%E8%A9%A2"
    .Send msg
    strText = .responsetext
    CopyToClipbox (strText)
    Set temp_ie = CreateObject("htmlfile")
    temp_ie.Write .responsetext
    Set get_table = temp_ie.DocumentElement.all.tags("table")
    Set get_cell = get_table(get_table.Length - 1).Cells
    
    Cells.Clear
    For i = 4 To get_cell.Length - 1 Step 2
        [a1048576].End(xlUp).Offset(1, 0) = get_cell(i).innertext
        [a1048576].End(xlUp).Offset(0, 1) = get_cell(i + 1).innertext
    Next
End With
End Sub
Sub CopyToClipbox(strText As String)

   '文本拷?到剪?板

    With CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
        .SetText strText
        .PutInClipboard
    End With
End Sub
Function encodeURI(strText As String) As String
    With CreateObject("msscriptcontrol.scriptcontrol")
        .Language = "JavaScript"
        encodeURI = .Eval("encodeURIComponent('" & strText & "');")
    End With
End Function
登入發表回應

我要發表回答

立即登入回答
iThome鐵人賽
參賽組數
1123 組
團體組數
52 組
累計文章數
23096 篇
完賽人數
656 人
iT+看影片追技術 看影片追技術 看更多
熱門tag 看更多
15th鐵人賽 13th鐵人賽 14th鐵人賽 12th鐵人賽 11th鐵人賽 鐵人賽 2019鐵人賽 2018鐵人賽 javascript 2017鐵人賽 python windows php c# windows server linux css react 程式設計 vue.js
熱門問題
熱門回答
熱門文章
IT邦幫忙