python 使用 xlwt 写入单元格时,如何合并单元格
我想展示成这样:
----------------
| 名称 |
----------------
| 1 | 2 |
----------------
用下列代码写入:
sheet.write(0, 0, '名称')
sheet.write(1, 0, 1)
sheet.write(1, 1, 2)
但实际展示成了:
--------------------
| 名称 | |
--------------------
| 1 | 2 |
--------------------
求解
jobgene
10 years, 2 months ago
Answers
stackoverflow上有个几乎相同的问题:
http://stackoverflow.com/questions/19672760/how-to-write-a-cell-with-multiple-columns-in-xlwt
代码就是这样了:
sheet.write_merge(0, 0, 0, 1, 'Long Cell')
sheet.write(1, 0, 1)
sheet.write(1, 1, 2)
我只是一个宅
answered 10 years, 2 months ago