Version

Search Results

GetCellAssociatedMergedCellsRegion Method

Gets the merged cells region which contains the cell at the specified index, or null if the cell is not merged. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow. Return Value The merged cells region which contains the cell at the specified index, or null if the cell is not merged...

GetCellAssociatedTable Method

Gets the WorksheetTable to which the cell at the specified index belongs. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow. Exceptions Exception Description System.InvalidOperationException If the row was removed from the worksheet. Remarks A cell belongs to a table if it exists ...

GetCellBoundsInTwips(Int32) Method

Gets the bounds of the cell at the specified column index in twips (1/20th of a point). Syntax Parameters columnIndex Return Value The bounds of the cell at the specified column index on its worksheet. Exceptions Exception Description System.ArgumentOutOfRangeException columnIndex is less than zero or greater than...

GetCellBoundsInTwips(Int32,PositioningOptions) Method

Gets the bounds of the cell at the specified column index in twips (1/20th of a point). Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow.options The options to use when getting the bounds of the cell. Return Value The bounds of the cell at the specified column index on its worksh...

GetCellBoundsInTwips Method

Gets the bounds of the cell at the specified column index in twips (1/20th of a point). Overload List

GetCellComment Method

Gets or sets the comment applied to the cell at the specified column index. Syntax Parameters columnIndex Return Value The comment applied to the cell. Exceptions Exception Description System.ArgumentOutOfRangeException columnIndex is less than zero or greater than or equal to the number of columns in the workshee...

GetCellConditionalFormat Method (WorksheetRow)

Gets the cell conditional format for the cell at the specified column index. Syntax Parameters 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 re...

GetCellFormat Method

Gets the cell formatting for the cell at the specified column index. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow. Return Value The cell formatting for the cell at the specified column index. Exceptions Exception Description System.ArgumentOutOfRangeException columnIndex is l...

GetCellFormula Method

Gets the formula which has been applied to the cell at the specified column index. Syntax Parameters columnIndex Return Value The formula which has been applied to the cell or null if no formula has been applied. Exceptions Exception Description System.ArgumentOutOfRangeException columnIndex is less than zero or g...

GetCellHyperlink Method

Gets the effective hyperlink on the cell at the specified index. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow. Remarks If multiple hyperlinks are applied to the cell, the last one in the Worksheet.Hyperlinks collection will be used. If the cell has one or more hyperlinks in t...