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

G

GENERAL - Static variable in exception com.aspose.cells.ExcelException
Represents a general error.
GENERAL - Static variable in interface com.aspose.cells.HorizontalAlignmentType
Represents general text alignment.
get(int) - Method in class com.aspose.cells.ConditionalFormattings
Gets FormatConditions 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.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
Gets the active sheet.
getActiveSheetIndex() - Method in class com.aspose.cells.Workbook
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.
getAreaList() - Method in class com.aspose.cells.Validation
Gets a collection of CellArea
getBlue() - Method in class com.aspose.cells.Color
Gets the blue component value.
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.
getCalculationMode() - Method in class com.aspose.cells.Workbook
Returns the calculation mode.
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
Gets the cell object with the specified row index and column index.
getCell(String) - Method in class com.aspose.cells.Worksheet
Gets the cell object by the cell name(like "A1").
getCellIterator() - Method in class com.aspose.cells.Row
Returns an iterator which can iterate all defined cells in this row.
getCenterFooter() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the center section footer of an Excel file.
getCenterHeader() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the center section header of an Excel file.
getCharacters() - Method in class com.aspose.cells.Cell
Gets the rich text settings of a cell.
getCode() - Method in exception com.aspose.cells.ExcelException
Gets the exception code.
getColor() - Method in class com.aspose.cells.Font
Gets the font color.
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.Style
Gets the cell shading color.
getColumn() - Method in class com.aspose.cells.VPageBreak
Gets column index, zero based.
getColumnIndex() - Method in class com.aspose.cells.Cell
Gets the column index of the cell.
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.Worksheet
Gets the width of the column at the given column index, in unit of characters using default font.
getConditionalFormattings() - Method in class com.aspose.cells.Worksheet
Gets the ConditionalFormattings in the worksheet.
getCustom() - Method in class com.aspose.cells.Style
Gets the custom number format string.
getDefaultColumnWidth() - Method in class com.aspose.cells.Worksheet
Returns the default column width of the worksheet, in unit of characters with default font.
getDefaultRowHeight() - Method in class com.aspose.cells.Worksheet
Gets the default row height of the worksheet in points.
getDefaultStyle() - Method in class com.aspose.cells.Workbook
Gets the default style of the workbook.
getEndColumn() - Method in class com.aspose.cells.CellArea
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.
getErrorMessage() - Method in class com.aspose.cells.Validation
Gets the data validation error message.
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.
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
Returns the first defined row index.
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.
getFont() - Method in class com.aspose.cells.Characters
Gets the font of this object.
getFont() - Method in class com.aspose.cells.Style
Gets the font of the style.
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.
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.
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.Row
Gets the height of the row in points.
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.
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.
getLastCellIndex() - Method in class com.aspose.cells.Row
Gets the index of the last defined row.
getLastRowIndex() - Method in class com.aspose.cells.Worksheet
Returns the last defined row index.
getLeftFooter() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the left section footer of an Excel file.
getLeftHeader() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the left section header of an Excel file.
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.
getLength() - Method in class com.aspose.cells.Characters
Gets the character counts start at the start index.
getMergedCells() - Method in class com.aspose.cells.Worksheet
Gets the collection of merged cell ranges in the worksheet.
getName() - Method in class com.aspose.cells.Font
Gets the font name.
getName() - Method in class com.aspose.cells.Style
Gets the style name.
getName() - Method in class com.aspose.cells.Worksheet
Returns the name of the worksheet.
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.
getNumber() - Method in class com.aspose.cells.Style
Gets the built-in display format of numbers and dates.
getNumerOfSheets() - Method in class com.aspose.cells.Workbook
Gets the number of sheets in the workbook.
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.
getOrientation() - Method in class com.aspose.cells.PageSetup
Gets page print orientation.
getPageOrder() - Method in class com.aspose.cells.PageSetup
Gets the order that Microsoft Excel uses to number pages when printing a large worksheet.
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.
getPassword() - Method in class com.aspose.cells.Protection
Gets the password to protect the worksheet.
getPatternColor() - Method in class com.aspose.cells.Style
Gets the pattern color.
getPatternStyle() - Method in class com.aspose.cells.Style
Gets the pattern style.
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.
getRed() - Method in class com.aspose.cells.Color
Gets the red component value.
getRightFooter() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the right section footer of an Excel file.
getRightHeader() - Method in class com.aspose.cells.PageSetup
Gets a script formatting the right section header of an Excel 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.Style
Gets the rotation degrees.
getRow() - Method in class com.aspose.cells.HPageBreak
Gets rolumn index, zero based.
getRow(int) - Method in class com.aspose.cells.Worksheet
Gets the row at the specified row index.
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.Worksheet
Returns an iterator which can iterate all defined rows in this worksheet.
getScreenTip() - Method in class com.aspose.cells.Hyperlink
Gets screen tip of the hyperlink.
getSheet(int) - Method in class com.aspose.cells.Workbook
Returns the sheet at the specified index.
getSheet(String) - Method in class com.aspose.cells.Workbook
Gets the sheet with the specified name.
getSheetIndex(String) - Method in class com.aspose.cells.Workbook
Gets the sheet's index according to its name.
getSheetName(int) - Method in class com.aspose.cells.Workbook
Returns the name of the sheet at the specified index.
getSize() - Method in class com.aspose.cells.Font
Gets the font size in points.
getStartColumn() - Method in class com.aspose.cells.CellArea
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.
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.FormatCondition
Gets style of conditional formatted cell range.
getStyle() - Method in class com.aspose.cells.Row
Gets the style of the row.
getTabColor() - Method in class com.aspose.cells.Worksheet
Gets the colour of the tab below the sheet containing the sheet name.
getTextDirection() - Method in class com.aspose.cells.Style
Gets the text direction type.
getTextToDisplay() - Method in class com.aspose.cells.Hyperlink
Gets text to be displayed for the hyperlink.
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.
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.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.
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.
getValueType() - Method in class com.aspose.cells.Cell
Gets the cell's value type.
getVPageBreaks() - Method in class com.aspose.cells.Worksheet
Get the VPageBreaks in the worksheet.
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.
GRAY - Static variable in class com.aspose.cells.Color
The color gray.
GRAY12 - Static variable in interface com.aspose.cells.PatternType
Represents 12.5% gray pattern.
GRAY25 - Static variable in interface com.aspose.cells.PatternType
Represents 25% 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.
GRAY75 - Static variable in interface com.aspose.cells.PatternType
Represents 75% 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.Worksheet
Groups columns.
groupColumns(int, int, boolean) - Method in class com.aspose.cells.Worksheet
Groups columns.
groupRows(int, int) - Method in class com.aspose.cells.Worksheet
Groups rows.
groupRows(int, int, boolean) - Method in class com.aspose.cells.Worksheet
Groups rows.

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