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
S
SEMIAUTOMATIC
- Static variable in interface com.aspose.cells.
CalculationMode
automatic except for multiple table operations
setAddress(String)
- Method in class com.aspose.cells.
Hyperlink
Sets the address of the hyperlink.
setAlertType(int)
- Method in class com.aspose.cells.
Validation
Sets the validation alert style.
setAreaList(ArrayList<CellArea>)
- Method in class com.aspose.cells.
Validation
Sets a collection of CellArea.
setArrayFormula(String, int, int)
- Method in class com.aspose.cells.
Cell
Sets an array formula to a range of cells.
setBlackAndWhite(boolean)
- Method in class com.aspose.cells.
PageSetup
Sets elements of the document will be printed in black and white.
setBlue(int)
- Method in class com.aspose.cells.
Color
Sets the blue component value.
setBold(boolean)
- Method in class com.aspose.cells.
Font
Sets the font whether to be bold or not.
setBorderColor(int, Color)
- Method in class com.aspose.cells.
Style
Sets the color of the specified border.
setBorderLine(int, int)
- Method in class com.aspose.cells.
Style
Sets the border line type of the specified border.
setBottomMargin(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the bottom margin, in unit of centimeters.
setBottomMarginInch(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the bottom margin, in unit of inches .
setCalculateBeforeSave(boolean)
- Method in class com.aspose.cells.
Workbook
Sets whether workbooks are calculated before they're saved to disk.
setCalculationMode(int)
- Method in class com.aspose.cells.
Workbook
Sets the calculation mode.
setCellLocked(boolean)
- Method in class com.aspose.cells.
Style
Sets whether cells to be locked or not.
setCenterFooter(String)
- Method in class com.aspose.cells.
PageSetup
Sets a script formatting the center section footer of an Excel file.
setCenterHeader(String)
- Method in class com.aspose.cells.
PageSetup
Sets na script formatting the center section header of an Excel file
setCenterHorizontally(boolean)
- Method in class com.aspose.cells.
PageSetup
Sets whether the sheet is printed centered horizontally.
setCenterVertically(boolean)
- Method in class com.aspose.cells.
PageSetup
Sets whether the sheet is printed centered vertically.
setCharacters(int, int, Font)
- Method in class com.aspose.cells.
Cell
Performs rich text formatting.
setColor(Color)
- Method in class com.aspose.cells.
Font
Sets the font color.
setColor(int, Color)
- Method in class com.aspose.cells.
Palette
Sets the color in the palette at the specified index(0-55).
setColor(Color)
- Method in class com.aspose.cells.
Style
Sets the cell shading color.
setColumn(int)
- Method in class com.aspose.cells.
VPageBreak
Sets column index, zero based.
setColumnHidden(int, boolean)
- Method in class com.aspose.cells.
Worksheet
Sets whether the specified column to be hidden or not.
setColumnStyle(short, Style)
- Method in class com.aspose.cells.
Worksheet
Sets a style to the specified column.
setColumnWidth(int, float)
- Method in class com.aspose.cells.
Worksheet
Sets the width of the specified column, in unit of characters using default font.
setCustom(String)
- Method in class com.aspose.cells.
Style
Sets the custom number format string.
setDefaultColumnWidth(float)
- Method in class com.aspose.cells.
Worksheet
Sets the default column width of the worksheet, in unit of characters using default font.
setDefaultHeight()
- Method in class com.aspose.cells.
Row
Invalidate the row height setting.
setDefaultRowHeight(float)
- Method in class com.aspose.cells.
Worksheet
Sets the default row height of the worksheet, in unit of points.
setDeletingColumnsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the deletion of columns is allowed on a protected worksheet.
setDeletingRowsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the deletion of rows is allowed on a protected worksheet.
setDraftQuality(boolean)
- Method in class com.aspose.cells.
PageSetup
Sets whether the sheet will be printed without graphics.
setEditingContentsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to edit contents of locked cells on a protected worksheet.
setEditingObjectsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to manipulate drawing objects on a protected worksheet.
setEditingScenariosAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to edit scenarios on a protected worksheet.
setEndColumn(int)
- Method in class com.aspose.cells.
CellArea
Sets the column index of the bottom right cell.
setEndRow(int)
- Method in class com.aspose.cells.
CellArea
Sets the row index of the bottom right cell.
setErrorMessage(String)
- Method in class com.aspose.cells.
Validation
Sets the data validation error message.
setErrorTitle(String)
- Method in class com.aspose.cells.
Validation
Sets the title of the data-validation error dialog box.
setEscapement(int)
- Method in class com.aspose.cells.
Font
Sets the escapement type.
setFamily(int)
- Method in class com.aspose.cells.
Font
setFilteringAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
setFirstPageNumber(short)
- Method in class com.aspose.cells.
PageSetup
Sets the first page number that will be used when this sheet is printed.
setFirstVisibleColumn(int)
- Method in class com.aspose.cells.
Worksheet
Sets first visible column index.
setFirstVisibleRow(int)
- Method in class com.aspose.cells.
Worksheet
Sets first visible row index.
setFitToPagesTall(short)
- Method in class com.aspose.cells.
PageSetup
Sets the number of pages tall the worksheet will be scaled to when it's printed.
setFitToPagesWide(short)
- Method in class com.aspose.cells.
PageSetup
Sets the number of pages wide the worksheet will be scaled to when it's printed.
setFont(Font)
- Method in class com.aspose.cells.
Style
Sets the font of the style.
setFooterMargin(double)
- Method in class com.aspose.cells.
PageSetup
Sets the distance from the bottom of the page to the footer, in unit of centimeters.
setFooterMarginInch(double)
- Method in class com.aspose.cells.
PageSetup
Sets the distance from the bottom of the page to the footer, in unit of inches.
setFormattingCellsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the formatting of cells is allowed on a protected worksheet.
setFormattingColumnsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the formatting of columns is allowed on a protected worksheet.
setFormattingRowsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the formatting of rows is allowed on a protected worksheet.
setFormula(String)
- Method in class com.aspose.cells.
Cell
Sets the formula of the cell at runtime.
setFormula1(String)
- Method in class com.aspose.cells.
FormatCondition
Sets the value or expression associated with conditional formatting.
setFormula1(String)
- Method in class com.aspose.cells.
Validation
Sets the value or expression associated with the data validation.
setFormula2(String)
- Method in class com.aspose.cells.
FormatCondition
Gets the value or expression associated with conditional formatting.
setFormula2(String)
- Method in class com.aspose.cells.
Validation
Sets the value or expression associated with the data validation.
setFormulaHidden(boolean)
- Method in class com.aspose.cells.
Style
Sets whether formulas to be hidden or not.
setGreen(int)
- Method in class com.aspose.cells.
Color
Sets the green component value.
setGridlinesVisible(boolean)
- Method in class com.aspose.cells.
Worksheet
Sets whether the grid lines to be visible or not.
setHAlignment(short)
- Method in class com.aspose.cells.
Style
Sets the horizontal text alignment type.
setHeaderMargin(double)
- Method in class com.aspose.cells.
PageSetup
Sets the distance from the top of the page to the header, in unit of centimeters.
setHeaderMarginInch(double)
- Method in class com.aspose.cells.
PageSetup
Sets the distance from the top of the page to the header, in unit of inches.
setHeight(float)
- Method in class com.aspose.cells.
Row
Sets the row height, in points.
setHidden(boolean)
- Method in class com.aspose.cells.
Row
Sets whether the row to be hidden or not.
setHorizontalScrollBarHidden(boolean)
- Method in class com.aspose.cells.
Workbook
Sets the horizontal scroll bar to be hidden or not.
setIgnoreBlank(boolean)
- Method in class com.aspose.cells.
Validation
Sets whether blank values are permitted by the range data validation.
setInCellDropDown(boolean)
- Method in class com.aspose.cells.
Validation
Sets whether data validation displays a drop-down list that contains acceptable values.
setIndent(int)
- Method in class com.aspose.cells.
Style
Sets the indent level.
setInputMessage(String)
- Method in class com.aspose.cells.
Validation
Sets the data validation input message.
setInputTitle(String)
- Method in class com.aspose.cells.
Validation
Sets the title of the data validation input dialog box.
setInsertingColumnsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the insertion of columns is allowed on a protected worksheet.
setInsertingHyperlinksAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the insertion of hyperlinks is allowed on a protected worksheet.
setInsertingRowsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the insertion of rows is allowed on a protected worksheet.
setItalic(boolean)
- Method in class com.aspose.cells.
Font
Sets whether the font to be italic or not.
setLeftFooter(String)
- Method in class com.aspose.cells.
PageSetup
Sets a script formatting the left section footer of an Excel file.
setLeftHeader(String)
- Method in class com.aspose.cells.
PageSetup
Sets a script formatting the left section header of an Excel file.
setLeftMargin(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the left margin, in unit of centimeters.
setLeftMarginInch(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the left margin, in unit of inches.
setLicense(InputStream)
- Method in class com.aspose.cells.
License
Licenses the component.
setName(String)
- Method in class com.aspose.cells.
Font
Sets the font name.
setName(String)
- Method in class com.aspose.cells.
Style
Sets the name of the style.
setName(String)
- Method in class com.aspose.cells.
Worksheet
Sets the worksheet name.
setNumber(int)
- Method in class com.aspose.cells.
Style
Sets the built-in display format of numbers and dates.
Use built-in numbers for better performance.
setOperator(int)
- Method in class com.aspose.cells.
FormatCondition
Sets the conditional format operator.
setOperator(int)
- Method in class com.aspose.cells.
Validation
Sets the operator for the data validation.
setOrientation(short)
- Method in class com.aspose.cells.
PageSetup
Sets orientation page print orientation.
setPageBreakPreview(boolean)
- Method in class com.aspose.cells.
Worksheet
Sets the specified worksheet is shown in normal view or page break preview.
setPageOrder(short)
- Method in class com.aspose.cells.
PageSetup
Sets the order that Microsoft Excel uses to number pages when printing a large worksheet.
setPaperSize(short)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the paper.
setPassword(String)
- Method in class com.aspose.cells.
Protection
Sets the password to protect the worksheet.
setPatternColor(Color)
- Method in class com.aspose.cells.
Style
Sets the pattern color.
setPatternStyle(short)
- Method in class com.aspose.cells.
Style
Sets the pattern style.
setPrintArea(String)
- Method in class com.aspose.cells.
PageSetup
Sets the range to be printed.
setPrintComments(short)
- Method in class com.aspose.cells.
PageSetup
Sets the way comments are printed with the sheet.
setPrintErrors(short)
- Method in class com.aspose.cells.
PageSetup
Gets the type of print error displayed.
setPrintGridlines(boolean)
- Method in class com.aspose.cells.
PageSetup
Sets whether cell gridlines are printed on the page.
setPrintHeadings(boolean)
- Method in class com.aspose.cells.
PageSetup
Sets whether row and column headings are printed with this page.
setPrintQuality(short)
- Method in class com.aspose.cells.
PageSetup
Sets the print quality.
setPrintTitleColumns(String)
- Method in class com.aspose.cells.
PageSetup
Sets the columns that contain the cells to be repeated on the left side of each page.
setPrintTitleRows(String)
- Method in class com.aspose.cells.
PageSetup
Sets the rows that contain the cells to be repeated at the top of each page.
setRed(int)
- Method in class com.aspose.cells.
Color
Sets the red component value.
setRightFooter(String)
- Method in class com.aspose.cells.
PageSetup
Sets a script formatting the right section footer of an Excel file.
setRightHeader(String)
- Method in class com.aspose.cells.
PageSetup
Sets a script formatting the right section header of an Excel file.
setRightMargin(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the right margin, in unit of centimeters.
setRightMarginInch(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the right margin, in unit of inches.
setRotation(int)
- Method in class com.aspose.cells.
Style
Sets the rotation degrees.
setRow(int)
- Method in class com.aspose.cells.
HPageBreak
Sets rolumn index, zero based.
setRowColumnHeadersVisible(boolean)
- Method in class com.aspose.cells.
Worksheet
Sets whether the worksheet will display row and column headers.
setScreenTip(String)
- Method in class com.aspose.cells.
Hyperlink
Sets screen tip of the hyperlink.
setSelectingLockedCellsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to select locked cells on a protected worksheet.
setSelectingUnlockedCellsAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to select unlocked cells on a protected worksheet.
setSheetTabBarHidden(boolean)
- Method in class com.aspose.cells.
Workbook
Sets the sheet tab bar to be hidden or not.
setShowError(boolean)
- Method in class com.aspose.cells.
Validation
Sets whether the data validation error message will be displayed whenever the user enters invalid data.
setShowInput(boolean)
- Method in class com.aspose.cells.
Validation
Sets whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
setShrinked(boolean)
- Method in class com.aspose.cells.
Style
Sets whether the text should be shrunk to fit or not.
setSize(int)
- Method in class com.aspose.cells.
Font
Sets the font size.
setSortingAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the sorting option is allowed on a protected worksheet.
setStartColumn(int)
- Method in class com.aspose.cells.
CellArea
Sets the column index of the top left cell.
setStartRow(int)
- Method in class com.aspose.cells.
CellArea
Sets the row index of the top left cell.
setStrikeOut(boolean)
- Method in class com.aspose.cells.
Font
Sets the strikeout horizontal line to be used or not.
setStyle(Style)
- Method in class com.aspose.cells.
Cell
Sets the cell a style.
setStyle(Style)
- Method in class com.aspose.cells.
FormatCondition
Sets style of conditional formatted cell range.
setStyle(Style)
- Method in class com.aspose.cells.
Row
Sets the style of the row.
setStyle(int, int, Style)
- Method in class com.aspose.cells.
Row
Sets style for a continuous range of cells of the row.
setStyle(int, int, int, int, Style)
- Method in class com.aspose.cells.
Worksheet
Sets a style for an area of cells.
setTabColor(Color)
- Method in class com.aspose.cells.
Worksheet
Sets the colour of the tab below the sheet containing the sheet name.
setTextDirection(int)
- Method in class com.aspose.cells.
Style
Sets the text direction type.
setTextToDisplay(String)
- Method in class com.aspose.cells.
Hyperlink
Sets text to be displayed for the hyperlink.
setTextWrapped(boolean)
- Method in class com.aspose.cells.
Style
Sets whether the text should be wrapped.
setTopMargin(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the top margin, in unit of centimeters.
setTopMarginInch(double)
- Method in class com.aspose.cells.
PageSetup
Sets the size of the top margin, in unit of inches.
setType(int)
- Method in class com.aspose.cells.
FormatCondition
Sets whether the conditional format is based on a cell value or an expression.If type is changed to FormatConditionType.EXPRESSION, operator type would become OperatorType.NONE and fomula2 would be set null automatically.
setType(int)
- Method in class com.aspose.cells.
Validation
Sets the validation data type.
setUnderline(int)
- Method in class com.aspose.cells.
Font
Sets the underline type.
setUsingPivotTablesAllowed(boolean)
- Method in class com.aspose.cells.
Protection
Sets if the user is allowed to manipulate pivot tables on a protected worksheet.
setVAlignment(short)
- Method in class com.aspose.cells.
Style
Sets the vertical text alignment type.
setValue(int)
- Method in class com.aspose.cells.
Cell
Sets the cell an int value.
setValue(double)
- Method in class com.aspose.cells.
Cell
Sets the cell a double value.
setValue(String)
- Method in class com.aspose.cells.
Cell
Sets the cell a string value.
setValue(boolean)
- Method in class com.aspose.cells.
Cell
Sets the cell a boolean value.
setValue(Calendar)
- Method in class com.aspose.cells.
Cell
Sets the cell a datetime value.
setValue(Object)
- Method in class com.aspose.cells.
Cell
Sets the cell an object value.
setVerticalScrollBarHidden(boolean)
- Method in class com.aspose.cells.
Workbook
Sets the vertical scroll bar to be hidden or not.
setVisible(boolean)
- Method in class com.aspose.cells.
Worksheet
Sets whether the worksheet to be visible or not.
setZoom(short)
- Method in class com.aspose.cells.
PageSetup
Sets the scaling factor in percent.
setZoom(short)
- Method in class com.aspose.cells.
Worksheet
Sets the scaling factor in percent.
SheetType
- Interface in
com.aspose.cells
Enumerates worksheet types.
SILVER
- Static variable in class com.aspose.cells.
Color
The color silver.
size()
- Method in class com.aspose.cells.
ConditionalFormattings
Gets number of the FormatConditions objects.
size()
- Method in class com.aspose.cells.
HPageBreaks
Gets number of the HPageBreak objects.
size()
- Method in class com.aspose.cells.
Hyperlinks
Gets number of the Hyberlink objects.
size()
- Method in class com.aspose.cells.
Validations
Gets number of the Validation objects.
size()
- Method in class com.aspose.cells.
VPageBreaks
Gets number of the VPageBreak objects.
sizeOfConditionList()
- Method in class com.aspose.cells.
FormatConditions
Gets size of formatting conditions.
SLANTED_MEDIUM_DASH_DOTTED
- Static variable in interface com.aspose.cells.
BorderLineType
Represents slanted medium dash-dotted line.
SOLID
- Static variable in interface com.aspose.cells.
PatternType
Represents solid pattern.
split()
- Method in class com.aspose.cells.
Worksheet
Splits window.
STOP
- Static variable in interface com.aspose.cells.
ValidationAlertType
STOP alert style.
STRING
- Static variable in interface com.aspose.cells.
CellValueType
Cell value is string.
Style
- Class in
com.aspose.cells
Represents display styles of Excel spreadsheets.
swapSheet(int, int)
- Method in class com.aspose.cells.
Workbook
Swaps the positions of two sheets.
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!