访问Python下载的Excel文件的一张床单之一

Question

我已经下载了一个带有Web 4张纸的Excel文件，但是当我尝试将其转换为pandas dataframe时，我只能访问第一张纸。

import requests
import pandas as pd
dls = "http://www.nasdaqomxnordic.com/digitalAssets/110/110149_the-nordic-list-july-12--2019.xlsx"
resp = requests.get(dls)
output = open('test.xlsx', 'wb')
output.write(resp.content)
output.close()
df = pd.read_excel("test.xlsx", sheet_name = 1)

我收到以下错误消息：" typeError：'值'未订购，请通过传递类别参数明确指定类别顺序。"

Answer 1

可能有一种更直接的方法来执行此操作，但是我最终使用XLRD软件包，该软件包可以访问任何工作表，然后XLSXWriter从表格创建Excel文件，然后最后，大熊猫将其读为数据框。

import requests
import pandas as pd
dls = "http://www.nasdaqomxnordic.com/digitalAssets/110/110149_the-nordic-list-july-12--2019.xlsx"
resp = requests.get(dls)
output = open('test.xlsx', 'wb')
output.write(resp.content)
output.close()
import xlrd 
loc = ('test.xlsx') 
wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(1)
import xlsxwriter
workbook = xlsxwriter.Workbook('hello.xlsx') 
worksheet = workbook.add_worksheet() 
for i in range(sheet.nrows):
    for j in range(sheet.ncols):
        worksheet.write(i, j, sheet.cell_value(i, j)) 
workbook.close()
df = pd.read_excel("hello.xlsx")