Python 3使用xlrd和xlwt按原样复制数据

pip install xlrd
pip install xlwt

import xlrd
import xlwt

source_file = xlrd.open_workbook('source.xls')
target_file = xlwt.Workbook()

source_sheet_names = source_file.sheet_names()

for sheet_name in source_sheet_names:
    source_sheet = source_file.sheet_by_name(sheet_name)
    target_sheet = target_file.add_sheet(sheet_name)

    for row in range(source_sheet.nrows):
        for col in range(source_sheet.ncols):
            cell_value = source_sheet.cell_value(row, col)
            cell_type = source_sheet.cell_type(row, col)

            if cell_type == xlrd.XL_CELL_TEXT:
                target_sheet.write(row, col, cell_value)
            elif cell_type == xlrd.XL_CELL_NUMBER:
                target_sheet.write(row, col, cell_value)
            elif cell_type == xlrd.XL_CELL_DATE:
                target_sheet.write(row, col, cell_value)
            # 处理其他类型的单元格数据

target_file.save('target.xls')