Python Excel 处理模块 openpyxl
from openpyxl import workbook
# excel文件 & sheet
wb = workbook.Workbook()
sheet = wb.worksheets[0]
# sheet = wb.active
# 找到单元格(行,列),写入值
cell = sheet.cell(1, 1)
cell.value = '李小龙'
wb.save('info.xlsx')
读取Excel
from openpyxl import load_workbook
wb = load_workbook('abc.xlsx')
sheet = wb['Sheet1']
# sheet.rows返回一个生成器对象,用推导列表把对象取出来放list里
rows = [x for x in sheet.rows]
# 从第二行开始取值
for i in rows[1:]:
print(i[0].value, i[1].value, i[2].value)
当前页面是本站的「Google AMP」版。查看和发表评论请点击:完整版 »