Hi Adrian
I can find a rename method on TSheetNameList but no exposure on the ExcelFile or Workbook - is this possible or could it be added to a future version?
Thanks, Bob
To rename a sheet just set the activesheet to the sheet you want to rename and then change the sheetname.
xls.ActiveSheetByName := 'sheet1';
xls.SheetName := 'potato';