Version 20.1 (latest)

Workbook Class Methods

For a list of all members of this type, see Workbook members.

Public Methods
 NameDescription
Public MethodCharacterWidth256thsToPixelsConverts units of 1/256s of the average character width to pixels.  
Public MethodClearConnectionDataClears all external data connections from the Workbook.  
Public MethodClearPivotTableDataClears all pivot tables and associated slicers from the Workbook.  
Public MethodClearVbaDataClears all vba information from the Workbook.  
Public MethodCreateNewWorkbookFontFactory method which creates new workbook font.  
Public MethodCreateNewWorksheetCellFormatCreates new worksheet cell format.  
Public Methodstatic (Shared in Visual Basic)GetMaxColumnCountReturns the number of columns that are supported by the specified format.  
Public Methodstatic (Shared in Visual Basic)GetMaxRowCountReturns the number of rows that are supported by the specified format.  
Public MethodGetTableGets the table with the specified name.  
Public Methodstatic (Shared in Visual Basic)GetWorkbookFormatReturns the WorkbookFormat based on the file extension of the specified file.  
Public MethodIsValidFunctionNameGets a value indicating whether the specified function will be recognized and solved by Microsoft Excel when the workbook is saved out.  
Public Methodstatic (Shared in Visual Basic)IsWorkbookEncryptedDetermines whether the workbook in the specified stream is encrypted with an open password.  
Public Methodstatic (Shared in Visual Basic)LoadReads a workbook from a stream.  
Public MethodPixelsToCharacterWidth256thsConverts pixels to units of 1/256s of the average character width.  
Public MethodProtectProtects the Workbook without a password.  
Public MethodRecalculateOverloaded. Recalculates all dirty formulas pending a calculation on the workbook.  
Public MethodRegisterUserDefinedFunctionRegisters a single Infragistics.Documents.Excel.CalcEngine.ExcelCalcFunction instance.  
Public MethodRegisterUserDefinedFunctionLibraryRegisters an assembly containing Infragistics.Documents.Excel.CalcEngine.ExcelCalcFunction derived types.  
Public MethodResumeCalculationsResumes the calculation of formulas.  
Public MethodSaveOverloaded. Writes the workbook to a stream.  
Public MethodSetCurrentFormatSets the current format of the workbook.  
Public MethodSuspendCalculationsTemporarily suspends the calculation of formulas.  
Public MethodUnprotectRemoves the Workbook protection.  
See Also