python - 如何在 xlwt 中编写具有多列的单元格？

Question

我想写一个这样的表格:

----------------
| Long Cell    |
----------------
| 1    | 2     |
----------------

单元格Long Cell怎么写？谢谢。

我试过这样做:

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

但结果是这样的:

--------------------
| Long Cell |      |
--------------------
| 1         | 2    |
--------------------

Answer 1

据我所知，这没有记录 - 您必须阅读源代码才能找到它。 Worksheet 类有两种方法可以做到这一点，write_merge 和 merge。 merge 获取现有单元格并将它们合并，而 write_merge 写入一个标签(就像 write 一样)然后执行相同的操作 merge 确实如此。

两者都将单元格合并为r1、r2、c1、c2，并接受可选的style参数。

根据您的示例，这将是最简单的调用:

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

更明确地说明调用的工作原理:

top_row = 0
bottom_row = 0
left_column = 0
right_column = 1
sheet.write_merge(top_row, bottom_row, left_column, right_column, 'Long Cell')

或者，使用 merge:

sheet.write(top_row, left_column, 'Long Cell')
sheet.merge(top_row, bottom_row, left_column, right_column)

merge 在源码中有一些注释指出了潜在的问题:

    # Problems: (1) style to be used should be existing style of
    # the top-left cell, not an arg.
    # (2) should ensure that any previous data value in
    # non-top-left cells is nobbled.
    # Note: if a cell is set by a data record then later
    # is referenced by a [MUL]BLANK record, Excel will blank
    # out the cell on the screen, but OOo & Gnu will not
    # blank it out. Need to do something better than writing
    # multiple records. In the meantime, avoid this method and use
    # write_merge() instead.

但对于这样一个简单的案例来说，它会很好。