GrapeCity.Windows.SpreadSheet.Data Namespace : Workbook Class |
The following tables list the members exposed by Workbook.
Name | Description | |
---|---|---|
Workbook Constructor | Overloaded. |
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. |
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 stream. | |
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 and start and end location, and whether to search notes and tags as well. | |
SetCustomName | Overloaded. Adds a custom name to the name collection. | |
SuspendCalcService | Suspends the calculation service. | |
SuspendEvent | Suspends the event. |
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. |