Τεκμηρίωση HotXLS

AfterTitles γεγονός

Occurs after all the column titles are saved into the Worksheet

Περιγραφή

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

Σύνταξη

TAfterTitles = procedure(Sender: TObject; Range: IXLSRange) of object;
Sender TObject. Καθορίζει the TDataToXLS component that triggered the event
Range IXLSRange. Αντιπροσωπεύει a range which contains the whole header

Παράδειγμα

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;