# -*- coding: iso-8859-1 -*- #. // _ex_WorkSheetAddAtEnd.py #. // Ajoute une feuille à la fin du classeur. def ex_WorkSheetAddAtEnd( oBook, cName = None ): oBook.Worksheets.Add( None, oBook.Worksheets( oBook.Worksheets.Count ) ) oSheet = oBook.Worksheets( oBook.Worksheets.Count ) if not cName is None: oSheet.Name = cName #. endif return oSheet ''' Dernière modification : 2022-02-10 [Exemple] import sys sys.path.append( "modules" ) from _ex_ExcelNew import ex_ExcelNew # // Ouvre Excel. from _ex_WorkSheetAddAtEnd import ex_WorkSheetAddAtEnd # // Ajoute une feuille à la fin du classeur. oExcel = ex_ExcelNew() oBook = oExcel.Workbooks.Add() oSheet = ex_WorkSheetAddAtEnd( oBook, "Test1" ) oExcel.DisplayAlerts = False oExcel = None [/Exemple] '''