python3.85安装详细步骤_python 安装 xlwt 模块

xlwt的简介

这是一个开发人员用来生成与微软Excel版本95到2003兼容的电子表格文件的库。包本身是纯Python，在标准Python分布之外没有依赖于模块或包的依赖关系。

xlwt的安装

xlwt xlrd 模块

分别在https://pypi.python.org/pypi/xlwt

和 https://pypi.python.org/pypi/xlrd

windows:

pip3 install xlwt

pip3 install xlwt

Collecting xlwt

Downloading https://files.pythonhosted.org/packages/44/48/def306413b25c3d01753603b1a222a011b8621aed27cd7f89cbc27e6b0f4/xlwt-1.3.0-py2.py3-none-any.whl (99kB)

100% |████████████████████████████████| 102kB 42kB/s

Installing collected packages: xlwt

Successfully installed xlwt-1.3.0

You are using pip version 10.0.1, however version 18.1 is available.

You should consider upgrading via the ‘python -m pip install --upgrade pip’ command.

linux:

xlwt的使用方法

import xlwt

from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on',

num_format_str='#,##0.00')

style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

wb = xlwt.Workbook()

ws = wb.add_sheet('A Test Sheet')

ws.write(0, 0, 1234.56, style0)

ws.write(1, 0, datetime.now(), style1)

ws.write(2, 0, 1)

ws.write(2, 1, 1)

ws.write(2, 2, xlwt.Formula("A3+B3"))

wb.save('example.xls')

from xlwt import * #需要xlwt库的支持 或者#import xlwt

def write_to_excle(data):

file = Workbook(encoding = 'utf-8') #指定file以utf-8的格式打开

table = file.add_sheet('data') #指定打开的文件名，sheet名

ldata = []

num = [a for a in data] #for循环指定取出key值存入num中

num.sort() #字典数据取出后无需，需要先排序

for x in num: #for循环将data字典中的键和值分批的保存在ldata中

t = [int(x)]

for a in data[x]:

t.append(a)

ldata.append(t)

for i,p in enumerate(ldata): #将数据写入文件,i是enumerate()函数返回的序号数

for j,q in enumerate(p):

print(i,j,q)

table.write(i,j,q)

file.save('data.xlsx')

row01=["第一行",11,12]

row02=["第二行",21,22]

row03=["第三行",31,32]

data = {

"1": row01,

"2":row02,

"3":row03

}

write_to_excle(data)