python 使用 xlwt 写入单元格时,如何合并单元格


我想展示成这样:


 ----------------
|     名称      |
----------------
| 1    | 2     |
----------------

用下列代码写入:


 sheet.write(0, 0, '名称')
sheet.write(1, 0, 1)
sheet.write(1, 1, 2)

但实际展示成了:


 --------------------
|    名称    |      |
--------------------
| 1         | 2    |
--------------------

求解

python xlwt

jobgene 10 years ago

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 ago

Your Answer