Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

A B C D E F G H I J L M N O P Q R S T U V W X Y Z

C

calculateCustomFunction(String, ArrayList, ArrayList) - Method in interface com.aspose.cells.ICustomFunction
Calculates the result of custom function.
calculateFormula() - Method in class com.aspose.cells.Workbook
Calculates the result of formulas.
calculateFormula(boolean, ICustomFunction) - Method in class com.aspose.cells.Workbook
Calculates the result of formulas.
calculateFormula(boolean) - Method in class com.aspose.cells.Workbook
Calculates the result of formulas.
calculateFormula(boolean, boolean) - Method in class com.aspose.cells.Worksheet
Calculates all formulas in this worksheet.
calculateFormula(int, int, boolean, boolean) - Method in class com.aspose.cells.Worksheets
Calculates formulas in some worksheets.
CalculationMode - Interface in com.aspose.cells
Represents the calculation mode.
CALM_WATER - Static variable in interface com.aspose.cells.GradientPresetType
Represents calm Water preset color.
CANADA - Static variable in interface com.aspose.cells.CountryCode
 
Canvas - Static variable in interface com.aspose.cells.TextureType
Represents Canvas texture type.
CATEGORY_SCALE - Static variable in interface com.aspose.cells.CategoryType
 
CategoryAxis - Class in com.aspose.cells
Encapsulates the object that represents a chart's category axis.
CategoryType - Interface in com.aspose.cells
Represents the category axis type.
Cell - Class in com.aspose.cells
Encapsulates the object that represents a single Workbook cell.
CELL_VALUE - Static variable in interface com.aspose.cells.FormatConditionType
The conditional formatting is based on a cell value.
CellArea - Class in com.aspose.cells
Represents a range of cells in a worksheet.
CellArea(int, int, int, int) - Constructor for class com.aspose.cells.CellArea
Constructs an object with the given values.
CellArea(String, String) - Constructor for class com.aspose.cells.CellArea
Constructs an object with the given values.
CellArea() - Constructor for class com.aspose.cells.CellArea
Default constructor.
CellHandler - Interface in com.aspose.cells
Handler for processing cell values in Excel file cell by cell in Event driven mode.
Cells - Class in com.aspose.cells
Encapsulates a collection of Cell objects.
CellsException - Exception in com.aspose.cells
The exception that is thrown which indicates an error occurs.
CellsException(String, int) - Constructor for exception com.aspose.cells.CellsException
Initializes a new instance of the Exception class.
CellsException() - Constructor for exception com.aspose.cells.CellsException
Initializes a new instance of the CellsException class.
CellsHelper - Class in com.aspose.cells
Contains helper static functions.
CellValueType - Interface in com.aspose.cells
Specifies a cell value type.
CENTER - Static variable in interface com.aspose.cells.LabelPositionType
Only for Bar, Column, Line, Bubble, Scatter, or Pie chart group.
CENTER - Static variable in interface com.aspose.cells.TextAlignmentType
Represents center text alignment.
CENTER - Static variable in interface com.aspose.cells.TileAlignmentType
 
CENTRED - Static variable in interface com.aspose.cells.HorizontalAlignmentType
Represents center text alignment.
CENTRED - Static variable in interface com.aspose.cells.VerticalAlignmentType
Represents center aligned.
CENTRED_ACROSS - Static variable in interface com.aspose.cells.HorizontalAlignmentType
Represents center across text alignment.
CFValueObject - Class in com.aspose.cells
Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
CFValueObject(FormatCondition, byte, Object, boolean) - Constructor for class com.aspose.cells.CFValueObject
Constructs a CFValueObject instance.
CFValueObject(FormatCondition, byte, Object) - Constructor for class com.aspose.cells.CFValueObject
Constructs a CFValueObject instance.
CFValueObject(FormatCondition, byte) - Constructor for class com.aspose.cells.CFValueObject
Constructs a CFValueObject instance.
CFValueObjectCollection - Class in com.aspose.cells
Describes a collection of CFValueObject.
changeSeriesOrder(int, int) - Method in class com.aspose.cells.NSeries
Chanages the tow serieses order.It will cause the series index changed.
Characters - Class in com.aspose.cells
Represents a range of characters within the cell text.
Chart - Class in com.aspose.cells
Encapsulates the object that represents a single Workbook chart.
CHART - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the Chart shape.
CHART - Static variable in interface com.aspose.cells.SheetType
Represents chart.
ChartArea - Class in com.aspose.cells
Encapsulates the object that represents the chart area in the worksheet.
ChartDataTable - Class in com.aspose.cells
Represents a chart data table.
ChartFrame - Class in com.aspose.cells
 
