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

Question

我想展示成这样：

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

用下列代码写入：

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

但实际展示成了：

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

求解

Answer 1

There is an almost identical question on stackoverflow:
http://stackoverflow.com/questions/19672760/how-to-write-a-cell-with-multiple-columns-in-xlwt

The code is like this:

sheet.write_merge(0, 0, 0, 1, 'Long Cell')
sheet.write(1, 0, 1)
sheet.write(1, 1, 2)