The following tables list the members exposed by Workbook.
Public Constructors
| Name | Description | |
|---|---|---|
 | Workbook Constructor | Overloaded. |
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveSheet | Gets or sets the active sheet in the component. |
| ActiveSheetIndex | Gets or sets the index of the active sheet in the component. |
| AutoRecalculation | Gets or sets a value that indicates whether to automatically recalculate. |
| AutoRefresh | Gets or sets whether the sheet can auto-refresh itself. |
| BackgroundCalculation | Gets or sets whether to calculate the formulas in the background thread to reduce the time for opening an excel file. |
| CanCellOverflow | Gets or sets whether data can overflow into adjacent empty cells in the component. |
| CurrentTheme | Gets or sets the current theme for the workbook. |
| CurrentThemeName | Gets or sets the current theme information for the workbook. |
| CustomFunctions | Gets the custom functions. |
| CustomNames | Gets the custom names. |
| GridLineColor | Gets or sets the color of the gridline. |
| HorizontalScrollBarVisibility | Gets or sets the horizontal scroll bar visibility. |
| Item | Overloaded. Gets the worksheet at the specified index. |
| LoadExcelOnDemand | Gets or sets whether to load data on demand to reduce the time for opening an excel file. |
| Name | Gets or sets the name of the workbook. |
| NamedStyles | Gets or sets a collection of StyleInfo objects for this sheet. |
| Protect | Gets or sets whether this workbook is protected. |
| ReferenceStyle | Gets or sets the style for cell and range references in cell formulas on this sheet. |
| SheetCount | Gets or sets the number of sheets for this workbook. |
| Sheets | Gets a collection of Worksheet objects for this workbook. |
| ShowDragDropTip | Gets or sets a value that indicates whether to show the drag drop tip. |
| ShowDragFillTip | Gets or sets a value that indicates whether to show the drag fill tip. |
| ShowGridLine | Gets or sets a value that indicates whether to show the gridline. |
| ShowResizeTip | Gets or sets whether to display a resize tip. |
| ShowScrollTip | Gets or sets whether to display a scroll tip. |
| StartSheetIndex | Gets or sets the index of the start sheet of the Workbook |
| Themes | Gets themes for the workbook. |
| VerticalScrollBarVisibility | Gets or sets the vertical scroll bar visibility. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddCustomFunction | Adds the custom function on this sheet. |
| ClearCustomFunctions | Removes all user-defined custom functions (FunctionInfo object) on this sheet. |
| ClearCustomName | Clears the specified name on this sheet. |
| ClearCustomNames | Removes all custom names on this sheet. |
| Clone | Creates a new object that is a copy of the current instance. |
 | CopyTo | Copies data from one range to another. |
| FindTable | Gets the table with a specified name. |
| GetCustomFunction | Gets the custom function based on the function name. |
| GetCustomName | Gets the custom name based on the name. |
| GetThemeColor | Gets the color with a specified theme name. |
| GetThemeFont | Gets the font family with a specified theme name. |
| MoveTo | Moves data from one range to another. |
| OpenExcel | Overloaded. Opens an Excel Compound Document File and loads it into GcSpreadSheet. |
| OpenXml | Overloaded. Loads the data on the sheet from the specified XML stream. |
| Recalculate | Overloaded. Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle. |
| RemoveCustomFunctions | Removes the specified custom function on this sheet. |
| Reset | Resets the workbook to its default settings. |
| ResetThemes | Reset the changed theme color and font name. |
| ResumeCalcService | Resumes the calculation service. |
| ResumeEvent | Resumes the event. |
| SaveExcel | Saves the control to an Excel Compound Document File stream. |
| SavePdf | Overloaded. Saves the content of the GcSpreadSheet component to the specified PDF file. |
| SaveXml | Overloaded. Saves the data on the sheet to the specified XML stream. |
| Search | Overloaded. Searches the text in the cells in the specified sheet for the specified string with the specified criteria. |
| SetCustomName | Overloaded. Adds a custom name to the name collection. |
| SuspendCalcService | Suspends the calculation service. |
| SuspendEvent | Suspends the event. |
Public Events
| Name | Description | |
|---|---|---|
 | DataCalculated | Occurs when all formulas are calculated. |
| ExcelError | Occurs when an error happens while loading or saving Excel-formatted files. |
| PropertyChanged | Occurs when a property value changes. |
See Also