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 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. |
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. |