Workbook Methods

The Workbook type exposes the following members.

Methods
  NameDescription
Public methodAcceptAllRevisions
Accepts all tracked changes in the workbook.
Public methodAddDigitalSignature
Adds digital signature to an OOXML spreadsheet file (Excel2007 and later).
Public methodCalculateFormula
Calculates the result of formulas.
Public methodCalculateFormula(Boolean)
Calculates the result of formulas.
Public methodCalculateFormula(CalculationOptions)
Calcualting formulas in this workbook.
Public methodCalculateFormula(Boolean, ICustomFunction)
Calculates the result of formulas.
Public methodChangePalette
Changes the palette for the spreadsheet in the specified index.
Public methodCombine
Combines another Workbook object.
Public methodCopy
Copies data from a source Workbook object.
Public methodCopyTheme
Copies the theme from another workbook.
Public methodCreateBuiltinStyle
Creates built-in style by given type.
Public methodCreateCellsColor
Creates a CellsColor object.
Public methodCreateStyle
Creates a new style.
Public methodCustomTheme
Customs the theme.
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodExportXml
Export XML data.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetDigitalSignature
Gets digital signature from file.
Public methodGetFonts
Gets all fonts in the style pool.
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetMatchingColor
Find best matching Color in current palette.
Public methodGetNamedStyle
Gets the named style in the style pool.
Public methodGetStyleInPool
Gets the style in the style pool. All styles in the workbook will be gathered into a pool. There is only a simple reference index in the cells.
Public methodGetThemeColor
Gets theme color.
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodHasExernalLinks
Indicates whether this workbook contains external links to other data sources.
Public methodImportXml
Imports an xml file into the workbook.
Public methodIsColorInPalette
Checks if a color is in the palette for the spreadsheet.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodProtect
Protects a workbook.
Public methodProtectSharedWorkbook
Protects a shared workbook.
Public methodRemoveDigitalSignature
Removes digital signature from this spreadsheet.
Public methodRemoveExternalLinks
Removes all external links in the workbook.
Public methodRemoveMacro
Removes VBA/macro from this spreadsheet.
Public methodRemoveUnusedStyles
Remove all unused styles.
Public methodReplace(Boolean, Object)
Replaces cells' values with new data.
Public methodReplace(Int32, Object)
Replaces cells' values with new data.
Public methodCode exampleReplace(String, DataTable)
Replaces cells' values with data from a DataTable.
Public methodCode exampleReplace(String, Double)
Replaces a cell's value with a new double.
Public methodCode exampleReplace(String, Int32)
Replaces a cell's value with a new integer.
Public methodCode exampleReplace(String, String)
Replaces a cell's value with a new string.
Public methodCode exampleReplace(String, Double, Boolean)
Replaces cells' values with a double array.
Public methodCode exampleReplace(String, Int32, Boolean)
Replaces cells' values with an integer array.
Public methodReplace(String, String, ReplaceOptions)
Replaces a cell's value with a new string.
Public methodCode exampleReplace(String, String, Boolean)
Replaces a cell's value with a new string array.
Public methodSave(String)
Save the workbook to the disk.
Public methodSave(Stream, SaveFormat)
Saves the workbook to the stream.
Public methodSave(Stream, SaveOptions)
Saves the workbook to the stream.
Public methodSave(String, SaveFormat)
Saves the workbook to the disk.
Public methodSave(String, SaveOptions)
Saves the workbook to the disk.
Public methodSave(HttpResponse, String, ContentDisposition, SaveOptions)
Creates the result spreadsheet and transfer it to the client then open it in the browser or MS Workbook.
Public methodSaveToStream
Saves Excel file to a MemoryStream object and returns it.
Public methodSetDigitalSignature
Sets digital signature to an spreadsheet file (Excel2007 and later).
Public methodSetEncryptionOptions
Set Encryption Options.
Public methodSetThemeColor
Sets the theme color
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUnprotect
Unprotects a workbook.
Public methodUnprotectSharedWorkbook
Unprotects a shared workbook.
Public methodUpdateLinkedDataSource
If this workbook contains external links to other data source, Aspose.Cells will attempt to retrieve the latest data.
See Also