Dokumentacija HotXLS

AfterNewSheet događaj

Occurs after the new Worksheet is added into the Workbook

Opis

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

Sintaksa

TAfterNewSheet = procedure(Sender: TObject; Worksheet: TXLSWorksheet) of object;
Sender TObject. Određuje the TDataToXLS component that triggered the event
Worksheet TXLSWorksheet which represents a new Worksheet

Primjer

This example sets the PageSetup options for created Worksheet

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