import xlrd,xlwt
def split_ecel(excel_name):
    try:
        with xlrd.open_workbook(excel_name) as file:
            print(file.sheet_names())  # execl名字列表
            print(file.sheet_by_index(0), file.sheet_by_name(file.sheet_names()[0]))  # 根据索引和name获取
            for f in file:
                name = f.name  # 工作表名
                rows = f.nrows  # 行数
                cols = f.ncols  # 列数
                print(name, rows, cols)
                cell = f.cell(0, 0)  # 第一行第一列的表格 包括数据类型和内容 .value
                print(type(cell), cell, cell.value)  # 读取信息
                workbook = xlwt.Workbook()  #
                sheet = workbook.add_sheet(name)  # 添加一个工作表
                for r in range(0, rows):
                    for c in range(0, cols):
                        value = f.cell(r, c).value  # 取出数据
                        sheet.write(r, c, value)  # 写入
                workbook.save(name + '.xls')  # 保存
    except Exception as e:
        print(e)
        return False
    return True
print("input excel name to split:")
name=str(input())
split_ecel(name)