HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

AddAfter method

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

Syntax

function AddAfter(Index: Integer): IXLSWorksheet;
function AddAfter(Name: WideString): IXLSWorksheet;
function AddAfter(Worksheet: IXLSWorksheet): IXLSWorksheet;
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 IXLSWorksheet. An object that specifies the sheet after which the new sheet is added.

Example

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

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

Workbook.Sheets.AddAfter(1);
Copyright©2007-2019 loslab.com