Python的openpyxl使用

#coding=utf-8
import openpyxl


class ReadExcel:
    def __init__(self, path=None):
        try:
            if path != None:
                # 打开已有的Excel
                self.wb = openpyxl.load_workbook(path)
                return self.wb
            self.wb = openpyxl.load_workbook('./Case.xlsx')
        except:
            pass

    # 获取所有sheetName
    def get_sheet_name(self):
        sheet_name = self.wb.get_sheet_names()
        # print(sheet_name)
        return sheet_name

    # 使用固定的sheet
    def get_sheet(self, sheet_name=None):
        if sheet_name != None:
            now_sheet = self.wb[sheet_name]
        now_sheet = self.wb['Sheet1']
        # print(now_sheet)
        return now_sheet

    # 获取总行数
    def get_rows(self):
        self.rows = self.get_sheet().max_row
        # print(self.rows)
        return self.rows

    # 获取总列数
    def get_columns(self):
        self.columns = self.get_sheet().max_column
        # print(self.columns)
        return self.columns

    # 获取cell值
    def get_value(self, row=None, column=None):
        if row != None:
            if column != None:
                cell_value = self.get_sheet().cell(row=row, column=column).value
                print(cell_value)
        cell_value = self.get_sheet().cell(row=self.get_rows(), column=self.get_columns()).value

if __name__ == '__main__':
    excel = ReadExcel()
    excel.get_value(row=71, column=3)