导入openpyxl
import openpyxl
只读方式打开excel
wb=openpyxl.load_workbook(filename="test.xlsx", read_only=True)
创建excel
from openpyxl import Workbook
wb=Workbook()
打开指定sheet
ws = wb['test']
获取最大列数
max_col = ws.max_colum
读取excel指定行数据
for i in range(1, max_col + 1):
cell_value=ws.cell(row=row, column=i).value
print(cell_value)
写入excel单元格数据
ws['A1'] = '12345'
修改单元格字体格式
from openpyxl.styles import Font
ws['A1'].font = Font(size=14, bold=True, color="0000FF")
保存excel
wb.save("test.xlsx")
wb.close()