Das deutsche Python-Forum

Code: Alles auswählen

       ""                         ""                      ""         ""            ""          ""       ""
       ""                         ""                    "                       Adresse                    "
"Laufende Nummer"    "Positionstext Rechnungslegung"    "Name"    "Straße"    "Hausnummer"    "Ort"    "PLZ"
       ""                         ""                      ""         ""            ""          ""       ""
        101                   Mustertext                Gebers   Hansastraße     154         Irgendwo  1234
        102
        103
        104

Code: Alles auswählen

    def import_IGM_FILE(self):
        col_list = []
        for col_index in range(self.WB_TABLE_WRITE.ncols):
            col = []
            for row_index in range(self.WB_TABLE_WRITE.nrows):
                valor = self.WB_TABLE_WRITE.cell(row_index, col_index).value
                for crange in self.WB_TABLE_WRITE.merged_cells:
                    rlo, rhi, clo, chi = crange
                    if rlo <= row_index < rhi and clo <= col_index < chi:
                        valor = self.WB_TABLE_WRITE.cell(rlo, clo).value
                        break
                col.append(valor)
            col_list.append(col)

        self.columns = defaultdict(dict)
        for (a, b, *c) in col_list:
            self.columns[a][b] = c
        return self.columns

Code: Alles auswählen

 {'': ['', '', '', '', '', ''], 'Adresse': ['PLZ', '', 49666.0, '', '', '']}

Code: Alles auswählen

        self.columns = defaultdict(dict)
        for (a, b, c, *d) in col_list:
            self.columns[a][b][c] = d
        return self.columns

Code: Alles auswählen

Traceback (most recent call last):
  File "C:/Users/colling/Documents/PyCharm/Dateiimport/MAIN.py", line 61, in <module>
    imp.main()
  File "C:/Users/colling/Documents/PyCharm/Dateiimport/MAIN.py", line 41, in main
    IGM.IGM_IMPORT(sheet_name, self.INPUT_FILE, output_igm_path)
  File "C:\Users\colling\Documents\PyCharm\Dateiimport\IGM.py", line 30, in __init__
    self.import_IGM_FILE()
  File "C:\Users\colling\Documents\PyCharm\Dateiimport\IGM.py", line 49, in import_IGM_FILE
    self.columns[a][b][c] = d
KeyError: ''

Code: Alles auswählen

{
" :{ " :{'Laufende \nNummer': ['', 101, 102, 103, 104], '' :{'Positionstext Rechnungslegung': ['', Mustertext, '', '', '']},
" :{ 'Adresse' :{'Name': ['', Gebers, '', '', ''], 'Straße': ['', Hansastraße, '', '', ''], 'Ort': ['', Irgendwo, '', '', ''], 'PLZ': ['', 1234, '', '', '']}
}