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

A

ABOVE - Static variable in interface com.aspose.cells.LabelPositionType
Only for Line, Bubble, or Scatter chart group.
ABOVE_AVERAGE - Static variable in interface com.aspose.cells.FormatConditionType
This conditional formatting rule highlights cells that are above or below the average for all values in the range.
AboveAverage - Class in com.aspose.cells
Describes the AboveAverage conditional formatting rule.
AboveAverage() - Constructor for class com.aspose.cells.AboveAverage
 
add(CFValueObject) - Method in class com.aspose.cells.CFValueObjectCollection
Adds a CFValueObject to the collection.
add(int, int, int, int, int) - Method in class com.aspose.cells.Charts
Deprecated. replaced by Charts.addChart(int, int, int, int, int)
add(int, int, int, int, int, int, int) - Method in class com.aspose.cells.Charts
Deprecated. replaced by Charts.addChart(int, int, int, int, int, int, int)
add(int, int) - Method in class com.aspose.cells.Comments
Deprecated. replaced by Shapes.addComment(int, int)
add(String) - Method in class com.aspose.cells.Comments
Deprecated. replaced by Shapes.addComment(String)
add() - Method in class com.aspose.cells.ConditionalFormattings
Adds an empty FormatConditions object to the ConditionalFormattings.
add(CellArea, int, int, String, String) - Method in class com.aspose.cells.ConditionalFormattings
Adds an FormatConditions object to the ConditionalFormattings.
add(String, String) - Method in class com.aspose.cells.CustomDocumentProperties
Creates a new custom document property of the PropertyType.String data type.
add(String, int) - Method in class com.aspose.cells.CustomDocumentProperties
Creates a new custom document property of the PropertyType.Number data type.
add(String, Date) - Method in class com.aspose.cells.CustomDocumentProperties
Creates a new custom document property of the PropertyType.DateTime data type.
add(String, boolean) - Method in class com.aspose.cells.CustomDocumentProperties
Creates a new custom document property of the PropertyType.Boolean data type.
add(String, double) - Method in class com.aspose.cells.CustomDocumentProperties
Creates a new custom document property of the PropertyType.Float data type.
add(String) - Method in class com.aspose.cells.HPageBreaks
Adds a horizontal page break to the HPageBreaks.
add(int) - Method in class com.aspose.cells.HPageBreaks
Adds a horizontal page break to the HPageBreaks.
add(int, int, int, int, String, String, String) - Method in class com.aspose.cells.Hyperlinks
Adds a hyperlink to a specified cell or a range of cells.
add(String, String, String, String, String) - Method in class com.aspose.cells.Hyperlinks
Adds a hyperlink to a specified cell or a range of cells.
add(String, int, int, String, String, String) - Method in class com.aspose.cells.Hyperlinks
Adds a hyperlink to a specified cell or a range of cells.
add(CellArea, String, String, String) - Method in class com.aspose.cells.Hyperlinks
Adds a hyperlink to a specified cell or a range of cells.
add() - Method in class com.aspose.cells.NSeries
Adds an empty ASeries object to a chart.
add(String, boolean) - Method in class com.aspose.cells.NSeries
Adds the Series Collection to a chart.
add(int, int, int, int, String) - Method in class com.aspose.cells.Pictures
Deprecated. Replaced by Shapes.addPicture(int, int, int, int, String)
add(int, int, int, int, InputStream) - Method in class com.aspose.cells.Pictures
Deprecated. Replaced by Shapes.addPicture(int, int, int, int, InputStream)
add(int, int, InputStream, int, int) - Method in class com.aspose.cells.Pictures
Deprecated. Replaced by Shapes.addPicture(int, int, InputStream, int, int)
add(int, int, String, int, int) - Method in class com.aspose.cells.Pictures
Deprecated. Replaced by Shapes.addPicture(int, int, String, int, int)
add(int, int, InputStream) - Method in class com.aspose.cells.Pictures
Deprecated. Replaced by Shapes.addPicture(int, int, InputStream)
add(int, int, String) - Method in class com.aspose.cells.Pictures
Deprecated. Replaced by Shapes.addPicture(int, int, String)
add(PivotField) - Method in class com.aspose.cells.PivotFields
Adds a PivotField Object to the specific type PivotFields.
add(String, String, String) - Method in class com.aspose.cells.PivotTables
Adds a new PivotTable object to the collection.
add(String, int, int, String) - Method in class com.aspose.cells.PivotTables
Adds a new PivotTable object to the collection.
add(PivotTable, String, String) - Method in class com.aspose.cells.PivotTables
Adds a new PivotTable Object to the collection from another PivotTable.
add(PivotTable, int, int, String) - Method in class com.aspose.cells.PivotTables
Adds a new PivotTable Object to the collection from another PivotTable.
add(String[], boolean, PivotPageFields, String, String) - Method in class com.aspose.cells.PivotTables
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
add(String[], boolean, PivotPageFields, int, int, String) - Method in class com.aspose.cells.PivotTables
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
add(int, String, boolean, CellArea) - Method in class com.aspose.cells.SparklineGroupCollection
Adds an SparklineGroup item to the collection.
add(int, int, int, int) - Method in class com.aspose.cells.TextBoxes
Deprecated. replaced by Shapes.addTextBox(int, int, int, int, int, int)
add(int, int, int, int, int, int) - Method in class com.aspose.cells.TextBoxes
Deprecated. replaced by Shapes.addTextBox(int, int, int, int, int, int)
add(int, int, int, String, String) - Method in class com.aspose.cells.Validations
Adds a data validation to the Validations.
add() - Method in class com.aspose.cells.Validations
Adds an empty data validation to the Validations.
add(String) - Method in class com.aspose.cells.VPageBreaks
Adds a vertical page break to the VPageBreaks.
add(int) - Method in class com.aspose.cells.VPageBreaks
Adds a vertical page break to the VPageBreaks.
addArc(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Add an Arc to this collection
addArea(CellArea) - Method in class com.aspose.cells.FormatConditions
Adds a conditional formatted cell range.
addButton(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a button to the collection.
addByBaseIndex(int) - Method in class com.aspose.cells.PivotFields
Adds a PivotField Object to the specific type PivotFields.
addCalculatedField(String, String, boolean) - Method in class com.aspose.cells.PivotTable
Adds a calclulated field to pivot field.
addCellArea(CellArea) - Method in class com.aspose.cells.Validation
Adds an affected cell range to cell range address list .
addChart(int, int, int, int, int) - Method in class com.aspose.cells.Charts
Adds a chart to the collection.
addChart(int, int, int, int, int, int, int) - Method in class com.aspose.cells.Charts
Adds a chart to the collection.
addCheckBox(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a checkbox to the collection.
addComboBox(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a combobox to the collection.
addComment(int, int) - Method in class com.aspose.cells.Shapes
Adds a comment to the collection.
addComment(int, int, byte) - Method in class com.aspose.cells.Shapes
Adds a comment to the collection and sets its placement as given type.
addComment(String) - Method in class com.aspose.cells.Shapes
Adds a comment to the collection.
addCopy(Shape) - Method in class com.aspose.cells.Shapes
Copies a shape and adds the copied one to the collection.
addCopy(int) - Method in class com.aspose.cells.Worksheets
Adds a worksheet to the collection and copys data from an existed worksheet.
addCopy(String) - Method in class com.aspose.cells.Worksheets
Adds a worksheet to the collection and copys data from an existed worksheet.
addFieldToArea(byte, int) - Method in class com.aspose.cells.PivotTable
Adds the field to the specific area.
addFieldToArea(byte, PivotField) - Method in class com.aspose.cells.PivotTable
Adds the field to the specific area.
addFormatCondition(CellArea, int, int, String, String) - Method in class com.aspose.cells.FormatConditions
Adds a formatting condition and effected cell rang to the FormatConditions.
addFormatCondition(int) - Method in class com.aspose.cells.FormatConditions
Add a format condition.
addFormatCondition(int, int, String, String) - Method in class com.aspose.cells.FormatConditions
Adds a formatting condition.
addGroupBox(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a groupbox to the collection.
addHyperlink(String) - Method in class com.aspose.cells.Shape
Adds a hyperlink to the mso drawing object.
addIdentify(int, int[]) - Method in class com.aspose.cells.PivotPageFields
Sets which item label in each page field to use to identify the data range.
addInChart(int, int, int, int) - Method in class com.aspose.cells.TextBoxes
Deprecated. replaced by Shapes.addTextBoxInChart(int, int, int, int)
addLabel(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a label to the collection.
addLine(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Add a line to this collection.
addListBox(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a list box to the collection.
addOleObject(int, int, int, int, byte[], byte[]) - Method in class com.aspose.cells.Shapes
Embed an OleObject in this collection.
addOleObject(int, int, int, int, byte[], byte[], byte, String) - Method in class com.aspose.cells.Shapes
Embed an OleObject in this collection.
addOleObject(int, int, int, int, InputStream, InputStream, byte, String) - Method in class com.aspose.cells.Shapes
Embed an OleObject in this collection.
addOval(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Add an Oval to this collection
addPageBreaks(String) - Method in class com.aspose.cells.Worksheet
Adds a page break to the worksheet.
addPageBreaks(int, int) - Method in class com.aspose.cells.Worksheet
Adds a page break to the worksheet.
addPageField(String[]) - Method in class com.aspose.cells.PivotPageFields
Adds a page field.
addPicture(boolean, int, String) - Method in class com.aspose.cells.PageSetup
Add a picture to header/footer.
addPicture(boolean, int, InputStream) - Method in class com.aspose.cells.PageSetup
Add a picture to header/footer.
addPicture(int, int, int, int, String) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPicture(int, int, int, int, InputStream) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPicture(int, int, InputStream, int, int) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPicture(int, int, String, int, int) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPicture(int, int, InputStream) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPicture(int, int, String) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPictureInChart(int, int, int, int, InputStream) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addPictureInChart(int, int, int, int, String) - Method in class com.aspose.cells.Shapes
Adds a picture to the collection.
addRadioButton(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a radio button to the collection.
addRectangle(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Add an Rectangle to this collection
addScrollBar(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a ScrollBar to the collection.
addShape(short, int, int, int, int, int, int, InputStream) - Method in class com.aspose.cells.Shapes
Add a shape to this collection.
addSheet() - Method in class com.aspose.cells.Worksheets
Adds a new worksheet in this workbook.
addSheet(int) - Method in class com.aspose.cells.Worksheets
Adds a new worksheet in this workbook.
addSheet(String) - Method in class com.aspose.cells.Worksheets
Adds a new worksheet in this workbook with the specified sheet name.
addSheet(int, String) - Method in class com.aspose.cells.Worksheets
Adds a new worksheet in this workbook with the specified sheet name.
addSpinner(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a spinner to the collection.
addStop(float, Color, float) - Method in class com.aspose.cells.GradientStops
Adds a Gradient stop to the collection.
addTextBox(int, int, int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a text box to the text boxes collection.
addTextBoxInChart(int, int, int, int) - Method in class com.aspose.cells.Shapes
Adds a text box to the text boxes collection of Chart.
addTrendline(int) - Method in class com.aspose.cells.Trendlines
Adds a object to this collection with specified type.
addTrendline(int, String) - Method in class com.aspose.cells.Trendlines
Adds a object to this collection with specified type and name.
ALL - Static variable in interface com.aspose.cells.PivotItemPosition
Represents All items in one of the pivot page fields in the PivotTable.
ANYVALUE - Static variable in interface com.aspose.cells.ValidationType
Any value validation type.
applyStyle(Style, StyleFlag) - Method in class com.aspose.cells.Cell
Applies formattings for a cell.
applyStyle(Style, StyleFlag, int, int, int, int) - Method in class com.aspose.cells.Cells
Applies formattings for a range of cells.
applyStyle(Style, StyleFlag) - Method in class com.aspose.cells.Column
Applies formattings for a whole column.
applyStyle(Style, StyleFlag) - Method in class com.aspose.cells.Row
Applies formattings for a whole row.
ARC - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the oval shape type
ArcShape - Class in com.aspose.cells
 
Area - Class in com.aspose.cells
Encapsulates the object that represents a chart area.
AREA - Static variable in interface com.aspose.cells.BubbleSizeRepresents
Represents the size is area.
AREA - Static variable in interface com.aspose.cells.ChartType
Represents Area Chart.
AREA_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 100% Stacked Area Chart.
AREA_3D - Static variable in interface com.aspose.cells.ChartType
Represents 3D Area Chart.
AREA_3D_100PERCENT_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 3D 100% Stacked Area Chart.
AREA_3D_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents 3D Stacked Area Chart.
AREA_STACKED - Static variable in interface com.aspose.cells.ChartType
Represents Stacked Area Chart.
ARROW - Static variable in interface com.aspose.cells.MsoLineEndType
Line end type: ARROW
ARROW_DIAMOND - Static variable in interface com.aspose.cells.MsoLineEndType
Line end type: ARROW_DIAMOND
ARROW_OPEN - Static variable in interface com.aspose.cells.MsoLineEndType
Line end type: ARROW_OPEN
ARROw_OVAL - Static variable in interface com.aspose.cells.MsoLineEndType
Line end type: ARROW_OVAL
ARROW_STEALTH - Static variable in interface com.aspose.cells.MsoLineEndType
Line end type: ARROW_STEALTH
ASCENDING - Static variable in interface com.aspose.cells.SortOrderType
Presents ascending sort order type.
ASeries - Class in com.aspose.cells
Encapsulates the object that represents a single data series in a chart.
ASPOSE_PDF - Static variable in interface com.aspose.cells.FileFormatType
Represents an aspose pdf xml file.
AsposeDataTable - Interface in com.aspose.cells
Represts the data table.It's used for smart marker.
AsposeLicenseException - Exception in com.aspose.cells
This exception is thrown if any errors with license are detected.
AsposeLicenseException() - Constructor for exception com.aspose.cells.AsposeLicenseException
Creates a new AsposeLicenseException.
AsposeLicenseException(String) - Constructor for exception com.aspose.cells.AsposeLicenseException
Creates a new AsposeLicenseException with a message string.
AsposeLicenseException(String, Throwable) - Constructor for exception com.aspose.cells.AsposeLicenseException
Creates a new AsposeLicenseException with a message string and a reason.
AsposeLicenseException(Throwable) - Constructor for exception com.aspose.cells.AsposeLicenseException
Creates a new AsposeLicenseException with a reason.
AUTO - Static variable in interface com.aspose.cells.DataLabelsSeparatorType
 
AUTO - Static variable in interface com.aspose.cells.LabelPositionType
Auto position.
AUTO - Static variable in interface com.aspose.cells.LineCapType
Automatic: cap type will be determined by Excel automatically.
AUTO_INDIVIDUAL - Static variable in interface com.aspose.cells.SparklineAxisMinMaxType
Automatic for each sparkline.
AutoFilter - Class in com.aspose.cells
Represents autofiltering for the specified worksheet.
autoFitColumn(int, int, int) - Method in class com.aspose.cells.Worksheet
Autofits the column width.
autoFitColumn(int) - Method in class com.aspose.cells.Worksheet
Autofits the column width.
autoFitColumns(int, int, int, int) - Method in class com.aspose.cells.Worksheet
Autofits columns width in a rectangle range.
autoFitColumns(int, int) - Method in class com.aspose.cells.Worksheet
Autofits columns width from startColumn to endColumn.
autoFitColumns() - Method in class com.aspose.cells.Worksheet
Autofits all columns width in this worksheet.
autoFitRow(int, int, int) - Method in class com.aspose.cells.Worksheet
Autofits the row height.
autoFitRow(int) - Method in class com.aspose.cells.Worksheet
Autofits the row height.
autoFitRows(int, int, int, int) - Method in class com.aspose.cells.Worksheet
Autofits rows height in a rectangle range.
autoFitRows(int, int) - Method in class com.aspose.cells.Worksheet
Autofits rows height from startRow to endRow.
autoFitRows() - Method in class com.aspose.cells.Worksheet
Autofits all rows height in this worksheet.
autoLayout() - Method in class com.aspose.cells.PlotArea
The components in chart, such as, plot area, legend, title etc.
AUTOMATIC - Static variable in interface com.aspose.cells.BackgroundMode
 
AUTOMATIC - Static variable in interface com.aspose.cells.CalculationMode
automatically (default)
AUTOMATIC - Static variable in interface com.aspose.cells.ChartMarkerType
Automatic markers.
AUTOMATIC - Static variable in interface com.aspose.cells.FillType
Represents automatic formatting type.
AUTOMATIC - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents Automatic subtotal type.
AUTOMATIC_SCALE - Static variable in interface com.aspose.cells.CategoryType
 
AVERAGE - Static variable in interface com.aspose.cells.ConsolidationFunction
Represents Average function.
AVERAGE - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents Average subtotal type.
AVI - Static variable in interface com.aspose.cells.OleFileType
Represents the Audio/Video Interleaved file
Axis - Class in com.aspose.cells
Encapsulates the object that represents a chart's axis.

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