python读取excel代码

# coding=utf-8
import xlrd
import xlwt
import datetime

import os

if __name__ == '__main__':
    readbook = xlrd.open_workbook(r'./data/Blog记录.xlsx')
    # sheet = readbook.sheet_by_index(1)  # 索引的方式，从0开始
    sheet = readbook.sheet_by_name('BlogURL')  # 名字的方式
    nrows = sheet.nrows  # 行
    ncols = sheet.ncols  # 列
    for i in range(nrows):
        value_url = sheet.cell(i, 4)
        if "microsoft" in str(value_url):
            print(str(i),sheet.cell(i,1))
    # print(sheet.cell(0,0))