ich verzweifle bald. Ich möchte etwas ganz simples machen und schaffe es nicht , dass die bekannten Funktionen funktionieren. Thema ist oben genannt. Der Code ist bisher:
Code: Alles auswählen
def saveas_file(self):
print('SAVEAS_FILE')
#Abfrage etablieren, ob bereits etwas vorhanden ist, was gespeichert werden kann.
savedas_obj = openfile.asksaveasfile(mode='ab', **self.file_opt)
self.fname = savedas_obj.name
#Anlegen des Excel-Workbooks und Worksheets
wb = openpyxl.Workbook()
wb.create_sheet(worksheetname1)
wb.create_sheet(worksheetname2)
wb.create_sheet(worksheetname3)
wb.create_sheet(worksheetname4)
wb.create_sheet(worksheetname5)
wb.create_sheet(worksheetname6)
wb.create_sheet(worksheetname7)
wb.create_sheet(worksheetname8)
wsA = wb.get_sheet_by_name(name = worksheetname1)
wsB = wb.get_sheet_by_name(name = worksheetname2)
wsC = wb.get_sheet_by_name(name = worksheetname3)
wsD = wb.get_sheet_by_name(name = worksheetname4)
wsE = wb.get_sheet_by_name(name = worksheetname5)
wsF = wb.get_sheet_by_name(name = worksheetname6)
wsG = wb.get_sheet_by_name(name = worksheetname7)
wsH = wb.get_sheet_by_name(name = worksheetname8)
#Ausblenden Hilfs-Worksheets zur Programmsteuerung
wsB.sheet_state = 'hidden'
wsF.sheet_state = 'hidden'
wsG.sheet_state = 'hidden'
wsH.sheet_state = 'hidden'
#Löschen StandardSheet bei der Anlage der Datei
std = wb.get_sheet_by_name('Sheet')
wb.remove_sheet(std)
#Layout und Beschriftung
wsA['A1'].value = "Input1"
wsA['A2'].value = "Input2"
wsA['A3'].value = "Input3"
wsA['A4'].value = "Input4"
wsA.column_dimensions('A').width = 60
wb.save(self.fname)
TypeError: 'DimensionHolder' object is not callable