HotXLS Docs

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;