Documentazione HotXLS

AfterNewSheet evento

Occurs after the new Worksheet is added into the Workbook

Descrizione

You can use this event to set any additional options for created Worksheet

Sintassi

TAfterNewSheet = procedura(Sender: TObject; Worksheet: TXLSWorksheet) of object;
Sender TObject. Specifica the TDataToXLS component that triggered the event
Worksheet TXLSWorksheet which represents a new Worksheet

Esempio

This example sets the PageSetup options for created Worksheet

procedure TForm1.DataToXLS1AfterNewSheet(Sender: TObject;
  Worksheet: TXLSWorksheet);
begin
  Worksheet.PageSetup.CenterHeader := 'Monthly report';
end;