Version

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)IsWorkbookEncryptedOverloaded. Determines whether the workbook at the specified path is encrypted with an open password.  
Public Methodstatic (Shared in Visual Basic)LoadOverloaded. Reads a workbook from a file.  
Public MethodPixelsToCharacterWidth256thsConverts pixels to units of 1/256s of the average character width.  
Public MethodProtectOverloaded. Protects the worksheet with the specified password.  
Public MethodRecalculateOverloaded. Recalculates all dirty formulas pending a calculation on the workbook.  
Public MethodRecalculateAsyncRecalculates all formulas 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 file.  
Public MethodSetCurrentFormatSets the current format of the workbook.  
Public MethodSetEncryptionModeSets the encryption modes to use to encrypt documents saved in the 2007 file formats and later.  
Public MethodSetFileWriteProtectionPasswordOverloaded. Sets the password used to protect the file from automatic writes.  
Public MethodSetOpenPasswordOverloaded. Sets the password used to encrypt the document on subsequent saves.  
Public MethodSuspendCalculationsTemporarily suspends the calculation of formulas.  
Public MethodUnprotectOverloaded. Attempts to use the specified password to remove the Worksheet protection currently in place.  
Public MethodValidateFileWriteProtectionPasswordOverloaded. Validates the password for a Workbook loaded with file write protection. and returns the value indicating whether the protection was successfully disabled.  
See Also