python excel读取与写入

import xlrd
import os


def get_school_list():
    school_list = []
    path = os.getcwd() + '\全国高等学校名单.xls'
    workbook = xlrd.open_workbook(path)
    worksheet = workbook.sheet_by_index(0)
    nrows = worksheet.nrows
    for i in range(nrows):
        nrow_list = worksheet.row_values(i)
        nrow_list.pop(0)
        try:
            int(nrow_list[1])
            school_list.append(nrow_list)
        except:
            pass
    print(school_list)


def get_family_names():
    family_names = []
    path = os.getcwd() + '\百家姓.xls'
    workbook = xlrd.open_workbook(path)
    worksheet = workbook.sheet_by_index(0)
    nrows = worksheet.nrows
    for i in range(nrows):
        nrow_list = worksheet.row_values(i)
        family_names.append(nrow_list[0])
    print(family_names)


def get_major_list():
    major_list = []
    path = os.getcwd() + '\专业.xls'
    workbook = xlrd.open_workbook(path)
    worksheet = workbook.sheet_by_index(0)
    nrows = worksheet.nrows
    for i in range(nrows):
        nrow_list = worksheet.row_values(i)
        major_list.append(nrow_list[0])
    print(major_list)


get_major_list()
# get_school_list()
# get_family_names()


import xlwt

# def write_xlx():
#     book = xlwt.Workbook(encoding='utf-8', style_compression=0)
#     sheet = book.add_sheet('test', cell_overwrite_ok=True)
#     for i in range(len(major_list)):
#         sheet.write(i, 0, major_list[i])
#     book.save(r'C:\Users\l\Desktop\pandas库\resume\专业.xls')


# write_xlx()


# with open('1.txt','r',encoding='utf-8') as w:
#     s = w.read()
# print(s.split('|'))