Home
Products
Purchase
Downloads
Demos
Forums
Blogs
Ticket
Wiki
API
Corporate
Package
Class
Tree
Deprecated
Index
Help
PREV LETTER
NEXT LETTER
FRAMES
NO FRAMES
All Classes
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
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.
Package
Class
Tree
Deprecated
Index
Help
PREV LETTER
NEXT LETTER
FRAMES
NO FRAMES
All Classes
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
R
S
T
U
V
W
Y
See Also:
We guarantee a prompt response to any inquiry!