HotXLS Belgeleri

AfterTitles olay

Occurs after all the column titles are saved into the Worksheet

Açıklama

You can use this event to apply additional formatting to the whole header

Sözdizimi

TAfterTitles = procedure(Sender: TObject; Range: IXLSRange) of object;
Sender TObject. Belirtir the TDataToXLS component that triggered the event
Range IXLSRange. Temsil eder a range which contains the whole header

Örnek

This example puts the thick border around the header
procedure TForm1.DataToXLS1AfterTitles(Sender: TObject;
  Range: IXLSRange);
begin
  With Range.Borders do begin
     Item[xlEdgeBottom].LineStyle := xlContinuous;
     Item[xlEdgeBottom].Weight := xlThick;
     Item[xlEdgeTop].LineStyle := xlContinuous;
     Item[xlEdgeTop].Weight := xlThick;
     Item[xlEdgeLeft].LineStyle := xlContinuous;
     Item[xlEdgeLeft].Weight := xlThick;
     Item[xlEdgeRight].LineStyle := xlContinuous;
     Item[xlEdgeRight].Weight := xlThick;
  end;
end;