Public Properties Public Methods Public Operators
Public Methods
Public Properties
Applies a formula to the cell. Syntax Parameters value The formula to parse and apply to the cell. Exceptions Exception Description System.ArgumentNullException value is null or empty. FormulaParseException value is not a valid formula. System.InvalidOperationException The cell is part of an array formula or data ...
Gets the data table to which the cell belongs. Syntax Property Value The data table to which the cell belongs or null if the cell does not belong to a data table. Remarks The cells in the left-most column and top-most row of the data table will return null for the associated data table. If a data table is associat...
Gets the merged cells region which contains the cell, or null if the cell is not merged. Syntax Property Value The merged cells region which contains the cell, or null if the cell is not merged. Remarks Note: it is slightly faster to use the WorksheetRow.GetCellAssociatedMergedCellsRegion method, which does not cr...
Gets the WorksheetTable to which this cell belongs. Syntax Remarks A cell belongs to a table if it exists in any area of the table. It can be a header cell, total cell, or a cell in the data area. Note: it is slightly faster to use the WorksheetRow.GetCellAssociatedTable method, which does not create a WorksheetCe...
Gets the cell formatting for this cell. Syntax Property Value The cell formatting for this cell. Remarks Use this property to set cell formatting specific to the cell. If you will be applying the format to numerous cells, see the CreateNewWorksheetCellFormat method for performance considerations. If this cell belo...
Gets the column index of the cell. Syntax Property Value The column index of the cell.
Gets or sets the comment applied to the cell. Syntax Property Value The comment applied to the cell. Exceptions Exception Description System.InvalidOperationException The value applied only has only one anchor cell set. It should have both or neither anchor cells set. System.InvalidOperationException The value has...