''' from Basics import openExcel, openWorkbook, saveCopy, closeExcel xl = openExcel() wb = openWorkbook("../files/testWorkbook.xlsx", xl) def insertSheetAt(position, name, workbook): """Position can be an integer (position of the sheet), or its name (String). name is the name of the new sheet (DUH).""" #Selecting the position, the sheet will be inserted #one step before. workbook.Sheets(position).Select() #Inserting a blank sheet. new_ws = wb.Worksheets.Add() #Renaming. new_ws.Name = name insertSheetAt(2, "firstNewSheet", wb) insertSheetAt("lol", "SecondNewSheet", wb) saveCopy("../files/testWorkbookInsertNewSheetResult.xlsx", wb) closeExcel(xl) #Voila. #At first you add 3 sheets : "toto", "titi", "lol" #After the execution you then have #"toto", "firstNewSheet", "titi", "SecondNewSheet", "lol"
''' Created on 26 avr. 2013 @author: Alexis Thongvan The purpose of this code is to copy one of the workbook's sheet and rename it ''' from Basics import openExcel, openWorkbook, saveCopy, closeExcel xl = openExcel() wb = openWorkbook("../files/testWorkbook.xlsx", xl) def copySheet(source_sheet, new_name, wb): """Copy a sheet, source_sheet must be the name in a String, you cannot use an integer""" ws = wb.Sheets(source_sheet) ws.Copy(Before=wb.Sheets(source_sheet)) ws = wb.Sheets(source_sheet + " (2)") ws.Name = new_name copySheet("lol", "BOOOM", wb) saveCopy("../files/testWorkbookCopySheetResult.xlsx", wb) closeExcel(xl) #The "lol" has been duplicated and rename "BOOOM" #Before : "toto", "titi", "lol" #After : "toto", "titi", "BOOOM", "lol"
''' Created on 26 avr. 2013 @author: Alexis Thongvan Some sheets can be hidden, masked, to display them right clic on any sheet name in excel and choose display. then select one of the hidden sheets. Our testWorkbook.xls contains 2 hidden sheet : Hidden1 and data ''' from Basics import openExcel, openWorkbook, saveCopy, closeExcel xl = openExcel() wb = openWorkbook("../files/testWorkbook.xlsx", xl) def displayHiddenSheet(sheet_name, wb): wb.Sheets(sheet_name).Visible = True displayHiddenSheet("Hidden1", wb) saveCopy("../files/testWorkbookDisplayHiddenSheetResult.xlsx", wb) closeExcel(xl) #As you can see the hidden sheet is now selectable and visible #Before : "toto", "titi", "lol" #After : "toto", "titi", "lol", "Hidden1"