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

## S

Scatter - Static variable in class com.smartxls.ChartShape
SeriesScale - Static variable in class com.smartxls.ChartShape
set3DBevel(int, int, int, int) - Method in class com.smartxls.ChartShape
set3DClustered(boolean) - Method in class com.smartxls.ChartShape
set3Dimensional(boolean) - Method in class com.smartxls.ChartShape
  Sets whether the chart is 3 dimensional or not.
set3DRotX(int) - Method in class com.smartxls.ChartShape
set3DRotY(int) - Method in class com.smartxls.ChartShape
set3DViewAngle(boolean, int) - Method in class com.smartxls.ChartShape
setActiveCell(int, int) - Method in class com.smartxls.WorkBook
  Sets the row and column coordinates of the active cell.
setAllowBlank(boolean) - Method in class com.smartxls.DataValidation
  set whether the data validation allows the use of empty or blank entries
setAltText(String) - Method in interface com.smartxls.Table
setApplicationName(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the application name
setArrayFormula(int, int, int, int, String) - Method in class com.smartxls.WorkBook
  Sets the array formula for the specified range.
setAspectRatioLocked(boolean) - Method in class com.smartxls.PictureShape
setAuthor(String) - Method in class com.smartxls.CommentShape
  set author of the comment
setAuthor(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the author name
setAuthor(String) - Method in class com.smartxls.TextboxShape
  set author of the comment
setAutoLayoutDirection(boolean) - Method in class com.smartxls.ShapeObj
setAutoMaximumScale(short, int, boolean) - Method in class com.smartxls.ChartShape
  Sets whether the upper limit of the scale of the specified axis is automatically calculated.
setAutoMinimumScale(short, int, boolean) - Method in class com.smartxls.ChartShape
  Sets whether the lower limit of the scale of the selected axis is automatically calculated.
setAutoRecalc(boolean) - Method in class com.smartxls.WorkBook
  enable/disable auto recalc flag
setAxisAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
  set the axis type whether based on the value or not,the axis type is one of auto,text,date
setAxisFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets formatting for the specified axis.
setAxisLengthRatio(int) - Method in class com.smartxls.ChartShape
  Sets the ratio of the area taken up on the selected axis.
setAxisLengthRatio(short, int, int) - Method in class com.smartxls.ChartShape
  Sets the ratio of the area taken up on the specified axis.
setAxisScaleCrosses(short, int, boolean, double) - Method in class com.smartxls.ChartShape
  Sets the crosses value for the specified axis.
setAxisScaleCrossMax(short, int, boolean) - Method in class com.smartxls.ChartShape
  set the axis scale to cross max
setAxisScaleCrossMin(short, int, boolean) - Method in class com.smartxls.ChartShape
  set the axis scale to cross min
setAxisScaleLabelUnit(short, int, int) - Method in class com.smartxls.ChartShape
  set the label unit of the axis scale
setAxisScaleReversed(short, int, boolean) - Method in class com.smartxls.ChartShape
  set the axis scale to be reversed
setAxisScaleTick(short, int, int) - Method in class com.smartxls.ChartShape
  set the tick of the axis scale
setAxisScaleType(short) - Method in class com.smartxls.ChartShape
  Sets the axis scale type for the selected axis.
setAxisScaleType(short, int, short) - Method in class com.smartxls.ChartShape
  Sets the axis scale type for the specified axis.
setAxisTitle(short, int, String) - Method in class com.smartxls.ChartShape
  Sets the title of the specified axis.
setAxisTitleFormat(short, int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets the formatting for the title of the specified axis.
setAxisVisible(boolean) - Method in class com.smartxls.ChartShape
  Sets whether the selected axis is visible.
setAxisVisible(short, int, boolean) - Method in class com.smartxls.ChartShape
  Sets whether the specified axis is visible.
setBackColor(int) - Method in class com.smartxls.ChartFormat
  Sets the color used to display the pattern background.
setBarGapRatio(int) - Method in class com.smartxls.ChartShape
  Sets the bar gap ratio on a bar or column chart.
setBookProtection(boolean, int, String) - Method in class com.smartxls.WorkBook
  Sets whether protection is enabled for this workbook.
setBottomBorder(short) - Method in class com.smartxls.RangeStyle
  Sets the style for the bottom border.
setBottomBorderColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the bottom edge of the cell.
setByteCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the byte count
setCalcOnSave(boolean) - Method in class com.smartxls.WorkBook
  sheet calculated on save setting
setCategory(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the category name
setCategoryFormula(String) - Method in class com.smartxls.ChartShape
  Links the chart categories to the specified formula.
setCategoryScaleCrossBetween(boolean) - Method in class com.smartxls.ChartShape
  set the category scale to cross between
setCellLink(String) - Method in class com.smartxls.FormControlShape
  set the link cell of the control
setCellRange(String) - Method in class com.smartxls.FormControlShape
  set the source range link to the control
setCharCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the char count
setChartFormat(ChartFormat) - Method in class com.smartxls.ChartShape
  Sets chart formatting.
setChartType(short) - Method in class com.smartxls.ChartShape
  A constant designating a chart type.
setCheckState(int) - Method in class com.smartxls.FormControlShape
  set the check box check state 0-uncheck 1-check 2-mixed
setCol(short) - Method in class com.smartxls.CommentShape
  set column of the commented cell.
setCol(short) - Method in class com.smartxls.TextboxShape
  set column of the commented cell.
setCol1(int) - Method in class com.smartxls.RangeArea
  set the start column
setCol2(int) - Method in class com.smartxls.RangeArea
  set the end col
setColHidden(int, boolean) - Method in class com.smartxls.WorkBook
  Sets a flag indicating whether or not the specified column is hidden.
setColorScale(int, Color[]) - Method in class com.smartxls.ConditionFormat
  Sets the colorscale's type of this conditional format.
setColOutlineLevel(int, int, int, boolean) - Method in class com.smartxls.WorkBook
  Sets the outline level of a range of columns.
setColumnTotalsFunc(String, int) - Method in interface com.smartxls.Table
setColWidth(int, int) - Method in class com.smartxls.WorkBook
  Sets the width of a single column.
setColWidthAutoSize(int, boolean) - Method in class com.smartxls.WorkBook
  Sets the widths of the specified columns to automatically adjust to the largest column entry.
setColWidthAutoSize(int, int, int, int, boolean) - Method in class com.smartxls.WorkBook
  Sets the widths of the specified columns to automatically
setCombSelIndex(int) - Method in class com.smartxls.FormControlShape
  set the combox select index
setComments(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the comments
setCompact(boolean) - Method in class com.smartxls.BookPivotRange
  the compact flag is set if true
setCompany(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the company name
setConditionalFormat(ConditionFormat, int, int) - Method in class com.smartxls.BookPivotRange
  apply the conditional formatting to the pivot table
setConditionalFormats(ConditionFormat[]) - Method in class com.smartxls.WorkBook
  Sets the specified conditional formats for the current selection.
setCreationDate(Date) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the creation date
setCSVSeparator(char) - Method in class com.smartxls.WorkBook
  set the csv to use the specified char
setCSVString(String) - Method in class com.smartxls.WorkBook
setCustomFormat(String) - Method in class com.smartxls.ChartFormat
  Sets the number format string
setCustomFormat(String) - Method in class com.smartxls.RangeStyle
  Sets the number format string.
setDataCaption(String) - Method in class com.smartxls.BookPivotRange
  set the data caption
setDataLabelFormat(int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets data label formatting for the specified series.
setDataLabelFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets data label formatting for the specified data point.
setDataLabelPosition(short) - Method in class com.smartxls.ChartFormat
  Sets position of the data label.
setDataLabelSeparator(String) - Method in class com.smartxls.ChartFormat
  Sets the data label separator.
setDataLabelText(int, int, String, boolean) - Method in class com.smartxls.ChartShape
  Sets data label text for the specified data point.
setDataLabelType(short) - Method in class com.smartxls.ChartFormat
  Sets the type of data label to use.
setDataLabelTypes(int) - Method in class com.smartxls.ChartFormat
  Sets the types of data label to use.
setDataLableType(int) - Method in class com.smartxls.ChartShape
  Sets the type of data label to use
setDataOnRow(boolean) - Method in class com.smartxls.BookPivotRange
  set the data field in the column area if flag is false.
setDataPointFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets formatting for the specified data point.
setDataQuery(SXQuery) - Method in class com.smartxls.BookPivotRangeModel
  Deprecated.
  relaced by workbook.addPivotRange(com.smartxls.data.SXQuery query, int dstSheet, int dstRow1, int dstCol1)
setDataValidation(DataValidation) - Method in class com.smartxls.WorkBook
  Sets the specified data validations for the current selection.
setDataValidationForCell(int, int, DataValidation) - Method in class com.smartxls.WorkBook
  Deprecated.
  used for fast adding cell only,should avoid multi-ranges/overlaped cell(range) adding.
setDefaultColWidth(int) - Method in class com.smartxls.WorkBook
  Sets the default column width of worksheet.
setDefaultFontName(String) - Method in class com.smartxls.WorkBook
  set the default font name
setDefaultRowHeight(int) - Method in class com.smartxls.WorkBook
  Sets the default row height of whole worksheet.
setDefinedName(String, String) - Method in class com.smartxls.WorkBook
  Sets the formula associated with a defined name
setDiagBorderAndColor(boolean, boolean, short, int) - Method in class com.smartxls.RangeStyle
setDisplayName(String) - Method in interface com.smartxls.Table
setDocPropParsing(boolean) - Method in class com.smartxls.WorkBook
  set this flag will allow to parse the document property,default not parsing
setDropLinesFormat(ChartFormat) - Method in class com.smartxls.ChartShape
  Sets drop line formatting.
setDropLinesVisible(boolean) - Method in class com.smartxls.ChartShape
  Sets whether drop lines are visible.
setEnableProtection(boolean) - Method in class com.smartxls.WorkBook
  enable/disable protection for current selected sheet.
setEntry(int, int, String) - Method in class com.smartxls.WorkBook
  Sets the value to the specified cell of current selected worksheets.
setEntry(int, int, int, String) - Method in class com.smartxls.WorkBook
  Sets the value of a specified cell on the specified worksheet.
setErrorBars(int, boolean, int, boolean, String) - Method in class com.smartxls.ChartShape
  set the errorbar informations
setErrorBars(int, boolean, int, boolean, int, int) - Method in class com.smartxls.ChartShape
  set the errorbar informations
setErrorBoxText(String) - Method in class com.smartxls.DataValidation
  set dv's error box text
setErrorBoxTitle(String) - Method in class com.smartxls.DataValidation
  the dv's error box title
setErrorCaption(boolean, String) - Method in class com.smartxls.BookPivotRange
  set the error caption
setErrorStyle(int) - Method in class com.smartxls.DataValidation
  set the dv error style stop`DataValidation.eStop` warning info
setExplosion(int) - Method in class com.smartxls.ChartShape
  Sets the explosion percentage.
seText(String) - Method in class com.smartxls.CommentShape
  set the text content of the comment
seText(String) - Method in class com.smartxls.TextboxShape
  set the text content of the comment
setFieldItemHidden(int, boolean) - Method in class com.smartxls.BookPivotField
  set the field item hidden or shown
setFileShareProtection(String) - Method in class com.smartxls.WorkBook
  Set the workbook file to readonly with password
setFill(int) - Method in class com.smartxls.ShapeFormat
  set the fill color
setFillAlpha(double) - Method in class com.smartxls.ChartFormat
  specifies the input color with the specific opacity.
setFillAuto(boolean) - Method in class com.smartxls.ChartFormat
  Sets whether fill is auto.
setFillPicture(String) - Method in class com.smartxls.ChartFormat
setFillShadow(boolean) - Method in class com.smartxls.ChartFormat
  Sets whether an object includes a shadow behind it.
setFillTexture(ExcelTexture) - Method in class com.smartxls.ChartFormat
setFillVisible(boolean) - Method in class com.smartxls.ChartFormat
  set the visibility for this fill property
setFontAutoScale(boolean) - Method in class com.smartxls.ChartFormat
  Sets whether fonts are automatically scaled based on chart size.
setFontBold(boolean) - Method in class com.smartxls.ChartFormat
  Sets the bold attribute of the font.
setFontBold(boolean) - Method in class com.smartxls.RangeStyle
  Sets the bold attribute of the font.
setFontCharSet(int) - Method in class com.smartxls.RangeStyle
  Sets the font charset.
setFontColor(int) - Method in class com.smartxls.ChartFormat
  Sets the color used to display the font.
setFontColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the font.
setFontItalic(boolean) - Method in class com.smartxls.ChartFormat
  Sets the italic attribute of the font.
setFontItalic(boolean) - Method in class com.smartxls.RangeStyle
  Sets the italic attribute of the font.
setFontName(String) - Method in class com.smartxls.ChartFormat
  Sets the font name.
setFontName(String) - Method in class com.smartxls.RangeStyle
  Sets the font name.
setFontOutline(boolean) - Method in class com.smartxls.RangeStyle
  Sets the Outline attribute of the font.
setFontShadow(boolean) - Method in class com.smartxls.RangeStyle
  Sets the Shadow attribute of the font.
setFontSize(int) - Method in class com.smartxls.ChartFormat
  Sets the font size in twips.
setFontSize(int) - Method in class com.smartxls.RangeStyle
  Sets the font size in twips.
setFontSizeInPoints(double) - Method in class com.smartxls.ChartFormat
  set the font size
setFontStrikeout(boolean) - Method in class com.smartxls.RangeStyle
  Sets the strikeout attribute of the font.
setFontSubscript(boolean) - Method in class com.smartxls.RangeStyle
  Sets the Subscript attribute of the font.
setFontSuperscript(boolean) - Method in class com.smartxls.RangeStyle
  Sets the Subscript attribute of the font.
setFontUnderline(boolean) - Method in class com.smartxls.ChartFormat
  Sets the underline attribute of the font.
setFontUnderline(short) - Method in class com.smartxls.RangeStyle
  Sets the underline attribute of the font.
setForeColor(int) - Method in class com.smartxls.ChartFormat
  Sets the color used to display the pattern foreground.
setFormat(ShapeFormat) - Method in class com.smartxls.ShapeObj
  Sets the Format for this shape.
setFormula(int, int, String) - Method in class com.smartxls.WorkBook
  Sets the formula for the specified cell in current selected sheets.
setFormula(int, int, int, String) - Method in class com.smartxls.WorkBook
  Sets the formula for the specified cell on the specified sheet.
setFormula1(String, int, int) - Method in class com.smartxls.ConditionFormat
  Sets the first formula associated with this conditional format
setFormula1(String) - Method in class com.smartxls.DataValidation
  set the first formula
setFormula2(String, int, int) - Method in class com.smartxls.ConditionFormat
  Sets the second formula associated with this conditional format
setFormula2(String) - Method in class com.smartxls.DataValidation
  set the second formula
setGapWidthRatio(int) - Method in class com.smartxls.ChartShape
  Sets the gap width ratio.
setGradient() - Method in class com.smartxls.ChartFormat
  Sets the fill to Gradient.
setGradient(ExcelGradientStyle) - Method in class com.smartxls.ChartFormat
setGradientTwoColor(int, int, int, int) - Method in class com.smartxls.RangeStyle
  Sets the gradient fill with two colors.
setGroup(String) - Method in class com.smartxls.WorkBook
  group name
setHidden(boolean) - Method in class com.smartxls.RangeStyle
  Sets the hiden cell flag
setHiddenCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the hidden count
setHorizontalAlignment(short) - Method in class com.smartxls.RangeStyle
  Sets the horizontal alignment.
setHorizontalInsideBorder(short) - Method in class com.smartxls.RangeStyle
  Sets the horizontal inside border style.
setHorizontalInsideBorderColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color of the horizontal inside border.
setIgnoreEmptyCellsInParsing(boolean) - Method in class com.smartxls.WorkBook
  ignore empty cells when load xlsx file
setIndent(int) - Method in class com.smartxls.RangeStyle
  Set the indent attribute
setIndex(int) - Method in interface com.smartxls.Table
setInGridZone(boolean) - Method in class com.smartxls.BookPivotRange
  the grid zone is set if true
setInlineCellTextMode(boolean) - Method in class com.smartxls.WorkBook
  enable the xlsx/xlsm file writing in the inlinestr cell text mode
setIterationEnabled(boolean) - Method in class com.smartxls.WorkBook
  Sets whether iteration is enabled.
setIterationMax(int) - Method in class com.smartxls.WorkBook
  Sets the maximum number of iterations.
setIterationMaxChange(double) - Method in class com.smartxls.WorkBook
  Sets the maximum iteration change value.
setKeywords(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the key words
setLastAuthor(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the last author name
setLastPrinted(Date) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the last printed date
setLastSaveDate(Date) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the last saved date
setLayout(boolean, boolean, boolean) - Method in class com.smartxls.BookPivotField
  set the pivot field lay out setting
setLeftBorder(short) - Method in class com.smartxls.RangeStyle
  Sets the style for the left border.
setLeftBorderColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the left edge of the cell.
setLegendFormat(ChartFormat) - Method in class com.smartxls.ChartShape
  Sets legend formatting.
setLegendPosition(short) - Method in class com.smartxls.ChartShape
  set legend position
setLegendVisible(boolean) - Method in class com.smartxls.ChartShape
  Sets whether legend is visible.
setLineAuto() - Method in class com.smartxls.ChartFormat
  set line auto
setLineColor(int) - Method in class com.smartxls.ChartFormat
  Sets the color.
setLineCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the line count
setLineCustom() - Method in class com.smartxls.ChartFormat
  set line custom style and weight
setLineNone() - Method in class com.smartxls.ChartFormat
  set line none
setLineShadow(boolean) - Method in class com.smartxls.ChartFormat
  set the line shadow.
setLineStyle(short) - Method in class com.smartxls.ChartFormat
  Sets the style.
setLineWeight(int) - Method in class com.smartxls.ChartFormat
  Sets the weight.
setLinkedToDataSource(boolean) - Method in class com.smartxls.ChartFormat
  Sets whether the object gets the value format from the data source.
setLinkRange(String, boolean) - Method in class com.smartxls.ChartShape
  Links the chart to the range in the workbook represented by the specified formula.
setLinkShowString(String) - Method in class com.smartxls.HyperLink
  set the hyperlink's link show string
setLinkURLString(String) - Method in class com.smartxls.HyperLink
  set the hyperlink's link URL string
setList(String) - Method in class com.smartxls.BookPivotRangeModel
  Deprecated.
  relaced by workbook.addPivotRange(...)
setListSelection(int, boolean[]) - Method in class com.smartxls.FormControlShape
  set the listbox selection type and selected index
setLocation(int, int, int) - Method in class com.smartxls.BookPivotRangeModel
  Deprecated.
  relaced by workbook.addPivotRange(...)
setLocked(boolean) - Method in class com.smartxls.RangeStyle
  Sets the locked cell flag
setLogScale(boolean) - Method in class com.smartxls.ChartShape
  Sets the axis to logarithmic base.
setLogScale(int, int, boolean) - Method in class com.smartxls.ChartShape
  Sets the axis to logarithmic base.
setMajorGridFormat(short, int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets grid line formatting information for the major grid of the specified axis.
setMajorGridVisible(boolean) - Method in class com.smartxls.ChartShape
  Sets whether the major grid lines of the selected axis are visible.
setMajorGridVisible(short, int, boolean) - Method in class com.smartxls.ChartShape
  Sets whether the major grid lines of the specified axis are visible.
setManager(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the manager name
setMarkerAuto(boolean) - Method in class com.smartxls.ChartFormat
  Sets the marker type to be assigned automatically.
setMarkerBackground(int) - Method in class com.smartxls.ChartFormat
  Sets marker background color as an RGB value.
setMarkerForeground(int) - Method in class com.smartxls.ChartFormat
  Sets marker foreground color as an RGB value.
setMarkerSize(int) - Method in class com.smartxls.ChartFormat
  Sets marker size in twips.
setMarkerStyle(short) - Method in class com.smartxls.ChartFormat
  Sets marker style.
setMergeCells(boolean) - Method in class com.smartxls.RangeStyle
  Sets the mergeCells attribute.
setMinorGridFormat(short, int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets grid line formatting information for the minor grid of the specified axis.
setMinorGridVisible(boolean) - Method in class com.smartxls.ChartShape
  Sets whether the minor grid lines of the selected axis are visible.
setMinorGridVisible(short, int, boolean) - Method in class com.smartxls.ChartShape
  Sets whether the minor grid lines of the specified axis are visible.
setMissingCaption(boolean, String) - Method in class com.smartxls.BookPivotRange
  set the caption for the null values
setName(String) - Method in class com.smartxls.ShapeObj
  set the shape name
setName(String) - Method in interface com.smartxls.Table
setNumber(int, int, double) - Method in class com.smartxls.WorkBook
  Sets the numeric value of the specified cell in current selected sheet.
setNumber(String, double) - Method in class com.smartxls.WorkBook
  Sets the numeric value of the specified cell in current selected sheet.
setNumber(int, int, int, double) - Method in class com.smartxls.WorkBook
  Sets the numeric value of the specified cell in the specified worksheet.
setNumberFormatting(String) - Method in class com.smartxls.BookPivotField
  set the custom formatting for area in pivot table
setNumSheets(int) - Method in class com.smartxls.WorkBook
  Sets the number of worksheets in the current workbook.
setOperator(short) - Method in class com.smartxls.ConditionFormat
  Sets the operator for this conditional format.
setOperator(int) - Method in class com.smartxls.DataValidation
  set the dv operator between`DataValidation.eBetween` notbetween equal notequal greater less greaterorequal lessorequal
setOrientation(int) - Method in class com.smartxls.ChartFormat
  set the orientation
setOrientation(short) - Method in class com.smartxls.RangeStyle
  Sets the orientation type.
setPaletteEntry(int, int, int, int) - Method in class com.smartxls.WorkBook
  Sets a color in the workbook color palette using decimal values.
setPattern(int) - Method in class com.smartxls.ChartFormat
  Sets the pattern.
setPattern(short) - Method in class com.smartxls.RangeStyle
  Sets the pattern type.
setPatternBG(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the pattern background.
setPatternFG(int) - Method in class com.smartxls.ChartFormat
  set the fg color in RGB
setPatternFG(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the pattern foreground.
setPercent(boolean) - Method in class com.smartxls.ChartShape
  Sets boolean indicating whether the values in the chart are plotted as percentages of the category.
setPieExplosion(int, int) - Method in class com.smartxls.ChartShape
  Sets the explosion percentage of the specified data point.
setPivotSource(BookPivotRange) - Method in class com.smartxls.ChartShape
  link the chart to pivot range
setPlacementStyle(int) - Method in class com.smartxls.ShapeFormat
  set the place style freefloating`ShapeFormat.PlacementFreeFloating` move moveandsize
setPlotFormat(ChartFormat) - Method in class com.smartxls.ChartShape
  Sets plot formatting.
setPlotGroupStack(int, boolean) - Method in class com.smartxls.ChartShape
  Sets the selected PlotGroup to display stacked series.
setPlotStacked(boolean) - Method in class com.smartxls.ChartShape
  Sets the selected plot to display stacked series.
setPlotVisibleDataOnly(boolean) - Method in class com.smartxls.ChartShape
  Sets whether to display the hidden data.
setPosition(double, double, double, double) - Method in class com.smartxls.ShapeObj
  set the shape position
setPrintArea(String) - Method in class com.smartxls.WorkBook
  Sets the current print area to the specified range
setPrintAutoPageNumbering(boolean) - Method in class com.smartxls.WorkBook
  Turns on/off auto page numbering.
setPrintBottomMargin(double) - Method in class com.smartxls.WorkBook
  Sets the bottom print margin.
setPrintFooter(String) - Method in class com.smartxls.WorkBook
  Sets the current page footer.
setPrintFooterMargin(double) - Method in class com.smartxls.WorkBook
  Sets the page footer margin
setPrintGridLines(boolean) - Method in class com.smartxls.WorkBook
  Sets a flag indicating whether grid lines are printed for the current sheet.
setPrintHCenter(boolean) - Method in class com.smartxls.WorkBook
  Sets a flag indicating whether the current sheet is centered horizontally when printed.
setPrintHeader(String) - Method in class com.smartxls.WorkBook
  Sets the page header printed at the top of each page.
setPrintHeaderMargin(double) - Method in class com.smartxls.WorkBook
  Sets the page header margin .
setPrintHFAlignMargin(boolean) - Method in class com.smartxls.WorkBook
setPrintHFScaleDoc(boolean) - Method in class com.smartxls.WorkBook
setPrintLandscape(boolean) - Method in class com.smartxls.WorkBook
  set the orientation of the print job.
setPrintLeftMargin(double) - Method in class com.smartxls.WorkBook
  Sets the left print margin.
setPrintLeftToRight(boolean) - Method in class com.smartxls.WorkBook
  Sets a flag determining whether the current sheet is printed left to right then top to bottom, or top to bottom then left to right.
setPrintNoColor(boolean) - Method in class com.smartxls.WorkBook
  set print job printed in color black and white.
setPrintNumberOfCopies(int) - Method in class com.smartxls.WorkBook
  Sets the number copies to print.
setPrintPaperSize(short) - Method in class com.smartxls.WorkBook
  Sets paper size print setting value.
setPrintPaperSize(int, int) - Method in class com.smartxls.WorkBook
  Sets the size of the paper in twips (1/20th of a point)
setPrintRightMargin(double) - Method in class com.smartxls.WorkBook
  Sets the right print margin in inches.
setPrintRowColHeading(boolean) - Method in class com.smartxls.WorkBook
  Sets a flag that determines whether or not row/col headings are printed for the current sheet.
setPrintScale(int) - Method in class com.smartxls.WorkBook
  Sets the scale factor for the current worksheet.
setPrintScaleFitHPages(int) - Method in class com.smartxls.WorkBook
  Sets the number of horizontal pages to which the print job is fit.
setPrintScaleFitToPage(boolean) - Method in class com.smartxls.WorkBook
  Sets whether pages are scaled to fit the specified number of pages when printed.
setPrintScaleFitVPages(int) - Method in class com.smartxls.WorkBook
  Sets the number of vertical pages to which the print job is fit.
setPrintStartPageNumber(int) - Method in class com.smartxls.WorkBook
  Sets the starting page to print.
setPrintTitles(String) - Method in class com.smartxls.WorkBook
  Sets the print titles to be printed at the top of each page
setPrintTopMargin(double) - Method in class com.smartxls.WorkBook
  Sets the top print margin.
setPrintVCenter(boolean) - Method in class com.smartxls.WorkBook
  Sets a flag indicating whether the current sheet is centered vertically when printed.
setPromtBoxText(String) - Method in class com.smartxls.DataValidation
  set the dv's promt box text
setPromtBoxTitle(String) - Method in class com.smartxls.DataValidation
  set the title of the dv's promt box
setPropertyValue(String, Object) - Method in interface com.smartxls.DocumentCustomProperties
  set the property
setRange(int, int, int, int) - Method in class com.smartxls.HyperLink
  set the hyperlink range
setRangeStyle(RangeStyle) - Method in class com.smartxls.ConditionFormat
  Sets formatting options for this conditional format from the specified RangeStyle object.
setRangeStyle(RangeStyle) - Method in class com.smartxls.WorkBook
  Sets the RangeStyle of the selected range of cells.
setRangeStyle(RangeStyle, int, int, int, int) - Method in class com.smartxls.WorkBook
  Sets the RangeStyle of the selected range of cells.
setRightBorder(short) - Method in class com.smartxls.RangeStyle
  Sets the style for the right border.
setRightBorderColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the right edge of the cell.
setRow(short) - Method in class com.smartxls.CommentShape
  set row of the commented cell
setRow(short) - Method in class com.smartxls.TextboxShape
  set row of the commented cell
setRow1(int) - Method in class com.smartxls.RangeArea
  set the start row
setRow2(int) - Method in class com.smartxls.RangeArea
  set the end row
setRowHeight(int, int) - Method in class com.smartxls.WorkBook
  Sets the height of a single specified row.
setRowHeightAutoSize(int, boolean) - Method in class com.smartxls.WorkBook
  Specifies that the height of the specified row is automatically set to display the tallest entry in the row.
setRowHidden(int, boolean) - Method in class com.smartxls.WorkBook
  Sets the display status of the specified row.
setRowOutlineLevel(int, int, int, boolean) - Method in class com.smartxls.WorkBook
  Sets the outline level of a range of rows.
setRowStripes(boolean) - Method in interface com.smartxls.Table
setScaleMajorUnit(short, int, double) - Method in class com.smartxls.ChartShape
  set the major scale unit of the selected axis.
setScaleMajorUnitAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
  set the major unit of the scale to auto
setScaleMinorUnit(short, int, double) - Method in class com.smartxls.ChartShape
  set the minor scale unit of the selected axis.
setScaleMinorUnitAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
  set the minor unit of the scale to auto
setScaleValueRange(short, int, double, double) - Method in class com.smartxls.ChartShape
  Sets the minimum and maximum range of the selected axis.
setSelection(int, int, int, int) - Method in class com.smartxls.WorkBook
  Selects the specified range and moves the active cell to the top left cell in the range.
setSelection(String) - Method in class com.smartxls.WorkBook
  Selects the range represented by the formula.
setSeriesFormat(int, ChartFormat) - Method in class com.smartxls.ChartShape
  Sets the format of the specified series.
setSeriesName(int, String) - Method in class com.smartxls.ChartShape
  Sets the name of the specified series.
setSeriesPicFormat(int, int) - Method in class com.smartxls.ChartShape
  Sets the picture/texture fill options of the specified series.
setSeriesSizeValueFormula(int, String) - Method in class com.smartxls.ChartShape
  Sets the size value formula of the specified series.
setSeriesSmoothedLine(int) - Method in class com.smartxls.ChartShape
  set the series smooth line
setSeriesSmoothedLine(int, boolean) - Method in class com.smartxls.ChartShape
  set the series to use smothed line
setSeriesType(short) - Method in class com.smartxls.ChartShape
  Sets the series type of the selected series.
setSeriesType(int, short) - Method in class com.smartxls.ChartShape
  Sets the series type of the specified series.
setSeriesXValueFormula(int, String) - Method in class com.smartxls.ChartShape
  Sets the X axis value formula of the specified series.
setSeriesYAxisIndex(int, int) - Method in class com.smartxls.ChartShape
  Sets the index of the Y axis that the specified series is plotted on.
setSeriesYValueFormula(int, String) - Method in class com.smartxls.ChartShape
  Returns the Y axis value formula of the specified series.
setSheet(int) - Method in class com.smartxls.RangeArea
  set the sheet index
setSheet(int) - Method in class com.smartxls.WorkBook
  Selects a worksheet
setSheetHidden(int) - Method in class com.smartxls.WorkBook
  Sets the hidden state for the current selected sheet.
setSheetName(int, String) - Method in class com.smartxls.WorkBook
  Assigns a name to the specified worksheet.
setSheetProtected(int, boolean, String) - Method in class com.smartxls.WorkBook
  Sets whether protection is enabled for the specified sheet.
setSheetProtected(int, int, String) - Method in class com.smartxls.WorkBook
  Sets whether protection is enabled for the specified sheet.
setSheetRightToLeft(boolean) - Method in class com.smartxls.WorkBook
  sheet right to left setting
setSheetTabColor(Color) - Method in class com.smartxls.WorkBook
  set the color to the sheet tab
setSheetViewType(int) - Method in class com.smartxls.WorkBook
  Sets the sheet view type..
setShowColGrandTotal(boolean) - Method in class com.smartxls.BookPivotRange
  set the col grand total is shown if true
setShowDataAs(ShowDataAs) - Method in class com.smartxls.BookPivotField
  set the ShowDataAs value for the summary field
setShowDetail(boolean) - Method in class com.smartxls.BookPivotField
  set whether the details are hidden for this field
setShowDrill(boolean) - Method in class com.smartxls.BookPivotRange
  the drill flag is set if true
setShowDropDown(boolean) - Method in class com.smartxls.DataValidation
setShowErrorMessage(boolean) - Method in class com.smartxls.DataValidation
setShowGridLines(boolean) - Method in class com.smartxls.WorkBook
  Sets whether grid lines are displayed.
setShowHeader(boolean) - Method in class com.smartxls.BookPivotRange
  header is shown if true
setShowHScrollBar(short) - Method in class com.smartxls.WorkBook
  Sets the mode for the horizontal scroll bar.
setShowInputMessage(boolean) - Method in class com.smartxls.DataValidation
setShowOutlines(boolean) - Method in class com.smartxls.WorkBook
  set whether the outline shown or not
setShowRowColHeader(boolean) - Method in class com.smartxls.WorkBook
  Sets whether row/col headers are displayed.
setShowRowGrandTotal(boolean) - Method in class com.smartxls.BookPivotRange
  set the row grand total is shown if true
setShowTabs(short) - Method in class com.smartxls.WorkBook
  Sets the visibility or position of the sheet name tabs on a workbook.
setShowVScrollBar(short) - Method in class com.smartxls.WorkBook
  Sets the mode for the vertical scroll bar.
setShowZeroValues(boolean) - Method in class com.smartxls.WorkBook
  Sets whether zero value cells are displayed.
setShrinkToFit(boolean) - Method in class com.smartxls.RangeStyle
  Sets the ShrinkToFit attribute.
setSizeEMUs(long, long) - Method in class com.smartxls.PictureShape
setSizePixels(int, int) - Method in class com.smartxls.PictureShape
setSolid() - Method in class com.smartxls.ChartFormat
  Sets the fill to solid.
setSortType(int) - Method in class com.smartxls.BookPivotField
  set the sort type
setStartAngle(int) - Method in class com.smartxls.ChartShape
  set the start angle of the 3D chart
setSubject(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the subject
setSubTotalType(int) - Method in class com.smartxls.BookPivotField
  set the type of subtotal
setSummarizeFieldCalcType(int, String) - Method in class com.smartxls.BookPivotField
  Set the current calculation type of the summary field
setSummaryColsBeforeDetail(boolean) - Method in class com.smartxls.WorkBook
  Sets whether col outline summaries come before col detail information.
setSummaryRowsBeforeDetail(boolean) - Method in class com.smartxls.WorkBook
  Sets whether row outline summaries come before row detail information.
setTabbedText(int, int, boolean, String) - Method in class com.smartxls.WorkBook
  set tab-delimited text in workbook
setTableBuiltInStyles(TableBuiltInStyles) - Method in interface com.smartxls.Table
setTableCustomStyle(String) - Method in class com.smartxls.BookPivotRange
  apply the custom table style to the pivot table,the style must be exist in the workbook
setTableCustomStyle(String) - Method in interface com.smartxls.Table
setTableFormat(RangeStyle, int) - Method in class com.smartxls.BookPivotRange
  format the selection part of the pivot table
setTableStyle(PivotBuiltInStyles) - Method in class com.smartxls.BookPivotRange
setTemplate(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the template name
setText(String) - Method in class com.smartxls.AutoShape
  set the text content of the control
setText(String) - Method in class com.smartxls.FormControlShape
  set the lable of the control
setText(int, int, int, String) - Method in class com.smartxls.WorkBook
  Sets the value of the specified cell in the specified sheet.
setText(String, String) - Method in class com.smartxls.WorkBook
  sets the text value to the specified named cell
setText(int, int, String) - Method in class com.smartxls.WorkBook
  Sets the value of the specified cell for current selected sheet.
setTextRotation(int) - Method in class com.smartxls.ChartFormat
  set the text rotation
setTextSelection(RangeStyle, int, int) - Method in class com.smartxls.CommentShape
  Sets text selection formatting
setTextSelection(int, int) - Method in class com.smartxls.WorkBook
  Sets text selection for the selected cell
setTickLabelPosition(int, int, int) - Method in class com.smartxls.ChartShape
  Sets the tick label position on the specified axis.
setTickStyle(int, int, boolean, int) - Method in class com.smartxls.ChartShape
  Sets the tick label position on the specified axis.
setTimeScaleBaseUnitAndInterval(int, int, int, int) - Method in class com.smartxls.ChartShape
  set the time scale base unit and interval
setTimeScaleBaseUnitAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
  set base unit of the timescale to auto
setTimeScaleMajorUnit(int, int, int, int) - Method in class com.smartxls.ChartShape
  set the time scale major unit
setTimeScaleMinorUnit(int, int, int, int) - Method in class com.smartxls.ChartShape
  set the time scale minor unit
setTitle(String) - Method in class com.smartxls.ChartShape
  Sets the chart title.
setTitle(String) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the title
setTitleFormat(ChartFormat) - Method in class com.smartxls.ChartShape
  Sets chart title formatting.
setToolTip(String) - Method in class com.smartxls.HyperLink
  set the tool tip string
setTopBorder(short) - Method in class com.smartxls.RangeStyle
  Sets the style for the top edge of the cell.
setTopBorderColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the top edge of the cell.
setTotalRow(boolean, String) - Method in interface com.smartxls.Table
setTotalRowCount(int) - Method in interface com.smartxls.Table
setTrendLineDisplayEquation(int, int, boolean) - Method in class com.smartxls.ChartShape
setTrendLineDisplayRSquared(int, int, boolean) - Method in class com.smartxls.ChartShape
setTrendLineFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
setTrendLineIntercept(int, int, double) - Method in class com.smartxls.ChartShape
setTrendLinePeriod(int, int, short) - Method in class com.smartxls.ChartShape
setTrendLineType(int, int, int) - Method in class com.smartxls.ChartShape
  set the trendline type -1-linear(default) 0-ploy 1-exp 2-log 3-power 4-movingAvg
setType(short) - Method in class com.smartxls.ConditionFormat
  Sets the type of this conditional format.
setType(int) - Method in class com.smartxls.DataValidation
  set the data validation type any`DataValidation.eAny` integer decimal user date time textlength formula
setType(int) - Method in class com.smartxls.HyperLink
  set the hyperlink type
setValueFormatLinkedToDataSource(boolean) - Method in class com.smartxls.ChartFormat
  Sets whether the object gets the value format from the data source.
setValueScaleDisplayUnit(int, int, int) - Method in class com.smartxls.ChartShape
  set the display unit of the value scale
setValueScaleDisplayUnitValue(int, int, int) - Method in class com.smartxls.ChartShape
  set the display unit of the value scale
setVaryColors(boolean) - Method in class com.smartxls.ChartShape
  Sets a boolean indicating whether the series in the chart use varied colors.
setVerticalAlignment(short) - Method in class com.smartxls.RangeStyle
  Sets the type of vertical alignment.
setVerticalInsideBorder(short) - Method in class com.smartxls.RangeStyle
  Sets the border style for the vertical inside border.
setVerticalInsideBorderColor(int) - Method in class com.smartxls.RangeStyle
  Sets the color used to display the vertical inside border.
setViewScale(int) - Method in class com.smartxls.WorkBook
  Sets the current display scale for a workbook.
setWordCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
  set the words count
setWordWrap(boolean) - Method in class com.smartxls.RangeStyle
  Sets the wordwrap attribute.
setWorkbookName(String) - Method in class com.smartxls.WorkBook
  the workbook name
setWorkBookVersion(ExcelVersion) - Method in class com.smartxls.WorkBook
setXMLStaxMode(boolean) - Method in class com.smartxls.WorkBook
  enable the xlsx/xlsm file parsing in the stax mode
setYAxisCount(int) - Method in class com.smartxls.ChartShape
  Sets the number of Y axes on the chart.
ShapeFormat - Class in com.smartxls
  This class represents the shape format object.
ShapeObj - Class in com.smartxls
  This class is base class of drawing Format.
ShapePos - Class in com.smartxls
  the shape placement position
SheetNormalView - Static variable in class com.smartxls.WorkBook
  sheet page layout normal
SheetPageBreakPreView - Static variable in class com.smartxls.WorkBook
  sheet page layout in break preview mode
SheetPageLayoutView - Static variable in class com.smartxls.WorkBook
  sheet page layout in page mode
sheetProtectionAllowChangeLocked - Static variable in class com.smartxls.WorkBook
  sheet protection allow change locked
sheetProtectionAllowChangeUnlocked - Static variable in class com.smartxls.WorkBook
  sheet protection allow change unlocked
sheetProtectionAllowDefault - Static variable in class com.smartxls.WorkBook
  sheet protection allow default options
sheetProtectionAllowDeleteColumns - Static variable in class com.smartxls.WorkBook
  sheet protection allow delete cols
sheetProtectionAllowDeleteRows - Static variable in class com.smartxls.WorkBook
  sheet protection allow delete rows
sheetProtectionAllowEditObjects - Static variable in class com.smartxls.WorkBook
  sheet protection allow edit object
sheetProtectionAllowEditScenarios - Static variable in class com.smartxls.WorkBook
  sheet protection allow edit scenarios
sheetProtectionAllowEverything - Static variable in class com.smartxls.WorkBook
  sheet protection allow everything
sheetProtectionAllowFormatCells - Static variable in class com.smartxls.WorkBook
  sheet protection allow format cells
sheetProtectionAllowFormatColumns - Static variable in class com.smartxls.WorkBook
  sheet protection allow format columns
sheetProtectionAllowFormatRows - Static variable in class com.smartxls.WorkBook
  sheet protection allow format rows
sheetProtectionAllowInsertColumns - Static variable in class com.smartxls.WorkBook
  sheet protection allow insert columns
sheetProtectionAllowInsertHyperlinks - Static variable in class com.smartxls.WorkBook
  sheet protection allow insert hyperlink
sheetProtectionAllowInsertRows - Static variable in class com.smartxls.WorkBook
  sheet protection allow insert rows
sheetProtectionAllowLockedEditFocus - Static variable in class com.smartxls.WorkBook
  sheet protection allow locked edit focus
sheetProtectionAllowLockedInCellEdit - Static variable in class com.smartxls.WorkBook
  sheet protection allow locked in cell edit
sheetProtectionAllowNone - Static variable in class com.smartxls.WorkBook
  sheet protection none
sheetProtectionAllowSelectLocked - Static variable in class com.smartxls.WorkBook
  sheet protection allow selected locked
sheetProtectionAllowSelectUnlocked - Static variable in class com.smartxls.WorkBook
  sheet protection allow select unlocked
sheetProtectionAllowSort - Static variable in class com.smartxls.WorkBook
  sheet protection allow sort
sheetProtectionAllowUseAutoFilter - Static variable in class com.smartxls.WorkBook
  sheet protection allow use autofilter
sheetProtectionAllowUseOutlining - Static variable in class com.smartxls.WorkBook
  sheet protection allow use outlining
sheetProtectionAllowUsePivotRanges - Static variable in class com.smartxls.WorkBook
  sheet protection allow use pivot ranges
sheetRangeToImage(String) - Method in class com.smartxls.WorkBook
  write sheet range to image sheet range is from (0,0) to (last row,last col).
sheetRangeToImage(int, int, int, int, String) - Method in class com.smartxls.WorkBook
  write specified range to image
sheetRangeToImage(int, int, int, int) - Method in class com.smartxls.WorkBook
  rendering specified range content to an image
SheetStateHidden - Static variable in class com.smartxls.WorkBook
  sheet hidden
SheetStateShown - Static variable in class com.smartxls.WorkBook
  sheet shown normally
SheetStateVeryHidden - Static variable in class com.smartxls.WorkBook
  sheet hidden and can't be unhide from UI
SheetVarType - Enum in com.smartxls
  ignoredError_numberStoredAsText --- the attribute "numberStoredAsText" of the ignoredError for the current worksheet
ShiftColumns - Static variable in class com.smartxls.WorkBook
  cell/range shift direction,cols
ShiftHorizontal - Static variable in class com.smartxls.WorkBook
  cell/range shift direction,horizontal
ShiftRows - Static variable in class com.smartxls.WorkBook
  cell/range shift direction,rows
ShiftVertical - Static variable in class com.smartxls.WorkBook
  cell/range shift direction,vertical
ShowAutomatic - Static variable in class com.smartxls.WorkBook
  scrollbar shown automatically
ShowOff - Static variable in class com.smartxls.WorkBook
  scrollbar not shown
ShowOn - Static variable in class com.smartxls.WorkBook
  scrollbar shown always
sort(int, int, int, int, boolean, int, int, int) - Method in class com.smartxls.WorkBook
  Specified a range of data to be sorted by three keys.
sort(int, int, int, int, boolean, int[]) - Method in class com.smartxls.WorkBook
  Specified a range of data to be sorted by the keys.
SortAscend - Static variable in class com.smartxls.BookPivotField
SortAuto - Static variable in class com.smartxls.BookPivotField
SortDescend - Static variable in class com.smartxls.BookPivotField
SortManual - Static variable in class com.smartxls.BookPivotField
Step - Static variable in class com.smartxls.ChartShape
subTotal(int, int, int, int, int, int[]) - Method in class com.smartxls.WorkBook
  Specified a range of data to be subtotaled.
SubTotalTypeAutomatic - Static variable in class com.smartxls.BookPivotField
SubTotalTypeCustom - Static variable in class com.smartxls.BookPivotField
SubTotalTypeNone - Static variable in class com.smartxls.BookPivotField
SummarizeCalcAverage - Static variable in class com.smartxls.BookPivotField
SummarizeCalcCount - Static variable in class com.smartxls.BookPivotField
SummarizeCalcCountNums - Static variable in class com.smartxls.BookPivotField
SummarizeCalcMax - Static variable in class com.smartxls.BookPivotField
SummarizeCalcMin - Static variable in class com.smartxls.BookPivotField
SummarizeCalcProduct - Static variable in class com.smartxls.BookPivotField
SummarizeCalcStdDev - Static variable in class com.smartxls.BookPivotField
SummarizeCalcStdDevp - Static variable in class com.smartxls.BookPivotField
SummarizeCalcSum - Static variable in class com.smartxls.BookPivotField
SummarizeCalcVar - Static variable in class com.smartxls.BookPivotField
SummarizeCalcVarp - Static variable in class com.smartxls.BookPivotField
Surface - Static variable in class com.smartxls.ChartShape

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