python读写excel文件的基本操作

读操作

import xlrd


def test1(file_name):
    # 获取文件中第一个sheet表
    sheet = xlrd.open_workbook(file_name).sheets()[0]
    # 该表总函数
    nrows = sheet.nrows
    for x in range(1, nrows):
        row = sheet.row_values(x)
        # 除了表头，依次读出每行
        print(row)


if __name__ == '__main__':
    test1('123.xlsx')

写操作

import xlwt


def write_data(table_name, data_list):
    table_name = '123.xls'
    data_list = [['张三', '男', '15'], ['李四', '男', '16']]
    file = xlwt.Workbook()
    table = file.add_sheet(table_name, cell_overwrite_ok=True)
    # 第一行
    num = 0
    # 先写表头
    table.write(num, 0, ' 姓名')
    table.write(num, 1, '性别')
    table.write(num, 2, '年龄')
    num = 1
    for ac in data_list:
        # 依次写第2、3、4行的数据
        table.write(num, 0, ac[0])
        table.write(num, 1, ac[1])
        table.write(num, 2, ac[2])
        num = num + 1
    file.save(table_name)