Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

Package com.aspose.cells

Provides the API for accessing and processing Microsoft Workbook files.

See:
          Description

Interface Summary
BorderLineType Enumerates border line types.
BorderType Enumerates the border line and diagonal line types.
CalculationMode Represents the calculation mode.
CategoryType Represents the category axis type.
CellValueType Specifies a cell value type.
ChartMarkerType Represents the marker style in a line chart, scatter chart, or radar chart.
ChartType Enumerates all chart types used in Workbook.
ConsolidationFunction Represents consolidation function.
ErrorBarInclude Enumerates the type of the error bar parts to include.
ErrorBarType Enumerates error bar type.
FileFormatType Enumerates spreadsheet file format types.
FillPatternType Enumerates an area's display pattern types.
FormatConditionType Represent conditional formate type constants.
GradientColorType Represents the gradient color type for the specified fill.
GradientPresetType Represents gradient preset color type.
GradientStyleType Represents gradient shading style.
HorizontalAlignmentType Enumerates horizontal text alignment types.
LabelPositionType Represents data label position type.
LegendPositionType Enumerates the legend position types.
LineType Enumerates the type of Picture border or Chart line.
MsoLineDashStyle Enumerates the dash style of the shape border line.
MsoLineStyle Enumerates the line style of the shape border line.
MsoTextOrientation Represents mso text orientation constants.
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.
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.
PlacementType Represents the way the drawing object is attached to the cells below it.
PrintCommentsType Represents the way comments are printed with the sheet.
PrintErrorsType Represents print errors constants.
PrintOrderType Deprecated. Replaced by OrderType
PropertyType Specifies data type of a document property.
ProtectionType Represents workbook/file protection type.
SheetType Enumerates worksheet types.
TextAlignmentType Enumerates text alignment types.
TextDirectionType Enumerates text direction types.
TickLabelPositionType Represents the position type of tick-mark labels on the axis.
TickMarkerType Represents the tick mark type for the axis.
TrendlineType Represents the trendline type.
ValidationAlertType Represents the validation alert style.
ValidationType Represents data validation type.
VerticalAlignmentType Enumerates vertical text alignment types.
WeightType Enumerates the weight types for a picture border or a chart line.
 

Class Summary
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.
BuiltInDocumentProperties Represents a collection of built-in document properties.
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.
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.
Charts Encapsulates a collection of Chart objects.
Color Represents a color which contains three, 8-bit components: red, green, and blue.
Column Represents a single column in a worksheet.
Columns Encapsulates a collection of Column objects.
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.
DataLabels Encapsulates a collection of all the DataLabel objects for the specified ASeries.
DocumentProperty Represents a custom or built-in document property.
ErrorBars Represents the error bars on a chart series.
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.
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.
Legend Encapsulates the object that represents the chart legend.
License Provides methods to license the component.
Line Encapsulates the object that represents the chart line.
NamedRange Encapsulates the object that represents a named range
NSeries Encapsulates a collection of ASeries objects.
Outline Represents an outline on a worksheet.
PageSetup Encapsulates the object that represents the page setup description.
Palette Represents the palette of an Workbook file.
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.
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.
Row Represents a row of a spreadsheet.
Rows Encapsulates a collection of Row objects.
SeriesAxis Encapsulates the object that represents series axis.
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.
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.
Title Encapsulates the object that represents the title of chart or axis.
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.
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.
 

Package com.aspose.cells Description

Provides the API for accessing and processing Microsoft Workbook files.

Conventions
All indexes are zero based if not mentioned specifically.

Synchronization
Classes in the package are not synchronized and are not thread safe. Programmer's Guide
http://www.aspose.com/Wiki/Default.aspx/Aspose.Cells.Java/