Xlsx是python用来构造xlsx文件的模块,可以向excel2007+中写text,numbers,formulas 公式以及hyperlinks超链接。
可以完成xlsx文件的自动化构造,包括:
合并单元格,制作excel图表等功能:
1,Introduction:
xlsxWriter支持多种excle功能;与excel完美兼容;写大文件,速度快且只占用很小的内存空间
不支持读或者改现有的excel文件
2, Installing:
sudo pip install XlsxWriter;
sudo easy_install XlsxWriter;
或者源码安装:http://github.com/jmcnamara/XlsxWriter/archive/master.tar.gz
3,使用:
import xlsxwriter workbook = xlsxwriter.Workbook('hello.xlsx') # 建立文件 worksheet = workbook.add_worksheet() # 建立sheet, 可以work.add_worksheet('employee')来指定sheet名,但中文名会报UnicodeDecodeErro的错误 worksheet.write('A1', 'Hello world') # 向A1写入 workbook.close()
excel公式计算
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
# Some data we want to write to the worksheet.
expenses
=
(
[
'Rent'
,
1000
],
[
'Gas'
,
100
],
[
'Food'
,
300
],
[
'Gym'
,
50
],
)
# Start from the first cell. Rows and columns are zero indexed. 按标号写入是从0开始的,按绝对位置'A1'写入是从1开始的
row
=
0
col
=
0
# Iterate over the data and write it out row by row.
for
item, cost
in
(expenses):
worksheet.write(row, col, item)
worksheet.write(row, col
+
1
, cost)
row
+
=
1
# Write a total using a formula.
worksheet.write(row,
0
,
'Total'
)
worksheet.write(row,
1
,
'=SUM(B1:B4)'
)
# 调用excel的公式表达式
workbook.close()
|
excel自定义格式:
import xlsxwriter # 建文件及sheet. workbook = xlsxwriter.Workbook('Expenses02.xlsx