python简单读excel文件

# -*- coding: utf-8 -*-
import xlrd
def read_excel():
    workbook = xlrd.open_workbook(r'E:\python_test\op_xlrd.xlsx')
    sheet2=workbook.sheet_by_index(1)
    for i in range (sheet2.ncols-1):#遍历有数据的excel表格
        for j in range (sheet2.nrows-1):
            print sheet2.cell(i,j).value
                
if __name__ == '__main__':
    read_excel()