Returns a collection to which conditions can be added to control the visual attributes of a WorksheetCell based on user-defined criteria. Syntax
Gets the collection of data tables in the worksheet. Syntax Property Value The collection of data tables in the worksheet.
Gets the collection of data validation rules applied to cells in the Worksheet. Syntax
Gets or sets the default column width including padding, in 256ths of the 0 digit character width in the workbooks default font. Syntax Property Value The default column width including padding, in 256ths of the 0 digit character width in the workbooks default font. Remarks The default column width is the width of...
Gets or sets the default row height in twips (1/20th of a point). Syntax Property Value The default row height in twips (1/20th of a point). Exceptions Exception Description System.ArgumentOutOfRangeException The value assigned is outside the value range of -1 and 8192. Remarks The default row height is the height...
Deletes a region of cells. Syntax Parameters address The address of the region to deleteshiftCellsLeft If true will shift cells left from the right of the region to occupy the deleted region, otherwise will shift cells up from below the region. Exceptions Exception Description System.InvalidOperationException If t...
Deletes a region of cells. Syntax Parameters region The region to deleteshiftCellsLeft If true will shift cells left from the right of the region to occupy the deleted region, otherwise will shift cells up from below the region. Exceptions Exception Description System.InvalidOperationException If the operation is ...
Deletes a region of cells. Overload List
Gets the object which controls the display of the worksheet. Syntax Property Value The object which controls the display of the worksheet. Remarks The display options include any settings which affect the display of the worksheet when viewed in Microsoft Excel. These settings will not affect the printed worksheet ...
Exposes methods to identify a region in the worksheet and to apply filters and optionally sort criteria to that region. Syntax