com.grapecity.documents.excel Package

In This Topic

Classes

Class	Description
AsyncCustomFunction	Represents the base type for async custom function.
BaseCellType	Represents the base class for the other cell type classes.
ButtonCellType	Represents a button cell.
CalcReference	Represents an area in a spreadsheet.
CancellationToken	Token that propagates notification that an operation should be cancelled. This class is thread safe.
CancellationTokenSource	A CancellationTokenSource allows you to issue cancellation requests to one or more methods.To use a token source: Create a token source. Attach the token to one or more operations by passing the return value of getToken as parameter. Later, you can cancel the associated operations by calling cancel on this token source. This class is thread safe.
CellColorSortField	Specifies the interior sort.
CellInfo	Provide some helper functions.
CellPadding	Gets or sets the cell padding.
CheckBoxCellType	Represents a check box cell.
CheckBoxListCellType	Represents a check-box-list cell type.
Color	Creates the color structure.
ComboBoxCellItem	Represents an comboBox item.
ComboBoxCellType	Represents an editable combo box cell.
CsvOpenOptions	Option class for opening csv file.
CsvParseContext	Represents the CSV parse context of the current cell.
CsvParseResult	Represents the parsed result(value and number format).
CsvSaveOptions	Option class for saving csv file.
CustomBorderStyle	Option class for customising border when saving to PDF.
CustomFunction	Represents the base type for custom function.
DataValidationJsonError	Represents the DataValidation error in the json.
DateInfo
DeserializationOptions	Represents some settings when deserialize workbook or worksheet from JSON.
DocumentProperties	Represents the document properties of pdf.
Event<T>	Represents an event.
EventArgs
FindOptions	Wraps all optional parameters of the IRange.Find function.
FontColorSortField	Represents the color sort.
FontInfo
FormulaJsonError	Represents the formula error in the json.
HyperLinkCellType	Represents the hyperlink cell.
IconSortField	Represents sorting by icon.
ImageSaveOptions	Options for exporting image file.
ImageSource	Represents the image source.
InvalidFormulaException	Specifies the invalid formula exception.
JsonError	The base class for all the json error classes..
Margin	Gets or sets the watermark margin in pixels relative to the cell.
NumberFormatParseException	Throws when unable to set the NumberFormat property of the Range class.
OpenOptionsBase	Base option class for opening.
PageContentInfo	Represent a page content info.
PageInfo	Represent the page information.
PagePrintedEventArgs	Provides data for the PagePrinted event.
PagePrintEventArgs	Provides data for the PagePrinting and PagePrinted events.
PagePrintingEventArgs	Provides data for the PagePrinting event.
PageSettings	Represent the settings of the page.
Parameter	Represents the parameter of a function.
PasteOption	Wraps all optional parameters in IRange.Copy(IRange, PasteType).
PdfSaveOptions	Option class for saving PDF file.
PdfSecurityOptions	Represents the security setting.
PivotFilterOptions	Pivot filter optional settings, contains some special settings for Value filter, date filter, and top 10 filter.
Point
PrintManager	Represents a print settings class.
RadioButtonListCellType
RangeEventArgs	Specifies EventArgs that contain a IRange object.
RangeFindReplace
RangeFindReplace.FindReplaceImpl
RangePartialClasses
RangePartialClasses.FindReplaceImpl
RangeTemplateCellType	RangeTemplate provide a template from a range of referenced worksheet, it can apply to a cell. It will render the cell same as the template and fill data differently. If the param row, col, rowCount, colCount not set, it will use the sheet's usedrange as the range scope.
Rectangle	Represents a rectangle class.
RepeatSetting	Represents the repeat settings of a range.
ReplaceOptions	Wraps all optional parameters in IRange.Replace(object, object, ReplaceOptions) to be consistent with the Java edition.
SaveOptionsBase	Base option class for saving.
SelectFieldItem	Represents an checkBoxList/radioList item.
SerializationOptions	Represents some settings when serialize workbook or worksheet to JSON.
SheetEventArgs	Represents EventArgs which contain a Worksheet object;
SignatureDetails	Provides signature details for application developers to implement the "Sign" button on "Signature Details" dialog. Represents data of SignatureInfoV1, SignatureInfoV2 and XAdES part in the signature.
Size	Represents a Size class.
SjsOpenOptions	Option class for opening SpreadJS .sjs file.
SjsSaveOptions	Option class for saving SpreadJS file.
SortFieldBase	Represents the sort base class.
SpecialCellsValue	Specifies cells with a particular type of value to include in the result.
TableStyleFactory
TextFormatInfo	Describes font and layout options for drawing text.
Theme
Themes	Represents the theme manager.
ThemeStorage
ValueSortField	Represents the sort by value field.
WebRequestResult	Represents the result of a web request, including the success status, the response content, any connection failure, and the HTTP status code.
Workbook	Represents a workbook.
WorkbookOptions	Options class for creating the workbook.
WriteProtection	Provides access to the workbook write protection options.
XlsmOpenOptions	Option class for opening xlsm file.
XlsmSaveOptions	Option class for saving xlsm file.
XlsxOpenOptions	Option class for opening xlsx file.
XlsxSaveOptions	Option class for saving xlsx file.
XltxOpenOptions	Option class for opening xltx file.
XltxSaveOptions	Option class for saving xltx file.

