python的openpyxl模块_Python 操作excel之 openpyxl模块

1、 安装

pip install openpyxl

想要在文件中插入图片文件，需要安装pillow，安装文件：PIL-fork-1.1.7.win-amd64-py2.7.exe

· font(字体类)：字号、字体颜色、下划线等

· fill(填充类)：颜色等

· border(边框类)：设置单元格边框

· alignment(位置类)：对齐方式

· number_format(格式类)：数据格式

· protection(保护类)：写保护

2、写入单元格：

def init_file(self):

wb = openpyxl.Workbook()

ws1 = wb.active # 创建一个sheet

ws1["A1"] = '日期'

ws1["B1"] = "省市"

ws1["C1"] = "报价地址"

ws1["D1"] = "产品名称"

ws1["E1"] = "分类"

ws1["F1"] = "价格"

ws1["G1"] = "买/卖"

ws1["H1"] = "发布人"

ws1["I1"] = "联系方式"

ws1["J1"] = "备注"

ws.append(tit)

for d in to:

print 'AAA>>>',d

try:

ws.append(d)

wb.save('/root/nowdata.xlsx')

#可重复写入

def save_execl(self,datals):

data = openpyxl.load_workbook('/root/nowdata.xlsx')

sheetnames = data.get_sheet_names()

wsobj = data.get_sheet_by_name(sheetnames[0])

wsobj.append(datals)

data.save('/root/nowdata.xlsx')

return True