一、openpyxl读Excel文件
1.打开Excel文件
import openpyxl
wb = openpyxl.open('./files/data.xlsx')
2.获取工作薄中所有工作表的表名
# 工作薄对象.sheetnames
names = wb.sheetnames
print(names)
3.获取工作表
sheet1 = wb.active
print(sheet1)
sheet2 = wb['原始数据']
print(sheet2)
4.获取最大行数和列数
m_r=sheet2.max_row
m_c=sheet2.max_column
print(m_r, m_c)
5.获取单元格
cell1 = sheet2.cell(2, 1)
cell2 = sheet2.cell(2, 2)
6.获取单元格中的内容
print(cell1.value, cell2.value)
二、灵活获取Excel文件中的数据
获取指定行所有的数据
row = 3
for col in range(1, sheet.max_column+1):
cell = sheet.cell(row, col)
print(cell.value)
col = 2
for row in range(1, sheet.max_row+1):
cell = sheet.cell(row, col)
print(cell.value)
for row in range(1, sheet.max_row+1):
for col in range(1,sheet.max_column+1):
cell = sheet.cell(row, col)
print(cell.value)
list1 = []
for row in range(2, sheet.max_row+1):
stu = {
}
for col in range(1, sheet.max_column+1):
date_cell = sheet.cell