python操作Excel表格

Windows下python操作Excel表格比较麻烦，需要导入xlrd模块进行读取，如果是写入内容的话需要导入xlwt
给出一个实例进行Excel表格的读取
这是获取了批量的抖音视频链接，标题，点赞，评论关注等相关信息，这里是提取了视频链接进行下载

import xlrd
import requests


def extract(inpath):
    data = xlrd.open_workbook(inpath, encoding_override='utf-8')
    table = data.sheets()[0]  # 选定表
    nrows = table.nrows  # 获取行号
    ncols = table.ncols  # 获取列号

    for i in range(1, nrows):  # 第0行为表头
        alldata = table.row_values(i)  # 循环输出excel表中每一行，即所有数据
        result_link = alldata[6]  # 取出表中第二列数据
        result_title = alldata[1]
        try:
            if not result_title:
                continue
            res = requests.get(result_link)
            if res.status_code == 200:
                video = res.content
                with open(r'C:\Users\Administrator\Desktop\video'+'\\'+result_title+'.mp4','wb') as f:
                    f.write(video)
                    print('第{}次下载成功！'.format(i))
            else:
                print('被禁止访问...')
        except Exception as e:
            print(e)
        # print(result_title)
        # print(result_link)


inpath = 'funny.xls'  # excel文件所在路径
extract(inpath)