import requests
import xlrd
import xlwt


# 读取Excle
def readerExcel():
	# 打开Excle文件
    work_book = xlrd.open_workbook(r"C:\Users\Administrator\Desktop\talent_tb.xlsx")
    print(work_book.sheet_names())          #输出页签名
    sheet2 = work_book.sheet_by_name('talent_tb')       #打开页签
    nrows = sheet2.nrows        #获取行数
    ncols = sheet2.ncols        #获取列数
    print(nrows, ncols)

    cell_A = sheet2.cell(1, 1).value        #取出第2行第2列的值
    print(cell_A)


# 写入Excle
def writerExcle():
    # 下面是写入部分
    stus = [['年', '月'], ['2018', '09'], ['2019', '10'], ['2020', '11']]
    Excle = xlwt.Workbook()    #新建Excle
    sheet = Excle.add_sheet('B')      #新建标签页
    rows = 0

    for stu in stus:
        clos = 0
        for s in stu:
            sheet.write(rows, clos, s)    #开始写入
            clos += 1
        rows += 1
    Excle.save('Excle.xls')
        

if __name__ == '__main__':
    readerExcel()
    writerExcle()