Resize(String,CellReferenceMode) Method

Resizes the table to a new range of data on the worksheet.

Syntax

C#

public void Resize( 
   string headerAndDataRegionAddress,
   CellReferenceMode cellReferenceMode
)

Parameters

headerAndDataRegionAddress

The address of the new region of headers (if currently visible) and data for the table, which must contain at least one data row, and overlap and have the same top as the current table region.

cellReferenceMode

The cell reference mode to use to parse the region address.

Exceptions

Exception	Description
System.InvalidOperationException	Occurs when the WorksheetTable has previously been removed from the worksheet.
System.ArgumentNullException	Occurs when headerAndDataRegionAddress is null.
System.ArgumentException	Occurs when headerAndDataRegionAddress is not a valid name or a valid cell or region address in the workbook's cell reference mode.
System.InvalidOperationException	Occurs when headerAndDataRegionAddress is a relative R1C1 address. The overload taking an origin cell must be used to resolve relative R1C1 references.
System.ArgumentException	Occurs when the top of the headerAndDataRegionAddress does is not the same as the top of the table.
System.ArgumentException	Occurs when the headerAndDataRegionAddress does not contain at least one data row for the table.
System.ArgumentException	Occurs when the headerAndDataRegionAddress does not overlap the current table region.
System.InvalidOperationException	Occurs when the there is a merged cell, array formula, data table, or another table in the new region.

Remarks

If the totals row is visible, it will be placed below the last data row automatically. If the totals row is currently inside the new table region, it will be moved out to below the new data rows, which will be shifted up by one row.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+