GetCellConditionalFormat(Int32,Int32) Method

Gets the cell conditional format for the cell at the specified row and column index.

Syntax

Visual Basic

'Declaration
 
Public Function GetCellConditionalFormat( _
   ByVal rowIndex As Integer, _
   ByVal columnIndex As Integer _
) As CellConditionalFormat

C#

public CellConditionalFormat GetCellConditionalFormat( 
   int rowIndex,
   int columnIndex
)

Parameters

rowIndex

The 0-based index of the WorksheetRow within the Rows collection.

columnIndex

The 0-based index of the cell within the WorksheetRow.

Return Value

The aggregated condition format for the cell at the specified column index or null if the cell is not contained in any conditional format region.

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	rowIndex is less than zero or greater than or equal to the number of rows in the worksheet. columnIndex is less than zero or greater than or equal to the number of columns in the worksheet.

Remarks

Note: if the cell is contained in one or more conditional format regions but doesn't match any of thse criteria an instance of Infragistics.Documents.Excel.ConditionalFormatting.CellConditionalFormat will still be returned but its Infragistics.Documents.Excel.ConditionalFormatting.CellConditionalFormat.HasConditionFormatting property will return null. However, if the sell is not contained in any conditional format region then this method will return null.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2