Rename sheet using API

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';