from openpyxl import load_workbook
def readExcle(filename,sheetname):
wb = load_workbook(filename)
sheet = wb[sheetname]
sheet.max_row #获取最大的行数
sheet.max_column #获取最大的列数
sheet_list =[]
row = 2
while row <= sheet.max_row:
# print(sheet.cell(row,1).value)
# print(sheet.cell(row,2).value)
# print(sheet.cell(row,3).value)
d = {}
d["序号"] =sheet.cell(row,1).value
d["姓名"] =sheet.cell(row,2).value
d["年龄"] =sheet.cell(row,3).value
sheet_list.append(d)
row +=1
return sheet_list
#回写值
def writeExcle(filename,sheetname,row,cell,value):
wb = load_workbook(filename)
sheet = wb[sheetname]
sheet.cell(row,cell).value = value
wb.save(filename)
if __name__ == '__main__':
d = readExcle("./test.xlsx","Sheet1")
print(d)
writeExcle("./test.xlsx","Sheet1",1,2,"测试")
python 中 读写excel 文件 openpyxl 封装方法读取excel中的内容并返回列表
最新推荐文章于 2024-07-12 16:16:27 发布