简介
通过读取excel指定列内容。
代码
#!/usr/bin/python
#coding:utf-8
import xlrd
def read_excel(filename,
Row_num,
Col_num):
book = xlrd.open_workbook(filename)
sheet = book.sheet_by_name('target')
return sheet.cell_value(Row_num, Col_num)
if __name__ == '__main__':
# 读取excel
excel_filename = "C:\\赏金列表20190806.xls"
book = xlrd.open_workbook(excel_filename)
sheet = book.sheet_by_name('target')
rows = sheet.nrows #获取行数
cols = sheet.ncols #获取列数
for rows_num in range(1,rows):
type = read_excel(excel_filename, rows_num, 0) # 读取第N行第1列的数据
name = read_excel(excel_filename, rows_num, 1) # 读取第N行第2列的数据
domain = read_excel(excel_filename, rows_num, 2) # 读取第N行第3列的数据
domain_ip = read_excel(excel_filename, rows_num, 3) # 读取