ChartMarkerType - Interface in com.aspose.cells
Represents the marker style in a line chart, scatter chart, or radar chart.
ChartPoint - Class in com.aspose.cells
Represents a single point in a series in a chart.
ChartPoints - Class in com.aspose.cells
Represents a collection that contains all the points in one series.
Charts - Class in com.aspose.cells
Encapsulates a collection of Chart objects.
ChartShape - Class in com.aspose.cells
 
ChartSplitType - Interface in com.aspose.cells
Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
ChartType - Interface in com.aspose.cells
Enumerates all chart types used in Workbook.
CHECK_BOX - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the checkbox.
CheckBox - Class in com.aspose.cells
 
checkCell(String) - Method in class com.aspose.cells.Cells
Given a cell name(like "A1"), checks whether the cell has been defined.
checkCell(int, int) - Method in class com.aspose.cells.Cells
Given a row index and column index, checks whether the cell has been defined.
checkCell(int) - Method in class com.aspose.cells.Row
Given a column index, checks if the cell has been defined.
checkColumn(int) - Method in class com.aspose.cells.Cells
Given a column index, checks if the column has been defined.
checkColumn(int) - Method in class com.aspose.cells.Columns
Gets a column object by its index.
CHECKED - Static variable in interface com.aspose.cells.CheckValueType
Check value type: CHECKED
checkRow(int) - Method in class com.aspose.cells.Cells
Given a row index, checks if the row has been defined.
CheckValueType - Interface in com.aspose.cells
Represents the type of Check value.
CHINA - Static variable in interface com.aspose.cells.CountryCode
 
CHROME - Static variable in interface com.aspose.cells.GradientPresetType
Represents chrome preset color.
CHROME_II - Static variable in interface com.aspose.cells.GradientPresetType
Represents chrome II preset color.
CIRCLE - Static variable in interface com.aspose.cells.ChartMarkerType
Circular markers.
CIRCLE - Static variable in exception com.aspose.cells.FormulaCalcException
Represents circle reference.
CLASSIC - Static variable in interface com.aspose.cells.PivotTableAutoFormatType
Represents Classic auto format type.
clear() - Method in class com.aspose.cells.CFValueObjectCollection
Removes all of the CFValueObject objects from this collection.
clear() - Method in class com.aspose.cells.Comments
Clears all the comments in the worksheet.
clear() - Method in class com.aspose.cells.DataSorter
Clear all setting for this data sorter.
clear() - Method in class com.aspose.cells.HPageBreaks
Clear all horizonal page breaks
clear() - Method in class com.aspose.cells.Hyperlinks
Clears all hyper links.
clear() - Method in class com.aspose.cells.SparklineCollection
Removes all of the sparklines from this collection.
clear() - Method in class com.aspose.cells.SparklineGroupCollection
Removes all of the sparklineGroups from this collection.
clear() - Method in class com.aspose.cells.Validations
Clear all validation objects.
clear() - Method in class com.aspose.cells.VPageBreaks
Clear all vertical page breaks
clearComments() - Method in class com.aspose.cells.Shapes
Remove all comments from the collection
clearComments() - Method in class com.aspose.cells.Worksheet
Clears all comments in the worksheet.
clearContent() - Method in class com.aspose.cells.Cell
Clear the content of the cell.
clearContents(int, int, int, int) - Method in class com.aspose.cells.Cells
Clears contents of a range.
clearContents(CellArea) - Method in class com.aspose.cells.Cells
Clears contents of a range.
clearDataSource() - Method in class com.aspose.cells.WorkbookDesigner
Clears all data sources.
clearDataSource(String) - Method in class com.aspose.cells.WorkbookDesigner
Clears the data source by the source name.
clearFormats(int, int, int, int) - Method in class com.aspose.cells.Cells
Clears formatting of a range.
clearFormats(CellArea) - Method in class com.aspose.cells.Cells
Clears formatting of a range.
clearRange(int, int, int, int) - Method in class com.aspose.cells.Cells
Clears contents and formatting of a range.
clearRange(CellArea) - Method in class com.aspose.cells.Cells
Clears contents and formatting of a range.
clearSparklineGroups(CellArea) - Method in class com.aspose.cells.SparklineGroupCollection
Clears the sparkline groups that overlaps an area of cells.
clearSparklines(CellArea) - Method in class com.aspose.cells.SparklineGroupCollection
Clears the sparklines that is inside an area of cells.
clone() - Method in class com.aspose.cells.Color
Creates and returns a copy of this object.
clone() - Method in class com.aspose.cells.Fill
 
clone() - Method in class com.aspose.cells.Font
Creates and returns a copy of this object.
clone() - Method in class com.aspose.cells.GradientFill
 
clone() - Method in class com.aspose.cells.PatternFill
 
clone() - Method in class com.aspose.cells.Style
Creates and returns a copy of this object.
clone() - Method in class com.aspose.cells.TextureFill
 
