- getActiveCol() - Method in class com.smartxls.WorkBook
-
return the col index of the active cell
- getActivePivotRange() - Method in class com.smartxls.BookPivotRangeModel
-
- getActivePivotRange(int, int) - Method in class com.smartxls.WorkBook
-
return the pivot table if the active cell is in
- getActiveRow() - Method in class com.smartxls.WorkBook
-
return the row index of the active cell
- getAltText() - Method in interface com.smartxls.Table
-
- getApplicationName() - Method in interface com.smartxls.DocumentBuiltInProperties
-
application name
- getArea(short) - Method in class com.smartxls.BookPivotRange
-
Returns the Area object associated with the specified area value.
- getAuthor() - Method in class com.smartxls.CommentShape
-
Comment's author.
- getAuthor() - Method in interface com.smartxls.DocumentBuiltInProperties
-
author
- getAuthor() - Method in class com.smartxls.TextboxShape
-
Comment's author.
- getAutoFilter() - Method in class com.smartxls.WorkBook
-
- getAxisFormat(int, int) - Method in class com.smartxls.ChartShape
-
Returns the format of the specified axis.
- getAxisLengthRatio() - Method in class com.smartxls.ChartShape
-
Returns the ratio of the area taken up on the selected axis.
- getAxisLengthRatio(short, int) - Method in class com.smartxls.ChartShape
-
Returns the ratio of the area taken up on the specified axis.
- getAxisScaleCrosses(short, int) - Method in class com.smartxls.ChartShape
-
gets the crosses value for the specified axis.
- getAxisScaleLabelUnit(short, int) - Method in class com.smartxls.ChartShape
-
return the label unit of the axis scale
- getAxisScaleTick(short, int) - Method in class com.smartxls.ChartShape
-
- getAxisScaleType() - Method in class com.smartxls.ChartShape
-
Returns the axis scale type for the selected axis.
- getAxisScaleType(short, int) - Method in class com.smartxls.ChartShape
-
Returns the axis scale type for the specified axis.
- getAxisTitle(short, int) - Method in class com.smartxls.ChartShape
-
Returns the title of the specified axis.
- getAxisTitleFormat(short, int) - Method in class com.smartxls.ChartShape
-
Returns the specified axis title format object.
- getBackColor() - Method in class com.smartxls.ChartFormat
-
Returns the color used to display the pattern background.
- getBarGapRatio() - Method in class com.smartxls.ChartShape
-
Returns the bar gap ratio on a bar or column chart.
- getBookProtection() - Method in class com.smartxls.WorkBook
-
Return the flags indicating what are protected on this workbook when protection is enabled.
- getBottom() - Method in class com.smartxls.ShapeObj
-
bottom edge
- getBottomBorder() - Method in class com.smartxls.RangeStyle
-
Returns the border style for the bottom edge of the cell.
- getBottomBorderColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the bottom edge of the cell.
- getBuiltInDocumentProperties() - Method in class com.smartxls.WorkBook
-
build in document properties
- getByteCount() - Method in interface com.smartxls.DocumentBuiltInProperties
-
byte count
- getCategory() - Method in interface com.smartxls.DocumentBuiltInProperties
-
category name
- getCategoryFormula() - Method in class com.smartxls.ChartShape
-
Returns a formula that the categories are linked to
- getCharCount() - Method in interface com.smartxls.DocumentBuiltInProperties
-
char count
- getChart(int) - Method in class com.smartxls.WorkBook
-
Returns the first chart in the active worksheet.
- getChartCount() - Method in class com.smartxls.WorkBook
-
get the picture numbers in the current sheet
- getChartFormat() - Method in class com.smartxls.ChartShape
-
Returns chart formatting information.
- getChartType() - Method in class com.smartxls.ChartShape
-
Returns the current chart type.
- getCheckState() - Method in class com.smartxls.FormControlShape
-
return the check box check state
0-uncheck 1-check 2-mixed
- getCol() - Method in class com.smartxls.CommentShape
-
Column of the commented cell.
- getCol() - Method in class com.smartxls.TextboxShape
-
Column of the commented cell.
- getCol1() - Method in class com.smartxls.RangeArea
-
start col
- getCol2() - Method in class com.smartxls.RangeArea
-
end col
- getColOutlineLevel(int) - Method in class com.smartxls.WorkBook
-
Returns the outline level of a single specified column.
- getColPageBreaks() - Method in class com.smartxls.WorkBook
-
return all col index which has page break
- getColumns() - Method in interface com.smartxls.Table
-
- getColWidth(int) - Method in class com.smartxls.WorkBook
-
Returns the width of a single column.
- getCombSelIndex() - Method in class com.smartxls.FormControlShape
-
return the combox select index
- getComment(int, int) - Method in class com.smartxls.WorkBook
-
get the comment from the specified cell
- getComment(int) - Method in class com.smartxls.WorkBook
-
Returns the specified comment in the active worksheet.
- getCommentCount() - Method in class com.smartxls.WorkBook
-
Returns the Comment count in the active worksheet.
- getComments() - Method in interface com.smartxls.DocumentBuiltInProperties
-
comments
- getCompany() - Method in interface com.smartxls.DocumentBuiltInProperties
-
company name
- getConditionalFormatAppliedCellStyle(int, int, int) - Method in class com.smartxls.WorkBook
-
Returns the RangeStyle of the specified cell with conditional format applied
- getConditionalFormats() - Method in class com.smartxls.WorkBook
-
Returns the conditional formats for the current selection.
- getCreationDate() - Method in interface com.smartxls.DocumentBuiltInProperties
-
creation date
- getCSVSeparator() - Method in class com.smartxls.WorkBook
-
get the csv seprator char
- getCustomDocumentProperties() - Method in class com.smartxls.WorkBook
-
custom document properties
- getCustomFormat() - Method in class com.smartxls.ChartFormat
-
Returns the number format.
- getCustomFormat() - Method in class com.smartxls.RangeStyle
-
Returns the number format.
- getDataCaption() - Method in class com.smartxls.BookPivotRange
-
return the data caption
- getDataLabelFormat(int) - Method in class com.smartxls.ChartShape
-
Returns data label formatting information for the specified series.
- getDataLabelFormat(int, int) - Method in class com.smartxls.ChartShape
-
Returns data label formatting information for the specified point of the specified series.
- getDataLabelPosition() - Method in class com.smartxls.ChartFormat
-
Returns the data label position value.
- getDataLabelSeparator() - Method in class com.smartxls.ChartFormat
-
Returns the data label separator value.
- getDataLabelText(int, int) - Method in class com.smartxls.ChartShape
-
Returns the data label text of the specified data point of the specified series.
- getDataLabelType() - Method in class com.smartxls.ChartFormat
-
Returns the data label type value.
- getDataLabelTypes() - Method in class com.smartxls.ChartFormat
-
Returns the types of the data label.
- getDataPointCount(int) - Method in class com.smartxls.ChartShape
-
Returns the number of data points in the specified series.
- getDataPointFormat(int, int) - Method in class com.smartxls.ChartShape
-
Returns data point formatting information for the specified data point.
- getDefaultColWidth() - Method in class com.smartxls.WorkBook
-
Returns the default column width of the worksheet.
- getDefaultRowHeight() - Method in class com.smartxls.WorkBook
-
Returns the default row height of the worksheet.
- getDefinedName(String) - Method in class com.smartxls.WorkBook
-
Returns the definition associated with the specified name.
- getDefinedName(int) - Method in class com.smartxls.WorkBook
-
Returns the defined name for the specified index number.
- getDefinedNameCount() - Method in class com.smartxls.WorkBook
-
Returns the number of defined names
- getDisplayName() - Method in interface com.smartxls.Table
-
- getDropLinesFormat() - Method in class com.smartxls.ChartShape
-
Returns drop line formatting information.
- getErrorBoxText() - Method in class com.smartxls.DataValidation
-
the error box text
- getErrorBoxTitle() - Method in class com.smartxls.DataValidation
-
return the error box title
- getErrorCaption() - Method in class com.smartxls.BookPivotRange
-
return the error caption
- getErrorStyle() - Method in class com.smartxls.DataValidation
-
- getExplosion() - Method in class com.smartxls.ChartShape
-
Returns the explosion percentage.
- getField(int) - Method in class com.smartxls.BookPivotArea
-
Returns the PivotRange field at the specified index within this area.
- getField(String) - Method in class com.smartxls.BookPivotRange
-
- getField(int) - Method in class com.smartxls.BookPivotRange
-
Returns the Field located at the specified index.
- getFieldCount() - Method in class com.smartxls.BookPivotArea
-
Returns the number of fields in this area.
- getFieldCount() - Method in class com.smartxls.BookPivotRange
-
Returns the number of Fields in the PivotRange.
- getFieldItems() - Method in class com.smartxls.BookPivotField
-
return the name of the field items
- getFillAlpha() - Method in class com.smartxls.ChartFormat
-
specifies the input color with the specific opacity.
- getFontBold() - Method in class com.smartxls.ChartFormat
-
Returns whether the font is bold.
- getFontBold() - Method in class com.smartxls.RangeStyle
-
Returns whether the font is bold.
- getFontCharSet() - Method in class com.smartxls.RangeStyle
-
Returns the charset of the font.
- getFontColor() - Method in class com.smartxls.ChartFormat
-
Returns the color used to display the font.
- getFontColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the font.
- getFontItalic() - Method in class com.smartxls.ChartFormat
-
Returns whether the font is italic.
- getFontItalic() - Method in class com.smartxls.RangeStyle
-
Returns whether the font is italic.
- getFontName() - Method in class com.smartxls.ChartFormat
-
Returns the name of the font.
- getFontName() - Method in class com.smartxls.RangeStyle
-
Returns the name of the font.
- getFontOutline() - Method in class com.smartxls.RangeStyle
-
Returns whether the font is Outline.
- getFontShadow() - Method in class com.smartxls.RangeStyle
-
Returns whether the font is Shadow.
- getFontSize() - Method in class com.smartxls.ChartFormat
-
Returns the size of the font in twips.
- getFontSize() - Method in class com.smartxls.RangeStyle
-
Returns the size of the font in twips.
- getFontStrikeout() - Method in class com.smartxls.RangeStyle
-
Returns whether the font is strikeout.
- getFontUnderline() - Method in class com.smartxls.ChartFormat
-
Returns whether the font is underline.
- getFontUnderline() - Method in class com.smartxls.RangeStyle
-
Returns the underline attribute of the font.
- getForeColor() - Method in class com.smartxls.ChartFormat
-
Returns the color used to display the pattern foreground.
- getFormat() - Method in class com.smartxls.ShapeObj
-
Returns the Format object associated with this shape.
- getFormattedText(int, int) - Method in class com.smartxls.WorkBook
-
Returns the formatted text value of the specified cell.
- getFormattedText(int, int, int) - Method in class com.smartxls.WorkBook
-
Returns the formatted text value of the specified cell.
- getFormatType() - Method in class com.smartxls.RangeStyle
-
Returns the number format type.
- getFormControl(int, int) - Method in class com.smartxls.WorkBook
-
get the specified index formcontrol from the current sheet
- getFormula(int, int) - Method in class com.smartxls.WorkBook
-
Returns the text of the formula of the specified cell
- getFormula(int, int, int) - Method in class com.smartxls.WorkBook
-
Returns the text of the formula of the specified cell in current selected sheets.
- getFormula1(int, int) - Method in class com.smartxls.ConditionFormat
-
Returns the first formula associated with this conditional format
- getFormula1() - Method in class com.smartxls.DataValidation
-
the first formula
- getFormula2(int, int) - Method in class com.smartxls.ConditionFormat
-
Returns the second formula associated with this conditional format
- getFormula2() - Method in class com.smartxls.DataValidation
-
the second formula
- getFormulaRange(String) - Method in class com.smartxls.WorkBook
-
formula string to rangearea object
- getGapWidthRatio() - Method in class com.smartxls.ChartShape
-
Returns the gap width ratio.
- getGradientShadingStyle() - Method in class com.smartxls.RangeStyle
-
Returns the gradient fill shading style.
- getHeightEmu() - Method in class com.smartxls.PictureShape
-
- getHiddenCount() - Method in interface com.smartxls.DocumentBuiltInProperties
-
hidden count
- getHiddenState() - Method in class com.smartxls.WorkBook
-
Returns the hidden state for the sheet.
- getHorizontalAlignment() - Method in class com.smartxls.RangeStyle
-
Returns the type of horizontal alignment.
- getHorizontalInsideBorder() - Method in class com.smartxls.RangeStyle
-
Returns the border style for the horizontal inside border.
- getHorizontalInsideBorderColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the horizontal inside border.
- getHyperlink(int) - Method in class com.smartxls.WorkBook
-
get the specified index hyperlink object from current sheet
- getHyperlink(int, int) - Method in class com.smartxls.WorkBook
-
get the specified index hyperlink object from current sheet
- getHyperlinkImpl() - Method in class com.smartxls.HyperLink
-
- getHyperlinks() - Method in class com.smartxls.WorkBook
-
- getIndent() - Method in class com.smartxls.RangeStyle
-
Returns the indent attribute
- getIndex() - Method in interface com.smartxls.Table
-
- getIterationMax() - Method in class com.smartxls.WorkBook
-
Returns the maximum number of calculation iterations.
- getIterationMaxChange() - Method in class com.smartxls.WorkBook
-
Returns the maximum iteration change value.
- getKeywords() - Method in interface com.smartxls.DocumentBuiltInProperties
-
key words
- getLastAuthor() - Method in interface com.smartxls.DocumentBuiltInProperties
-
last author
- getLastCol() - Method in class com.smartxls.WorkBook
-
Returns the number of the last occupied column.
- getLastColForRow(int) - Method in class com.smartxls.WorkBook
-
Returns the number of the last occupied column in the specified row.
- getLastPrinted() - Method in interface com.smartxls.DocumentBuiltInProperties
-
last printed date
- getLastRow() - Method in class com.smartxls.WorkBook
-
Returns the number of the last row that is not empty, including cells that contain only formatting.
- getLastSaveDate() - Method in interface com.smartxls.DocumentBuiltInProperties
-
last saved date
- getLeft() - Method in class com.smartxls.ShapeObj
-
left edge
- getLeftBorder() - Method in class com.smartxls.RangeStyle
-
Returns the border style for the left edge of the cell.
- getLeftBorderColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the left edge of the cell.
- getLegendFormat() - Method in class com.smartxls.ChartShape
-
Returns legend formatting information.
- getLegendPosition() - Method in class com.smartxls.ChartShape
-
return current legend position
0 - LegendPlacementBottom 1 - LegendPlacementCorner 2 - LegendPlacementTop 3 - LegendPlacementRight
4 - LegendPlacementLeft 5 - LegendPlacementTopRightCorner 6 - LegendPlacementBottomRightCorner 7 - LegendPlacementNotDocked
8 - LegendPlacementTopLeftCorner 9 - LegendPlacementBottomLeftCorner
- getLineColor() - Method in class com.smartxls.ChartFormat
-
Gets the color.
- getLineCount() - Method in interface com.smartxls.DocumentBuiltInProperties
-
line count
- getLineStyle() - Method in class com.smartxls.ChartFormat
-
Gets the style.
- getLineWeight() - Method in class com.smartxls.ChartFormat
-
Gets the weight.
- getLinkRange() - Method in class com.smartxls.ChartShape
-
Returns a formula indicating the range that the chart is linked to.
- getLinkShowString() - Method in class com.smartxls.HyperLink
-
Returns the hyperlink link show string.
- getLinkURLString() - Method in class com.smartxls.HyperLink
-
Returns the hyperlink link URL string.
- getListBoxSelection() - Method in class com.smartxls.FormControlShape
-
return the listbox select type 0-single 1-multi 2-extend
- getListBoxSelType() - Method in class com.smartxls.FormControlShape
-
return the listbox select type 0-single 1-multi 2-extend
- getLock() - Method in class com.smartxls.WorkBook
-
Acquire a lock for the group.
- getMajorGridFormat(short, int) - Method in class com.smartxls.ChartShape
-
Returns grid line formatting information for the major grid of the specified axis.
- getManager() - Method in interface com.smartxls.DocumentBuiltInProperties
-
manager name
- getMarkerBackground() - Method in class com.smartxls.ChartFormat
-
Returns the marker background color as an RGB value.
- getMarkerForeground() - Method in class com.smartxls.ChartFormat
-
Returns the marker foreground color as an RGB value.
- getMarkerSize() - Method in class com.smartxls.ChartFormat
-
Returns the marker size in twips.
- getMarkerStyle() - Method in class com.smartxls.ChartFormat
-
Returns the marker style.
- getMergeCells() - Method in class com.smartxls.RangeStyle
-
Returns the merge cells setting.
- getMergedRanges() - Method in class com.smartxls.WorkBook
-
return the list merged range from the current selected worksheet
- getMinorGridFormat(short, int) - Method in class com.smartxls.ChartShape
-
Returns grid line formatting information for the minor grid of the specified axis.
- getMissingCaption() - Method in class com.smartxls.BookPivotRange
-
return the null value caption
- getName() - Method in class com.smartxls.BookPivotField
-
the name of the pivot field
- getName() - Method in class com.smartxls.ShapeObj
-
get the shape name
- getName() - Method in interface com.smartxls.Table
-
- getNumber(String) - Method in class com.smartxls.WorkBook
-
Returns the numeric value of the specified cell.
- getNumber(int, int) - Method in class com.smartxls.WorkBook
-
Returns the numeric value of the specified cell.
- getNumber(int, int, int) - Method in class com.smartxls.WorkBook
-
Returns the numeric value of the specified cell in the specified worksheet.
- getNumberFormatting() - Method in class com.smartxls.BookPivotField
-
get the custom formatting string from the specified area in pivot table
- getNumSheets() - Method in class com.smartxls.WorkBook
-
Returns the number of worksheets in the current workbook.
- getOperator() - Method in class com.smartxls.ConditionFormat
-
Returns the operator for this conditional format.
- getOperator() - Method in class com.smartxls.DataValidation
-
- getOrientation() - Method in class com.smartxls.ChartFormat
-
return the orientation
- getOrientation() - Method in class com.smartxls.RangeStyle
-
Returns the orientation type.
- getPaletteEntry(int) - Method in class com.smartxls.WorkBook
-
Returns a color in the color palette.
- getPattern() - Method in class com.smartxls.RangeStyle
-
Returns the pattern type.
- getPatternBG() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the pattern background.
- getPatternFG() - Method in class com.smartxls.ChartFormat
-
return the foreground color
- getPatternFG() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the pattern foreground.
- getPictureCount() - Method in class com.smartxls.WorkBook
-
get the picture numbers in the current sheet
- getPictureData() - Method in class com.smartxls.PictureShape
-
write picture image data to specified stream
- getPictureShape(int) - Method in class com.smartxls.WorkBook
-
Returns the specified index picture from the active worksheet.
- getPictureType() - Method in class com.smartxls.PictureShape
-
get picture image data type
- getPieExplosion(int) - Method in class com.smartxls.ChartShape
-
Returns explosion percentage for the specified data point.
- getPivotModel() - Method in class com.smartxls.WorkBook
-
- getPlacementStyle() - Method in class com.smartxls.ShapeFormat
-
- getPlotFormat() - Method in class com.smartxls.ChartShape
-
Returns plot formatting information.
- getPos() - Method in class com.smartxls.ShapeObj
-
get the shape position
- getPrintArea() - Method in class com.smartxls.WorkBook
-
Returns the current print area.
- getPrintBottomMargin() - Method in class com.smartxls.WorkBook
-
Returns the bottom print margin in inches.
- getPrintFooter() - Method in class com.smartxls.WorkBook
-
Returns the current page footer.
- getPrintFooterMargin() - Method in class com.smartxls.WorkBook
-
Returns the page footer margin
- getPrintHeader() - Method in class com.smartxls.WorkBook
-
Returns the page header printed at the top of each page.
- getPrintHeaderMargin() - Method in class com.smartxls.WorkBook
-
Returns the page header margin used during printing.
- getPrintLeftMargin() - Method in class com.smartxls.WorkBook
-
Returns the left print margin in inches.
- getPrintNumberOfCopies() - Method in class com.smartxls.WorkBook
-
Returns the number copies to print
- getPrintPaperHeight() - Method in class com.smartxls.WorkBook
-
Returns the height of the paper in twips.
- getPrintPaperSize() - Method in class com.smartxls.WorkBook
-
Returns paper size print setting value.
- getPrintPaperWidth() - Method in class com.smartxls.WorkBook
-
Returns the width of the paper in twips.
- getPrintRightMargin() - Method in class com.smartxls.WorkBook
-
Returns the right print margin in inches.
- getPrintScale() - Method in class com.smartxls.WorkBook
-
Returns the scale factor for the current worksheet.
- getPrintScaleFitHPages() - Method in class com.smartxls.WorkBook
-
Returns the number of horizontal pages to which the print job is fit.
- getPrintScaleFitVPages() - Method in class com.smartxls.WorkBook
-
Returns the number of vertical pages to which the print job is fit.
- getPrintStartPageNumber() - Method in class com.smartxls.WorkBook
-
Returns the number displayed on the first page printed.
- getPrintTitles() - Method in class com.smartxls.WorkBook
-
Returns the print titles to be printed at the top of each page
- getPrintTopMargin() - Method in class com.smartxls.WorkBook
-
Returns the top print margin in inches.
- getPromtBoxText() - Method in class com.smartxls.DataValidation
-
return the promt box text
- getPromtBoxTitle() - Method in class com.smartxls.DataValidation
-
return the title of the dv's promt box
- getPropertyValue(String) - Method in interface com.smartxls.DocumentCustomProperties
-
return the value of the specified property
- getPropsKeys() - Method in interface com.smartxls.DocumentCustomProperties
-
enum of the custom properties keys
- getRange() - Method in class com.smartxls.HyperLink
-
Returns the range to which this hyperlink applies.
- getRangeArea() - Method in class com.smartxls.BookPivotRange
-
returns the boundary of the PivotRange
- getRangeStyle() - Method in class com.smartxls.ConditionFormat
-
Returns the cell format with the formatting options for this conditional format.
- getRangeStyle() - Method in class com.smartxls.WorkBook
-
Returns the format of the selected range of cells.
- getRangeStyle(int, int, int, int) - Method in class com.smartxls.WorkBook
-
Returns the RangeStyle of the specified range of cells
- getRight() - Method in class com.smartxls.ShapeObj
-
right edge
- getRightBorder() - Method in class com.smartxls.RangeStyle
-
Returns the border style for the right edge of the cell.
- getRightBorderColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the right edge of the cell.
- getRow() - Method in class com.smartxls.CommentShape
-
Row of the commented cell.
- getRow() - Method in class com.smartxls.TextboxShape
-
Row of the commented cell.
- getRow1() - Method in class com.smartxls.RangeArea
-
start row
- getRow2() - Method in class com.smartxls.RangeArea
-
end row
- getRowHeight(int) - Method in class com.smartxls.WorkBook
-
Returns the height of a single specified row.
- getRowOutlineLevel(int) - Method in class com.smartxls.WorkBook
-
Returns the outline level of a single specified row.
- getRowPageBreaks() - Method in class com.smartxls.WorkBook
-
return all row index which has page break
- getScaleMajorUnit(short, int) - Method in class com.smartxls.ChartShape
-
get the major scale unit of the selected axis.
- getScaleMinorUnit(short, int) - Method in class com.smartxls.ChartShape
-
get the minor scale unit of the selected axis.
- getSelection() - Method in class com.smartxls.WorkBook
-
return the current selected range
- getSeriesCount() - Method in class com.smartxls.ChartShape
-
returns the series count in the chart
- getSeriesFormat(int) - Method in class com.smartxls.ChartShape
-
Returns formatting information for the specified series.
- getSeriesName(int) - Method in class com.smartxls.ChartShape
-
Returns the name of the specified series.
- getSeriesSizeValueFormula(int) - Method in class com.smartxls.ChartShape
-
Returns the size value formula of the specified series.
- getSeriesType() - Method in class com.smartxls.ChartShape
-
Returns the series type value for the selected series.
- getSeriesType(int) - Method in class com.smartxls.ChartShape
-
Returns the series type value for the specified series.
- getSeriesXValueFormula(int) - Method in class com.smartxls.ChartShape
-
Returns the X axis value formula of the specified series.
- getSeriesYValueFormula(int) - Method in class com.smartxls.ChartShape
-
Returns the Y axis value formula of the specified series.
- getSheet() - Method in class com.smartxls.RangeArea
-
sheet index -1 if not used
- getSheet() - Method in class com.smartxls.WorkBook
-
Returns the current selected worksheet index.
- getSheetName(int) - Method in class com.smartxls.WorkBook
-
Returns the name of the specified worksheet.
- getSheetProperty(SheetVarType) - Method in class com.smartxls.WorkBook
-
access the sheet internal property by the variant type
- getSheetProtection(int) - Method in class com.smartxls.WorkBook
-
Returns the flags indicating what are allowed when sheet protection is enabled.
- getSheetTabColor() - Method in class com.smartxls.WorkBook
-
return the color used by the sheet tab
- getSheetViewType() - Method in class com.smartxls.WorkBook
-
Returns the sheet view type.
- getShowHScrollBar() - Method in class com.smartxls.WorkBook
-
Returns the mode for the horizontal scroll bar.
- getShowTabs() - Method in class com.smartxls.WorkBook
-
Returns the display status and position of the sheet name tabs on a workbook.
- getShowVScrollBar() - Method in class com.smartxls.WorkBook
-
Returns the mode for the vertical scroll bar.
- getSortType() - Method in class com.smartxls.BookPivotField
-
return the sort type
- getStartAngle() - Method in class com.smartxls.ChartShape
-
get the start angle of the 3D chart
- getSubject() - Method in interface com.smartxls.DocumentBuiltInProperties
-
subject
- getSubTotalType() - Method in class com.smartxls.BookPivotField
-
return the type of subtotal
- getSummarizeFieldCalcType() - Method in class com.smartxls.BookPivotField
-
Indicates the summary function type
- getTable(int, int) - Method in class com.smartxls.WorkBook
-
return the table if the active cell is in
- getTableBuiltInStyles() - Method in interface com.smartxls.Table
-
- getTemplate() - Method in interface com.smartxls.DocumentBuiltInProperties
-
template name
- getText() - Method in class com.smartxls.AutoShape
-
text content.
- getText() - Method in class com.smartxls.CommentShape
-
Comment text.
- getText() - Method in class com.smartxls.FormControlShape
-
lable text.
- getText() - Method in class com.smartxls.TextboxShape
-
Comment text.
- getText(int, int, int) - Method in class com.smartxls.WorkBook
-
c
Returns the text value of the specified cell.
- getText(String) - Method in class com.smartxls.WorkBook
-
return the text value of the specified named cell
- getText(int, int) - Method in class com.smartxls.WorkBook
-
Returns the text value of the specified cell.
- getText(int, int, boolean) - Method in class com.smartxls.WorkBook
-
Returns the text value of the specified cell.
- getTickLabelPosition(int, int) - Method in class com.smartxls.ChartShape
-
Returns the tick label position of the specified axis.
- getTickStyle(int, int, boolean) - Method in class com.smartxls.ChartShape
-
Returns the tick style of the specified axis.
- getTitle() - Method in class com.smartxls.ChartShape
-
Returns the current chart title.
- getTitle() - Method in interface com.smartxls.DocumentBuiltInProperties
-
title
- getTitleFormat() - Method in class com.smartxls.ChartShape
-
Returns chart title formatting information.
- getToolTipString() - Method in class com.smartxls.HyperLink
-
Returns the tool tip string.
- getTop() - Method in class com.smartxls.ShapeObj
-
top edge
- getTopBorder() - Method in class com.smartxls.RangeStyle
-
Returns the border style for the top edge of the cell.
- getTopBorderColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the top edge of the cell.
- getTotalRowCount() - Method in interface com.smartxls.Table
-
- getTrendLineCount(int) - Method in class com.smartxls.ChartShape
-
- getTrendLineFormat(int, int) - Method in class com.smartxls.ChartShape
-
- getTrendLineIntercept(int, int) - Method in class com.smartxls.ChartShape
-
- getTrendLinePeriod(int, int) - Method in class com.smartxls.ChartShape
-
- getTrendLineType(int, int, short) - Method in class com.smartxls.ChartShape
-
- getType() - Method in class com.smartxls.ConditionFormat
-
Returns the conditional format type associated with this conditional format.
- getType() - Method in class com.smartxls.DataValidation
-
- getType() - Method in class com.smartxls.HyperLink
-
Returns the current hyperlink type.
- getType(int, int) - Method in class com.smartxls.WorkBook
-
Returns the cell type of the specified cell.
- getType(int, int, int) - Method in class com.smartxls.WorkBook
-
Returns the cell type of the specified cell.
- getType() - Method in class com.smartxls.WorkBook
-
Returns the cell type of the active cell.
- getValidation(int, int) - Method in class com.smartxls.WorkBook
-
get the validation object from specified cell
- getVersionString() - Method in class com.smartxls.WorkBook
-
Returns the version of this component in a string.
- getVerticalAlignment() - Method in class com.smartxls.RangeStyle
-
Returns the type of vertical alignment.
- getVerticalInsideBorder() - Method in class com.smartxls.RangeStyle
-
Returns the border style for the vertical inside border.
- getVerticalInsideBorderColor() - Method in class com.smartxls.RangeStyle
-
Returns the color used to display the vertical inside border.
- getViewScale() - Method in class com.smartxls.WorkBook
-
Returns the current display scale for a workbook.
- getWidthEmu() - Method in class com.smartxls.PictureShape
-
- getWordCount() - Method in interface com.smartxls.DocumentBuiltInProperties
-
words count
- getWorkBookVersion() - Method in class com.smartxls.WorkBook
-
- getX1() - Method in class com.smartxls.ShapePos
-
left position
The whole part of the value is the column containing the left side, and the fractional part of the value is the position of the left side within that column.
- getX2() - Method in class com.smartxls.ShapePos
-
right position
The whole part of the value is the column containing the right side, and the fractional part of the value is the position of the right side within that column.
- getY1() - Method in class com.smartxls.ShapePos
-
top position
The whole part of the value is the row containing the top side, and the fractional part of the value is the position of the top side within that row.
- getY2() - Method in class com.smartxls.ShapePos
-
bottom position
The whole part of the value is the row containing the bottom side, and the fractional part of the value is the position of the bottom side within that row.
- getYAxisCount() - Method in class com.smartxls.ChartShape
-
Returns the number of Y axes on the chart.