使用python读取 Excel文件
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import xlrd
# 获取 Excel
workbook = xlrd.open_workbook('test.xls')
# 获取第一个sheet
sheet = workbook.sheet_by_index(0)
rows = sheet.nrows  # 行
cols = sheet.ncols  # 列 
for row in xrange(rows):
    # 获取第一行第一列
    ip = sheet.cell_value(row, 0)
    # 获取第一行第二列
    nfs = sheet.cell_value(row, 1)