1. 读写单元格
from openpyxl import load_workbook
wb = load_workbook('tmp.xlsx')
sheet = wb.active
value = sheet.cell(row=3, column=1).value
print(value)
sheet.cell(row=3, column=7).value = 123
wb.save('tmp.xlsx')
wb.close()
注意:写完之后必须保存才能生效。
2. 创建表单
from openpyxl import Workbook
wb = Workbook()
wb.create_sheet('sheet1')
wb.create_sheet('sheet2')
sheet2 = wb['sheet2']
print(sheet2)
wb.save('file.xlsx')
wb.close()
3. 遍历表单
from openpyxl import load_workbook
wb = load_workbook('tmp.xlsx')
sheet = wb.active
for row in sheet.iter_rows(min_row=3, max_row=10):
for cell in row:
print(cell.value, end=',')
print()
wb.close()
遍历的同时进行写入:
from openpyxl import load_workbook
wb = load_workbook('tmp.xlsx')
sheet = wb.active
for row in sheet.iter_rows(min_row=3, max_row=10):
print(row[0].value)
row[1].value = 'abc'
wb.save('tmp.xlsx')
wb.close()
遍历一个区域:
from openpyxl import load_workbook
wb = load_workbook('tmp.xlsx')
sheet = wb.active
for row in sheet.iter_rows(min_row=3, max_row=10, min_col=1, max_col=3):
for cell in row:
print(cell.value, end=',')
print()
wb.close()
4. 合并单元格
from openpyxl import load_workbook
wb = load_workbook('tmp.xlsx')
sheet = wb.active
sheet.merge_cells(start_row=1, end_row=2, start_column=8, end_column=10)
sheet.cell(row=1, column=8).value = 'Hello, World!'
wb.save('tmp.xlsx')
wb.close()
5. 拆分单元格
from openpyxl import load_workbook
wb = load_workbook('tmp.xlsx')
sheet = wb.active
sheet.unmerge_cells(start_row=1, end_row=2, start_column=8, end_column=10)
wb.save('tmp.xlsx')
wb.close()
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)