HotXLS-dokumentation

AfterNewSheet hændelse

Occurs after the new Worksheet is added into the Workbook

Beskrivelse

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

Syntaks

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

Eksempel

This example sets the PageSetup options for created Worksheet

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