TdxSpreadSheetTableView.Rows Property

Provides access to the Table View worksheet’s row collection.

Declaration

property Rows: TdxSpreadSheetTableRows read;

Property Value

Type
TdxSpreadSheetTableRows

Remarks

Use this property to manage and customize row objects in the current Table View worksheet.

The following code example demonstrates how to use the Rows property to customize the row’s appearance:

Delphi

//...
var
  ATableView: TdxSpreadSheetTableView;
  ARow: TdxSpreadSheetTableRow;
//...
  ATableView := TdxSpreadSheetTableView(dxSpreadSheet1.ActiveSheet);
  if(ATableView.Rows[2] = nil) then
    begin
      ATableView.Rows.CreateItem(2);
// Creating the row object for individual customization
    end;
// An indexed access to the third row in a Table View
  ARow := ATableView.Rows[2];
  ARow.Style.Borders[bTop].Color := clBlue;
  ARow.Style.Borders[bTop].Style := sscbsMediumDashDotDot;
  ARow.Style.Borders[bBottom].Color := clBlue;
  ARow.Style.Borders[bBottom].Style := sscbsMediumDashDotDot;
  ARow.Style.Brush.Style := sscfsRevDiagonalStrip;
  ARow.Style.Brush.BackgroundColor := clHotLight;
  ARow.Style.Brush.ForegroundColor := clSkyBlue;

C++

//...
  TdxSpreadSheetTableView* ATableView;
  TdxSpreadSheetTableRow* ARow;
//...
  ATableView = static_cast<TdxSpreadSheetTableView*>(dxSpreadSheet1->ActiveSheet);
  if(ATableView->Rows->Items[2] == NULL)
  {
// Creating the row object for individual customization
    ATableView->Rows->CreateItem(2);
  }
// An indexed access to the third row in a Table View
  ARow = ATableView->Rows->Items[2];
  ARow->Style->Borders[bTop]->Color = clBlue;
  ARow->Style->Borders[bTop]->Style = sscbsMediumDashDotDot;
  ARow->Style->Borders[bBottom]->Color = clBlue;
  ARow->Style->Borders[bBottom]->Style = sscbsMediumDashDotDot;
  ARow->Style->Brush->Style = sscfsRevDiagonalStrip;
  ARow->Style->Brush->BackgroundColor = clHotLight;
  ARow->Style->Brush->ForegroundColor = clSkyBlue;

For additional information, refer to the Table Item Appearance Customization Level topic.