可以在判断单元格是否为None之前先判断单元格是否为字符串类型，如果是字符串类型则创建一个新的单元格对象并将其值设置为None。修改后的代码如下：

添加第一列单元格内容到新工作表

for row_num, cell_value in enumerate(col1_values): if cell_value == value: row = [cell.value for cell in sheet[row_num + 2]] new_row = [] for cell in row: if isinstance(cell.value, str): new_cell = Cell(new_sheet, column=cell.column, row=cell.row, value=None) elif cell.value is None: new_cell = Cell(new_sheet, column=cell.column, row=cell.row) else: new_cell = Cell(new_sheet, column=cell.column, row=cell.row, value=cell.value) new_cell.font = cell.font new_cell.fill = cell.fill new_row.append(new_cell) new_sheet.append(new_row