python操作excel

# !/usr/bin/python
# -*- coding:UTF-8 -*-
# author:jiyanjiao
# 基础包:excel的封装

import xlrd

class readExcel(object):
    def __init__(self,path):
        self.path = path

    @property
    def getSheet(self):
        # 获取索引
        xl = xlrd.open_workbook(self.path)
        #sheet = xl.sheet_by_index(0)
        table = xl.sheets()[0]
        #print('table的返回值为:',table)
        return table

    @property
    def getRows(self):
        # 获取行数
        nrows = self.getSheet.nrows
        print('getrows的值:',nrows)
        return nrows

    @property
    def getCol(self):
        # 获取列数
        col = self.getSheet.ncols
        return col

    """以下是分别获取每一列的数值"""

    @property
    def getName(self):
        test_name = []
        for i in range(1,self.getRows):
            test_name.append(self.getSheet.cell_value(i,0))
        return test_name

    @property
    def getData(self):
        test_data = []
        for i in range(1,self.getRows):
            test_data.append(self.getSheet.cell_value(i,1))
        return test_data

if __name__ == '__main__':
    ex_path = 'C:\Users\lenovo\Desktop\jiekou.xlsx'
    re = readExcel(ex_path)
    rows = re.getRows
    print('行数为:',rows)
    names = re.getName
    print('姓名:',names)