metodo Prenchendo

    def prencher(self):
        i=2
        for row in self.ws2[0].iter_cols(min_row=2,min_col=2,max_col=2):
            for cell in row:
                if str(cell.value) in self.dadosWs.keys():
                    dados = str(self.dadosWs.get(str(cell.value)))
                    self.ws2[0].cell(row=i, column=22, value=str(dados[10:20]))
                    self.ws2[0].cell(row=i, column=26, value=str(dados[31:46].strip("{''}")))

                i=i+1

        self.wb.save("arquivo.xlsx")