HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

AfterRows event

Occurs after all rows of dataset are saved into Worksheet.

Description

You can use this event to apply additional formatting to the detail area.

Syntax

TAfterRows = procedure (Sender: TObject; Range: IXLSRange) of object;
Sender TObject. Specifies the TDataToXLS component that triggered the event.
Range IXLSRange. Represents a range which contains the whole detail area.

Example

This example puts the line between rows in the detail area.

procedure TForm1.DataToXLS1AfterRows(Sender: TObject;
  Range: IXLSRange);
begin
  Range.Borders[xlInsideHorizontal].LineStyle := xlContinuous;
end;
Copyright©2014 loslab.com