Skip navigation links
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 stopDataValidation.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 betweenDataValidation.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 freefloatingShapeFormat.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 anyDataValidation.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 
Skip navigation links