Das deutsche Python-Forum

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)