python实现Excel内数据转存

python实现Excel内数据转存

import xlrd
import xlwt


def excel_demo(path, new_path):
    book = xlrd.open_workbook(path)
    table = book.sheets()[0]
    rows = int(table.nrows)
    cols = int(table.ncols)
    print("excel_size:{}行{}列".format(rows, cols))
    num = []
    new_book = xlwt.Workbook()
    new_table = new_book.add_sheet('sheet_name', cell_overwrite_ok=True)
    for i in range(rows):
        print("第{}行正在读取".format(i + 1))
        for j in range(cols):
            try:
                cell = table.cell(i, j)
                cell = str(cell).split(':')[1]
                if i == 0:
                    cell = cell.split("'")[1]
                # print(cell)
                new_table.write(i, j, cell)
            except:
                continue
            # num.append(cell)
        print("第{}行读取完毕".format(i + 1))
    new_book.save(new_path)


if __name__ == "__main__":
    path = r""  # excel路径
    new_path = r"" # 转存路径
    excel_demo(path, new_path)

目标excel

转存excel

过程打印