Documentazione HotXLS
Home Contenuti Panoramica

AddAfter metodo

Creates a new Worksheet after specified Worksheet. The new Worksheet becomes the active sheet

Sintassi

funzione AddAfter(Index: Integer): TXLSWorksheet;
funzione AddAfter(Name: WideString): TXLSWorksheet;
funzione AddAfter(Worksheet: TXLSWorksheet): TXLSWorksheet;
Index Integer. An index of Worksheet that specifies the sheet after which the new sheet is added
Name WideString. A name of Worksheet that specifies the sheet after which the new sheet is added
Worksheet TXLSWorksheet. An object that specifies the sheet after which the new sheet is added

Esempio

This example creates new Worksheet after the sheet with name 'Sheet1' 

Var Worksheet: TXLSWorksheet;
begin
  Worksheet := Workbook.Sheets.AddAfter('Sheet1');
  Worksheet.Name := 'After Sheet1';
end;
This example creates new Worksheet after first Worksheet 

Workbook.Sheets.AddAfter(1);