GrapeCity.Documents.Excel.ITableRow

ITableRow Interface

Represents a row in an ITable.

An ITableRow object is a member of the ITableRows collection and corresponds to a single data row in a table. You can use it to access the row index, obtain the row range, or delete the row from the table.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ITableRow

Public Interface ITableRow

Examples

worksheet.Range["A1:B3"].Value = new object[,] {{"Name", "Value"}, {"A", 1}, {"B", 2}};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ITableRow tableRow = table.Rows[0];
IRange range = tableRow.Range;

Properties

Name	Description
Index	Gets the index of this ITableRow within the ITableRows collection. Use this property to determine the position of a data row in the table's row collection.
Range	Gets the IRange object that represents the range occupied by this table row. The returned range corresponds to the cells occupied by the current data row within its parent ITable.

Name

Description

Index

Gets the index of this ITableRow within the ITableRows collection.

Use this property to determine the position of a data row in the table's row collection.

Range

Gets the IRange object that represents the range occupied by this table row.

The returned range corresponds to the cells occupied by the current data row within its parent ITable.

Methods

Name	Description
Delete()	Deletes the cells in this table row and shifts the cells below the deleted row upward. Use this method to remove a data row from a ITable. The deleted row is removed from the table's data rows, and the remaining cells below it are shifted up.

Name

Description

Delete()

Deletes the cells in this table row and shifts the cells below the deleted row upward.

Use this method to remove a data row from a ITable. The deleted row is removed from the table's data rows, and the remaining cells below it are shifted up.