Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


Package com.aspose.cells

Interface Summary
AsposeDataTable Represts the data table.It's used for smart marker.
BackgroundMode Represents the display mode of the background.
Bar3DShapeType Represents the shape used with the 3-D bar or column chart.
BorderLineType Enumerates border line types.
BorderType Enumerates the border line and diagonal line types.
BubbleSizeRepresents Represents what the bubble size represents on a bubble chart.
CalculationMode Represents the calculation mode.
CategoryType Represents the category axis type.
CellHandler Handler for processing cell values in Excel file cell by cell in Event driven mode.
CellValueType Specifies a cell value type.
ChartMarkerType Represents the marker style in a line chart, scatter chart, or radar chart.
ChartSplitType Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
ChartType Enumerates all chart types used in Workbook.
CheckValueType Represents the type of Check value.
ConsolidationFunction Represents consolidation function.
CountryCode Represents Excel country identifiers.
DataLabelsSeparatorType  
DisplayUnitType Represents the type of display unit.
EncryptionType Enumerates the Encryption Type.
ErrorBarInclude Enumerates the type of the error bar parts to include.
ErrorBarType Enumerates error bar type.
ExportObjectListener Represents the method that will handle the ExportObjectEvent event.
FileFormatType Enumerates spreadsheet file format types.
FillPatternType Enumerates an area's display pattern types.
FillType Enumerates fill formatting type.
FilterOperatorType Custom Filter operator type.
FormatConditionType Represents conditional format type constants.
FormatConditionValueType Represents conditional format value type constants
FormulaType Enumerates the formula types.
GradientColorType Represents the gradient color type for the specified fill.
GradientDirectionType Enumerates the direction type for Gradient fill.
GradientFillType Represents types for Gradient Fill.
GradientPresetType Represents gradient preset color type.
GradientStyleType Represents gradient shading style.
HorizontalAlignmentType Enumerates horizontal text alignment types for cell style.
IconSetType Icon set type for conditional formatting.
ICustomFunction Allows users to add their custom formula calculation functions to extend the calculation engine.
ImageFormat Specifies the format of the image
LabelPositionType Represents data label position type.
LegendPositionType Enumerates the legend position types.
LineCapType Enumerates Cap types for chart line.
LineJoinType  
LineType Enumerates the type of Picture border or Chart line.
MsoLineDashStyle Enumerates the dash style of the shape border line.
MsoLineEndLength Enumerates the line end length of the shape border line.
MsoLineEndType Enumerates the line end type of the shape border line.
MsoLineEndWidth Enumerates the line end width of the shape border line.
MsoLineStyle Enumerates the line style of the shape border line.
MsoTextOrientation Represents mso text orientation constants.
OleFileType Ole object file type.
OperatorType Represents the operator type of conditional format and data validation.
OrderType Represent order type constants.
PageOrientationType Represents print orientation constants.
PaperSizeType Represents paper size constants.
PatternType Enumerates cell background pattern types.
PdfCompliance Allowing user to set PDF convertion's Compatibility
PivotFieldDataDisplayFormat Represents data display format in the PivotTable data field.
PivotFieldSubtotalType Represents PivotTable field subtotal type.
PivotFieldType Represents PivotTable field type.
PivotItemPosition Represents PivotTable base item Next/Previous/All position in the base field .
PivotTableAutoFormatType Represents PivotTable auto format type.
PivotTableGroupType Represents PivotTable group type.
PlacementType Represents the way the drawing object is attached to the cells below it.
PlotEmptyCellsType Repesents all types for how blank cells shall be plotted on a chart.
PrintCommentsType Represents the way comments are printed with the sheet.
PrintErrorsType Represents print errors constants.
PrintingPageType Indicates which pages will not be printed.
PrintOrderType Deprecated. Replaced by OrderType
PrintSizeType Represnts the printed chart size.
PropertyType Specifies data type of a document property.
ProtectionType Represents workbook/file protection type.
SelectionType  
SheetType Enumerates worksheet types.
SortOrderType Presents sort order type.
SparklineAxisMinMaxType Represents the minimum and maximum value types for the sparkline vertical axis.
SparklinePresetStyleType Represents the preset style types for sparkline.
SparklineType Represents the sparkline types.
TextAlignmentType Enumerates text alignment types for text in Shape related objects, such as text alignment of TextBox, Chart's Title, DataLabels, and so on.
TextDirectionType Enumerates text direction types.
TextureType Represents the preset texture type.
TickLabelPositionType Represents the position type of tick-mark labels on the axis.
TickMarkerType Represents the tick mark type for the axis.
TileAlignmentType Represents Alignment of Tiling options for Picture or Texture fill.
TileMirrorType Represents mirror type of Tiling options for Picture or Texture fill.
TimePeriodType Used in a FormatConditionType.TimePeriod conditional formatting rule.
TimeUnit Represents the base unit for the category axis.
TrendlineType Represents the trendline type.
ValidationAlertType Represents the validation alert style.
ValidationType Represents data validation type.
VerticalAlignmentType Enumerates vertical text alignment types for cell style.
WeightType Enumerates the weight types for a picture border or a chart line.
 

