NativeExcel suite v2.x

AfterDetail event

Occurs after the all rows of dataset are saved into the Excel.

Description

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

Syntax

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

Example

This example puts the line between rows in the detail area.
procedure TForm1.Dataset2Excel1AfterDetail(Sender: TObject;
  Range: IXLSRange);
begin
  Range.Borders[xlInsideHorizontal].LineStyle := xlContinuous;
end;
Copyright © NikaSoft 2004-2012