openyxl 读取表格,修改内容

# coding=utf-8
from openpyxl import load_workbook
from openpyxl import Workbook


class Get_Excel_Data():
    def __init__(self, filename):
        self.filename = filename
        self.wb = load_workbook(self.filename)
        self.sheet_names = self.wb.sheetnames

    def write_excel(self):
        pass

    def save_excel(self):
        pass

    def read_excel(self):
        for i in range(len(self.sheet_names)):
            ws = self.wb[self.sheet_names[i]]   # 表 索引位置
            sheet_name = self.sheet_names[i]
            # 读取原表数据
            l_num = ws.max_column  # 最大列
            h_num = ws.max_row  # 最大行
            for i in range(1, h_num + 1):  # h_num + 1
                line_title = ws.cell(row=i, column=2)
                line_class = ws.cell(row=i, column=9)
                title_value = line_title.value
                class_value = line_class.value    # 读取
                print(title_value, ' --- ', class_value)
                if class_value in title_value:
                    ws.cell(row=i, column=10, value=1)    # 保存

                # for j in range(1, l_num + 1):
                #     lie_title = ws.cell(row=i, column=j)  # 每列标题  <Cell '固定费用'.A1>
                #     print(lie_title)
                #     a_value = lie_title.value  # 此单元格里边的值
                #     coord = lie_title.coordinate  # 此单元格坐标  A1  B1
                    # print(aa, type(aa))  # class= str
                    # print(coord, type(coord))  # class= str
            self.wb.save('1120.xlsx')








if __name__ == '__main__':
    filename = '三级类目_20181119.xlsx'
    f = Get_Excel_Data(filename)
    f.read_excel()