Sets the bounds of the shape in twips (1/20th of a point). Overload List
Gets or sets the cell where the top-left corner of the shape resides. Syntax Property Value The cell where the top-left corner of the shape resides. Exceptions Exception Description System.ArgumentException The value assigned is a cell whose worksheet is not the same as this shapes worksheet. System.ArgumentNullEx...
Gets or sets the position in the TopLeftCornerCell of the shapes top-left corner, expressed in percentages. Syntax Property Value The position in the top-left corner cell of the shapes top-left corner. Exceptions Exception Description System.ArgumentOutOfRangeException Either coordinate of the value assigned is ou...
Gets or sets the value indicating whether the shape is visible on the worksheet. Syntax Property Value The value indicating whether the shape is visible on the worksheet.
Gets the worksheet on which the shape resides. Syntax Property Value The worksheet on which the shape resides.
Determines whether worksheet rows of columns are sorted within the region Syntax Members Member Description Columns Sort columns Rows Sort rows
Represents a region of cells formatted as a table. Syntax Remarks Tables assist in managing and analyzing a range of related data. This management can be done separately from the rest of the data in the worksheet. A table can have one or more columns sorted and filtered. There are various sorting and filtering cri...
Represents the various areas which can have a format applied at the table level. Syntax Members Member Description DataArea The format is applied to the data area of the table. HeaderRow The format is applied to the header row of the table. All but the top border properties can be set on this area format. Setting ...
A collection of formats for areas of a WorksheetTable. Syntax Type Parameters TArea An enumeration defining the various table areas which can contain formats.
Public Properties Public Methods