Class Summary
AboveAverage Describes the AboveAverage conditional formatting rule.
ArcShape  
Area Encapsulates the object that represents a chart area.
ASeries Encapsulates the object that represents a single data series in a chart.
AutoFilter Represents autofiltering for the specified worksheet.
Axis Encapsulates the object that represents a chart's axis.
BIFF7Encrypter  
BuiltInDocumentProperties Represents a collection of built-in document properties.
Button  
CategoryAxis Encapsulates the object that represents a chart's category axis.
Cell Encapsulates the object that represents a single Workbook cell.
CellArea Represents a range of cells in a worksheet.
Cells Encapsulates a collection of Cell objects.
CellsHelper Contains helper static functions.
CFValueObject Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
CFValueObjectCollection Describes a collection of CFValueObject.
Characters Represents a range of characters within the cell text.
Chart Encapsulates the object that represents a single Workbook chart.
ChartArea Encapsulates the object that represents the chart area in the worksheet.
ChartDataTable Represents a chart data table.
ChartFrame  
ChartPoint Represents a single point in a series in a chart.
ChartPoints Represents a collection that contains all the points in one series.
Charts Encapsulates a collection of Chart objects.
ChartShape  
CheckBox  
Color Represents a color which contains three, 8-bit components: red, green, and blue.
ColorScale Describes the ColorScale conditional formatting rule.
Column Represents a single column in a worksheet.
Columns Encapsulates a collection of Column objects.
ComboBox  
Comment Encapsulates the object that represents a cell comment.
Comments Encapsulates a collection of Comment objects.
ConditionalFormattings Represents all conditional formattings in the worksheet.
CustomDocumentProperties Represents a collection of custom document properties.
DataBar Describes the DataBar conditional formatting rule.
DataLabels DataLabels of specified ASeries, ChartPoint or Trendline.
DataSorter Represents data sorter.
DisplayUnitLabel  
DocumentProperty Represents a custom or built-in document property.
DropBar  
ErrorBars Represents the error bars on a chart series.
ExportObjectEvent Provides data for the ExportObjectListener.
Fill Represents fill settings.
FillFormat Encapsulates the object that represents fill formatting for a shape
FindOptions Represents find options.
Floor Encapsulates the object that represents the floor of a 3-D chart.
Font Represents a font used in a spreadsheet.
FormatCondition Represents conditional formatting condition.
FormatConditions Represents conditional formatting.
GradientFill Fill format settings for GRADIENT type
GradientStop Represents one Gradient stop for Gradient Fill.
GradientStops Represents Gradient stops collection for Gradient Fill.
GroupBox  
GroupShape  
HPageBreak Encapsulates the object that represents a horizontal page break.
HPageBreaks Encapsulates a collection of HPageBreak objects.
Hyperlink Encapsulates the object that represents a hyperlink.
Hyperlinks Encapsulates a collection of Hyperlink objects.
IconSet Describes the IconSet conditional formatting rule.
ImageOptions Represents settings for generating Image.
Label  
Legend Encapsulates the object that represents the chart legend.
LegendEntries  
LegendEntry Represents a legend entry in a chart legend.
License Provides methods to license the component.
LightCell Wrapper for data of one cell, used for process spreadsheet file in Event-Driven access mode
LightCells Cells processor for processing spreadsheet files in Event-Driven mode.
LightCellsSettings This is a bean which client applications may use to set various advanced LightCells properties.
Line Encapsulates the object that represents the chart line.
LineShape Repesents the mso drawing line.
ListBox  
Marker Represents the marker in a line chart, scatter chart, or radar chart.
MsoDrawingType Represents the type of the shape.
Name Encapsulates the object that represents a name, including NamedRange
NamedRange Encapsulates the object that represents a named range
NSeries Encapsulates a collection of ASeries objects.
NumberFormatType Represents the number formate type of the style.
OleObject  
OpenOptions Provides various options that control how a workbook is opened from template file.
Outline Represents an outline on a worksheet.
OvalShape  
PageSetup Encapsulates the object that represents the page setup description.
Palette Represents the palette of an Workbook file.
PatternFill Fill format of type PATTERN
PdfBookmarkEntry PdfBookmarkEntry is an entry in pdf bookmark.
Picture Encapsulates the object that represents a single picture in a spreadsheet.
Pictures Encapsulates a collection of Picture objects.
PivotField Represents a field in a PivotTable report.
PivotFields Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.
PivotItem Represents an item in a PivotTable field.
PivotItems Presents a collection of all the PivotItem objects in a PivotTable field.
PivotPageFields Represents the pivot page field items if the pivot table data source is consolidation ranges.
PivotTable Represents a PivotTable report on a worksheet.
PivotTables Represents the collection of all the PivotTable objects on the specified worksheet.
PlotArea Encapsulates the object that represents the chart's plotarea in the worksheet.
Protection Represents the various types of protection options available for a worksheet.
RadioButton  
Range Reprents a range in a worksheet.
RectangleShape  
Row Represents a row of a spreadsheet.
Rows Encapsulates a collection of Row objects.
SaveOptions Provides various options that control how a workbook is saved.
ScrollBar  
SeriesAxis Encapsulates the object that represents series axis.
Shape Common Shape Property.
ShapeFill Encapsulates the object that contains fill formatting properties for the specified shape.
ShapeLine Encapsulates the object that contains formatting information for the shape's border.
Shapes Represents all the shapes in the worksheet.
SheetRender Represents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG,EMF...)
Sparkline A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
SparklineCollection Encapsulates a collection of Sparkline objects.
SparklineGroup Sparkline is organized into sparkline group.
SparklineGroupCollection Encapsulates a collection of SparklineGroup objects.
Spinner  
Style Represents display styles of Workbook spreadsheets.
StyleFlag Represents flags which indicates applied formatting properties.
TextBox Encapsulates the object that represents a textbox in a spreadsheet.
TextBoxes Encapsulates a collection of TextBox objects.
TextureFill Fill format settings for TEXTURE type
Title Encapsulates the object that represents the title of chart or axis.
Top10 Describes the Top10 conditional formatting rule.
Trendline Represents a trendline in a chart.
Trendlines Represents a collection of all the Trendline objects for the specified data series.
Validation Represents data validation.settings.
Validations Represents data validation collection.
ValueAxis Encapsulates the object that represents a chart's value axis.
VPageBreak Encapsulates the object that represents a vertical page break.
VPageBreaks Encapsulates a collection of VPageBreak objects.
Walls Encapsulates the object that represents the walls of a 3-D chart.
Workbook Represents an Workbook Object.
WorkbookDesigner Encapsulates the object that represents a designer spreadsheet.
WorkbookRender Represents a Workbook render.
Worksheet Represents a worksheet.
Worksheets Encapsulates a collection of Worksheet objects.
 

Exception Summary
AsposeLicenseException This exception is thrown if any errors with license are detected.
CellsException The exception that is thrown which indicates an error occurs.
FormulaCalcException The exception that is thrown which indicates an error occurs when calculating formuals.