Version

CellsInTable Property

Gets or sets the region of cells in the data table.
Syntax
'Declaration
 
Public Property CellsInTable As WorksheetRegion
public WorksheetRegion CellsInTable {get; set;}

Property Value

The region of cells in the data table.
Exceptions
ExceptionDescription
System.ArgumentNullException The value assigned is null.
System.InvalidOperationException The value is assigned after the data table has been removed from the worksheet.
System.ArgumentException The value assigned is a region from a worksheet other than the data table's worksheet.
System.InvalidOperationException The region specified contains the RowInputCell or the ColumnInputCell.
System.InvalidOperationException One or more of the interior cells of the value assigned (all cells except the left-most column and top row) is an interior cell of another data table or is a cell in an array formula, and the entire range of that other entity extends outside the interior cells of the value assigned.
System.ArgumentException The assigned value is only one row tall or one column wide. The cells in the table must be at least two rows by two columns.
System.InvalidOperationException The assigned value contains merged regions which are not confined to the left-most column or top row. No merged regions can exist in the interior cells of the data table and no merged regions can exist in the left-most column or top row and extend outside the data table region.
Remarks

Any interior cells (cells not in the left-most column or top row) in this region will have their values removed when this is set. If any interior cells have array formulas with a region that crosses outside the data table, an error will occur. However, if the array formula's region is confined to cells in the interior of the data table, the array formula will have ClearCellRange called on it, which will remove it from all its cells. Similarly, if an existing data table's interior cells contain some of the interior cells in this region as well as some external cells, an error will occur. However, if all interior cells of the existing data table are contained in the interior cells of the new region specified here, the existing data table will be removed from the worksheet.

After the cells in the table have been specified, the interior cells' values cannot be modified.

Note: The RowInputCell and ColumnInputCell cannot be with the region.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, 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

See Also