Home
Products
Purchase
Downloads
Demos
Forums
Blogs
Ticket
Wiki
API
Corporate
Package
Class
Tree
Deprecated
Index
Help
PREV LETTER
NEXT LETTER
FRAMES
NO FRAMES
All Classes
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.
Package
Class
Tree
Deprecated
Index
Help
PREV LETTER
NEXT LETTER
FRAMES
NO FRAMES
All Classes
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
See Also:
We guarantee a prompt response to any inquiry!