Name | Description | |
---|---|---|
Workbook Constructor | Overloaded. |
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. | |
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. |