在python中读取excel文件时出现问题

请尝试以下代码

import pandas as pd 
import xlrd as xl 
from pandas import ExcelWriter
from pandas import ExcelFile 

df=pd.read_excel("sample.xlsx",sheet_name='Sheet1')

除此之外,这个问题还有很多答案。请通过them:-

Read Excel File in Python

import xlrd

loc = ("Excel_path")
wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(0) 
row_count = sheet.nrows
while (n<row_count):
    data=sheet.cell_value(n, 0)#to read data from first column of excel

在 data=sheet.cell_value(n, 0) 可以将0替换为1以读取下一列,依此类推。