Interfaces

Interface	Description
EventHandler<T>
IAboveAverage	Represents an above average visual of a conditional formatting rule. Applies a color or fill to a range or selection to help you see the value of a cell relative to other cells.
IAreas	Represents a collection of ranges, each of which represent a single contiguous range of one or more cells.
IAuthor	Represents an author of threaded comment.
IAutoCorrect	Contains AutoCorrect attributes.
IAutoFilter	Represents autofiltering for the specified worksheet.
IBarcode	All types of barcode inherits this interface.
IBorder	Represents the border of an object.
IBorders	Represents a collection of four IBorder objects that represent thefour borders of an IRange or IStyle object.
IBuiltInDocumentPropertyCollection	A collection of built-in document properties.
ICalcContext	Represents the context of the calclation.
ICalculatedFields	A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.
ICalculatedItems	A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
ICascadeSparkLine	Represents a cascade sparkLine.
ICellCollection	Gets an individual cell by its reference string.
ICellColorSortField	Represents the sort field by cell color.
ICellPadding	Gets or sets the cell padding.
ICodabar	Codabar is a barcode that uses alphanumeric characters including : A B C D + - : . / $ and all numbers.A screenshot depicting Codabar sparkline is shared below.
ICode128	The Code 128 barcode is a linear barcode that represents high-density linear symbology to encode text, numbers, various functions and the entire 128 ASCII character set (from ASCII 0 to ASCII 128).
ICode39	Code 39 is a linear barcode that uses a total of nine bars to represent each symbol which includes numeric characters, upper case characters and some special characters ("%" , "*", "$", "/", "." , "-", "+").
ICode49	Code 49 is a two dimensional, high-density stacked barcode with two to eight rows (having eight characters each). Each row has a start code and a stop code. This barcode is especially used to encodes the complete ASCII character set.
ICode93	Code93 barcode is a barcode that uses uppercase characters and numeric characters along with some special characters ("%" , "*", "$", "/", "." , "-", "+").
IColorScale	Represents a color scale conditional formatting rule.
IColorScaleCriteria	Represents a collection of ColorScaleCriterion objects that represent all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale.
IColorScaleCriterion	Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
IColorStop	Represents the color stop point for a gradient fill in a range or selection.
IColorStops	Represents a collection of all the IColorStop objects for thespecified series.
IComment	Represents a cell comment.
IComments	Represents a collection of cell comments. Each comment is represented by an IComment object.
ICommentsThreaded	A collection of top-level threaded comment objects in a Worksheet, or a collection of replies in a single threaded comment. Each comment is represented by an ICommentThreaded object.
ICommentThreaded	Represents a cell's threaded comment. This object can represent both a top-level comment or its replies.
IConditionValue	Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
ICsvParser	Represents the customized parser.
ICustomDocumentPropertyCollection	A collection of custom document properties.
ICustomView	Represents a custom workbook view.
ICustomViews	A collection of custom workbook views.
IDataBar	Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells.
IDataBarBorder	Represents the border of the data bars specified by a conditional formatting rule.
IDataMatrix	DataMatrix barcode is a high density, two-dimensional barcode with square modules typically arranged in a square or a rectangular matrix pattern.
IDataOptions	Represents the options related to data import and data analysis.
IDisplayFormat	Represents the display settings for an associated Range object. Remark: Actions such as changing the conditional formatting or table style of a range can cause what is displayed in the current user interface to be inconsistent with the values in the corresponding properties of the Range object. Use the properties of the DisplayFormat object to return the values as they are displayed in the current user interface.
IDocumentProperty	Represents a custom or built-in document property.
IDocumentPropertyCollection	Represents a collection of document properties.
IEAN13	EAN-13 barcode is a code that makes use of numeric characters (twelve numbers) and a check digit.
IEAN8	EAN-8 barcode is a barcode that uses only numeric characters and a check digit. This barcode accepts only seven numbers as a string to calculate a check digit (CheckSum) and add it to the eighth position.
IExcelOptions	Represents the option for working with Excel.
IFilter	Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.
IFilters	Represents a collection of Filter objects that represents all the filters in an autofiltered range.
IFont	Contains the font attributes (font name, font size, color, and so on) for an object.
IFontColorSortField	Represents the sort field by font color.
IFontOption	Font option.
IFontProvider	Provides the font provider.
IFormatColor	Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format.
IFormatCondition	Represents a conditional format.
IFormatConditions	Represents the conditional formats associated with a range.
IFormulaOptions	Represents the options related to formula calculation, performance, and error handing.
IFormulaResolver
IGraphic	Represents the picture field included in the specified header or footer.
IGraphicsInfo	Provides graphics information.
IGroupInfo	Represents the information of a group.
IGS1128	GS1-128 is a barcode that uses a series of application Identifiers in order to encode data. This barcode makes use of the complete ASCII character set while also using FNC1 character as the first character position.
IHeaderFooter	Represents a picture or text how to be aligned in the page header and footer.
IHPageBreak	Represents a horizontal page break.
IHPageBreaks	Represents the collection of horizontal page breaks within the print area.
IHyperlink	Represents a hyperlink.
IHyperlinks	Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by the IHyperlink object.
IIcon	Represents a single icon in an icon set used in a conditional formatting rule.
IIconCriteria	Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.
IIconCriterion	Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.
IIconSet	Represents a single set of icons that are used in an icon set conditional formatting rule.
IIconSetCondition	Represents an icon set conditional formatting rule.
IIconSets	Represents a collection of icon sets used in an icon set conditional formatting rule.
IIconSortField	Represents the sort field by icon.
IInterior	Represents the interior of an object.
IJsonSerializer	Represents a serializer/deserializer for custom type in from/to json.
ILabelOption	Barcode lable option
ILabelOptions	Indicates the cell label options.
ILinearGradient	Represents the ILinearGradient object that transitions through aseries of colors in a linear manner along a specific angle.
IName	Represents a defined name for a range of cells.
INames	Represents a collection of all the IName objects in the workbook.Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.
INegativeBarFormat	Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
IOutline	Represents an outline on a worksheet.
IOutlineColumn	Represents the outline column for the worksheet.
IPage	Represents the alignment of text on the page of a workbook or section.
IPageSetup	Represents the page setup description.
IPane	Worksheet pane.
IPanes	Worksheet panes.
IPDF417	PDF417 barcode is a popular high-density, two-dimensional barcode with symbology that possesses the capability to encode up to 1108 bytes of information. This barcode comprises a stacked set of small barcodes and can encode up to 35 alphanumeric characters and 2,710 numeric characters.
IPivotAxis	Represents the axis for a PivotTable report.
IPivotCache	Represents the memory cache for a PivotTable report.
IPivotCaches	Represents the collection of memory caches from the PivotTable reports in a workbook.
IPivotCell	Represents a cell in a PivotTable report.
IPivotField	Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.
IPivotFields	Represents a collection of all the PivotField objects in a PivotTable report.
IPivotFilter	Represents a pivot filter in the PivotFilters collection.
IPivotFilters	Represents a collection of all the pivot filters in the pivot field.
IPivotFormula	An object representing the order in which custom formulas are calculated in a PivotTable
IPivotFormulas	Represents the collection of IPivotFormula
IPivotItem	Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField.
IPivotItemList	A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
IPivotItems	Represents a collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
IPivotLine	A PivotLine object is a line of rows or columns in an Excel PivotTable.
IPivotLineCells	Collection of PivotCell objects for a specific PivotLine.
IPivotLines	The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows or columns of the pivot. Each line is a set of PivotCells.
IPivotTable	Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.
IPivotTables	Represents a collection of all the PivotTable objects on the specified worksheet.
IPivotValueCell	Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.
IProtectionSettings	Represents the various types of protection options available for a worksheet. The setting action will take effect only if the worksheet is under protection.
IQRCode	QRCode is a two dimensional barcode representing symbology that enables effective handling of numeric, alphanumeric and byte data. This barcode can encode up to 7,366 characters.
IRange	Represents the IRange object.
IRangeProvider	Provides access to the IRange object of cells in the worksheet.
IReadOnlySignatureDetails	Represents read-only detail of the signature.
IRectangularGradient	The IRectangularGradient object transitions through a series ofcolors in a linear manner along a specific angle
IRichText	Represents the rich text class for a cell.
IShrinkToFitSettings	Represents the shrink to fit settings of this workbook.
ISignature	Corresponds to a digital signature that is attached to a document.
ISignatureSet	A collection of Signature objects that correspond to the digital signature attached to a document.
ISignatureSetup	Represents the information used to set up a signature packet.
ISlicer	Represents a slicer in a IWorkbook.
ISlicerCache	Represents the current filter state for a slicer and information about which IPivotCache.
ISlicerCaches	Represents the collection of slicer caches associated with the specified workbook.
ISlicerItem	Represents an item in a slicer.
ISlicerItems	Represents the collection of ISlicerItem objects contained in a ISlicerCache object.
ISlicerPivotTables	Represents information about the collection of IPivotTablesassociated with the specified ISlicerCache object.
ISlicers	A collection of ISlicer objects.
ISort	Represents the sort interface.
ISortField	Represents the sort field.
ISortFields	Represents the sort condition list.
ISparkAxes	Represents the settings for the horizontal and vertical axes of a group of sparklines.
ISparkColor	Represents the color of the markers for points in a sparkline.
ISparkHorizontalAxis	Represents the settings for the horizontal axes of a group of sparklines.
ISparkline	Represents a single sparkline.
ISparklineGroup	Represents a group of sparklines.
ISparklineGroups	Represents a collection of sparkline groups.
ISparkLineObject	SparkLine Object.
ISparkPoints	Represents the settings of the markers for points of data on a sparkline.
ISparkVerticalAxis	Represents the settings for the vertical axes of a group of sparklines.
IStyle	Represents a style description for a range.
IStyleCollection	Represents a collection of all the IStyle objects in the specified oractive workbook.
ITable	Represents a table object on a worksheet.
ITableColumn	Represents a column in a table. The ITableColumn object is a memberof the ITableColumns collection. The ITableColumns collectioncontains all the columns in a table ( ITable object).
ITableColumns	Represents a collection of all the ITableColumn objects in thespecified ITable object. Each ITableColumn object represents a columnin the table.
ITableDataSource	Classes that implement this interface can be regarded as data sources
ITableRow	Represents a row in the ITable object. The ITableRow objectis a member of the ITableRows collection. The ITableRows collectioncontains all the rows in a list object.
ITableRows	Represents a collection of all the ITableRow objects in the specified ITable object. Each ITableRow object represents a row in the table.
ITables	Represents a collection of all the ITable objects on a worksheet.Each ITable object represents a list in the worksheet.
ITableStyle	Represents a single style that can be applied to a table.
ITableStyleCollection	Represents a collection of table styles contained in the workbook.
ITableStyleElement	Represents a single table style element.
ITableStyleElements	Represents table style elements.
ITableStyleInfo	Gets or sets the style information applied to the table.
ITextRun	Represents a range of characters in a IRichText object.
ITheme	Contains the theme information.
IThemeColor	Represents the theme color information.
IThemeColorScheme	Represents the theme color.
IThemeFont	Represents the theme font.
IThemeFonts	Contains the theme fonts in different language.
IThemeFontScheme	Specifies the font theme to use.
ITop10	Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.
IUniqueValues	The UniqueValues object uses the UniqueValues.DupeUnique property to return or set an enumeration that determines whether the rule should look for duplicate or unique values in the range.
IValidation	Represents data validation for a worksheet range.
IValueSortField	Represents the sort field by cell value (ascending or descending or custom value list).
IVPageBreak	Represents a vertical page break.
IVPageBreaks	Represents the collection of vertical page breaks within the print area.
IWebRequestHandler	Defines an interface for handling web requests asynchronously. This interface provides a way to send GET requests to a specified URI.
IWorkbook	Represents an IWorkbook object.
IWorkbookView	Represents the view settings of this workbook.
IWorksheet	Represents a worksheet.
IWorksheets	Represents a collection of all the sheets in the workbook.
IWorksheetView	Represents worksheet view options.
RangeFindReplace.FindReplaceImpl.FindMatch
RangePartialClasses.FindReplaceImpl.FindMatch

