HotXLS-dokumentation

AfterRow händelse

Occurs after the specified by RowIndex record is saved into the Worksheet

Beskrivning

Du kan använda den här händelsen för att tillämpa villkorsstyrd formatering på hela raden i detaljområdet

Syntax

TDBGridAfterRow = procedure (Sender: TObject; Range: IXLSRange; RowIndex: Integer) of object;
Sender TObject. Anger the TGridToXLS component that triggered the event
Range IXLSRange. Representerar a range which contains the exported row
RowIndex Integer. The index of the row which is exported

Exempel

This example sets the interior color for odd rows to aqua

procedure TForm1.GridToXLS1AfterRow(Sender: TObject;
  Range: IXLSRange; RowIndex: Integer);
begin
  if Odd(RowIndex) then Range.Interior.Color := ColorToRGB(clAqua);
end;