如何使用Python读取excel文件？（代码示例）

pip install xlrd

# 使用Python读取excel文件
import xlrd 
  
# 给出文件的位置
loc = ("path of file") 
  
# 打开Workbook 
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0) 
  
# 对于第0行和第0列
sheet.cell_value(0, 0)

'NAME'

# 使用Python提取行数
import xlrd 
  
#给出文件的位置
loc = ("path of file") 
  
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0) 
sheet.cell_value(0, 0) 
  
#提取行数 
print(sheet.nrows)

4

# 用Python程序提取列数
import xlrd 
  
loc = ("path of file") 
  
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0) 
  
# 对于第0行和第0列
sheet.cell_value(0, 0) 
  
# 提取列数
print(sheet.ncols)

3

# 提取所有列名
import xlrd 
  
loc = ("path of file") 
  
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0) 
  
sheet.cell_value(0, 0) 
  
for i in range(sheet.ncols): 
    print(sheet.cell_value(0, i))

NAME
SEMESTER
ROLL NO

# 提取第一列
import xlrd 
  
loc = ("path of file") 
  
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0) 
sheet.cell_value(0, 0) 
  
for i in range(sheet.nrows): 
    print(sheet.cell_value(i, 0))

NAME
ALEX
CLAY
JUSTIN

['ALEX', 4.0, 2011272.0]]