Color - Class in com.aspose.cells
Represents a color which contains three, 8-bit components: red, green, and blue.
Color(int, int, int) - Constructor for class com.aspose.cells.Color
Initializes a new instance of the Color class.
Color() - Constructor for class com.aspose.cells.Color
Initializes a new instance of the Color class.
COLOR_SCALE - Static variable in interface com.aspose.cells.FormatConditionType
This conditional formatting rule creates a gradated color scale on the cells.
ColorScale - Class in com.aspose.cells
Describes the ColorScale conditional formatting rule.
Column - Class in com.aspose.cells
Represents a single column in a worksheet.
COLUMN - Static variable in interface com.aspose.cells.PivotFieldType
Presents pivot column field type.
COLUMN - Static variable in interface com.aspose.cells.SparklineType
Column sparkline.
COLUMN_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 100% Stacked Column Chart.
COLUMN_3D - Static variable in interface com.aspose.cells.ChartType
Represents 3D Column Chart.
COLUMN_3D_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 3D 100% Stacked Column Chart.
COLUMN_3D_CLUSTERED - Static variable in interface com.aspose.cells.ChartType
Represents 3D Colustered Column Chart.
COLUMN_3D_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 3D Stacked Column Chart.
COLUMN_CLUSTERED - Static variable in interface com.aspose.cells.ChartType
Represents Clustered Column Chart.
COLUMN_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents Stacked Column Chart.
Columns - Class in com.aspose.cells
Encapsulates a collection of Column objects.
com.aspose.cells - package com.aspose.cells
 
combine(Workbook) - Method in class com.aspose.cells.Workbook
Combines another Workbook object.
COMBO_BOX - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the combo_box.
ComboBox - Class in com.aspose.cells
 
COMMA - Static variable in interface com.aspose.cells.DataLabelsSeparatorType
 
Comment - Class in com.aspose.cells
Encapsulates the object that represents a cell comment.
COMMENT - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the comment.
Comments - Class in com.aspose.cells
Encapsulates a collection of Comment objects.
compareTo(int) - Method in class com.aspose.cells.Cell
Compares this Cell with another one that has given column index for order.
compareTo(Cell) - Method in class com.aspose.cells.Cell
Compares this Cell with another one for order.
compareTo(int) - Method in class com.aspose.cells.ChartPoint
Compares this ChartPoint with another one that has given point index for order.
compareTo(ChartPoint) - Method in class com.aspose.cells.ChartPoint
Compares this ChartPoint with another one for order.
compareTo(int) - Method in class com.aspose.cells.Column
Compares this Column with another one that has given column index for order.
compareTo(Column) - Method in class com.aspose.cells.Column
Compares this Column with another one for order.
compareTo(int) - Method in class com.aspose.cells.LegendEntry
Compares this LegendEntry with another one that has given entry index for order.
compareTo(LegendEntry) - Method in class com.aspose.cells.LegendEntry
Compares this LegendEntry with another one for order.
compareTo(int) - Method in class com.aspose.cells.Row
Compares this Row with another one that has given row index for order.
compareTo(Row) - Method in class com.aspose.cells.Row
Compares this Row with another one for order.
ConditionalFormattings - Class in com.aspose.cells
Represents all conditional formattings in the worksheet.
CONE - Static variable in interface com.aspose.cells.ChartType
Represents Cone Chart.
CONE_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 100% Stacked Cone Chart.
CONE_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents Stacked Cone Chart.
CONE_TO_MAX - Static variable in interface com.aspose.cells.Bar3DShapeType
 
CONE_TO_POINT - Static variable in interface com.aspose.cells.Bar3DShapeType
 
