Public Constructors Public Fields Public Properties Public Methods Public Events
Public Methods
Public Properties
Gets or sets the value which indicates how a formula will be recalculated when a referenced value changes. Syntax Property Value The value which indicates how a formula will be recalculated when a referenced value changes. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The assi...
Gets or sets the value which indicates the way cells in the workbook are referenced. Syntax Property Value The value which indicates the way cells in the workbook are referenced. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The assigned value is not defined in the CellReferen...
Converts units of 1/256s of the average character width to pixels. Syntax Parameters characterWidth256ths The number of units of 1/256s of the average character width. Return Value The number of pixels equivalent to the characterWidth256ths value. Remarks The units of 1/256s of the average character width are base...
Clears all external data connections from the Workbook. Syntax
Clears all pivot tables and associated slicers from the Workbook. Syntax
Factory method which creates new workbook font. Syntax Return Value The created excel font object. Remarks IWorkbookFont describes font used in excel workbook. If many parts of excel workbook have same and complex (more than one property in common) font formatting, use this method in following manner: Create new f...
Creates new worksheet cell format. Syntax Return Value The cell format which was created. Remarks IWorksheetCellFormat describes cell specific formatting (font, number format, appearance etc.). Total number of different cell formats in excel workbook is limited to MaxExcelCellFormatCount. If many parts of excel wo...