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

AfterRows event

Occurs after all rows of DBGrid are saved into the Worksheet.

Description

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

Syntax

TDBGridAfterRows = procedure (Sender: TObject; Range: IXLSRange) of object;
Sender TObject. Specifies the TGridToXLS 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.GridToXLS1AfterRows(Sender: TObject;
  Range: IXLSRange);
begin
  Range.Borders[xlInsideHorizontal].LineStyle := xlContinuous;
end;
Copyright©2014 loslab.com