Add method - HotXLS Geliştirici Başvurusu

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

Sözdizimi

function Add: TXLSWorksheet;

function Add(Before, After: TXLSWorksheet; Count: Integer; Type_: OleVariant): TXLSWorksheet;

function Add(Before, After: TXLSWorksheet; Count: Integer): TXLSWorksheet;

function Add(Before, After: TXLSWorksheet): TXLSWorksheet;

Before	TXLSWorksheet İsteğe bağlı. Yeni sayfadan önce gelecek sayfayı belirten bir nesne
After	TXLSWorksheet İsteğe bağlı. Yeni sayfadan sonra gelecek sayfayı belirten bir nesne. Varsayılan değer son çalışma sayfasıdır
Count	Integer Optional. The number of sheets to be added. The default value is one
Type_	OleVariant Optional. Belirtir the sheet type. Can be one of the following XlSheetType constants: xlWorksheet, xlChart, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. The default value is xlWorksheet. This argument is ignored by this library

This example creates new Worksheet and sets the name to it

Var Worksheet: TXLSWorksheet;
begin
  Worksheet := Workbook.Sheets.Add;
  Worksheet.Name := 'New sheet';
end;

This example creates new Worksheet after second Worksheet