python--操作excel

一、模块安装

pip install xlrd 

二、操作excel封装

代码如下（示例）：

import xlrd
class OperateExcel():
    def __init__(self,filname=None,sheetid=None):
        self.filename = filname
        self.sheetid = sheetid
        self.data = self.get_data()

    def get_data(self):
        "获取sheet内容"
        data = xlrd.open_workbook(self.filename)
        tables = data.sheets()[self.sheetid]
        return tables

    def get_lines(self):
        "获取单元格行数"
        tables = self.data
        return tables.nrows

    def get_cell_value(self,row,col):
        "获取某个单元格内容"
        return self.data.cell_value(row,col)

if __name__ == '__main__':
    filename = r".\hello.xls"
    sheetid = 0
    print(filename)
    obj = OperateExcel(filename,sheetid)
    print(obj.get_data().nrows)
    print(obj.get_cell_value(0,0))

hello.xls

三、运行结果