HotXLS-dokumentaatio

AfterNewSheet tapahtuma

Occurs after the new Worksheet is added into the Workbook

Kuvaus

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

Syntaksi

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

Esimerkki

This example sets the PageSetup options for created Worksheet

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