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

S

save(OutputStream) - Method in class com.aspose.cells.Excel
Saves the workbook to the given stream.
save(OutputStream, int) - Method in class com.aspose.cells.Excel
Saves the workbook to the given stream.
save(String) - Method in class com.aspose.cells.Excel
Saves the workbook to a file.
save(String, int) - Method in class com.aspose.cells.Excel
Saves the workbook to a file.
SCATTER - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart.
SCATTER_CONNECTED_BY_CURVES_WITH_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by curves, with data markers.
SCATTER_CONNECTED_BY_CURVES_WITHOUT_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by curves, without data markers.
SCATTER_CONNECTED_BY_LINES_WITH_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by lines, with data markers.
SCATTER_CONNECTED_BY_LINES_WITHOUT_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by lines, without data markers.
SEMIAUTOMATIC - Static variable in interface com.aspose.cells.CalculationMode
automatic except for multiple table operations
SeriesAxis - Class in com.aspose.cells
Encapsulates the object that represents series axis.
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.
setAuto(boolean) - Method in class com.aspose.cells.Area
Sets whether Microsoft Excel automatically determines the area pattern.
setAuto(boolean) - Method in class com.aspose.cells.Line
Sets whether Microsoft Excel automatically determines the line pattern.
setAutoCross(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether Microsoft Excel automatically sets the axis crossing point.
setBackgroundColor(Color) - Method in class com.aspose.cells.Area
Sets the background Color of the Area.
setBackward(double) - Method in class com.aspose.cells.Trendline
Sets the number of periods (or units on a scatter chart) that the trendline extends backward.
setBetweenCategories(boolean) - Method in class com.aspose.cells.CategoryAxis
Sets whether the value axis crosses the category axis between categories.
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.
setBorderHorizonal(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the chart data table has horizontal cell borders.
setBorderLine(int, int) - Method in class com.aspose.cells.Style
Sets the border line type of the specified border.
setBorderOutline(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the chart data table has outline borders.
setBorderVertical(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the chart data table has vertical cell borders.
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 .
setBubbleShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label Percentage display.
setBubbleSizes(String) - Method in class com.aspose.cells.ASeries
Sets the size data for the bubble chart.
setCalculateBeforeSave(boolean) - Method in class com.aspose.cells.Excel
Sets whether workbooks are calculated before they're saved to disk.
setCalculationMode(int) - Method in class com.aspose.cells.Excel
Sets the calculation mode.
setCategoryData(String) - Method in class com.aspose.cells.NSeries
Sets the range of category Axis values.
setCategoryNameShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label category name display.
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(Color) - Method in class com.aspose.cells.Line
Sets the Color of the line.
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.
setColorVaried(boolean) - Method in class com.aspose.cells.NSeries
Sets whether the color of points is varied.
setColumn(int) - Method in class com.aspose.cells.VPageBreak
Sets column index, zero based.
setColumnHidden(int, boolean) - Method in class com.aspose.cells.Cells
Sets whether the specified column to be hidden or not.
setColumnHidden(int, boolean) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setColumnHidden(int,boolean)
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.Cells
Sets the width of the specified column, in unit of characters using default font.
setColumnWidth(int, float) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setColumnWidth(int,float)
setCrossAt(int) - Method in class com.aspose.cells.CategoryAxis
Sets the point on the category axis where the other axis crosses.
setCrossAt(double) - Method in class com.aspose.cells.ValueAxis
Sets the point on the value axis where the other axis crosses.
setCrossAtMax(boolean) - Method in class com.aspose.cells.CategoryAxis
Sets whether the axis crosses at the maximum value.
setCrossAtMax(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether the axis crosses at the maximum value.
setCustom(String) - Method in class com.aspose.cells.Style
Sets the custom number format string.
setDataTableShown(boolean) - Method in class com.aspose.cells.Chart
Indicates whether the chart displays a data table.
setDefaultColumnWidth(float) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setStandardWidth(float)
setDefaultHeight() - Method in class com.aspose.cells.Row
Invalidate the row height setting.
setDefaultRowHeight(float) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setStandardHeight(float)
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.
setDepthPercent(int) - Method in class com.aspose.cells.Chart
Represents the depth of a 3-D chart view as a percentage of the chart width (between 20 and 2000 percent).
setDisplayEquation(boolean) - Method in class com.aspose.cells.Trendline
Sets whether the R-squared value of the trendline is displayed on the chart (in the same data label as the equation).
setDisplayRSquared(boolean) - Method in class com.aspose.cells.Trendline
Sets whether the equation for the trendline is displayed on the chart (in the same data label as the R-squared value).
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.
setElevation(int) - Method in class com.aspose.cells.Chart
Represents the elevation of the 3-D chart view, in degrees(between -90 and 90).
setEndColumn(int) - Method in class com.aspose.cells.CellArea
Sets the column index of the bottom right cell.
setEndColumn(int) - Method in class com.aspose.cells.NamedRange
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.
setEndRow(int) - Method in class com.aspose.cells.NamedRange
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.
setFirstSliceAngle(int) - Method in class com.aspose.cells.Chart
Sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).
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.ChartArea
Sets a Font object of the chart area.
setFont(Font) - Method in class com.aspose.cells.ChartDataTable
Sets a Font object which represents the font setting of the specified chart data table.
setFont(Font) - Method in class com.aspose.cells.DataLabels
Sets a Font object of the chart data label.
setFont(Font) - Method in class com.aspose.cells.Legend
Sets a Font object of the chart legend.
setFont(Font) - Method in class com.aspose.cells.Style
Sets the font of the style.
setFont(Font) - Method in class com.aspose.cells.Title
Sets a Font object of title.
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.
setForegroundColor(Color) - Method in class com.aspose.cells.Area
Sets the foreground Color.
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.
setForward(double) - Method in class com.aspose.cells.Trendline
Sets the number of periods (or units on a scatter chart) that the trendline extends forward.
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.Excel
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.
setIntercept(double) - Method in class com.aspose.cells.Trendline
Sets the point where the trendline crosses the value axis.
setInterceptAuto(boolean) - Method in class com.aspose.cells.Trendline
Sets whether Microsoft Excel automatically determines the intercept of the trendline.
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.
setLegendShown(boolean) - Method in class com.aspose.cells.Chart
Sets whether the chart legend will be displayed.Default is true.
setLicense(InputStream) - Method in class com.aspose.cells.License
Licenses the component.
setLine(Line) - Method in class com.aspose.cells.Trendline
Sets the line or border of Trendlines object.
setLogarithmic(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether the value axis scale type is logarithmic or not.
setMajorUnit(double) - Method in class com.aspose.cells.ValueAxis
Sets the major units for the value axis.
setMarkerBackgroundColor(Color) - Method in class com.aspose.cells.ASeries
Sets the marker backgournd color in a line chart, scatter chart, or radar chart.
setMarkerForegroundColor(Color) - Method in class com.aspose.cells.ASeries
Represents the marker foregournd color in a line chart, scatter chart, or radar chart.
setMarkerSize(int) - Method in class com.aspose.cells.ASeries
Sets the marker size in a line chart, scatter chart, or radar chart.
setMarkerStyle(short) - Method in class com.aspose.cells.ASeries
Sets the marker style in a line chart, scatter chart, or radar chart.
setMaxValue(double) - Method in class com.aspose.cells.ValueAxis
Sets the maximum value on the value axis.
setMinorUnit(double) - Method in class com.aspose.cells.ValueAxis
Sets the minor units for the value axis.
setMinValue(double) - Method in class com.aspose.cells.ValueAxis
Sets the minimum value on the value axis.
setName(String) - Method in class com.aspose.cells.ASeries
Sets the name of the data series.
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.Trendline
Sets the name of the trendline.
setName(String) - Method in class com.aspose.cells.Worksheet
Sets the worksheet name.
setNameAuto(boolean) - Method in class com.aspose.cells.Trendline
Sets whether Microsoft Excel automatically determines the name of the trendline.
setNumber(int) - Method in class com.aspose.cells.DataLabels
Sets the built-in display format of numbers and dates.
Use built-in numbers for better performance.
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.
setOrder(int) - Method in class com.aspose.cells.Trendline
Sets the trendline order (between 2 and 6) when the trendline type is Polynomial.
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.
setPercentageShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label Percentage display.
setPeriod(int) - Method in class com.aspose.cells.Trendline
Sets the period for the moving-average trendline.It must be between 2 and 255.
setPerspective(int) - Method in class com.aspose.cells.Chart
Gets the perspective for the 3-D chart view.
setPlacement(byte) - Method in class com.aspose.cells.Picture
Sets the way the picture is attached to the cells below it.
setPlotOrderReversed(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether Microsoft Excel plots data points from last to first.
setPosition(int) - Method in class com.aspose.cells.Legend
Sets the legend position type.
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.
setRange(CellArea) - Method in class com.aspose.cells.AutoFilter
Sets cell range of auto filter.
setRangeStyle(int, int, int, int, Style) - Method in class com.aspose.cells.Cells
Sets a style for an area of cells.
setRed(int) - Method in class com.aspose.cells.Color
Sets the red component value.
setReversed(boolean) - Method in class com.aspose.cells.CategoryAxis
Sets whether Microsoft Excel plots data points from last to first.
setReversed(boolean) - Method in class com.aspose.cells.SeriesAxis
Sets whether Microsoft Excel plots data points from last to first.
setRightAngleAxes(boolean) - Method in class com.aspose.cells.Chart
True if the chart axes are at right angles, independent of chart rotation or elevation.
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.Chart
Represents the rotation of the 3-D chart view (the rotation of the plot area around the series axis, in degrees)(between 0 and 360).
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.
setSeriesShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether chart's data label series names display.
setShadow(boolean) - Method in class com.aspose.cells.ChartArea
Sets whether the chart area has a shadow.
setSheetTabBarHidden(boolean) - Method in class com.aspose.cells.Excel
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.
setShowLegendKeys(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the data label legend key is visible.
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.
setStandardHeight(float) - Method in class com.aspose.cells.Cells
Sets the default row height of the worksheet, in unit of points.
setStandardWidth(float) - Method in class com.aspose.cells.Cells
Sets the default column width of the worksheet, in unit of characters using default font.
setStartColumn(int) - Method in class com.aspose.cells.CellArea
Sets the column index of the top left cell.
setStartColumn(int) - Method in class com.aspose.cells.NamedRange
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.
setStartRow(int) - Method in class com.aspose.cells.NamedRange
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.Column
Sets a style to the column.
setStyle(Style) - Method in class com.aspose.cells.FormatCondition
Sets style of conditional formatted cell range.
setStyle(int) - Method in class com.aspose.cells.Line
Sets the style of the line
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
Deprecated. Replaced by Cells.setRangeStyle(int,int,int,int,Style)
setTabColor(Color) - Method in class com.aspose.cells.Worksheet
Sets the colour of the tab below the sheet containing the sheet name.
setText(String) - Method in class com.aspose.cells.NamedRange
Sets the name of the range.
setText(String) - Method in class com.aspose.cells.Title
Gets the text of a frame's title.
setTextDirection(int) - Method in class com.aspose.cells.Style
Sets the text direction type.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.DataLabels
Sets the text horizontal alignment.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.Title
Sets the text horizontal alignment.
setTextToDisplay(String) - Method in class com.aspose.cells.Hyperlink
Sets text to be displayed for the hyperlink.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.DataLabels
Sets the text vertical alignment of text.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.Title
Sets the text vertical alignment of text.
setTextWrapped(boolean) - Method in class com.aspose.cells.Style
Sets whether the text should be wrapped.
setTickLabelSpacing(int) - Method in class com.aspose.cells.CategoryAxis
Sets the number of category between tick-mark labels.
setTickLabelSpacing(int) - Method in class com.aspose.cells.SeriesAxis
Sets the number of series between tick-mark labels.
setTickMarkSpacing(int) - Method in class com.aspose.cells.CategoryAxis
Sets the number of category between tick marks.
setTickMarkSpacing(int) - Method in class com.aspose.cells.SeriesAxis
Sets the number of series between tick marks.
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.
setUseDefaultHeight(boolean) - Method in class com.aspose.cells.Row
Sets whether row has default row heigt .
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.
setValues(String) - Method in class com.aspose.cells.ASeries
Sets the data of the chart series.
setValueShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label values display.
setVerticalScrollBarHidden(boolean) - Method in class com.aspose.cells.Excel
Sets the vertical scroll bar to be hidden or not.
setVisible(boolean) - Method in class com.aspose.cells.Line
Sets whether the line is visible in the chart.
setVisible(boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the worksheet to be visible or not.
setWeight(int) - Method in class com.aspose.cells.Line
Sets the weight type of the line.
setXValues(String) - Method in class com.aspose.cells.ASeries
Sets the range of x values.
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.
showAll() - Method in class com.aspose.cells.AutoFilter
Shows all items.
SILVER - Static variable in class com.aspose.cells.Color
The color silver.
SINGLE_LINE - Static variable in interface com.aspose.cells.WeightType
Represents the weight of single line.
size() - Method in class com.aspose.cells.Charts
Gets number of charts in the worksheet.
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.NSeries
Gets number of series.
size() - Method in class com.aspose.cells.Pictures
Gets number of pictures in the worksheet.
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.LineType
Represent a solid line.
SOLID - Static variable in interface com.aspose.cells.PatternType
Represents solid pattern.
split() - Method in class com.aspose.cells.Worksheet
Splits window.
SQUARE - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers.
SQUARE_PLUS - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers with a plus sign.
SQUARE_STAR - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers with an asterisk.
SQUARE_X - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers with an X.
STOCK_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents High-Low-Close Stock Chart.
STOCK_OPEN_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents Open-High-Low-Close Stock Chart.
STOCK_VOLUME_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents Volume-High-Low-Close Stock Chart.
STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents Volume-Open-High-Low-Close Stock Chart.
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.
SURFACE_3D - Static variable in interface com.aspose.cells.ChartType
Represents Surface Chart: 3D Surface Chart.
SURFACE_CONTOUR - Static variable in interface com.aspose.cells.ChartType
Represents Contour Chart.
SURFACE_CONTOUR_WIREFRAME - Static variable in interface com.aspose.cells.ChartType
Represents Wireframe Contour Chart.
SURFACE_WIREFRAME_3D - Static variable in interface com.aspose.cells.ChartType
Represents Wireframe 3D Surface Chart.
swapSheet(int, int) - Method in class com.aspose.cells.Excel
Deprecated. Replaced by Worksheets.swapSheet(int,int).
swapSheet(int, int) - Method in class com.aspose.cells.Worksheets
Swaps the positions of two sheets.

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