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 R S T U V W 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.
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.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.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.PivotTables
Gets the PivotTable report by 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.
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.Floor
Gets the Area.
getArea() - Method in class com.aspose.cells.Walls
Gets the Area.
getAreaList() - Method in class com.aspose.cells.Validation
Gets a collection of CellArea
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.
getBackgroundColor() - Method in class com.aspose.cells.Area
Gets the background Color of the Area.
getBackward() - Method in class com.aspose.cells.Trendline
Gets the number of periods (or units on a scatter chart) that the trendline extends backward.
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.
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.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.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.
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.
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.
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) - 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)
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.NamedRange
Gets all cells in the range.
getCells() - Method in class com.aspose.cells.Worksheet
Gets a collection of Cell objects.
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.
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.
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.
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.
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.
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.Font
Gets the font color.
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.
getColor2() - Method in class com.aspose.cells.FillFormat
Gets the gradient color 2 or the pattern foreground color for the the specified fill.
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.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.
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 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)
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.
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.
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.
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).
getCustom() - Method in class com.aspose.cells.Style
Gets the custom number format string.
getCustomAmount() - Method in class com.aspose.cells.ErrorBars
Gets the positive error amount when type is custom.
getCustomDocumentProperties() - Method in class com.aspose.cells.Worksheets
Returns a DocumentProperties collection that represents all the custom document properties of the spreadsheet.
getDashStyle() - Method in class com.aspose.cells.ShapeLine
Gets the border line dash style of the shape.
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.
getDateTimeValue() - Method in class com.aspose.cells.Cell
Gets the cell's 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.
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).
getDisplayName() - Method in class com.aspose.cells.PivotField
Gets the PivotField display name.
getDoubleValue() - Method in class com.aspose.cells.Cell
Gets the cell's double value.
getElevation() - Method in class com.aspose.cells.Chart
Gets the elevation of the 3-D chart view, in degrees(between -90 and 90).
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.
getFamily() - Method in class com.aspose.cells.Font
Gets the font family.
getFields(byte) - Method in class com.aspose.cells.PivotTable
Gets the specific fields by the field type.
getFillFormat() - Method in class com.aspose.cells.Area
Gets a object that contains fill formatting properties for the specified chart or shape.
getFirstCellIndex() - Method in class com.aspose.cells.Row
Gets the index of the first defined row.
getFirstPageNumber() - Method in class com.aspose.cells.PageSetup
Gets the first page number that will be used when this sheet is printed.
getFirstRowIndex() - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.getMinRow()
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.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.Comment
Gets the font of comment.
getFont() - Method in class com.aspose.cells.DataLabels
Gets a Font object of the chart data label.
getFont() - Method in class com.aspose.cells.Legend
Gets a Font object of the chart legend.
getFont() - Method in class com.aspose.cells.Style
Gets the font of the style.
getFont() - Method in class com.aspose.cells.TextBox
Gets the font of textbox.
getFont() - Method in class com.aspose.cells.Title
Gets a Font object of title.
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.
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.
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.
getForward() - Method in class com.aspose.cells.Trendline
Gets the number of periods (or units on a scatter chart) that the trendline extends forward.
getFunction() - Method in class com.aspose.cells.PivotField
Gets the function used to summarize the PivotTable data field.
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.
getGradientDegree() - Method in class com.aspose.cells.FillFormat
Gets the gradient degree for the the specified fill.
getGradientStyle() - Method in class com.aspose.cells.FillFormat
Gets the gradient style for the specified fill.
getGradientVariant() - Method in class com.aspose.cells.FillFormat
Gets the gradient variant for the the specified fill.
getGreen() - Method in class com.aspose.cells.Color
Gets the green component value.
getHAlignment() - Method in class com.aspose.cells.Style
Gets the horizontal alignment type.
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
Gets the height, in unit of pixel.
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.
getHeightCM() - Method in class com.aspose.cells.ChartArea
Gets the height, in unit of centimeters.
getHeightInch() - Method in class com.aspose.cells.ChartArea
Gets the height, in unit of inches.
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).
getHPageBreaks() - Method in class com.aspose.cells.Worksheet
Get the HPageBreaks in the worksheet.
getHyperlink(int) - Method in class com.aspose.cells.Hyperlinks
Gets Hyberlink object by index.
getHyperlinks() - Method in class com.aspose.cells.Worksheet
Get the Hyperlinks in the worksheet.
getInclude() - Method in class com.aspose.cells.ErrorBars
Gets type of the error bar parts to include.
getIndent() - Method in class com.aspose.cells.Style
Gets the indent level.
getInputMessage() - Method in class com.aspose.cells.Validation
Getss the data validation input message.
getInputTitle() - Method in class com.aspose.cells.Validation
Gets the title of the data validation input dialog box.
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.
getKeywords() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the document keywords.
getLabelPosition() - Method in class com.aspose.cells.DataLabels
Gets the lable position.
getLastCellIndex() - Method in class com.aspose.cells.Row
Gets the index of the last defined row.
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.
getLeft() - Method in class com.aspose.cells.ChartArea
Gets the horizontal offset of textbox from its left column, in unit of pixel.
getLeftCM() - Method in class com.aspose.cells.ChartArea
Gets the horizontal offset of textbox 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
Gets the horizontal offset of textbox from its left column, in unit of inches.
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.
getLength() - Method in class com.aspose.cells.Characters
Gets the character counts start at the start index.
getLine() - Method in class com.aspose.cells.Trendline
Gets the line or border of Trendlines object.
getLines() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets an estimate of the number of lines in the document.
getLookinType() - Method in class com.aspose.cells.FindOptions
Gets the lookin type.
getMajorUnit() - Method in class com.aspose.cells.ValueAxis
Gets the major units for the value axis.
getManager() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the manager property.
getMarkerBackgroundColor() - Method in class com.aspose.cells.ASeries
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.
getMarkerSize() - Method in class com.aspose.cells.ASeries
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.
getMatchType() - Method in class com.aspose.cells.FindOptions
Gets the match type.
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.ValueAxis
Gets the maximum value on the value axis.
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()
getMinColumn() - Method in class com.aspose.cells.Cells
Gets minimum column index of cell which contains data or style.
getMinorUnit() - Method in class com.aspose.cells.ValueAxis
Gets the minor units for the value 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.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.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.
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.
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.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.
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().
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.
getOrientation() - Method in class com.aspose.cells.PageSetup
Gets page print orientation.
getOrientation() - Method in class com.aspose.cells.TextBox
Gets text orientation.
getOutline() - Method in class com.aspose.cells.Worksheet
Gets Outline object on a worksheet.
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.
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.
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.
getPatternColor() - Method in class com.aspose.cells.Style
Gets the pattern color.
getPatternStyle() - Method in class com.aspose.cells.Style
Gets the pattern style.
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.
getPictures() - Method in class com.aspose.cells.Worksheet
Gets a Pictures collection.
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
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.
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.
getPresetColor() - Method in class com.aspose.cells.FillFormat
Gets the gradient preset color for the the specified fill.
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.
getPrintQuality() - Method in class com.aspose.cells.PageSetup
Gets the print quality.
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.
getProtection() - Method in class com.aspose.cells.Worksheet
Gets the current protection settings.
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.
getRed() - Method in class com.aspose.cells.Color
Gets the red component value.
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.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.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(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.
getRowIndex() - Method in class com.aspose.cells.Cell
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.
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.
getSecondValueAxis() - Method in class com.aspose.cells.Chart
Gets the chart's second value axis.
getSeriesAxis() - Method in class com.aspose.cells.Chart
Gets the chart's series axis.
getSeriesNumber() - Method in class com.aspose.cells.ASeries
Gets the series number (as shown in name box -- Sereies1, Sereies2, etc.).
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.
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.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.
getSize() - Method in class com.aspose.cells.Font
Gets the font size in points.
getSmartMarkers(int) - Method in class com.aspose.cells.WorkbookDesigner
Gets a collection of smart markers in a spreadsheet.
getStandardHeight() - Method in class com.aspose.cells.Cells
Gets the default row height of the worksheet in points.
getStandardWidth() - Method in class com.aspose.cells.Cells
Returns the default column width of the worksheet, in unit of characters with default font.
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.
getStringValue() - Method in class com.aspose.cells.Cell
Gets the string value contained in the cell.
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.Row
Gets the style of the row.
getStyle() - Method in class com.aspose.cells.ShapeLine
Gets the border line style of the shape.
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.NamedRange
Gets the name of the range.
getText() - Method in class com.aspose.cells.Title
Sets 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.Style
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.TextBox
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.
getTextVerticalAlignment() - Method in class com.aspose.cells.DataLabels
Gets the text vertical alignment of text.
getTextVerticalAlignment() - Method in class com.aspose.cells.TextBox
Gets the text vertical alignment of text.
getTextVerticalAlignment() - Method in class com.aspose.cells.Title
Gets the text vertical alignment of text.
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.
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
Gets the vertical offset of textbox from its top row, in unit of pixel.
getTopCM() - Method in class com.aspose.cells.ChartArea
Gets the vertical offset of textbox from its top row, in unit of centimeters.
getTopInch() - Method in class com.aspose.cells.ChartArea
Gets the vertical offset of textbox from its top row, in unit of inches.
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).
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.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 whether the conditional format is based on a cell value or an expression.
getType() - Method in class com.aspose.cells.PivotFields
Gets the PivotFields 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.
getUpperLeftColumn() - Method in class com.aspose.cells.ChartArea
Gets the upper left column index.
getUpperLeftRow() - Method in class com.aspose.cells.ChartArea
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.DocumentProperty
Gets the value of the property.
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.
getVersion() - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the version number of the application that created the document.
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
Gets the widthx, in unit of pixel.
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.PlotArea
Gets the width of the plot area, in units of 1/4000 of the chart area.
getWidthCM() - Method in class com.aspose.cells.ChartArea
Gets the width, in unit of centimeters.
getWidthInch() - Method in class com.aspose.cells.ChartArea
Gets the width, in unit of inches.
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.
getWorksheets() - Method in class com.aspose.cells.Workbook
Gets the Worksheets collection in the spreadsheet.
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.
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.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.
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.
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.
GradientColorType - Interface in com.aspose.cells
Represents the gradient color type for the specified fill.
GradientPresetType - Interface in com.aspose.cells
Represents gradient preset color type.
GradientStyleType - Interface in com.aspose.cells
Represents gradient shading style.
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.OperatorType
Represents GreaterOrEqual operator of conditional format and data validation.
GREEN - Static variable in class com.aspose.cells.Color
The color green.
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)

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