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

G

GENERAL - Static variable in exception com.aspose.cells.CellsException
Represents a general error.
GENERAL - Static variable in exception com.aspose.cells.FormulaCalcException
Represents a general error.
GENERAL - Static variable in interface com.aspose.cells.HorizontalAlignmentType
Represents general text alignment.
GERMANY - Static variable in interface com.aspose.cells.CountryCode
 
GERNAL - Static variable in class com.aspose.cells.NumberFormatType
Gernal foramt.
get(int) - Method in interface com.aspose.cells.AsposeDataTable
Returns the value of the designated column in the current row.
get(String) - Method in interface com.aspose.cells.AsposeDataTable
Returns the value of the designated column in the current row.
get(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets a DocumentProperty object by the name of the property.
get(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets a DocumentProperty object by index.
get(int) - Method in class com.aspose.cells.CFValueObjectCollection
Gets the CFValueObject element at the specified index.
get(int) - Method in class com.aspose.cells.Comments
Gets Comment object by index.
get(int) - Method in class com.aspose.cells.ConditionalFormattings
Gets FormatConditions object by index.
get(String) - Method in class com.aspose.cells.CustomDocumentProperties
Returns a DocumentProperty object by the name of the property.
get(int) - Method in class com.aspose.cells.CustomDocumentProperties
Returns a DocumentProperty object by index.
get(int) - Method in class com.aspose.cells.GradientStops
 
get(int) - Method in class com.aspose.cells.HPageBreaks
Gets the HPageBreak object by index.
get(int) - Method in class com.aspose.cells.NSeries
Gets Series object by index.
get(int) - Method in class com.aspose.cells.Pictures
Gets Picture object by index.
get(int) - Method in class com.aspose.cells.PivotFields
Gets the PivotField Object at the specific index.
get(int) - Method in class com.aspose.cells.PivotItems
Gets the pivot item at the specific index.
get(String) - Method in class com.aspose.cells.PivotItems
Gets the pivot item index by the item string value.
get(int) - Method in class com.aspose.cells.PivotTables
Gets the PivotTable report by index.
get(int) - Method in class com.aspose.cells.Shapes
get Shape in collection at given index
get(int) - Method in class com.aspose.cells.SparklineCollection
Gets the sparkline element at the specified index.
get(int) - Method in class com.aspose.cells.SparklineGroupCollection
Gets the SparklineGroup element at the specified index.
get(int) - Method in class com.aspose.cells.TextBoxes
Gets text box object by index.
get(int) - Method in class com.aspose.cells.Trendlines
Gets Trendline object by index.
get(int) - Method in class com.aspose.cells.Validations
Gets validation object by index.
get(int) - Method in class com.aspose.cells.VPageBreaks
Gets the VPageBreak object by index.
getAboveAverage() - Method in class com.aspose.cells.FormatCondition
Gets the conditional formatting's "AboveAverage" instance.
getActiveCell() - Method in class com.aspose.cells.Worksheet
Gets the active cell.
getActiveSheet() - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.getActiveSheet().
getActiveSheet() - Method in class com.aspose.cells.Worksheets
Gets the active sheet.
getActiveSheetIndex() - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.getActiveSheetIndex().
getActiveSheetIndex() - Method in class com.aspose.cells.Worksheets
Gets the active sheet index.
getAddress() - Method in class com.aspose.cells.Hyperlink
Gets the address of the hyperlink
getAlertType() - Method in class com.aspose.cells.Validation
Gets the validation alert style.
getAmount() - Method in class com.aspose.cells.ErrorBars
Gets the error amount.
getArea() - Method in class com.aspose.cells.ASeries
Gets the background area of ASeries object.
getArea() - Method in class com.aspose.cells.Axis
Gets the area of Axis for fill formatting.
getArea() - Method in class com.aspose.cells.ChartFrame
Gets the Area.
getArea() - Method in class com.aspose.cells.ChartPoint
Gets the Area.
getArea() - Method in class com.aspose.cells.DropBar
 
getArea() - Method in class com.aspose.cells.Floor
Gets the Area.
getArea() - Method in class com.aspose.cells.LegendEntry
Gets the Area.
getArea() - Method in class com.aspose.cells.Marker
Gets the area for fill formatting of marker.
getArea() - Method in class com.aspose.cells.Walls
Gets the Area.
getAreaList() - Method in class com.aspose.cells.Validation
Gets a collection of CellArea.
getAreaOrNull() - Method in class com.aspose.cells.ChartFrame
Gets the customed area settings of this frame.
getAssociatedRanges() - Method in class com.aspose.cells.Cell
Gets all the named ranges which contain this cell.
getAuthor() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the name of the document's author.
getAutoFilter() - Method in class com.aspose.cells.Worksheet
Gets autofiltering object for the specified worksheet.
getAutoFormatType() - Method in class com.aspose.cells.PivotTable
Gets the PivotTable atuo format type.
getAutoShowCount() - Method in class com.aspose.cells.PivotField
Gets the number of top or bottom items that are automatically shown in the specified PivotTable field.
getAutoShowField() - Method in class com.aspose.cells.PivotField
Gets auto show field index.
getAutoSortField() - Method in class com.aspose.cells.PivotField
Gets auto sort field index.
getAxisLine() - Method in class com.aspose.cells.Axis
Gets the appearance of an axis.
getBackgroundColor() - Method in class com.aspose.cells.Area
Gets the background Color of the Area.
getBackgroundColor() - Method in class com.aspose.cells.PatternFill
Gets the background Color.
getBackgroundMode() - Method in class com.aspose.cells.Axis
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.ChartArea
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.ChartDataTable
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.DataLabels
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.DisplayUnitLabel
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.Legend
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.LegendEntry
Gets the display mode of the background.
getBackgroundMode() - Method in class com.aspose.cells.Title
Gets the display mode of the background.
getBackgroundTransparency() - Method in class com.aspose.cells.PatternFill
Gets the transparency of background color.
getBackward() - Method in class com.aspose.cells.Trendline
Gets the number of periods (or units on a scatter chart) that the trendline extends backward.
getBarShape() - Method in class com.aspose.cells.ASeries
Get the shape used with the 3D bar or column chart
getBaseField() - Method in class com.aspose.cells.PivotField
Gets the base field for a custom calculation.
getBaseFields() - Method in class com.aspose.cells.PivotTable
Returns a PivotFields object that includes all fields in the PivotTable report.
getBaseItem() - Method in class com.aspose.cells.PivotField
Gets the item in the base field for a custom calculation.
getBaseUnitScale() - Method in class com.aspose.cells.CategoryAxis
Gets the base unit scale for the category axis.
getBeginArrowLengthType() - Method in class com.aspose.cells.Line
Gets the begin arrow length type.
getBeginArrowType() - Method in class com.aspose.cells.Line
Gets the begin type of arrow settings for line style.
getBeginArrowWidthType() - Method in class com.aspose.cells.Line
Gets the begin arrow width type.
getBlue() - Method in class com.aspose.cells.Color
Gets the blue component value.
getBorder() - Method in class com.aspose.cells.ASeries
Gets the line or border of ASeries object.
getBorder() - Method in class com.aspose.cells.ChartDataTable
Gets a Line object that represents the border of the chart data table.
getBorder() - Method in class com.aspose.cells.ChartFrame
Gets the border Line.
getBorder() - Method in class com.aspose.cells.ChartPoint
Gets the border Line.
getBorder() - Method in class com.aspose.cells.DropBar
 
getBorder() - Method in class com.aspose.cells.ErrorBars
Gets the line or border of ErrorBars object.
getBorder() - Method in class com.aspose.cells.Floor
Gets the border Line.
getBorder() - Method in class com.aspose.cells.LegendEntry
Gets the border Line.
getBorder() - Method in class com.aspose.cells.Walls
Gets the border Line.
getBorderColor(int) - Method in class com.aspose.cells.Style
Gets the color of the specified border.
getBorderLine(int) - Method in class com.aspose.cells.Style
Gets the border line type of the specified boder.
getBorderOrNull() - Method in class com.aspose.cells.ChartFrame
Gets the customed border settings of this frame.
getBottomMargin() - Method in class com.aspose.cells.PageSetup
Gets the size of the bottom margin, in unit of centimeters.
getBottomMarginInch() - Method in class com.aspose.cells.PageSetup
Gets the size of the bottom margin, in unit of inches.
getBubbleScale() - Method in class com.aspose.cells.ASeries
Gets the scale factor for bubbles in the specified chart group.
getBubbleSizeRepresents() - Method in class com.aspose.cells.ASeries
Gets what the bubble size represents on a bubble chart.
getBubbleSizes() - Method in class com.aspose.cells.ASeries
Gets the size data for the bubble chart.
getBuiltInDocumentProperties() - Method in class com.aspose.cells.Worksheets
Returns a DocumentProperties collection that represents all the built-in document properties of the spreadsheet.
getBytes() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of bytes in the excel file.
getCalculationMode() - Method in class com.aspose.cells.Workbook
Returns the calculation mode.
getCapType() - Method in class com.aspose.cells.Line
Gets the cap type for line style.
getCategory() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the category of the document.
getCategoryAxis() - Method in class com.aspose.cells.Chart
Gets the chart's category axis.
getCategoryData() - Method in class com.aspose.cells.NSeries
Gets the range of category Axis values.
getCategoryType() - Method in class com.aspose.cells.CategoryAxis
Gets the category axis type.
getCell(int, int) - Method in class com.aspose.cells.Cells
Gets the cell object with the specified row index and column index.
getCell(String) - Method in class com.aspose.cells.Cells
Gets the cell object by the cell name(like "A1").
getCell(int, int) - Method in class com.aspose.cells.NamedRange
Gets Cell object in this range.
getCell(int, int) - Method in class com.aspose.cells.Range
Gets Cell object in this range.
getCell(int) - Method in class com.aspose.cells.Row
Gets the cell at the specified column index.
getCell(int, int) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getCell(int,int)
getCell(String) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getCell(String)
getCellArea(int) - Method in class com.aspose.cells.FormatConditions
Gets the conditional formatted cell range by index.
getCellArea() - Method in class com.aspose.cells.Hyperlink
Gets cell range of all cells containing the hyperlink.
getCellIterator() - Method in class com.aspose.cells.Cells
Returns an iterator which can iterate all defined cells in this worksheet.
getCellIterator() - Method in class com.aspose.cells.Row
Returns an iterator which can iterate all defined cells in this row.
getCells() - Method in class com.aspose.cells.Cell
Gets the parent cells of the cell.
getCells(int, int, int, int, boolean) - Method in class com.aspose.cells.Cells
Gets two dimensional array of all the cells(Cell object) in given range.
getCells(int, int, int, int) - Method in class com.aspose.cells.Cells
Gets two dimensional array of all the cells(Cell object) in given range.
getCells() - Method in class com.aspose.cells.NamedRange
Gets all cells in the range.
getCells() - Method in class com.aspose.cells.Range
Gets all cells in the range.
getCells() - Method in class com.aspose.cells.Worksheet
Gets a collection of Cell objects.
getCellStyle(int, int) - Method in class com.aspose.cells.Cells
Gets the cell's Style by the specified row index and column index.
getCenterFooter() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the center section footer of an Workbook file.
getCenterHeader() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the center section header of an Workbook file.
getCFValueObjectCollection() - Method in class com.aspose.cells.IconSet
Gets the CFValueObjects instance.
getCharacters() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of characters in the excel file.
getCharacters() - Method in class com.aspose.cells.Cell
Gets the rich text settings of a cell.
getCharacters() - Method in class com.aspose.cells.Shape
Gets rich text formatting of this Shape.
getCharacters() - Method in class com.aspose.cells.Title
Gets rich text formatting of this Title.
getCharactersWithSpaces() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of characters (including spaces) in the excel file.
getChart(int) - Method in class com.aspose.cells.Charts
Gets chart object by index.
getChart() - Method in class com.aspose.cells.ChartShape
Gets the Chart this Shape represents.
getChartArea() - Method in class com.aspose.cells.Chart
Gets the chart area in the worksheet.
getChartDataTable() - Method in class com.aspose.cells.Chart
Gets chart data table.
getChartPoint(int) - Method in class com.aspose.cells.ChartPoints
Gets ChartPoint Object by index.
getChartPoints() - Method in class com.aspose.cells.ASeries
Gets the collection of points in a series in a chart.
getCharts() - Method in class com.aspose.cells.Worksheet
Gets a Charts collection.
getChartShape() - Method in class com.aspose.cells.Chart
Gets the Shape object of this Chart.
getCheckValue() - Method in class com.aspose.cells.CheckBox
Gets checkbox' value.
getCode() - Method in exception com.aspose.cells.CellsException
Gets the exception code.
getCode() - Method in exception com.aspose.cells.FormulaCalcException
Gets the exception code.
getColor() - Method in class com.aspose.cells.DataBar
Gets this DataBar's Color.
getColor() - Method in class com.aspose.cells.Font
Gets the font color.
getColor() - Method in class com.aspose.cells.GradientStop
Gets the Color of this gradient stop.
getColor() - Method in class com.aspose.cells.Line
Gets the Color of the line.
getColor(int) - Method in class com.aspose.cells.Palette
Gets the color in the palette at the specified index(0-55).
getColor() - Method in class com.aspose.cells.ShapeFill
Gets the fill color of the shape.
getColor() - Method in class com.aspose.cells.ShapeLine
Gets the border line color of the shape.
getColor() - Method in class com.aspose.cells.Style
Gets the cell shading color.
getColor1() - Method in class com.aspose.cells.FillFormat
Gets the gradient color 1 or the pattern foreground color for the the specified fill.
getColor1() - Method in class com.aspose.cells.GradientFill
Gets the gradient color 1.
getColor2() - Method in class com.aspose.cells.FillFormat
Gets the gradient color 2 or the pattern foreground color for the the specified fill.
getColor2() - Method in class com.aspose.cells.GradientFill
Gets the gradient color 2.
getColors() - Method in class com.aspose.cells.Palette
Gets all colors in the palette.
getColorScale() - Method in class com.aspose.cells.FormatCondition
Gets the conditional formatting's "ColorScale" instance.
getColumn(int) - Method in class com.aspose.cells.Cells
Gets the column at the given column index.
getColumn(int) - Method in class com.aspose.cells.Columns
Gets a column object by its index.
getColumn() - Method in class com.aspose.cells.Comment
Gets the column index of the comment.
getColumn() - Method in class com.aspose.cells.Sparkline
Gets the column index of the sparkline.
getColumn() - Method in class com.aspose.cells.VPageBreak
Gets column index, zero based.
getColumnFields() - Method in class com.aspose.cells.PivotTable
Returns a PivotFields object that are currently shown as column fields.
getColumnIndex() - Method in class com.aspose.cells.Cell
Gets the column index of the cell.
getColumnIndex() - Method in class com.aspose.cells.LightCell
Gets the column index of the cell.
getColumnRange() - Method in class com.aspose.cells.PivotTable
Returns a CellArea object that represents the range that contains the column area in the PivotTable report.
getColumns() - Method in interface com.aspose.cells.AsposeDataTable
Gets the column's name.
getColumns() - Method in class com.aspose.cells.Cells
Gets the collection of Column objects that represents the individual columns in this worksheet.
getColumnStyle(int) - Method in class com.aspose.cells.Worksheet
Gets the style setting for the specified column.
getColumnWidth(int) - Method in class com.aspose.cells.Cells
Gets the width of the column at the given column index, in unit of characters using default font.
getColumnWidth(int) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getColumnWidth(int)
getColumnWidthInch(int) - Method in class com.aspose.cells.Cells
Gets the column width, in unit of inches.
getColumnWidthPixel(int) - Method in class com.aspose.cells.Cells
Gets the column width, in unit of pixels.
getComment(int, int) - Method in class com.aspose.cells.Comments
Gets the Comment for given cell position.
getComment(int, int) - Method in class com.aspose.cells.Shapes
Gets the comment of given cell.
getComments() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the document comments.
getComments() - Method in class com.aspose.cells.Worksheet
Gets the Comments collection.
getCompany() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the company property.
getCompoundType() - Method in class com.aspose.cells.Line
Gets the compound type for line style.
getConditionalFormattings() - Method in class com.aspose.cells.Worksheet
Gets the ConditionalFormattings in the worksheet.
getContent() - Method in class com.aspose.cells.TextBox
Gets the content of textbox.
getContentStatus() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the status of the document.
getContentType() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the content type of the document.
getCopies() - Method in class com.aspose.cells.PageSetup
Gets number of copies to print.
getCount() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets number of items in the collection.
getCount() - Method in class com.aspose.cells.CustomDocumentProperties
Gets number of items in the collection.
getCreatedTime() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets date of the document creation in UTC.
getCropFromBottom() - Method in class com.aspose.cells.Picture
Gets the bottom cropping information.
getCropFromLeft() - Method in class com.aspose.cells.Picture
Gets the left cropping information.
getCropFromRight() - Method in class com.aspose.cells.Picture
Gets the right cropping information.
getCropFromTop() - Method in class com.aspose.cells.Picture
Gets the top cropping information.
getCrossAt() - Method in class com.aspose.cells.CategoryAxis
Gets the point on the category axis where the other axis crosses.
getCrossAt() - Method in class com.aspose.cells.ValueAxis
Gets the point on the value axis where the other axis crosses.
getCurrentPageItem() - Method in class com.aspose.cells.PivotField
Gets the current page item showing for the page field (valid only for page fields).
getCurrentValue() - Method in class com.aspose.cells.Spinner
Gets the current value.
getCustom() - Method in class com.aspose.cells.Style
Gets the custom number format string.
getCustomAmount() - Method in class com.aspose.cells.ErrorBars
Deprecated. replaced by ErrorBars.getPlusValues()
getCustomDocumentProperties() - Method in class com.aspose.cells.Worksheets
Returns a DocumentProperties collection that represents all the custom document properties of the spreadsheet.
getCustomedPointIterator() - Method in class com.aspose.cells.ChartPoints
Gets an iterator to iterate all user customed ChartPoints in this collection.
getDashStyle() - Method in class com.aspose.cells.ShapeLine
Gets the border line dash style of the shape.
getDashType() - Method in class com.aspose.cells.Line
Gets the dash type for line style.
getData() - Method in class com.aspose.cells.Picture
Gets the data of the picture.
getDataBar() - Method in class com.aspose.cells.FormatCondition
Gets the conditional formatting's "DataBar" instance.
getDataBordyRange() - Method in class com.aspose.cells.PivotTable
Returns a CellArea object that represents the range that contains the data area in the list between the header row and the insert row.
getDataDisplayFormat() - Method in class com.aspose.cells.PivotField
Gets how to display the values contained in a data field.
getDataField() - Method in class com.aspose.cells.PivotTable
Gets a PivotField object that represents all the data fields in a PivotTable.
getDataFields() - Method in class com.aspose.cells.PivotTable
Returns a PivotFields object that are currently shown as data fields.
getDataLabels() - Method in class com.aspose.cells.ASeries
Gets the DataLabels object for the specified Series.
getDataLabels() - Method in class com.aspose.cells.ChartPoint
Gets the DataLabels object
getDataLabels() - Method in class com.aspose.cells.Trendline
Gets the DataLabels object for Trendline
getDataLabelsOrNull() - Method in class com.aspose.cells.ChartPoint
Gets the customed DataLabels object of this point.
getDataRange() - Method in class com.aspose.cells.Sparkline
Gets the data range of the sparkline.
getDataSorter() - Method in class com.aspose.cells.Workbook
Gets DataSorter Object
getDateTimeValue() - Method in class com.aspose.cells.Cell
Gets the cell's date time value.
getDateTimeValue() - Method in class com.aspose.cells.PivotItem
Gets the pivot item date time value.
getDefaultColumnWidth() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getStandardWidth()
getDefaultRowHeight() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getStandardHeight()
getDefaultStyle() - Method in class com.aspose.cells.Workbook
Gets the default style of the workbook.
getDependents(boolean) - Method in class com.aspose.cells.Cell
Get all cells which formula depends on this cell.
getDepthPercent() - Method in class com.aspose.cells.Chart
Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
getDestination() - Method in class com.aspose.cells.PdfBookmarkEntry
get the cell to which the bookmark link
getDisplayName() - Method in class com.aspose.cells.PivotField
Gets the PivotField display name.
getDisplayUnitLabel() - Method in class com.aspose.cells.Axis
Get the unit label on an axis.
getDisplayUnitType() - Method in class com.aspose.cells.Axis
Get the unit label type for the specified axis.
getDocumentVersion() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the status of the document.
getDoubleValue() - Method in class com.aspose.cells.Cell
Gets the cell's double value.
getDoubleValue() - Method in class com.aspose.cells.PivotItem
Gets the pivot item double value.
getDoughnutHoleSize() - Method in class com.aspose.cells.ASeries
Gets the size of the hole in a doughnut chart group.
getDownBar() - Method in class com.aspose.cells.ASeries
Get the DropBar object that represents the down bar on a line chart
getDropDownLines() - Method in class com.aspose.cells.ComboBox
Gets the number of list lines displayed in the drop-down portion of a combo box.
getDropLine() - Method in class com.aspose.cells.ASeries
Get the Line object that represents the drop line for a series on the line chart or area chart.
getElevation() - Method in class com.aspose.cells.Chart
Gets the elevation of the 3-D chart view, in degrees(between -90 and 90).
getEncoding() - Method in class com.aspose.cells.OpenOptions
Gets the name of the character encoding being used.
getEncoding() - Method in class com.aspose.cells.SaveOptions
Gets the name of the character encoding being used.
getEndArrowLengthType() - Method in class com.aspose.cells.Line
Gets the end arrow length type.
getEndArrowType() - Method in class com.aspose.cells.Line
Gets the end type of arrow settings for line style.
getEndArrowWidthType() - Method in class com.aspose.cells.Line
Gets the end arrow width type.
getEndColumn() - Method in class com.aspose.cells.CellArea
Gets the column index of the bottom right cell.
getEndColumn() - Method in class com.aspose.cells.NamedRange
Gets the column index of the bottom right cell.
getEndRow() - Method in class com.aspose.cells.CellArea
Gets the row index of the bottom right cell.
getEndRow() - Method in class com.aspose.cells.NamedRange
Gets the row index of the bottom right cell.
getErrorMessage() - Method in class com.aspose.cells.Validation
Gets the data validation error message.
getErrorString() - Method in class com.aspose.cells.PivotTable
Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string.
getErrorTitle() - Method in class com.aspose.cells.Validation
Gets the title of the data-validation error dialog box.
getEscapement() - Method in class com.aspose.cells.Font
Gets the escapement type.
getExplosion() - Method in class com.aspose.cells.ASeries
Get the distance of an open pie slice from the center of the pie chart, expressed as a percentage of the pie diameter.
getExplosion() - Method in class com.aspose.cells.ChartPoint
Get the distance of an open pie slice from the center of the pie chart, expressed as a percentage of the pie diameter.
getExportObjectListener() - Method in class com.aspose.cells.SaveOptions
Gets the ExportObjectListener to receive ExportObjectEvent.
getFamily() - Method in class com.aspose.cells.Font
Gets the font family.
getFashion() - Method in class com.aspose.cells.ImageOptions
Gets the generated image fashion.
getFields(byte) - Method in class com.aspose.cells.PivotTable
Gets the specific fields by the field type.
getFileFormatType() - Method in class com.aspose.cells.Workbook
Gets the file format type after this workbook opens data.
getFileType() - Method in class com.aspose.cells.OleObject
Gets the file type of the embedded ole object data
getFill() - Method in class com.aspose.cells.Area
Gets fill setting of this Area.
getFill() - Method in class com.aspose.cells.Line
Gets the GradientFill or PatternFill when the border is set to gradient or pattern.
getFill() - Method in class com.aspose.cells.Shape
Gets a object that contains fill formatting properties for the specified shape.
getFillFormat() - Method in class com.aspose.cells.Area
Gets a object that contains fill formatting properties for the specified chart or shape.
getFillType() - Method in class com.aspose.cells.Area
Gets fill type for area in chart.
getFirstCellIndex() - Method in class com.aspose.cells.Row
Gets the index of the first defined cell.
getFirstPageNumber() - Method in class com.aspose.cells.PageSetup
Gets the first page number that will be used when this sheet is printed.
getFirstPointColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the first point of data in the sparkline group.
getFirstRowIndex() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getMinRow()
getFirstSliceAngle() - Method in class com.aspose.cells.ASeries
Get the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).
getFirstSliceAngle() - Method in class com.aspose.cells.Chart
Gets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).
getFirstVisibleColumn() - Method in class com.aspose.cells.Worksheet
Gets first visible column index.
getFirstVisibleRow() - Method in class com.aspose.cells.Worksheet
Gets first visible row index.
getFitToPagesTall() - Method in class com.aspose.cells.PageSetup
Gets the number of pages tall the worksheet will be scaled to when it's printed.
getFitToPagesWide() - Method in class com.aspose.cells.PageSetup
Gets the number of pages wide the worksheet will be scaled to when it's printed.
getFloor() - Method in class com.aspose.cells.Chart
Gets a Floor object that represents the walls of a 3-D chart.
getFont() - Method in class com.aspose.cells.Axis
Gets a Font object that represents the font of the specified TickLabels object.
getFont() - Method in class com.aspose.cells.Characters
Gets the font of this object.
getFont() - Method in class com.aspose.cells.ChartArea
Gets a Font object of the chart area.
getFont() - Method in class com.aspose.cells.ChartDataTable
Gets a Font object which represents the font setting of the specified chart data table.
getFont() - Method in class com.aspose.cells.DataLabels
Gets a Font object of the chart data label.
getFont() - Method in class com.aspose.cells.DisplayUnitLabel
Gets a Font object of title.
getFont() - Method in class com.aspose.cells.Legend
Gets a Font object of the chart legend.
getFont() - Method in class com.aspose.cells.LegendEntry
Gets the Font of this LegendEntry.
getFont() - Method in class com.aspose.cells.Shape
Gets the font of text in shape.
getFont() - Method in class com.aspose.cells.Style
Gets the font of the style.
getFont() - Method in class com.aspose.cells.Title
Gets a Font object of title.
getFontPath() - Method in class com.aspose.cells.SaveOptions
Gets the font path(a list of directories containing fonts.
getFooterMargin() - Method in class com.aspose.cells.PageSetup
Gets the distance from the bottom of the page to the footer, in unit of centimeters.
getFooterMarginInch() - Method in class com.aspose.cells.PageSetup
Gets the distance from the bottom of the page to the footer, in unit of inches.
getForegroundColor() - Method in class com.aspose.cells.Area
Gets the foreground Color.
getForegroundColor() - Method in class com.aspose.cells.PatternFill
Gets the foreground Color.
getForegroundTransparency() - Method in class com.aspose.cells.Area
Gets the transparency of foreground color.
getForegroundTransparency() - Method in class com.aspose.cells.PatternFill
Gets the transparency of foreground color.
getFormatCondition(int) - Method in class com.aspose.cells.FormatConditions
Gets the formatting conidition by index.
getFormula() - Method in class com.aspose.cells.Cell
Gets the formula of the cell.
getFormula() - Method in class com.aspose.cells.LightCell
get cell's formula.
getFormula1() - Method in class com.aspose.cells.FormatCondition
Gets the value or expression associated with conditional formatting.
getFormula1() - Method in class com.aspose.cells.Validation
Gets the value or expression associated with the data validation.
getFormula2() - Method in class com.aspose.cells.FormatCondition
Gets the value or expression associated with conditional formatting.
getFormula2() - Method in class com.aspose.cells.Validation
Sets the value or expression associated with the second part of the data validation.
getFormulaRange() - Method in class com.aspose.cells.Cell
Gets the range of array formula or shared formula.
getFormulaRange() - Method in class com.aspose.cells.LightCell
If this cell's formula is the master formula of shared formula, array formula or data table, return the range of cells which the formula applies to.
getFormulaType() - Method in class com.aspose.cells.Cell
Gets the formula's type of this cell.
getFormulaType() - Method in class com.aspose.cells.LightCell
get the formula type.
getForward() - Method in class com.aspose.cells.Trendline
Gets the number of periods (or units on a scatter chart) that the trendline extends forward.
getFrozenInfo() - Method in class com.aspose.cells.Worksheet
Gets info of frozen panes.
getFunction() - Method in class com.aspose.cells.PivotField
Gets the function used to summarize the PivotTable data field.
getGapDepth() - Method in class com.aspose.cells.Chart
Gets the distance between the data series in a 3-D chart, as a percentage of the marker width.
getGapWidth() - Method in class com.aspose.cells.ASeries
Get the space between bar or column clusters, as a percentage of the bar or column width.
getGapWidth() - Method in class com.aspose.cells.Chart
Gets the space between bar or column clusters, as a percentage of the bar or column width.
getGradientColorType() - Method in class com.aspose.cells.FillFormat
Gets the gradient color type for the specified fill.
getGradientColorType() - Method in class com.aspose.cells.GradientFill
Gets the gradient color type for the specified fill.
getGradientDegree() - Method in class com.aspose.cells.FillFormat
Gets the gradient degree for the the specified fill.
getGradientDegree() - Method in class com.aspose.cells.GradientFill
Gets the gradient degree for the the specified fill.
getGradientFillAngle() - Method in class com.aspose.cells.GradientFill
Gets the angle for linear type Gradient fill, in degrees.
getGradientStops() - Method in class com.aspose.cells.GradientFill
Gets the gradient stops collection.
getGradientStyle() - Method in class com.aspose.cells.FillFormat
Gets the gradient style for the specified fill.
getGradientStyle() - Method in class com.aspose.cells.GradientFill
Gets the gradient style for the specified fill.
getGradientType() - Method in class com.aspose.cells.GradientFill
Gets gradient type.
getGradientVariant() - Method in class com.aspose.cells.FillFormat
Gets the gradient variant for the the specified fill.
getGradientVariant() - Method in class com.aspose.cells.GradientFill
Gets the gradient variant for the the specified fill.
getGreen() - Method in class com.aspose.cells.Color
Gets the green component value.
getGroup() - Method in class com.aspose.cells.Shape
get the GroupShape that this shape is in.
getGroupBox() - Method in class com.aspose.cells.RadioButton
Gets the GroupBox that contains this RadioButton.
getGroupMemberIterator() - Method in class com.aspose.cells.RadioButton
Returns an iterator which can iterate all RadioButtons in the same group(GroupBox) with this one(includint this one).
getHAlignment() - Method in class com.aspose.cells.Style
Gets the horizontal alignment type.
getHash(char[]) - Static method in class com.aspose.cells.BIFF7Encrypter
 
getHeaderMargin() - Method in class com.aspose.cells.PageSetup
Gets the distance from the top of the page to the header, in unit of centimeters.
getHeaderMarginInch() - Method in class com.aspose.cells.PageSetup
Gets the distance from the top of the page to the header, in unit of inches.
getHeight() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getHeight()
getHeight() - Method in class com.aspose.cells.Legend
Sets the height of frame, in units of 1/4000 of the chart area.
getHeight() - Method in class com.aspose.cells.PlotArea
Sets the height of the plot area, in units of 1/4000 of the chart area.
getHeight() - Method in class com.aspose.cells.Row
Gets the height of the row in points.
getHeight() - Method in class com.aspose.cells.Shape
Gets the height, in unit of pixel.
getHeightCM() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getHeightCM()
getHeightCM() - Method in class com.aspose.cells.Shape
Gets the height, in unit of centimeters.
getHeightInch() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getHeightInch()
getHeightInch() - Method in class com.aspose.cells.Shape
Gets the height, in unit of inches.
getHeightInChart() - Method in class com.aspose.cells.Shape
Gets the height, in units of 1/4000 of the chart area.
getHeightPercent() - Method in class com.aspose.cells.Chart
Gets the height of a 3-D chart as a percentage of the chart width(between 5 and 500 percent).
getHeightScale() - Method in class com.aspose.cells.Picture
Gets the height scale of picture(in unit of 1/100)
getHighPointColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the highest points of data in the sparkline group.
getHiLoLine() - Method in class com.aspose.cells.ASeries
Gets the HiLoLines object that represents the high-low line for a series on a line chart.
getHorizontalAxisColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the horizontal axis in the sparkline group.
getHorizontalAxisDateRange() - Method in class com.aspose.cells.SparklineGroup
Gets the range that contains the date values for the sparkline data.
getHorizontalResolution() - Method in class com.aspose.cells.ImageOptions
Gets the horizontal resolution for generated images, in dots per inch.
getHPageBreaks() - Method in class com.aspose.cells.Worksheet
Get the HPageBreaks in the worksheet.
getHtmlBasePath() - Method in class com.aspose.cells.OpenOptions
Gets the physical path where the html file is saved.
getHtmlExportImagesFolder() - Method in class com.aspose.cells.SaveOptions
Gets the physical folder where images are saved when exporting to HTML format.
getHtmlExportImagesFolderAlias() - Method in class com.aspose.cells.SaveOptions
Gets the name of the folder used to construct image URIs written into an HTML file.
getHyperlink(int) - Method in class com.aspose.cells.Hyperlinks
Gets Hyberlink object by index.
getHyperlink() - Method in class com.aspose.cells.Shape
Gets a hyperlink from the mso drawing object.
getHyperlinks() - Method in class com.aspose.cells.Worksheet
Get the Hyperlinks in the worksheet.
getIconSet() - Method in class com.aspose.cells.FormatCondition
Gets the conditional formatting's "IconSet" instance.
getImageData() - Method in class com.aspose.cells.OleObject
Gets the the image data of this OleObject.
getImageData() - Method in class com.aspose.cells.TextureFill
Gets the picture data for Texture or Picture fill.
getImageFormat() - Method in class com.aspose.cells.ImageOptions
Gets the format for generated Image.
getImageFormat() - Method in class com.aspose.cells.OleObject
Gets the image format of this OleObject.
getImageFormat() - Method in class com.aspose.cells.Picture
Gets the image format of the picture.
getImageFormat() - Method in class com.aspose.cells.TextureFill
Gets the image format of the picture in this fill.
getImageOptions() - Method in class com.aspose.cells.SaveOptions
Gets the settings for generating Images.
getInclude() - Method in class com.aspose.cells.ErrorBars
Gets type of the error bar parts to include.
getIncrementalChange() - Method in class com.aspose.cells.Spinner
Gets the amount that the scroll bar or spinner is incremented a line scroll.
getIndent() - Method in class com.aspose.cells.Style
Gets the indent level.
getIndex() - Method in class com.aspose.cells.Column
Gets the index of this column.
getIndex() - Method in class com.aspose.cells.LegendEntry
Gets the index of this LegendEntry.
getIndex() - Method in class com.aspose.cells.Worksheet
Gets the sheet index.
getInputMessage() - Method in class com.aspose.cells.Validation
Getss the data validation input message.
getInputRange() - Method in class com.aspose.cells.ComboBox
Gets the worksheet range used to fill the specified combo box.
getInputRange() - Method in class com.aspose.cells.ListBox
Gets the worksheet range used to fill the specified combo box.
getInputTitle() - Method in class com.aspose.cells.Validation
Gets the title of the data validation input dialog box.
getInstance(String) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given template file, using default settings.
getInstance(String, LightCellsSettings) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given template file, using default settings.
getInstance(InputStream) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given Excel data stream, using default settings.
getInstance(InputStream, LightCellsSettings) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given Excel data stream, using default settings.
getInstance(String, int) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given template file, using default settings.
getInstance(String, int, int) - Static method in class com.aspose.cells.LightCells
Deprecated. replaced by LightCells.getInstance(String, int, LightCellsSettings)
getInstance(String, int, LightCellsSettings) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given template file, using given settings.
getInstance(InputStream, int) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given Excel data stream, using default settings.
getInstance(InputStream, int, int) - Static method in class com.aspose.cells.LightCells
Deprecated. replaced by LightCells.getInstance(InputStream, int, LightCellsSettings)
getInstance(InputStream, int, LightCellsSettings) - Static method in class com.aspose.cells.LightCells
Get one LightCells to process given Excel data stream, using given settings.
getIntercept() - Method in class com.aspose.cells.Trendline
Gets the point where the trendline crosses the value axis.
getIntValue() - Method in class com.aspose.cells.Cell
Gets the cell's int value.
getItemCount() - Method in class com.aspose.cells.ListBox
Gets the number of items in the list box.
getJoinType() - Method in class com.aspose.cells.Line
Gets the join type for line style.
getKey(char[]) - Static method in class com.aspose.cells.BIFF7Encrypter
 
getKey() - Method in class com.aspose.cells.Cell
Gets the comparable key of this Cell.
getKey() - Method in class com.aspose.cells.ChartPoint
Gets the comparable key of this ChartPoint.
getKey() - Method in class com.aspose.cells.Column
Gets the comparable key of this Column.
getKey() - Method in class com.aspose.cells.LegendEntry
Gets the comparable key of this LegendEntry.
getKey() - Method in class com.aspose.cells.Row
Gets the comparable key of this Row.
getKey1() - Method in class com.aspose.cells.DataSorter
Represents first sorted key's column index.
getKey2() - Method in class com.aspose.cells.DataSorter
Gets second sorted key's column index.
getKey3() - Method in class com.aspose.cells.DataSorter
Gets third sorted key's column index.
getKeywords() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the document keywords.
getLabelPosition() - Method in class com.aspose.cells.DataLabels
Gets the lable position.
getLanguage() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the Language of the document.
getLanguage() - Method in class com.aspose.cells.Workbook
Gets the user interface language of the Workbook version that has saved the file.
getLastCellIndex() - Method in class com.aspose.cells.Row
Gets the index of the last defined cell.
getLastPointColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the last point of data in the sparkline group.
getLastPrinted() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the date when the document was last printed in UTC.
getLastRowIndex() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getMaxRow()
getLastSavedBy() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the name of the last author.
getLastSavedTime() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the time of the last save in UTC.
getLeaderLine() - Method in class com.aspose.cells.ASeries
Get the Leader Line object that represents the leader line for a chart.
getLeft() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getLeft()
getLeft() - Method in class com.aspose.cells.Shape
Gets the horizontal offset of shape from its left column, in unit of pixel.
getLeftCM() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getLeftCM()
getLeftCM() - Method in class com.aspose.cells.Shape
Gets the horizontal offset of shape from its left column, in unit of centimeters.
getLeftFooter() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the left section footer of an Workbook file.
getLeftHeader() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the left section header of an Workbook file.
getLeftInch() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getLeftInch()
getLeftInch() - Method in class com.aspose.cells.Shape
Gets the horizontal offset of shape from its left column, in unit of inches.
getLeftInChart() - Method in class com.aspose.cells.Shape
Gets the horizontal offset of shape from its left column, in units of 1/4000 of the chart area.
getLeftMargin() - Method in class com.aspose.cells.PageSetup
Gets the size of the left margin, in unit of centimeters.
getLeftMarginInch() - Method in class com.aspose.cells.PageSetup
Gets the size of the left margin, in unit of inches.
getLegend() - Method in class com.aspose.cells.Chart
Gets the chart legend.
getLegendEntries() - Method in class com.aspose.cells.Legend
Gets a collection of all the LegendEntry objects in the specified chart legend.
getLegendEntry(int) - Method in class com.aspose.cells.LegendEntries
Gets the LegendEntry at the specified index.
getLength() - Method in class com.aspose.cells.Characters
Gets the character counts start at the start index.
getLine() - Method in class com.aspose.cells.Marker
Gets the line for marker line formatting.
getLine() - Method in class com.aspose.cells.Shape
Gets a object that contains line formatting properties for the shape.
getLine() - Method in class com.aspose.cells.Trendline
Gets the line or border of Trendlines object.
getLineEndArrowHead() - Method in class com.aspose.cells.ArcShape
Gets the end arrow head type
getLineEndArrowHead() - Method in class com.aspose.cells.LineShape
Gets the end arrow head type
getLineEndArrowLengthType() - Method in class com.aspose.cells.ArcShape
Gets the end arrow length
getLineEndArrowLengthType() - Method in class com.aspose.cells.LineShape
Gets the end arrow length
getLineEndArrowWidthType() - Method in class com.aspose.cells.ArcShape
Gets the end arrow width
getLineEndArrowWidthType() - Method in class com.aspose.cells.LineShape
Gets the end arrow width
getLines() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of lines in the document.
getLineStartArrowHead() - Method in class com.aspose.cells.ArcShape
Gets the start arrow head type
getLineStartArrowHead() - Method in class com.aspose.cells.LineShape
Gets the start arrow head type
getLineStartArrowLengthType() - Method in class com.aspose.cells.ArcShape
Gets the start arrow length
getLineStartArrowLengthType() - Method in class com.aspose.cells.LineShape
Gets the start arrow length
getLineStartArrowWidthType() - Method in class com.aspose.cells.ArcShape
Gets the start arrow width
getLineStartArrowWidthType() - Method in class com.aspose.cells.LineShape
Gets the start arrow width
getLineWeight() - Method in class com.aspose.cells.SparklineGroup
Gets the line weight in each line sparkline in the sparkline group, in the unit of points.
getLinkedCell() - Method in class com.aspose.cells.CheckBox
Gets the worksheet range linked to the control's value
getLinkedCell() - Method in class com.aspose.cells.ComboBox
Gets the worksheet range linked to the control's value
getLinkedCell() - Method in class com.aspose.cells.ListBox
Gets the worksheet range linked to the control's value
getLinkedCell() - Method in class com.aspose.cells.RadioButton
Gets the worksheet range linked to the control's value
getLinkedCell() - Method in class com.aspose.cells.Shape
Gets the linked cell of shape.
getLinkedCell() - Method in class com.aspose.cells.Spinner
Gets the worksheet range linked to the control's value
getLogarithmicBase() - Method in class com.aspose.cells.ValueAxis
Gets the base of logarithmic scale.
getLookinType() - Method in class com.aspose.cells.FindOptions
Gets the lookin type.
getLowerRightColumn() - Method in class com.aspose.cells.Shape
Gets the lower right column index.
getLowerRightRow() - Method in class com.aspose.cells.Shape
Gets the lower right row index.
getLowPointColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the lowest points of data in the sparkline group.
getMajorGridLines() - Method in class com.aspose.cells.Axis
Gets major gridlines on a chart axis.
getMajorTickMark() - Method in class com.aspose.cells.Axis
Gets the type of major tick mark for the axis.
getMajorUnit() - Method in class com.aspose.cells.CategoryAxis
Gets the major units for the axis.
getMajorUnit() - Method in class com.aspose.cells.ValueAxis
Gets the major units for the value axis.
getMajorUnitScale() - Method in class com.aspose.cells.CategoryAxis
Gets the major unit scale for the category axis.
getManager() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the manager property.
getMarker() - Method in class com.aspose.cells.ASeries
Gets the Marker settings for line chart, scatter chart, or radar chart.
getMarker() - Method in class com.aspose.cells.ChartPoint
Gets the Marker settings for line chart, scatter chart, or radar chart.
getMarkerBackgroundColor() - Method in class com.aspose.cells.ASeries
Gets the marker backgournd color in a line chart, scatter chart, or radar chart.
getMarkerBackgroundColor() - Method in class com.aspose.cells.ChartPoint
Gets the marker backgournd color in a line chart, scatter chart, or radar chart.
getMarkerForegroundColor() - Method in class com.aspose.cells.ASeries
Gets the marker foregournd color in a line chart, scatter chart, or radar chart.
getMarkerForegroundColor() - Method in class com.aspose.cells.ChartPoint
Gets the marker foregournd color in a line chart, scatter chart, or radar chart.
getMarkersColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of points in each line sparkline in the sparkline group.
getMarkerSize() - Method in class com.aspose.cells.ASeries
Gets the marker size in a line chart, scatter chart, or radar chart.
getMarkerSize() - Method in class com.aspose.cells.ChartPoint
Gets the marker size in a line chart, scatter chart, or radar chart.
getMarkerStyle() - Method in class com.aspose.cells.ASeries
Gets the marker style in a line chart, scatter chart, or radar chart.
getMarkerStyle() - Method in class com.aspose.cells.ChartPoint
Gets the marker style in a line chart, scatter chart, or radar chart.
getMatchType() - Method in class com.aspose.cells.FindOptions
Gets the match type.
getMaxCfvo() - Method in class com.aspose.cells.ColorScale
Gets the max value object.
getMaxCfvo() - Method in class com.aspose.cells.DataBar
Gets this DataBar's max value object.
getMaxColor() - Method in class com.aspose.cells.ColorScale
Gets the max value object's corresponding color.
getMaxColumn() - Method in class com.aspose.cells.Cells
Gets maximum column index of cell which contains data or style.
getMaxDataColumn() - Method in class com.aspose.cells.Cells
Gets maximum column index of cell which contains data.
getMaxDataRow() - Method in class com.aspose.cells.Cells
Returns maximum row index of cell which contains data.
getMaxRow() - Method in class com.aspose.cells.Cells
Returns the last defined row index.
getMaxValue() - Method in class com.aspose.cells.CategoryAxis
Gets the max value of axis.
getMaxValue() - Method in class com.aspose.cells.Spinner
Gets the maximum value of a scroll bar or spinner range.
getMaxValue() - Method in class com.aspose.cells.ValueAxis
Gets the maximum value on the value axis.
getMergedArea() - Method in class com.aspose.cells.Cell
Gets the area that this Cell be merged in.
getMergedCells() - Method in class com.aspose.cells.Cells
Gets the collection of merged cell ranges in the worksheet.
getMergedCells() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getMergedCells()
getMidCfvo() - Method in class com.aspose.cells.ColorScale
Gets this ColorScale's mid value object.
getMidColor() - Method in class com.aspose.cells.ColorScale
Gets the mid value object's corresponding color.
getMinCfvo() - Method in class com.aspose.cells.ColorScale
Gets this ColorScale's min value object.
getMinCfvo() - Method in class com.aspose.cells.DataBar
Gets this DataBar's min value object.
getMinColor() - Method in class com.aspose.cells.ColorScale
Gets the min value object's corresponding color.
getMinColumn() - Method in class com.aspose.cells.Cells
Gets minimum column index of cell which contains data or style.
getMinorGridLines() - Method in class com.aspose.cells.Axis
Gets minor gridlines on a chart axis.
getMinorTickMark() - Method in class com.aspose.cells.Axis
Gets the type of minor tick mark for the axis.
getMinorUnit() - Method in class com.aspose.cells.CategoryAxis
Gets the minor units for the axis.
getMinorUnit() - Method in class com.aspose.cells.ValueAxis
Gets the minor units for the value axis.
getMinorUnitScale() - Method in class com.aspose.cells.CategoryAxis
Gets the minor unit scale for the category axis.
getMinRow() - Method in class com.aspose.cells.Cells
Returns the first defined row index.
getMinusValues() - Method in class com.aspose.cells.ErrorBars
Gets the negative error amount when type is custom.
getMinValue() - Method in class com.aspose.cells.CategoryAxis
Gets the min value of the axis.
getMinValue() - Method in class com.aspose.cells.Spinner
Gets the minimum value of a scroll bar or spinner range.
getMinValue() - Method in class com.aspose.cells.ValueAxis
Gets the minimum value on the value axis.
getName() - Method in class com.aspose.cells.ASeries
Gets the name of the data series.
getName() - Method in class com.aspose.cells.Cell
Gets the name of the cell.
getName() - Method in class com.aspose.cells.DocumentProperty
Gets the name of the property.
getName() - Method in class com.aspose.cells.Font
Gets the font name.
getName() - Method in class com.aspose.cells.PivotField
Gets the PivotField name.
getName() - Method in class com.aspose.cells.PivotTable
Gets the name of the PivotTable
getName() - Method in class com.aspose.cells.Shape
Gets the name of this Shape.
getName() - Method in class com.aspose.cells.Style
Gets the style name.
getName() - Method in class com.aspose.cells.Trendline
Gets the name of the trendline.
getName() - Method in class com.aspose.cells.Worksheet
Returns the name of the worksheet.
getName(String) - Method in class com.aspose.cells.Worksheets
Gets Name object by pre-defined name.
getName(String, boolean) - Method in class com.aspose.cells.Worksheets
Gets Name object by pre-defined name.
getNamedRanges() - Method in class com.aspose.cells.Worksheet
Gets all pre-defined named ranges in the specific worksheet.
getNamedRanges() - Method in class com.aspose.cells.Worksheets
Gets all pre-defined named ranges in the spreadsheet.
getNamedStyle(String) - Method in class com.aspose.cells.Workbook
Gets a style by it's name.
getNamedStyles() - Method in class com.aspose.cells.Workbook
Gets all named styles within the workbook.
getNameOfApplication() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the name of the application.
getNames() - Method in class com.aspose.cells.Worksheets
Gets all pre-defined named ranges in the spreadsheet.
getNegativePointsColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the negative values on the sparkline group.
getNote() - Method in class com.aspose.cells.Comment
Gets the content of comment.
getNSeries() - Method in class com.aspose.cells.Chart
Gets a NSeries object representing the data series in the chart.
getNullString() - Method in class com.aspose.cells.PivotTable
Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string.
getNumber() - Method in class com.aspose.cells.Axis
Gets the format index for the TickLabels object.
getNumber() - Method in class com.aspose.cells.DataLabels
Gets the built-in display format of numbers and dates.
getNumber() - Method in class com.aspose.cells.PivotField
Gets the built-in display format of numbers and dates.
getNumber() - Method in class com.aspose.cells.Style
Gets the built-in display format of numbers and dates.
getNumberFormat() - Method in class com.aspose.cells.Axis
Gets the format string for the TickLabels object.
getNumberFormat() - Method in class com.aspose.cells.DataLabels
Gets the format string for the DataLabels object.
getNumberFormat() - Method in class com.aspose.cells.PivotField
Represents the custom display format of numbers and dates.
getNumberFormatType() - Method in class com.aspose.cells.Style
Gets the number format typ.
getNumberOfSheets() - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.size().
getNumberOfSheets() - Method in class com.aspose.cells.Worksheets
Deprecated. Replaced by size().
getObjectData() - Method in class com.aspose.cells.OleObject
Gets embedded ole object data.
getOnePagePerSheet() - Method in class com.aspose.cells.SaveOptions
Checks whether render one sheet in one pdf page.
getOpenDocumentVersion() - Method in class com.aspose.cells.SaveOptions
Gets the version of Open Document.
getOpenOptions() - Method in class com.aspose.cells.Workbook
Provides options to control how the workbook is opened.
getOperator() - Method in class com.aspose.cells.FormatCondition
Gets the conditional format operator.
getOperator() - Method in class com.aspose.cells.Validation
Gets the operator for the data validation.
getOrder() - Method in class com.aspose.cells.Trendline
Gets the trendline order (between 2 and 6) when the trendline type is Polynomial.
getOrder1() - Method in class com.aspose.cells.DataSorter
Represents sort order of the first key.
getOrder2() - Method in class com.aspose.cells.DataSorter
Gets sort order of the second key.
getOrder3() - Method in class com.aspose.cells.DataSorter
Gets sort order of the third key.
getOrientation() - Method in class com.aspose.cells.PageSetup
Gets page print orientation.
getOrientation() - Method in class com.aspose.cells.Shape
Gets text orientation.
getOriginalHeight() - Method in class com.aspose.cells.Picture
Gets the original height of picture, in unit of pixel.
getOriginalHeightCM() - Method in class com.aspose.cells.Picture
Gets the original height of picture, in unit of centimeters.
getOriginalHeightInch() - Method in class com.aspose.cells.Picture
Gets the original height of picture, in unit of inches.
getOriginalWidth() - Method in class com.aspose.cells.Picture
Gets the original width of picture, in unit of pixel.
getOriginalWidthCM() - Method in class com.aspose.cells.Picture
Gets the original width of picture, in unit of centimeters.
getOriginalWidthInch() - Method in class com.aspose.cells.Picture
Gets the original width of picture, in unit of inches.
getOutline() - Method in class com.aspose.cells.Worksheet
Gets Outline object on a worksheet.
getOverlap() - Method in class com.aspose.cells.ASeries
Specifies how bars and columns are positioned.
getOverlap() - Method in class com.aspose.cells.Chart
Sets the space between bar or column in a cluster, as a percentage of the bar or column width.
getPageChange() - Method in class com.aspose.cells.ScrollBar
 
getPageCount() - Method in class com.aspose.cells.SheetRender
Get the total page count of current worksheet
getPageCount() - Method in class com.aspose.cells.WorkbookRender
Get the total page count of current workbook
getPageFieldOrder() - Method in class com.aspose.cells.PivotTable
Gets the order in which page fields are added to the PivotTable report's layout.
getPageFields() - Method in class com.aspose.cells.PivotTable
Returns a PivotFields object that are currently shown as page fields.
getPageFieldWrapCount() - Method in class com.aspose.cells.PivotTable
Gets the number of page fields in each column or row in the PivotTable report.
getPageNum() - Method in class com.aspose.cells.PdfBookmarkEntry
get the page number of destination cell
getPageOrder() - Method in class com.aspose.cells.PageSetup
Gets the order that Microsoft Workbook uses to number pages when printing a large worksheet.
getPages() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of pages in the document.
getPageSetup() - Method in class com.aspose.cells.Chart
Gets the page setup description in this chart.
getPageSetup() - Method in class com.aspose.cells.Worksheet
Get the page setup options in the worksheet.
getPalette() - Method in class com.aspose.cells.Workbook
Gets the palette of the workbook.
getPaperSize() - Method in class com.aspose.cells.PageSetup
Gets the size of the paper.
getParagraphs() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of paragraphs in the document.
getPassword() - Method in class com.aspose.cells.Protection
Gets the password to protect the worksheet.
getPasswordHash() - Method in class com.aspose.cells.Protection
Gets the password hash.
getPattern() - Method in class com.aspose.cells.FillFormat
Gets an area's display pattern.
getPattern() - Method in class com.aspose.cells.PatternFill
Gets an area's display pattern.
getPatternColor() - Method in class com.aspose.cells.Style
Gets the pattern color.
getPatternStyle() - Method in class com.aspose.cells.Style
Gets the pattern style.
getPdfBookmarkEntry() - Method in class com.aspose.cells.SaveOptions
Gets pdf bookmark.
getPdfCompliance() - Method in class com.aspose.cells.SaveOptions
Gets the compliance for PDF convertion.
getPeriod() - Method in class com.aspose.cells.Trendline
Gets the period for the moving-average trendline.
getPerspective() - Method in class com.aspose.cells.Chart
Gets the perspective for the 3-D chart view.
getPicture(boolean, int) - Method in class com.aspose.cells.PageSetup
Gets the picture of header/footer.
getPictures() - Method in class com.aspose.cells.Worksheet
Gets a Pictures collection.
getPivotItems() - Method in class com.aspose.cells.PivotField
Gets the pivot items in the field.
getPivotSource() - Method in class com.aspose.cells.Chart
Gets the pivot source.
getPivotTables() - Method in class com.aspose.cells.Worksheet
Gets the PivotTables Object which Represents the collection of all the PivotTable objects in the worksheet
getPlacement() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getPlacement()
getPlacement() - Method in class com.aspose.cells.Shape
Gets the way the drawing obejct is attached to the cells below it.
getPlotArea() - Method in class com.aspose.cells.Chart
Gets the chart's plot area.
getPlotEmptyCellsType() - Method in class com.aspose.cells.Chart
Gets the type to plot empty cells as.
getPlotEmptyCellsType() - Method in class com.aspose.cells.SparklineGroup
Gets the type to plot empty cells.
getPlusValues() - Method in class com.aspose.cells.ErrorBars
Gets the negative error amount when type is custom.
getPointIndex() - Method in class com.aspose.cells.ChartPoint
Gets the index of this ChartPoint.
getPosition() - Method in class com.aspose.cells.GradientStop
Gets the stop position.
getPosition() - Method in class com.aspose.cells.Legend
Gets the legend position type.
getPosition() - Method in class com.aspose.cells.PivotField
Get the position of the PivotField int the specific PivotFields.
getPrecedents() - Method in class com.aspose.cells.Cell
Gets all cells or ranges which this cell's formula depends on.
getPresetColor() - Method in class com.aspose.cells.FillFormat
Gets the gradient preset color for the the specified fill.
getPresetColor() - Method in class com.aspose.cells.GradientFill
Gets the gradient preset color.
getPresetStyle() - Method in class com.aspose.cells.SparklineGroup
Gets the preset style type of the sparkline group.
getPrintArea() - Method in class com.aspose.cells.PageSetup
Gets the range to be printed.
getPrintComments() - Method in class com.aspose.cells.PageSetup
Gets the way comments are printed with the sheet.
getPrintErrors() - Method in class com.aspose.cells.PageSetup
Gets the type of print error displayed.
getPrintingPageType() - Method in class com.aspose.cells.ImageOptions
Get the type that indicates which pages will not be printed.
getPrintQuality() - Method in class com.aspose.cells.PageSetup
Gets the print quality.
getPrintSize() - Method in class com.aspose.cells.Chart
Gets the printed chart size.
getPrintTitleColumns() - Method in class com.aspose.cells.PageSetup
Gets the columns that contain the cells to be repeated on the left side of each page.
getPrintTitleRows() - Method in class com.aspose.cells.PageSetup
Gets the rows that contain the cells to be repeated at the top of each page.
getPriority() - Method in class com.aspose.cells.FormatCondition
Gets the priority of this conditional formatting rule.
getProtection() - Method in class com.aspose.cells.Worksheet
Gets the current protection settings.
getQuality() - Method in class com.aspose.cells.ImageOptions
Gets a value determining the quality of the generated images.
getR1C1Formula() - Method in class com.aspose.cells.Cell
Gets a R1C1 formula of the Cell.
getRangeByName(String) - Method in class com.aspose.cells.Worksheets
Gets NamedRange object by pre-defined name.
getRangeByName(String, boolean) - Method in class com.aspose.cells.Worksheets
Gets NamedRange object by pre-defined name.
getRank() - Method in class com.aspose.cells.Top10
Gets the value of "n" in a "top/bottom n" conditional formatting rule.
getRed() - Method in class com.aspose.cells.Color
Gets the red component value.
getRefersTo() - Method in class com.aspose.cells.Name
 
getRefStyle() - Method in class com.aspose.cells.Column
Gets the style setting for the column.
getRefStyle() - Method in class com.aspose.cells.Row
Gets the style setting for the column.
getRegion() - Method in class com.aspose.cells.Workbook
Gets the system regional settings at the time the file was saved.
getReleaseVersion() - Static method in class com.aspose.cells.CellsHelper
Gets the version id.
getRevisionNumber() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the document revision number.
getRightFooter() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the right section footer of an Workbook file.
getRightHeader() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the right section header of an Workbook file.
getRightMargin() - Method in class com.aspose.cells.PageSetup
Gets the size of the right margin, in unit of centimeters.
getRightMarginInch() - Method in class com.aspose.cells.PageSetup
Gets the size of the right margin, in unit of inches.
getRotation() - Method in class com.aspose.cells.Axis
Gets text rotation angle.
getRotation() - Method in class com.aspose.cells.Chart
Gets the rotation of the 3-D chart view (the rotation of the plot area around the series axis, in degrees)(between 0 and 360).
getRotation() - Method in class com.aspose.cells.DataLabels
Gets text rotation angel.
getRotation() - Method in class com.aspose.cells.DisplayUnitLabel
Gets text rotation angel.
getRotation() - Method in class com.aspose.cells.Shape
Gets rotation of shape
getRotation() - Method in class com.aspose.cells.Style
Gets the rotation degrees.
getRotation() - Method in class com.aspose.cells.Title
Gets text rotation angel.
getRow(int) - Method in class com.aspose.cells.Cells
Gets the row at the specified row index.
getRow() - Method in class com.aspose.cells.Comment
Gets the row index of the comment.
getRow() - Method in class com.aspose.cells.HPageBreak
Gets rolumn index, zero based.
getRow(int) - Method in class com.aspose.cells.Rows
Gets the row at the specified row index.
getRow() - Method in class com.aspose.cells.Sparkline
Gets the row index of the sparkline.
getRow(int) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getRow(int)
getRowFields() - Method in class com.aspose.cells.PivotTable
Returns a PivotFields object that are currently shown as row fields.
getRowHeight(int) - Method in class com.aspose.cells.Cells
Gets the height of the row in points.
getRowHeightInch(int) - Method in class com.aspose.cells.Cells
Sets the row height, in inch.
getRowHeightPixel(int) - Method in class com.aspose.cells.Cells
Sets the row height, in pixels.
getRowIndex() - Method in class com.aspose.cells.Cell
Gets the row index of the cell.
getRowIndex() - Method in class com.aspose.cells.LightCell
Gets the row index of the cell.
getRowIndex() - Method in class com.aspose.cells.Row
Gets the row index.
getRowIterator() - Method in class com.aspose.cells.Cells
Returns an iterator which can iterate all defined rows in this worksheet.
getRowIterator(int) - Method in class com.aspose.cells.Cells
Returns an iterator which can iterate all defined rows in this worksheet from the start row index.
getRowIterator() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getRowIterator()
getRowRange() - Method in class com.aspose.cells.PivotTable
Returns a CellArea object that represents the range that contains the row area in the PivotTable report.
getRows() - Method in class com.aspose.cells.Cells
Gets the collection of Row objects that represents the individual rows in this worksheet.
getSaveOptions() - Method in class com.aspose.cells.Workbook
Provides options to control how the workbook is saved.
getScreenTip() - Method in class com.aspose.cells.Hyperlink
Gets screen tip of the hyperlink.
getSearchType() - Method in class com.aspose.cells.FindOptions
Gets the search type.
getSecondCategoryAxis() - Method in class com.aspose.cells.Chart
Gets the chart's second category axis.
getSecondCategoryData() - Method in class com.aspose.cells.NSeries
Gets the range of second category Axis values.
getSecondPlotSize() - Method in class com.aspose.cells.ASeries
Gets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie.
getSecondValueAxis() - Method in class com.aspose.cells.Chart
Gets the chart's second value axis.
getSecondValueXAxis() - Method in class com.aspose.cells.Chart
Gets the chart's second value x axis.Only applies for Scatter and Bubble chart.
getSelectedCell() - Method in class com.aspose.cells.ComboBox
Gets the selected cell in the input range of the combo box.
getSelectedCell() - Method in class com.aspose.cells.ListBox
Gets the selected cell.
getSelectedCells() - Method in class com.aspose.cells.ListBox
Gets the selected cells.
getSelectedIndex() - Method in class com.aspose.cells.ComboBox
Gets the index number of the currently selected item in the combo box.
getSelectedIndex() - Method in class com.aspose.cells.ListBox
Gets the index number of the currently selected item in the list box.
getSelectionType() - Method in class com.aspose.cells.ListBox
Gets the selection mode of the specified list box.
getSeparator() - Method in class com.aspose.cells.DataLabels
Get the separator used for the data labels on a chart.
getSeriesAxis() - Method in class com.aspose.cells.Chart
Gets the chart's series axis.
getSeriesColor() - Method in class com.aspose.cells.SparklineGroup
Gets the color of the sparklines in the sparkline group.
getSeriesLine() - Method in class com.aspose.cells.ASeries
Get the Series Line object that represents the series line for a stacked bar chart or a stacked column chart.
getSeriesNumber() - Method in class com.aspose.cells.ASeries
Gets the series number (as shown in name box -- Sereies1, Sereies2, etc.).
getSettings() - Method in class com.aspose.cells.LightCells
get settings to check or modify advanced cell-process features.
getShapes() - Method in class com.aspose.cells.Chart
Gets the Shapes object which this Chart is in.
getShapes() - Method in class com.aspose.cells.Worksheet
Gets the Shapes object in the worksheet.
getSheet(int) - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.getSheet(int).
getSheet(String) - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.getSheet(String).
getSheet(int) - Method in class com.aspose.cells.Worksheets
Returns the sheet at the specified index.
getSheet(String) - Method in class com.aspose.cells.Worksheets
Gets the sheet with the specified name.
getSheetCount() - Method in class com.aspose.cells.LightCells
get total count of sheet in a workbook
getSheetIndex(String) - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.getSheetIndex(String).
getSheetIndex(String) - Method in class com.aspose.cells.Worksheets
Gets the sheet's index according to its name.
getSheetName(int) - Method in class com.aspose.cells.LightCells
get name of sheet at given index
getSheetName(int) - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.getSheetName(int).
getSheetName(int) - Method in class com.aspose.cells.Worksheets
Returns the name of the sheet at the specified index.
getShowCompact() - Method in class com.aspose.cells.PivotField
Indicates when ShowInOutlineForm is true, whether the application will display fields compactly in the sheet on which this PivotTable resides.
getShowInOutlineForm() - Method in class com.aspose.cells.PivotField
Indicates whether layout this field in outline form on the Pivot Table view.
getShowSubtotalAtTop() - Method in class com.aspose.cells.PivotField
Indicates when ShowInOutlineForm is true, whether the application will display subtotals at the top of the list of items instead of at the bottom.
getSize() - Method in class com.aspose.cells.Font
Gets the font size in points.
getSize() - Method in class com.aspose.cells.Marker
Gets the marker size in a line chart, scatter chart, or radar chart.
getSmartMarkers(int) - Method in class com.aspose.cells.WorkbookDesigner
Gets a collection of smart markers in a spreadsheet.
getSource() - Method in class com.aspose.cells.ExportObjectEvent
Gets the object that contains the data to be saved.
getSourceFullName() - Method in class com.aspose.cells.OleObject
Gets the source full name of the source file for the linked OLE object.
getSourceSheet() - Method in class com.aspose.cells.NamedRange
Gets the worksheet which contains this range.
getSparklineCollection() - Method in class com.aspose.cells.SparklineGroup
Gets the SparklineCollection object of the sparkline group.
getSparklineGroupCollection() - Method in class com.aspose.cells.Worksheet
Gets the sparkline group collection in the worksheet.
getSplitType() - Method in class com.aspose.cells.ASeries
Gets the way the two sections of either a pie of pie chart or a bar of pie chart are split
getSplitValue() - Method in class com.aspose.cells.ASeries
Gets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart.
getStandardHeight() - Method in class com.aspose.cells.Cells
Gets the default row height of the worksheet in points.
getStandardHeightPixels() - Method in class com.aspose.cells.Cells
Gets the default row height of the worksheet in pixels.
getStandardWidth() - Method in class com.aspose.cells.Cells
Returns the default column width of the worksheet, in unit of characters with default font.
getStandardWidthPixels() - Method in class com.aspose.cells.Cells
Returns the default column width of the worksheet, in unit of pixels.
getStartColumn() - Method in class com.aspose.cells.CellArea
Gets the column index of the top left cell.
getStartColumn() - Method in class com.aspose.cells.NamedRange
Gets the column index of the top left cell.
getStartIndex() - Method in class com.aspose.cells.Characters
Gets the start index of characters.
getStartRow() - Method in class com.aspose.cells.CellArea
Gets the row index of the top left cell.
getStartRow() - Method in class com.aspose.cells.NamedRange
Gets the row index of the top left cell.
getStdDev() - Method in class com.aspose.cells.AboveAverage
Gets the number of standard deviations to include above or below the average in the conditional formatting rule.
getStretchOffsetBottom() - Method in class com.aspose.cells.TextureFill
Gets the bottom offset for stretching picture.
getStretchOffsetLeft() - Method in class com.aspose.cells.TextureFill
Gets the left offset for stretching picture.
getStretchOffsetRight() - Method in class com.aspose.cells.TextureFill
Gets the right offset for stretching picture.
getStretchOffsetTop() - Method in class com.aspose.cells.TextureFill
Gets the top offset for stretching picture.
getStringValue() - Method in class com.aspose.cells.Cell
Gets the string value contained in the cell.
getStringValue() - Method in class com.aspose.cells.PivotItem
Gets the pivot item string value.
getStyle() - Method in class com.aspose.cells.Cell
Gets the style of the cell.
getStyle() - Method in class com.aspose.cells.Column
Gets the style setting for the column.
getStyle() - Method in class com.aspose.cells.FormatCondition
Gets style of conditional formatted cell range.
getStyle() - Method in class com.aspose.cells.Line
Gets the style of the line.
getStyle() - Method in class com.aspose.cells.Marker
Gets the marker style in a line chart, scatter chart, or radar chart.
getStyle() - Method in class com.aspose.cells.Row
Gets the style of the row.
getStyle() - Method in class com.aspose.cells.ShapeLine
Gets the border line style of the shape.
getSubEntryList() - Method in class com.aspose.cells.PdfBookmarkEntry
get the sub entry array list
getSubject() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the subject of the document.
getSubtotals(short) - Method in class com.aspose.cells.PivotField
Gets whether the specified field shows that subtotals.
getTabColor() - Method in class com.aspose.cells.Worksheet
Gets the colour of the tab below the sheet containing the sheet name.
getTableRange1() - Method in class com.aspose.cells.PivotTable
Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields.
getTableRange2() - Method in class com.aspose.cells.PivotTable
Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields.
getTag() - Method in class com.aspose.cells.PivotTable
Gets a string saved with the PivotTable report.
getTemplate() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the informational name of the document template.
getText() - Method in class com.aspose.cells.DataLabels
Sets the text of a frame's title.
getText() - Method in class com.aspose.cells.DisplayUnitLabel
Sets the text of label.
getText() - Method in class com.aspose.cells.FormatCondition
Gets the text value in a "text contains" conditional formatting rule.
getText() - Method in class com.aspose.cells.Name
Gets the name of the range.
getText() - Method in class com.aspose.cells.NamedRange
Gets the name of the range.
getText() - Method in class com.aspose.cells.PdfBookmarkEntry
get title of a bookmark
getText() - Method in class com.aspose.cells.Shape
Gets the text in shape.
getText() - Method in class com.aspose.cells.Title
Gets the text of a frame's title.
getTextBoxes() - Method in class com.aspose.cells.Chart
Gets the TextBoxes collection.
getTextBoxes() - Method in class com.aspose.cells.Worksheet
Gets the TextBoxes collection.
getTextDirection() - Method in class com.aspose.cells.Axis
Gets the text direction type.
getTextDirection() - Method in class com.aspose.cells.DataLabels
Gets the text direction type.
getTextDirection() - Method in class com.aspose.cells.DisplayUnitLabel
Gets the text direction type.
getTextDirection() - Method in class com.aspose.cells.Style
Gets the text direction type.
getTextDirection() - Method in class com.aspose.cells.Title
Gets the text direction type.
getTextHorizontalAlignment() - Method in class com.aspose.cells.DataLabels
Gets the text horizontal alignment.
getTextHorizontalAlignment() - Method in class com.aspose.cells.DisplayUnitLabel
Gets the text horizontal alignment.
getTextHorizontalAlignment() - Method in class com.aspose.cells.Shape
Gets the text horizontal alignment.
getTextHorizontalAlignment() - Method in class com.aspose.cells.Title
Gets the text horizontal alignment.
getTextToDisplay() - Method in class com.aspose.cells.Hyperlink
Gets text to be displayed for the hyperlink.
getTexture() - Method in class com.aspose.cells.FillFormat
Gets the texture type for the specified fill.
getTextVerticalAlignment() - Method in class com.aspose.cells.DataLabels
Gets the text vertical alignment of text.
getTextVerticalAlignment() - Method in class com.aspose.cells.DisplayUnitLabel
Gets the text vertical alignment of text.
getTextVerticalAlignment() - Method in class com.aspose.cells.Shape
Gets the text vertical alignment.
getTextVerticalAlignment() - Method in class com.aspose.cells.Title
Gets the text vertical alignment of text.
getTickLabelPosition() - Method in class com.aspose.cells.Axis
Gets the position of tick-mark labels on the axis.
getTickLabelSpacing() - Method in class com.aspose.cells.CategoryAxis
Gets the number of category between tick-mark labels.
getTickLabelSpacing() - Method in class com.aspose.cells.SeriesAxis
Gets the number of series between tick-mark labels.
getTickMarkSpacing() - Method in class com.aspose.cells.CategoryAxis
Gets the number of category between tick marks.
getTickMarkSpacing() - Method in class com.aspose.cells.SeriesAxis
Gets the number of series between tick marks.
getTickOffset() - Method in class com.aspose.cells.CategoryAxis
Gets the distance between the levels of labels, and the distance between the first level and the axis line.
getTileAlignment() - Method in class com.aspose.cells.TextureFill
Gets the alignment for tiling.
getTileMirrorType() - Method in class com.aspose.cells.TextureFill
Gets the mirror type for tiling.
getTileOffsetX() - Method in class com.aspose.cells.TextureFill
Gets the X offset for tiling picture.
getTileOffsetY() - Method in class com.aspose.cells.TextureFill
Gets the Y offset for tiling picture.
getTileScaleX() - Method in class com.aspose.cells.TextureFill
Gets the X scale for tiling picture.
getTileScaleY() - Method in class com.aspose.cells.TextureFill
Gets the Y scale for tiling picture.
getTimePeriodType() - Method in class com.aspose.cells.FormatCondition
Gets the applicable time period in a "date occurring" conditional formatting rule.
getTitle() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the title of the document.
getTitle() - Method in class com.aspose.cells.CategoryAxis
Gets the category axis' title.
getTitle() - Method in class com.aspose.cells.Chart
Gets the chart's title.
getTitle() - Method in class com.aspose.cells.SeriesAxis
Gets the axis' title.
getTitle() - Method in class com.aspose.cells.ValueAxis
Gets the value axis' title.
getTop() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getTop()
getTop() - Method in class com.aspose.cells.Shape
Gets the vertical offset of shape from its top row, in unit of pixel.
getTop10() - Method in class com.aspose.cells.FormatCondition
Gets the conditional formatting's "Top10" instance.
getTopCM() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getTopCM()
getTopCM() - Method in class com.aspose.cells.Shape
Gets the vertical offset of shape from its top row, in unit of centimeters.
getTopInch() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getTopInch()
getTopInch() - Method in class com.aspose.cells.Shape
Gets the vertical offset of shape from its top row, in unit of inches.
getTopInChart() - Method in class com.aspose.cells.Shape
Gets the vertical offset of shape from its top row, in units of 1/4000 of the chart area.
getTopMargin() - Method in class com.aspose.cells.PageSetup
Gets the size of the top margin, in unit of centimeters.
getTopMarginInch() - Method in class com.aspose.cells.PageSetup
Gets the size of the top margin, in unit of inches.
getTotalEditingTime() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the total editing time in minutes.
getTransparence() - Method in class com.aspose.cells.ShapeFill
Gets the degree of transparency of the specified fill as a value from 0 (opaque) through 100 (clear).
getTransparency() - Method in class com.aspose.cells.GradientStop
Gets the transparency of this gradient stop.
getTransparency() - Method in class com.aspose.cells.Line
Gets the transparency.
getTransparency() - Method in class com.aspose.cells.TextureFill
Gets the transparency of this gradient stop.
getTrendlines() - Method in class com.aspose.cells.ASeries
Gets Trendlines object represents a collection of all the trendlines for the series.
getType() - Method in class com.aspose.cells.ASeries
Gets a data series' type.
getType() - Method in class com.aspose.cells.CFValueObject
Gets the type of this conditional formatting value object.
getType() - Method in class com.aspose.cells.Chart
Gets a chart's type.
getType() - Method in class com.aspose.cells.DocumentProperty
Gets the data type of the property.
getType() - Method in class com.aspose.cells.ErrorBars
Gets the error bar type.
getType() - Method in class com.aspose.cells.FormatCondition
Gets the conditional format's type.
getType() - Method in class com.aspose.cells.IconSet
Gets the icon set type to display.
getType() - Method in class com.aspose.cells.PivotFields
Gets the PivotFields type.
getType() - Method in class com.aspose.cells.Shape
Gets the shape type.
getType() - Method in class com.aspose.cells.SparklineGroup
Gets the sparkline type of the sparkline group.
getType() - Method in class com.aspose.cells.TextureFill
Gets the texture type.
getType() - Method in class com.aspose.cells.Trendline
Gets the trendline type
getType() - Method in class com.aspose.cells.Validation
Gets the validation data type.
getType() - Method in class com.aspose.cells.Worksheet
Returns the type of the worksheet.
getUnderline() - Method in class com.aspose.cells.Font
Gets the underline type.
getUpBar() - Method in class com.aspose.cells.ASeries
Get the DropBar object that represents the up bar on a line chart
getUpperLeftColumn() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getUpperLeftColumn()
getUpperLeftColumn() - Method in class com.aspose.cells.Shape
Gets the upper left column index.
getUpperLeftRow() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getUpperLeftRow()
getUpperLeftRow() - Method in class com.aspose.cells.Shape
Gets the upper left row index.
getValidations() - Method in class com.aspose.cells.Worksheet
Get the Validations in the worksheet.
getVAlignment() - Method in class com.aspose.cells.Style
Gets the vertical alignment type.
getValue() - Method in class com.aspose.cells.Cell
Gets the cell's value.
getValue() - Method in class com.aspose.cells.CFValueObject
Gets the value of this conditional formatting value object.
getValue() - Method in class com.aspose.cells.DocumentProperty
Gets the value of the property.
getValue() - Method in class com.aspose.cells.LightCell
get cell's value.
getValue() - Method in class com.aspose.cells.PivotItem
Gets the pivot item value.Read-only.
getValueAxis() - Method in class com.aspose.cells.Chart
Gets the chart's value axis.
getValues() - Method in class com.aspose.cells.ASeries
Gets the data of the chart series.
getValueType() - Method in class com.aspose.cells.Cell
Gets the cell's value type.
getValueType() - Method in class com.aspose.cells.LightCell
get type of cell value, see the value type defined in CellValueType.
getValueXAxis() - Method in class com.aspose.cells.Chart
Gets the chart's value x axis.Only applies for Scatter and Bubble chart.
getVersion() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the version number of the application that created the document.
getVerticalAxisMaxValue() - Method in class com.aspose.cells.SparklineGroup
Gets the custom maximum value for the vertical axis.
getVerticalAxisMaxValueType() - Method in class com.aspose.cells.SparklineGroup
Gets the vertical axis maximum value type.
getVerticalAxisMinValue() - Method in class com.aspose.cells.SparklineGroup
Gets the custom minimum value for the vertical axis.
getVerticalAxisMinValueType() - Method in class com.aspose.cells.SparklineGroup
Gets the vertical axis minimum value type.
getVerticalResolution() - Method in class com.aspose.cells.ImageOptions
Gets the vertical resolution for generated images, in dots per inch.
getVPageBreaks() - Method in class com.aspose.cells.Worksheet
Get the VPageBreaks in the worksheet.
getWalls() - Method in class com.aspose.cells.Chart
Gets a Walls object that represents the walls of a 3-D chart.
getWeight() - Method in class com.aspose.cells.Line
Gets the weight type of the line.
getWeight() - Method in class com.aspose.cells.ShapeLine
Gets the border line weight of the shape,in unit of pts.
getWidth() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getWidth()
getWidth() - Method in class com.aspose.cells.Legend
Gets the width of frame,in units of 1/4000 of the chart area.
getWidth() - Method in class com.aspose.cells.Line
Gets the width of line, in points.
getWidth() - Method in class com.aspose.cells.PlotArea
Gets the width of the plot area, in units of 1/4000 of the chart area.
getWidth() - Method in class com.aspose.cells.Shape
Gets the width, in unit of pixel.
getWidthCM() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getWidthCM()
getWidthCM() - Method in class com.aspose.cells.Shape
Gets the width, in unit of centimeters.
getWidthInch() - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.getWidthInch()
getWidthInch() - Method in class com.aspose.cells.Shape
Gets the width, in unit of inches.
getWidthInChart() - Method in class com.aspose.cells.Shape
Gets the widthx, in units of 1/4000 of the chart area.
getWidthScale() - Method in class com.aspose.cells.Picture
Gets the width scale of picture(in unit of 1/100)
getWords() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of words in the document.
getWorkbook() - Method in class com.aspose.cells.WorkbookDesigner
Gets the internal Workbook object.
getWorkbook() - Method in class com.aspose.cells.Worksheet
Gets the workbook which contains this worksheet.
getWorksheet() - Method in class com.aspose.cells.Name
Gets the worksheet which contians this Name .
getWorksheet() - Method in class com.aspose.cells.Range
Gets the worksheet which contians this range .
getWorksheets() - Method in class com.aspose.cells.Workbook
Gets the Worksheets collection in the spreadsheet.
getX() - Method in class com.aspose.cells.DataLabels
Gets position of DataLabels.
getX() - Method in class com.aspose.cells.Legend
Gets the x coordinate of the upper left corner in units of 1/4000 of the chart area.
getX() - Method in class com.aspose.cells.PlotArea
Gets the x coordinate of the upper left corner in units of 1/4000 of the chart area.
getX() - Method in class com.aspose.cells.Title
Gets the x coordinate of the Title's center in units of 1/4000 of the chart area.
getXErroBars() - Method in class com.aspose.cells.ASeries
Gets x error bars of the series
getXValues() - Method in class com.aspose.cells.ASeries
Gets the range of x values.
getY() - Method in class com.aspose.cells.DataLabels
Gets position of DataLabels.
getY() - Method in class com.aspose.cells.Legend
Gets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
getY() - Method in class com.aspose.cells.PlotArea
Gets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
getY() - Method in class com.aspose.cells.Title
Gets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
getYErroBars() - Method in class com.aspose.cells.ASeries
Gets y error bars of the series
getZoom() - Method in class com.aspose.cells.PageSetup
Gets the scaling factor in percent.
getZoom() - Method in class com.aspose.cells.Worksheet
Gets the scaling factor in percent.
getZOrderPosition() - Method in class com.aspose.cells.Shape
Gets the ZOrderPosition of Shape, 1 based.
GIF - Static variable in interface com.aspose.cells.ImageFormat
the Graphics Interchange Format (GIF) image format.
GOLD - Static variable in interface com.aspose.cells.GradientPresetType
Represents gold preset color.
GOLD_II - Static variable in interface com.aspose.cells.GradientPresetType
Represents gold II preset color.
GRADIENT - Static variable in interface com.aspose.cells.FillType
Represents gradient formatting type.
GradientColorType - Interface in com.aspose.cells
Represents the gradient color type for the specified fill.
GradientDirectionType - Interface in com.aspose.cells
Enumerates the direction type for Gradient fill.
GradientFill - Class in com.aspose.cells
Fill format settings for GRADIENT type
GradientFill() - Constructor for class com.aspose.cells.GradientFill
 
GradientFillType - Interface in com.aspose.cells
Represents types for Gradient Fill.
GradientPresetType - Interface in com.aspose.cells
Represents gradient preset color type.
GradientStop - Class in com.aspose.cells
Represents one Gradient stop for Gradient Fill.
GradientStop() - Constructor for class com.aspose.cells.GradientStop
 
GradientStops - Class in com.aspose.cells
Represents Gradient stops collection for Gradient Fill.
GradientStops() - Constructor for class com.aspose.cells.GradientStops
 
GradientStyleType - Interface in com.aspose.cells
Represents gradient shading style.
Granite - Static variable in interface com.aspose.cells.TextureType
Represents Granite texture type.
GRAY - Static variable in class com.aspose.cells.Color
The color gray.
GRAY10 - Static variable in interface com.aspose.cells.FillPatternType
Represents 10% gray pattern.
GRAY12 - Static variable in interface com.aspose.cells.PatternType
Represents 12.5% gray pattern.
GRAY20 - Static variable in interface com.aspose.cells.FillPatternType
Represents 20% gray pattern.
GRAY25 - Static variable in interface com.aspose.cells.FillPatternType
Represents 25% gray pattern.
GRAY25 - Static variable in interface com.aspose.cells.PatternType
Represents 25% gray pattern.
GRAY30 - Static variable in interface com.aspose.cells.FillPatternType
Represents 30% gray pattern.
GRAY40 - Static variable in interface com.aspose.cells.FillPatternType
Represents 40% gray pattern.
GRAY5 - Static variable in interface com.aspose.cells.FillPatternType
Represents 5% gray pattern.
GRAY50 - Static variable in interface com.aspose.cells.FillPatternType
Represents 50% gray pattern.
GRAY50 - Static variable in interface com.aspose.cells.PatternType
Represents 50% gray pattern.
GRAY6 - Static variable in interface com.aspose.cells.PatternType
Represents 6.25% gray pattern.
GRAY60 - Static variable in interface com.aspose.cells.FillPatternType
Represents 60% gray pattern.
GRAY70 - Static variable in interface com.aspose.cells.FillPatternType
Represents 70% gray pattern.
GRAY75 - Static variable in interface com.aspose.cells.FillPatternType
Represents 75% gray pattern.
GRAY75 - Static variable in interface com.aspose.cells.PatternType
Represents 75% gray pattern.
GRAY80 - Static variable in interface com.aspose.cells.FillPatternType
Represents 80% gray pattern.
GRAY90 - Static variable in interface com.aspose.cells.FillPatternType
Represents 90% gray pattern.
GREATE_THAN - Static variable in interface com.aspose.cells.OperatorType
Represents GreaterThan operator of conditional format and data validation.
GREATER_OR_EQUAL - Static variable in interface com.aspose.cells.FilterOperatorType
Represents GreaterOrEqual operator of filter.
GREATER_OR_EQUAL - Static variable in interface com.aspose.cells.OperatorType
Represents GreaterOrEqual operator of conditional format and data validation.
GREATER_THAN - Static variable in interface com.aspose.cells.FilterOperatorType
Represents GreaterThan operator of filter.
GREEN - Static variable in class com.aspose.cells.Color
The color green.
GreenMarble - Static variable in interface com.aspose.cells.TextureType
Represents Green Marble texture type.
GROUP - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the GroupShape.
group(Shape[]) - Method in class com.aspose.cells.Shapes
Groups given shapes
GROUP - Static variable in interface com.aspose.cells.SparklineAxisMinMaxType
Same for all sparklines in the group.
GROUP_BOX - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the GroupBox.
GroupBox - Class in com.aspose.cells
 
groupColumns(int, int) - Method in class com.aspose.cells.Cells
Groups columns.
groupColumns(int, int, boolean) - Method in class com.aspose.cells.Cells
Groups columns.
groupColumns(int, int) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.groupColumns(int,int)
groupColumns(int, int, boolean) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.groupColumns(int,int,boolean)
groupRows(int, int) - Method in class com.aspose.cells.Cells
Groups rows.
groupRows(int, int, boolean) - Method in class com.aspose.cells.Cells
Groups rows.
groupRows(int, int) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.groupRows(int,int)
groupRows(int, int, boolean) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.groupRows(int,int,boolean)
GroupShape - Class in com.aspose.cells
 

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