Spread WPF Documentation
ExcelWorkbook Class Members
Properties  Methods 


GrapeCity.Excel Namespace : ExcelWorkbook Class

The following tables list the members exposed by ExcelWorkbook.

Public Constructors
 NameDescription
Public ConstructorExcelWorkbook Constructor  
Top
Public Properties
 NameDescription
Public PropertyActivePaneIndexGets or sets the index of the active pane.  
Public PropertyActiveSheetIndexGets or sets the index of the active sheet.  
Public PropertyBuiltInNameListGets or sets the built-in names used in the workbook  
Public PropertyCalculationModeGets or sets the calculation mode of the workbook  
Public PropertyColorPaletteRepresents the custom color palette used in workbook.  
Public PropertyCustomOrFunctionNameListGets or sets the custom or function names used in the workbook.  
Public PropertyDefaultCellFormatGets or sets the default cell format of the workbook..  
Public PropertyDefaultPivotTableStyleNameGet or set the name of the default table style to apply to new PivotTables.  
Public PropertyDefaultTableStyleNameGet or set the name of the default table style to apply to new tables.  
Public PropertyDifferentialFormattingsGets or sets the differential formatting settings of the workbook.  
Public PropertyExcelCellFormatsGets or sets the excel cell formats used in the workbook.  
Public PropertyExcelRectGets or sets the excel rect used to represents the workbook window.  
Public PropertyExcelStylesGets the excel styles used in the workbook.  
Public PropertyExternWorkbooksGets or sets the extern workbook information used in the workbook  
Public PropertyFirstDisplayedTabIndexGets or sets the first index of the displayed tab.  
Public PropertyHorizontalScrollBarPolicyGets or sets the horizontal scroll bar policy.  
Public PropertyIs1904DateGets or sets a value indicating whether the workbook use 1904 date system.  
Public PropertyIsIterataCalculateGets or sets a value indicating whether this instance is iterate calculate.  
Public PropertyIsWindowDisplayAsIconGets or sets a value indicating whether this instance is window display as icon.  
Public PropertyIsWindowHiddenGets or sets a value indicating whether this instance is window hidden.  
Public PropertyLockedGets or sets a value indicating whether the IExcelWorkbook instance is locked.  
Public PropertyMaximumChangeGets or sets the maximum change of the workbook.  
Public PropertyMaximumIterationsGets or sets the maximum iterations of the workbook  
Public PropertyNamedCellRangesGets or sets the global named cell ranges.  
Public PropertyOperatorGets the excel operator which used to read or write information from (to) excel.  
Public PropertyPrecisionAsDisplayGets or sets a value indicating whether the value is full precision.  
Public PropertyRecalculateBeforeSaveGets or sets a value indicating whether recalculate formulas before save.  
Public PropertyReferenceStyleGets or sets the workbook reference style.  
Public PropertySaveExternalLinksGets or sets a value indicating whether save external links during save.  
Public PropertySelectedTabCountGets or sets the selected tab count.  
Public PropertyTableStylesGet the table styles used in the current workbook  
Public PropertyTabStripPolicyGets or sets the tab strip policy.  
Public PropertyTabStripRatioGets or sets the tab strip ratio.  
Public PropertyThemeRepresents the Theme used in the workbook  
Public PropertyVerticalScrollBarPolicyGets or sets the vertical scroll bar policy.  
Public PropertyWorksheetsGet an ExcelWorksheet collection that represents all the worksheets in the workbook.  
Top
Public Methods
 NameDescription
Public MethodGetPaletteColorGets the closest palette color of specified color.  
Public MethodGetThemeColorGets the color of the theme.  
Public MethodOpenOverloaded. Open an existing file.  
Public MethodSaveOverloaded. Save the workbook to stream, it will use the specified file type as the file format, the file will be encrypt if the password is not null.  
Top
See Also

Reference

ExcelWorkbook Class
GrapeCity.Excel Namespace

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page