安装
pip install openpyxl
导入头文件
from openpyxl import Workbook, load_workbook from openpyxl.styles import Font, colors, Alignment
创建文件
# wb = load_workbook('001.xlsx') #也可以直接加载现有xlsx 文件
wb=Workbook() #创建文件
wb.active #激活
创建工作表
wb.create_sheet(index=0, title='小猪') wb.create_sheet(index=1, title='佩奇')
选择表 & 删除表
ws = wb['小猪'] #选择 表 del wb['Sheet'] # 删除 表
设置单元格 宽高
ws.column_dimensions['A'].width = 20 ws.column_dimensions['B'].width = 20 ws.column_dimensions['C'].width = 20 ws.row_dimensions[1].height = 15 ws.row_dimensions[2].height = 15 ws.row_dimensions[3].height = 15
写数据
ws['A1'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
ws['A2'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
ws['A3'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
ws['A4'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
ws.append([1, 2, 3])
遍历内容 并 设置单元格样式（垂直居中）
for row in ws.iter_rows():
for cell in row:
ws[cell.coordinate].alignment = Alignment(horizontal='center', vertical='center')
print(cell.coordinate, cell.value)
输出xlsx文件
wb.save('Test.xlsx')