CONICAL_BAR - Static variable in interface com.aspose.cells.ChartType
Represents Conical Bar Chart.
CONICAL_BAR_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 100% Stacked Conical Bar Chart.
CONICAL_BAR_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents Stacked Conical Bar Chart.
CONICAL_COLUMN_3D - Static variable in interface com.aspose.cells.ChartType
Represents 3D Conical Column Chart.
ConsolidationFunction - Interface in com.aspose.cells
Represents consolidation function.
CONTAINS_BLANKS - Static variable in interface com.aspose.cells.FormatConditionType
This conditional formatting rule highlights cells that are completely blank.
CONTAINS_ERRORS - Static variable in interface com.aspose.cells.FormatConditionType
This conditional formatting rule highlights cells with formula errors.
CONTAINS_TEXT - Static variable in interface com.aspose.cells.FormatConditionType
This conditional formatting rule highlights cells containing given text.
CONTEXT - Static variable in interface com.aspose.cells.TextDirectionType
Decided by context.
convertCellIndexToName(int, int) - Static method in class com.aspose.cells.CellsHelper
Gets the cell name corresponds to it's row index and column index.
convertCellNameToIndex(String) - Static method in class com.aspose.cells.CellsHelper
Gets the row index and column index of a cell corresponds to it's name.
convertColumnIndexToName(int) - Static method in class com.aspose.cells.CellsHelper
Gets the column name corresponds to the column index.
convertColumnNameToIndex(String) - Static method in class com.aspose.cells.CellsHelper
Gets the column index corresponds to the column name.
convertExcelSerialDate(int) - Static method in class com.aspose.cells.CellsHelper
Converts Excel serial date to a Calendar object.
convertExcelSerialDate(double) - Static method in class com.aspose.cells.CellsHelper
Converts Excel serial date to a Calendar object.
copy(Color) - Method in class com.aspose.cells.Color
Copies component values from another color.
copy() - Method in class com.aspose.cells.LightCell
create a new copy of this object.
copy(Style) - Method in class com.aspose.cells.Style
Copies from another style.
copy(Workbook) - Method in class com.aspose.cells.Workbook
Copys contents and formats from another workbook.
copy(Worksheet) - Method in class com.aspose.cells.Worksheet
Copys contents and formats from another worksheet.
copyCellRange(Cells, int, int, int, int, int, int) - Method in class com.aspose.cells.Cells
Copys data and formattings of cells in given range.
copyColumn(Cells, int, int) - Method in class com.aspose.cells.Cells
Copys data and formattings of a whole column.
copyRow(Cells, int, int) - Method in class com.aspose.cells.Cells
Copys data and formattings of a whole column.
Cork - Static variable in interface com.aspose.cells.TextureType
Represents Cork texture type.
CORNER - Static variable in interface com.aspose.cells.LegendPositionType
Displays the legend to the corner of the chart's plot area.
COUNT - Static variable in interface com.aspose.cells.ConsolidationFunction
Represents Count function.
COUNT - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents Count subtotal type.
COUNT_NUMS - Static variable in interface com.aspose.cells.ConsolidationFunction
Represents Count Nums function.
COUNT_NUMS - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents Count Nums subtotal type.
CountryCode - Interface in com.aspose.cells
Represents Excel country identifiers.
createNamedRange(String, String, String) - Method in class com.aspose.cells.Cells
Creates a NamedRange object from a range of cells.
createNamedRange(String, int, int, int, int) - Method in class com.aspose.cells.Cells
Creates a Range object from a range of cells.
createNamedRange(String, int, int, boolean) - Method in class com.aspose.cells.Cells
Creates a NamedRange object from a range of cells.
createSheet() - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.addSheet().
createSheet(String) - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.addSheet(String).
createStyle() - Method in class com.aspose.cells.Workbook
Creates a new style.
CROSS - Static variable in interface com.aspose.cells.TickMarkerType
Tick mark type is Cross.
CSV - Static variable in interface com.aspose.cells.FileFormatType
Represents a CSV file.
CUSTOM - Static variable in interface com.aspose.cells.ChartSplitType
Represents custom split way
CUSTOM - Static variable in interface com.aspose.cells.ErrorBarType
Custom.
CUSTOM - Static variable in interface com.aspose.cells.LabelPositionType
Position moved by user.
CUSTOM - Static variable in interface com.aspose.cells.PrintSizeType
Custom
CUSTOM - Static variable in interface com.aspose.cells.SparklineAxisMinMaxType
Custom value for sparkline.
CUSTOM - Static variable in interface com.aspose.cells.SparklinePresetStyleType
No preset style.
CUSTOM - Static variable in interface com.aspose.cells.ValidationType
Custom validation type.
CustomDocumentProperties - Class in com.aspose.cells
Represents a collection of custom document properties.
customFilter(int, byte, String) - Method in class com.aspose.cells.AutoFilter
Filters a list with custom criterias.
CYAN - Static variable in class com.aspose.cells.Color
The color cyan.
CYLINDER - Static variable in interface com.aspose.cells.Bar3DShapeType
 
CYLINDER - Static variable in interface com.aspose.cells.ChartType
Represents Cylinder Chart.
CYLINDER_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 100% Stacked Cylinder Chart.
CYLINDER_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents Stacked Cylinder Chart.
CYLINDERICAL_BAR - Static variable in interface com.aspose.cells.ChartType
Represents Cylinderical Bar Chart.
CYLINDERICAL_BAR_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 100% Stacked Cylinderical Bar Chart.
CYLINDERICAL_BAR_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents Stacked Cylinderical Bar Chart.
CYLINDERICAL_COLUMN_3D - Static variable in interface com.aspose.cells.ChartType
Represents 3D Cylinderical Column Chart.

A B C D E F G H I J L M N O P Q R S T U V W X Y Z