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 stop`DataValidation.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 between`DataValidation.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 freefloating`ShapeFormat.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 any`DataValidation.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