Enumerations

Enumeration	Description
AboveBelow	Specifies if the values are above or below average.
AutoFilterOperator	Specifies the operator to use to associate two criteria applied by a filter.
BackgroundImageLayout	Specifies how a background image should be stretched to fill the destination rectangle.
BarcodeType	Specifies the type of barcode.
BorderLineStyle	Specifies the line style for the border.
BordersIndex	Specifies the border to be retrieved.
CalcError	Specifies the calculation error.
CalculationMode	Excel calculation mode.
CellTypeDirection	Specifies direction of the checkbox or radio list.
CellTypeTextAlign	Specifies the text alignment for checkbox/radiolist cells.
CheckBoxAlign	Specifies the text alignment for check box cells.
ColorDataIndex	Specifies the color of a selected feature such as border, font, or fill.
ColorScaleType	Specifies the type of color scale rule.
ConditionValueTypes	Specifies the types of condition values that can be used.
ConsolidationFunction	Specifies the subtotal function.
ContainsOperator	Specifies the operator used in a function.
CssExportType	CSS export type.
DataBarAxisPosition	Specifies the axis position for a range of cells with conditional formatting as data bars.
DataBarBorderType	Specifies the border of a data bar.
DataBarDirection	Specifies the direction of a data bar.
DataBarFillType	Specifies how a data bar is filled with color.
DataBarNegativeColorType	Specifies whether to use the same border and fill color as postive data bars.
DeleteShiftDirection	Specifies how to shift cells to replace deleted cells.
Direction	Specifies the direction in which to move.
DisplayBlanksAs	Specifies how blank cells are plotted on a chart.
DupeUnique	Specifies whether duplicate or unique values should be displayed.
DynamicFilterType	Specifies the filter type.
EccMode	A value that represents which ecc mode.
EditorValueType	Specifies what is written out to the data model for a selected item from certain cell types that offer a selection of multiple values.
ErrorCorrectionLevel	Represents the error correction level of QRCode.
FindLookIn	Specifies the type of data to search.
FontLanguageIndex	Specifies the font language type.
FormatConditionOperator	Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween, to compare two formulas.
FormatConditionType	Specifies whether the conditional format is based on a cell value or an expression.
FormFieldSubmitFormatType	Defines possible values of GrapeCity.Documents.Pdf.Actions.ActionSubmitForm.SubmitFormat property.
FunctionValueType	Specifies the value type of parameter or result.
GradientFillType	Specifies the type of gradient fill being used, either linear or path.
GraphicColorType	Represents type of color transformation applied to the specified picture or OLE object.
HeaderFooterPosition	Specifies the header/footer's position in the sheet.
HeaderFooterType	Specifies the current drawing is header or footer.
HorizontalAlignment	Specifies the horizontal alignment of a cell or object.
HyperLinkTargetType	Specifies the hyperlink's target type.
IconSetType	Specifies the type of icon set.
IconType	Specifies the icon for a criterion in an icon set conditional formatting rule.
IgnoredErrorType	The types of errors that can occur in cell.
IMEModeType	Specifies the description of the Japanese input rules.
ImportFlags	Options for reading data
InsertShiftDirection	Specifies the direction in which to shift cells during an insertion.
LabelAlignment	Specifies the cell label position.
LabelVisibility	Specifies the cell label visibility.
LayoutFormType	Specifies the way the specified PivotTable items appear—in table format or in outline format.
LayoutRowType	Specifies the type of layout row.
LookAt	Specifies whether a match is made against the whole of the search text or any part of the search text.
NumbersFitMode	Specifies the display mode when date or number data width is longer than the column width.
OpenFileFormat	Represents the format in which the workbook is opened.
Order	Represents the order uses to number pages when printing a large worksheet.
PageBreakExtent	Specifies whether a page break is full screen or applies only within the print area.
PageOrientation	Represents the portrait or landscape printing mode.
PaginationOrientation	Represents the type of the page.
PaperSize	Represents the size of the paper.
PasteType	Specifies the type of paste.
Pattern	Specifies the interior pattern of a chart or interior object.
PivotCellType	Specifies the PivotTable entity the cell corresponds to.
PivotFieldCalculation	Specifies the subtotal function.
PivotFieldOrientation	Specifies the location of the field in a PivotTable report.
PivotFieldRepeatLabels	Specifies whether to repeat all field item labels in a PivotTable report.
PivotFilterType	The type of pivot filter
PivotLineType	Specifies the type of the PivotLine.
PrintErrors	Represents an PrintErrors contstant specifying the type of print error displayed.
PrintLocation	Represents the way comments are printed with the sheet.
PrintQuality	Represents print quality of this page. Default is Dpi600.
PropertyType	Specifies data type of a document property.
ReadingOrder	Specified the text reading order.
ReferenceStyle	Specifies whether to use A1 style or R1C1 style for cell references.
SaveFileFormat	Represents the format in which the workbook is saved.
SearchDirection	Specifies the search direction when searching a range.
SearchOrder	Specifies the order in which to search the range.
SelectionModeType	Specifies the selection mode of Button List CellType.
SheetType	Represents the sheet type.
SlicerSortOrder	Specifies the slicer sort order.
SortDataOption	Specifies how to sort text.
SortOnType	Specifies the parameter on which the data should be sorted.
SortOrder	Specifies the sort order.
SortOrientation	Specifies the sort orientation.
SparklineRowCol	Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
SparkScale	Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
SparkType	Specifies the type of sparkline.
SpecialCellType	Specifies the type of cells.
SpreadJSTabStripPosition	Specifies the position of the tab strip relative to the workbook.
SubtotalLocationType	Specifies where the subtotal will be displayed on the worksheet.
SubtotalType	Specifies the type of subtotal for the specified pivot field.
SummaryColumn	Specifies the location of the summary columns in the outline.
SummaryRow	Specifies the location of the summary rows in the outline.
TableStyleElementType	Specifies the table style element used.
ThemeColor	Specifies the theme color. This is the displayed order.
ThemeFont	Specifies the theme font to use.
TimePeriods	Specifies the time period.
TopBottom	Specifies the top 10 values from the top or bottom of a series of values.
TotalsCalculation	Specifies the type of calculation in the totals row of a table column.
UnderlineType	Specifies the underline style of text.
UsedRangeType	Specifies the type of all supported features.
ValidationAlertStyle	Specifies the icon used in message boxes displayed during validation.
ValidationOperator	Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween, to compare two formulas.
ValidationType	Specifies the type of validation test to be performed in conjunction with values.
ValueQuoteType	Gets or sets how to quote values in the exported text file.
VerticalAlignment	Specifies the vertical alignment of text.
ViewType	Represents the view type of the worksheet.
Visibility	Specifies whether the object is visible.

Reference

Documents.for.Excel.Java.Edition.Packages Project