load excel

import pandas as pd
df = pd.read_excel (r'D:\Python_Test.xlsx')
#for an earlier version of Excel, you may need to use the file extension of 'xls'
lines = df.values
cols = df.columns
for i in cols:
     print(i)
for i in lines:
     print(i)

requests

import requests
url = "https://www.books.com.tw/"
htmlfile = requests.get(url)
print(type(htmlfile))
print(htmlfile.text)