Syncfusion.XlsIO.Base
Properties  Methods  Events

Syncfusion.XlsIO Namespace : IWorkbook Interface

IWorkbook Interface Members

The following tables list the members exposed by IWorkbook.

Public Properties
 NameDescription
 Property Gets an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only.  
 Property Gets or sets index of the active sheet.  
 Property Gets collection of all workbook's add-in functions. Read-only.  
 Property Indicates whether to allow usage of 3D ranges in DataValidation list property (MS Excel doesn't allow).  
 Property Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets the formula arguments separator.  
 Property Gets or sets the author of the comment.  
 Property Gets collection that represents all the built-in document properties for the specified workbook. Read-only.  
 Property Gets calculation options. Read-only.  
 Property Gets the collection of the chart objects.  
 Property Name which is used by macros to access the workbook items.  
 Property Gets the connection. Read Only.  
 Property Gets a MetaProperties collection that describes the meta data stored in the workbook. Read-only.  
 Property Gets collection that represents all the custom document properties for the specified workbook. Read-only.  
 Property Gets collection that represents all the Custom Xml parts for the specified workbook. Read-only.  
 Property True if the workbook uses the 1904 date system.  
 Property Indicates whether detect string value passed to Value (and Value2) property as DateTime. Default value is true.  
 Property Disables loading of macros from document.  
 Property Gets or sets index of tab which will be displayed on document open.  
 Property True if the tabs are visible. otherwise False.  
 Property Gets the name of the object, including its path on disk.  
 Property True if workbook contains VBA macros. Read-only.  
 Property True if cell is protected. Read-only.  
 Property Gets or sets a value indicating whether to display horizontal scroll bar.  
 Property Indicates whether worksheet is displayed right to left.  
 Property Gets or sets a value indicating whether to display vertical scroll bar.  
 Property True if window is protected. Read-only.  
 Property Gets maximum column count for each worksheet in the workbook. Read-only.  
 Property Gets maximum row count for each worksheet in the workbook. Read-only.  
 Property Gets Names collection.  
 Property Get Palette colors.  
 Property Gets Palette colors.  
 Property Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets or sets password to encrypt or decrypt document.  
 Property Gets pivot caches collection. Read-only.  
 Property True if the precision to be used as displayed. Read-only.  
 Property True if the workbook has been opened as Read-only. Read-only Boolean.  
 Property True to display a message when the file is opened, recommending that the file be opened as read-only.  
 Property Gets or sets row separator for array parsing.  
 Property True if no changes have been made to the specified workbook since it was last saved. If current value is false then setting it to true cause Save() method call.  
 Property Gets or sets the name of the standard font.  
 Property Gets or sets the standard font size, in points.  
 Property Gets a Styles collection that represents all the styles in the specified workbook. Read-only.  
 Property Gets the table styles object.  
 Property Gets collection of tab sheets. Read-only.  
 Property Indicates whether exception should be thrown when unknown name was found in a formula.  
 Property Toggles string searching algorithm.Default value is true.  
 Property Gets or sets excel version.  
 Property Gets grouped worksheets. Read-only.  
 Property Gets a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.  
 Property Returns the collection of XmlMap object. Read-Only.  
Top
Public Methods
 NameDescription
 Method Activates the first window associated with the workbook.  
 Method Adds font to the inner fonts collection. Read-only.  
 Method Creates copy of the current instance.  
 MethodOverloaded.  Closes the object and saves workbook to the specified file name.If True, all changes will be saved.  
 Method Copies workbook to the clipboard.  
 Method Creates the Data sorter to sort the data.  
 MethodOverloaded.  Creates a font object based on native font.  
 Method Creates header or footer engine.  
 Method Create an instance that can be used for template markers processing.  
 MethodOverloaded.  Returns the cells with specified string value.  
 MethodOverloaded. Returns the first occurrence of the specified double value with the specified ExcelFindType.  
 MethodOverloaded.  Returns the first occurrence that ends with the specified string value which ignores the case.  
 MethodOverloaded.  Returns the first occurrence that starts with the specified string value.  
 MethodOverloaded.  Gets the nearest color with the specified Color structure from Workbook palette.  
 Method Returns Color object from predefined colors by its index.  
 MethodOverloaded.  Import XML document to the workbook.  
 Method Marks workbook as final. Read-Only.  
 MethodOverloaded.  Sets protection for workbook.  
 MethodOverloaded.  Replaces string with the specified data table value.  
 Method Recover palette to default values.  
 Method Save changes to the specified workbook.  
 MethodOverloaded.  Saves workbook with the specified file name.  
 MethodOverloaded. Saves as Html to specified file name based on ExcelSaveType.  
 MethodOverloaded. Saves workbook with the specified file name and ExcelXmlSaveType.  
 MethodOverloaded.  Sets the color or Gets nearest color.  
 Method Sets the palette color for the given index.  
 Method Sets separators for formula parsing.  
 Method Sets write protection for workbook using password.  
 MethodOverloaded.  Unprotects workbook.  
Top
Public Events
 NameDescription
 Event This event is fired after workbook is successfully saved.  
 Event This event is fired when trying to save to a Read-only file.  
Top
See Also