HotXLS-documentatie
Startpagina Inhoud Overzicht

AddAfter methode

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

Syntaxis

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

Voorbeeld

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

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

Workbook.Sheets.AddAfter(1);