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 

G

getActiveCol() - Method in class com.smartxls.WorkBook
return the col index of the active cell
getActivePivotRange() - Method in class com.smartxls.BookPivotRangeModel
Deprecated.
relaced by workbook.getActivePivotRange(...)
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
error style stopDataValidation.eStop warning info
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
Deprecated.
replaced by BookPivotRange.addField
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
dv opertor betweenDataValidation.eBetween notbetween equal notequal greater less greaterorequal lessorequal
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
Deprecated.
relaced by workbook.addPivotRange(...) and workbook.getActivePivotRange(...)
getPlacementStyle() - Method in class com.smartxls.ShapeFormat
place style freefloatingShapeFormat.PlacementFreeFloating move moveandsize
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
type anyDataValidation.eAny integer decimal user date time textlength formula
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.
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