【python随笔】之【对xls或xlsx文件的读写】

from pyexcel_xls import get_data
from pyexcel_xls import save_data
from collections import OrderedDict


def read_xls(path):
    # 是一个有序字典类型：[('sheet1_name',[['row1','row1','row1'],['row2','row2','row2']]),(...)]
    xlsData = get_data(path)
    # 读取每个sheet
    for sheet in xlsData.items():
        for sheetName_and_value in sheet:
            # 如果是字符串则为sheet名
            if isinstance(sheetName_and_value, str):
                print(sheetName_and_value, '：\n' + '-' * 100)
            # 如果是列表则为值
            else:
                # 遍历每一行（为列表）
                for line in range(len(sheetName_and_value)):
                    print(line, sheetName_and_value[line])


def write_xls(path):
    # 创建表
    data = OrderedDict()
    # Sheet1
    sheet_1 = []
    row1 = ['姓名', '年龄', '性别']
    row2 = ['张三', '17', '男']
    sheet_1.append(row1)
    sheet_1.append(row2)
    # Sheet2
    sheet_2 = []
    # 更新表
    data.update({'Sheet1': sheet_1})
    data.update({'Sheet2': sheet_2})
    # 保存
    save_data(path, data)
    print('保存成功！')


if __name__ == '__main__':
    # 读
    read_path = r'D:\大学\大二\大二成绩\18网络.xlsx'
    read_xls(read_path)
    # 写
    save_path = r'3.xls'
    write_xls(save_path)