pyexcelerate写入数据新姿势

#写入单元格
from pyexcelerate import Workbook

wb = Workbook()
ws = wb.new_sheet("sheet name")
ws[1][1].value =15
#合并单元格

from pyexcelerate import Workbook

wb = Workbook()
ws = wb.new_sheet("sheet name")
ws[1][1].value =15
ws.range("A1", "B1").merge()
wb.save("output.xlsx")
#设置单元格格式

from pyexcelerate import Workbook, Color, Style, Font, Fill, Formatfrom datetime import datetime
wb = Workbook()
ws = wb.new_sheet("sheet name")
ws.set_cell_value(1, 1, 1)
ws.set_cell_style(1, 1, Style(font=Font(bold=True)))
ws.set_cell_style(1, 1, Style(font=Font(italic=True)))
ws.set_cell_style(1, 1, Style(font=Font(underline=True)))
ws.set_cell_style(1, 1, Style(font=Font(strikethrough=True)))
ws.set_cell_style(1, 1, Style(fill=Fill(background=Color(255,0,0,0))))
ws.set_cell_value(1, 2, datetime.now())
ws.set_cell_style(1, 1, Style(format=Format(‘mm/dd/yy‘)))
wb.save("output.xlsx")

-------------------------------

ws[1][1].style.font.bold =True
ws[1][1].style.font.italic =True
ws[1][1].style.font.underline =True
ws[1][1].style.font.strikethrough =True
ws[1][1].style.font.color = Color(255, 0, 255)
ws[1][1].style.fill.background = Color(0, 255, 0)
ws[1][1].style.alignment.vertical =‘top‘
ws[1][1].style.alignment.horizontal =‘right‘
ws[1][1].style.alignment.rotation =90
ws[1][1].style.alignment.wrap_text =True
ws[1][1].style.borders.top.color = Color(255, 0, 0)
ws[1][1].style.borders.right.style =‘-.‘

#设置范围样式

from pyexcelerate import Workbook, Color
from datetime import datetime
wb = Workbook()
ws = wb.new_sheet("test")
ws.range("A1","C3").value =1
ws.range("A1","C1").style.font.bold =True
ws.range("A2","C3").style.font.italic =True
ws.range("A3","C3").style.fill.background = Color(255, 0, 0, 0)
ws.range("C1","C3").style.font.strikethrough =True

pyexcelerate写入数据新姿势

原文：https://www.cnblogs.com/huangyz-xy/p/13305382.html