我该如何转到网站的特定页面并使用Python获取所需的数据并将其保存到Excel表中.该代码需要URL直至所需的页面

Question

import requests from bs4 
import BeautifulSoup 
import xlrd file="C:UsersAshadeepPycharmProjectsuntitled1xlwt.ashadee.xls" 
workbook=xlrd.open_workbook(file) 
sheet=workbook.sheet_by_index(0) 
print(sheet.cell_value(0,0)) 
r = requests.get(sheet.cell_value(0,0))
r.content soup = BeautifulSoup(r.content,"html.parser") g_data=soup.find_all("div",{"class":"admissionhelp-left"})
print(g_data)
text=soup.find_all("Tel") for item in g_data:print(item.text)

Answer 1

您是否尝试从网络下载Excel文件并将其保存到HDD？我看不到任何URL，但是您可以尝试这三个想法之一。

import urllib
dls = "http://www.muellerindustries.com/uploads/pdf/UW SPD0114.xls"
urllib.urlretrieve(dls, "test.xls")

import requests
dls = "http://www.muellerindustries.com/uploads/pdf/UW SPD0114.xls"
resp = requests.get(dls)
with open('test.xls', 'wb') as output:
    output.write(resp.content)

或，如果您不一定需要浏览浏览器，则可以使用Urllib模块将文件保存到指定的位置。

import urllib
url = 'http://www.example.com/file/processing/path/excelfile.xls'
local_fname = '/home/John/excelfile.xls'
filename, headers = urllib.retrieveurl(url, local_fname)