GrapeCity.Xaml.Excel
ExcelWorkbook Class Members
Properties  Methods 


The following tables list the members exposed by ExcelWorkbook.

Public Constructors
 NameDescription
Public ConstructorExcelWorkbook Constructor  
Top
Public Properties
 NameDescription
Public PropertyActivePaneIndex Gets or sets the index of the active pane.  
Public PropertyActiveSheetIndex Gets or sets the index of the active sheet.  
Public PropertyBuiltInNameList Gets or sets the built-in names used in the workbook  
Public PropertyCalculationMode Gets or sets the calculation mode of the workbook  
Public PropertyColorPalette Represents the custom color palette used in workbook.  
Public PropertyCustomOrFunctionNameList Gets or sets the custom or function names used in the workbook.  
Public PropertyDefaultCellFormat Gets or sets the default cell format of the workbook..  
Public PropertyDefaultPivotTableStyleName Get or set the name of the default table style to apply to new PivotTables.  
Public PropertyDefaultTableStyleName Get or set the name of the default table style to apply to new tables.  
Public PropertyDifferentialFormattings Gets or sets the differential formatting settings of the workbook.  
Public PropertyExcelCellFormats Gets or sets the excel cell formats used in the workbook.  
Public PropertyExcelRect Gets or sets the excel rect used to represents the workbook window.  
Public PropertyExcelStyles Gets the excel styles used in the workbook.  
Public PropertyExternWorkbooks Gets or sets the extern workbook information used in the workbook  
Public PropertyFirstDisplayedTabIndex Gets or sets the first index of the displayed tab.  
Public PropertyHorizontalScrollBarPolicy Gets or sets the horizontal scroll bar policy.  
Public PropertyIs1904Date Gets or sets a value indicating whether the workbook use 1904 date system.  
Public PropertyIsIterataCalculate Gets or sets a value indicating whether this instance is iterate calculate.  
Public PropertyIsWindowDisplayAsIcon Gets or sets a value indicating whether this instance is window display as icon.  
Public PropertyIsWindowHidden Gets 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 PropertyMaximumChange Gets or sets the maximum change of the workbook.  
Public PropertyMaximumIterations Gets or sets the maximum iterations of the workbook  
Public PropertyNamedCellRanges Gets or sets the global named cell ranges.  
Public PropertyOperator Gets the excel operator which used to read or write information from (to) excel.  
Public PropertyPrecisionAsDisplay Gets or sets a value indicating whether the value is full precision.  
Public PropertyRecalculateBeforeSave Gets or sets a value indicating whether recalculate formulas before save.  
Public PropertyReferenceStyle Gets or sets the workbook reference style.  
Public PropertySaveExternalLinks Gets or sets a value indicating whether save external links during save.  
Public PropertySelectedTabCount Gets or sets the selected tab count.  
Public PropertyTableStyles Get the table styles used in the current workbook  
Public PropertyTabStripPolicy Gets or sets the tab strip policy.  
Public PropertyTabStripRatio Gets or sets the tab strip ratio.  
Public PropertyTheme Represents the Theme used in the workbook  
Public PropertyVerticalScrollBarPolicy Gets 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 MethodGetPaletteColor Gets the closest palette color of specified color.  
Public MethodGetThemeColor Gets the color of the theme.  
Public MethodOpen Open the specified stream.  
Public MethodSave 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.

Support Options