Python XLWT 尝试覆盖单元格解决方法

Question

使用python模块xlwt，写入同一个cell两次会报错:

Message File Name   Line    Position    
Traceback               
    <module>    S:\******** 
    write   C:\Python26\lib\site-packages\xlwt\Worksheet.py 1003        
    write   C:\Python26\lib\site-packages\xlwt\Row.py   231     
    insert_cell C:\Python26\lib\site-packages\xlwt\Row.py   150     
Exception: Attempt to overwrite cell: sheetname=u'Sheet 1' rowx=1 colx=12   

代码片段

def insert_cell(self, col_index, cell_obj):
        if col_index in self.__cells:
            if not self.__parent._cell_overwrite_ok:
                msg = "Attempt to overwrite cell: sheetname=%r rowx=%d colx=%d" \
                    % (self.__parent.name, self.__idx, col_index)
                raise Exception(msg) #row 150
            prev_cell_obj = self.__cells[col_index]
            sst_idx = getattr(prev_cell_obj, 'sst_idx', None)
            if sst_idx is not None:
                self.__parent_wb.del_str(sst_idx)
        self.__cells[col_index] = cell_obj

看起来代码“引发”了一个停止整个过程的异常。删除“raise”项是否足以允许覆盖单元格？我感谢 xlwt 的警告，但我认为 pythonic 方式是假设“我们知道我们在做什么”。我不想在触摸模块时破坏任何其他东西。

Answer 1

问题是在 xlwt 中默认禁用工作表数据覆盖。您必须明确允许它，如下所示:

worksheet = workbook.add_sheet("Sheet 1", cell_overwrite_ok=True)