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

G

GROUP_BY_COLUMNS - Constant in class ActiveXLS.Constants.DataGroup

A constant indicating that the data must be grouped by columns.

GROUP_BY_ROWS - Constant in class ActiveXLS.Constants.DataGroup

A constant indicating that the data must be grouped by rows.

get2DCellElements(String) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sCellReference

get2DCellElementsR1C1style(String, int, int) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sCellReference

get2DColumnCellElementsR1C1style(String, int, int) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sCellReference

get2DColumnRangeElementsR1C1style(String, int, int) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sRange

get2DRangeElements(String) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sRange

get2DRangeElementsR1C1style(String, int, int) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sRange

get2DRowCellElementsR1C1style(String, int, int) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sCellReference

get2DRowRangeElementsR1C1style(String, int, int) - Static method in class ActiveXLS.Formula

Returns an array of integers containing the elements of the specified sRange

get3DCellElements(String) - Method in class ActiveXLS.Formula

Returns an array of objects containing the elements of the specified sCellReference

get3DCellElementsR1C1style(String, int, int) - Method in class ActiveXLS.Formula

Returns an array of objects containing the elements of the specified sCellReference

get3DColumnRangeElementsR1C1style(String, int, int) - Method in class ActiveXLS.Formula

Returns an array of objects containing the elements of the specified sRange

get3DRangeElements(String) - Method in class ActiveXLS.Formula

Returns an array of objects containing the elements of the specified sRange

get3DRangeElementsR1C1style(String, int, int) - Method in class ActiveXLS.Formula

Returns an array of objects containing the elements of the specified sRange

get3DRowRangeElementsR1C1style(String, int, int) - Method in class ActiveXLS.Formula

Returns an array of objects containing the elements of the specified sRange

getApplicationName() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the application name property.

getAuthor() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the author property.

getAutoFormat() - Method in class ActiveXLS.ExcelDataGroup

Returns the autoformat to be applied.

getAutoFormatType() - Method in class ActiveXLS.ExcelAutoFormat

Returns the type of this autoformat.

getBSEImage() - Method in class ActiveXLS.ExcelImage

Internal use only.

getBackground() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the chart area background color.

getBackground() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the background color of the chart legend.

getBackground() - Method in class ActiveXLS.Charts.ExcelPlotArea

Returns the chart plot area background color.

getBackground() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the chart series background color.

getBackground() - Method in class ActiveXLS.ExcelCell

Returns the background color of the cell.

getBackground() - Method in class ActiveXLS.ExcelColumn

Returns the background color of the column.

getBackground() - Method in class ActiveXLS.ExcelCondition

Returns the color of the conditional formatting background.

getBackground() - Method in class ActiveXLS.ExcelRow

Returns the background color of the row.

getBackground() - Method in class ActiveXLS.ExcelStyle

Returns the background color of the style.

getBorderColor() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the border color of the chart area.

getBorderColor() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the border color of the chart legend.

getBorderColor() - Method in class ActiveXLS.Charts.ExcelPlotArea

Returns the border color of the chart plot area.

getBorderStyle() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the border style of the chart area.

getBorderStyle() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the border style of the chart legend.

getBorderStyle() - Method in class ActiveXLS.Charts.ExcelPlotArea

Returns the border style of the chart plot area.

getBorderWeight() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the border weight of the chart area.

getBorderWeight() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the border weight of the chart legend.

getBorderWeight() - Method in class ActiveXLS.Charts.ExcelPlotArea

Returns the border style of the chart plot area.

getBottomColor_Border() - Method in class ActiveXLS.ExcelCell

Returns the color of the bottom border.

getBottomColor_Border() - Method in class ActiveXLS.ExcelColumn

Returns the color of the bottom border.

getBottomColor_Border() - Method in class ActiveXLS.ExcelCondition

Returns the color of the conditional formatting bottom border.

getBottomColor_Border() - Method in class ActiveXLS.ExcelRow

Returns the color of the bottom border.

getBottomColor_Border() - Method in class ActiveXLS.ExcelStyle

Returns the color of the bottom border.

getBottomLeftCellStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the bottom left cell.

getBottomMargin() - Method in class ActiveXLS.ExcelPageSetup

Returns the bottom margin of the paper.

getBottomRightCellStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the bottom right cell.

getBottomStyle_Border() - Method in class ActiveXLS.ExcelCell

Returns the style of the bottom border.

getBottomStyle_Border() - Method in class ActiveXLS.ExcelColumn

Returns the style of the bottom border.

getBottomStyle_Border() - Method in class ActiveXLS.ExcelCondition

Returns the style of the conditional formatting bottom border.

getBottomStyle_Border() - Method in class ActiveXLS.ExcelRow

Returns the style of the bottom border.

getBottomStyle_Border() - Method in class ActiveXLS.ExcelStyle

Returns the style of the bottom border.

getCategory() - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns the category property.

getColsNumber() - Method in class ActiveXLS.ExcelArrayFormula

Returns the number of columns in the range

getColumnMaxOutlineLevel() - Method in class ActiveXLS.ExcelWorksheet

Returns the highest number of outline levels for columns in this sheet.

getColumnNumberFromLetters(String) - Static method in class ActiveXLS.Formula

Returns the index of the column identified by sColumnName

getColumnNumberFromLetters(StringBuffer) - Static method in class ActiveXLS.Formula

getColumnWidth() - Method in class ActiveXLS.ExcelTable

Returns the default width of the columns.

getColumnWidth(int) - Method in class ActiveXLS.ExcelTable

Returns the width of the specified column.

getComment() - Method in class ActiveXLS.ExcelCell

Returns the comment of the cell.

getComments() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the comments property.

getCompanyName() - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns the company name property.

getConditionAt(int) - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the condition with the specified index.

getConditionType() - Method in class ActiveXLS.ExcelCondition

Returns the conditional formatting type.

getCreationDate() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the date of creation.

getCrossValue() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the crosses value of the axis.

getCurrentSheet() - Method in class ActiveXLS.ExcelDocument

Returns the current sheet displayed when the document is loaded in Microsoft Excel.

getCustomProperty(String) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns a custom property.

getDataLabels() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the chart series data label type.

getDataType() - Method in class ActiveXLS.ExcelCell

Returns the data type of the cell.

getDataType() - Method in class ActiveXLS.ExcelColumn

Returns the data type of the column.

getDataType() - Method in class ActiveXLS.ExcelRow

Returns the data type of the row.

getDataType() - Method in class ActiveXLS.ExcelStyle

Returns the data type of the style.

getDataType() - Method in class ActiveXLS.Util.FormulaResult

Returns the formula data type.

getDescription() - Method in class ActiveXLS.ExcelHyperlink

Returns the text that is shown in the table instead of the URL.

getDocumentSummaryInformation() - Method in class ActiveXLS.ExcelDocument

Returns the document summary information of an Excel document.

getErrorStyle() - Method in class ActiveXLS.ExcelDataValidator

Returns the "Error Alert" box style.

getErrorText() - Method in class ActiveXLS.ExcelDataValidator

Returns the message of the "Error Alert"

getErrorTitle() - Method in class ActiveXLS.ExcelDataValidator

Returns the title of the "Error Alert"

getEvenColumnStripesStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the even columns.

getEvenRowStripesStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the even rows.

getExcelDocument(String) - Method in class ActiveXLS.ExternalLinks

Returns the Excel document specified by the link.

getExcelName(String) - Method in class ActiveXLS.Formula

Returns the ExcelName with the specified name.

getExternalLinks() - Method in class ActiveXLS.ExcelDocument

Returns the list of the external links from the formulas inside the Excel document.

getFirstColumn() - Method in class ActiveXLS.ExcelArrayFormula

Returns the first column in the range

getFirstColumn() - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the first column index of the cells range.

getFirstColumn() - Method in class ActiveXLS.ExcelDataGroup

Returns the first column index of the cells range where the data group is located.

getFirstColumn() - Method in class ActiveXLS.ExcelDataValidator

Returns the first column of the cell range where the validation will be applied.

getFirstColumn() - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

getFirstFormula() - Method in class ActiveXLS.ExcelCondition

Returns the conditional formatting first formula

getFirstFormula() - Method in class ActiveXLS.ExcelDataValidator

Returns the expression of the first formula.

getFirstPageNumber() - Method in class ActiveXLS.ExcelPageSetup

Returns the starting page number.

getFirstRow() - Method in class ActiveXLS.ExcelArrayFormula

Returns the first row in the range

getFirstRow() - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the first row index of the cells range.

getFirstRow() - Method in class ActiveXLS.ExcelDataGroup

Returns the first row index of the cells range where the data group is located.

getFirstRow() - Method in class ActiveXLS.ExcelDataValidator

Returns the first row of the cell range where the validation will be applied.

getFirstRow() - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

getFitToPagesHeight() - Method in class ActiveXLS.ExcelPageSetup

Returns the number of pages to fit in the page height.

getFitToPagesWidth() - Method in class ActiveXLS.ExcelPageSetup

Returns the number of pages to fit in the page width.

getFont() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the chart axis font name.

getFont() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the font name used in the chart area.

getFont() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the font name used in the chart legend.

getFont() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the font name used in the chart data table.

getFont() - Method in class ActiveXLS.ExcelCell

Returns the name of the cell font.

getFont() - Method in class ActiveXLS.ExcelColumn

Returns the name of the column font.

getFont() - Method in class ActiveXLS.ExcelComment

Returns the font name of the comment text.

getFont() - Method in class ActiveXLS.ExcelRow

Returns the name of the row font.

getFont() - Method in class ActiveXLS.ExcelStyle

Returns the name of the style font.

getFontSize() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the size of the chart axis font.

getFontSize() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the size of the font used in the chart area.

getFontSize() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the size of the font used in the chart legend.

getFontSize() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the size of the font used in the chart data table.

getFontSize() - Method in class ActiveXLS.ExcelCell

Returns the size of the cell font.

getFontSize() - Method in class ActiveXLS.ExcelColumn

Returns the size of the column font.

getFontSize() - Method in class ActiveXLS.ExcelComment

Returns the font size of the comment text.

getFontSize() - Method in class ActiveXLS.ExcelRow

Returns the size of the row font.

getFontSize() - Method in class ActiveXLS.ExcelStyle

Returns the size of the style font.

getFooterMargin() - Method in class ActiveXLS.ExcelPageSetup

Returns the footer margin of the paper.

getFooterRowStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the footer row.

getFooterString() - Method in class ActiveXLS.ExcelFooter

Returns the footer expression.

getForeground() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the foreground color of the chart axis.

getForeground() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the text color of the chart area.

getForeground() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the text color of the chart legend.

getForeground() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the text color of the chart data table.

getForeground() - Method in class ActiveXLS.ExcelCell

Returns the foreground color of the cell.

getForeground() - Method in class ActiveXLS.ExcelColumn

Returns the foreground color of the column.

getForeground() - Method in class ActiveXLS.ExcelComment

Returns the foreground of the comment text.

getForeground() - Method in class ActiveXLS.ExcelCondition

Returns the foreground of the conditional formatting font.

getForeground() - Method in class ActiveXLS.ExcelRow

Returns the foreground color of the row.

getForeground() - Method in class ActiveXLS.ExcelStyle

Returns the foreground color of the style.

getFormat() - Method in class ActiveXLS.ExcelCell

Returns the number/date format of the cell.

getFormat() - Method in class ActiveXLS.ExcelColumn

Returns the number/date format of the column.

getFormat() - Method in class ActiveXLS.ExcelRow

Returns the number/date format of the row.

getFormat() - Method in class ActiveXLS.ExcelStyle

Returns the number/date format of the style.

getFormula() - Method in class ActiveXLS.ExcelArrayFormula

Returns the formula of the array.

getFormulaResult() - Method in class ActiveXLS.ExcelCell

Internal use only.

getFormulaResultValue() - Method in class ActiveXLS.ExcelCell

Returns the formula result if the cell contains a formula and the formula has been computed

getGroupType() - Method in class ActiveXLS.ExcelDataGroup

Returns the group per rows or columns option.

getHTMLValue() - Method in class ActiveXLS.ExcelCell

Returns the value of the cell containing the tags used to set the rich text format in cells.

getHeaderMargin() - Method in class ActiveXLS.ExcelPageSetup

Returns the header margin of the paper.

getHeaderRowStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the header row.

getHeaderString() - Method in class ActiveXLS.ExcelHeader

Returns the header expression.

getHeight() - Method in class ActiveXLS.Charts.ExcelAxis

Internal use only

getHeight() - Method in class ActiveXLS.Charts.ExcelChart

Returns the chart height.

getHeight() - Method in class ActiveXLS.ExcelComment

Returns the comment height.

getHeight() - Method in class ActiveXLS.ExcelImage

Returns the image height.

getHeight() - Method in class ActiveXLS.ExcelRow

Returns the height of the row.

getHorizontalAlignment() - Method in class ActiveXLS.ExcelCell

Returns the horizontal alignment of the cell.

getHorizontalAlignment() - Method in class ActiveXLS.ExcelColumn

Returns the horizontal alignment of the column.

getHorizontalAlignment() - Method in class ActiveXLS.ExcelRow

Returns the horizontal alignment of the row.

getHorizontalAlignment() - Method in class ActiveXLS.ExcelStyle

Returns the horizontal alignment of the style.

getHorizontalOffset() - Method in class ActiveXLS.Charts.ExcelChart

Returns the chart horizontal offset This method is applicable only to adding charts to ExcelWorksheet objects

getHorizontalOffset() - Method in class ActiveXLS.ExcelComment

Returns the comment horizontal offset (the distance - in pixels - between the left border of the left upper corner cell to the left border of the comment).

getHorizontalOffset() - Method in class ActiveXLS.ExcelImage

Returns the image horizontal offset

getHorizontalPageBreaks() - Method in class ActiveXLS.ExcelTable

Returns a list with all horizontal page breaks

getHyperlinkBase() - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns the hyperlink base property.

getHyperlinkType() - Method in class ActiveXLS.ExcelHyperlink

Returns a string representing the hyperlink type.

getImagePath() - Method in class ActiveXLS.ExcelImage

Returns the file path to image file.

getIndent() - Method in class ActiveXLS.ExcelCell

Returns the indent of the cell.

getIndent() - Method in class ActiveXLS.ExcelColumn

Returns the indent of the column.

getIndent() - Method in class ActiveXLS.ExcelRow

Returns the indent of the row.

getIndent() - Method in class ActiveXLS.ExcelStyle

Returns the indent of the style.

getIndexOf(String) - Method in class ActiveXLS.ExternalLinks

Returns the index of the specified link.

getInputText() - Method in class ActiveXLS.ExcelDataValidator

Returns the message of the "Input Message"

getInputTitle() - Method in class ActiveXLS.ExcelDataValidator

Returns the title of the "Input Message"

getKeysArrangementDirection() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the direction in which the keys are arranged inside the legend: vertically or horizontally.

getKeywords() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the keywords property.

getLabel() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the chart axis title.

getLabelFrequency() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the number of categories between tick-mark labels.

getLastColumn() - Method in class ActiveXLS.ExcelArrayFormula

Returns the last column in the range

getLastColumn() - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the last column index of the cells range.

getLastColumn() - Method in class ActiveXLS.ExcelDataGroup

Returns the last column index of the cells range where the data group is located.

getLastColumn() - Method in class ActiveXLS.ExcelDataValidator

Returns the last column of the cell range where the validation will be applied.

getLastColumn() - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

getLastPrinted() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the last printed property.

getLastRow() - Method in class ActiveXLS.ExcelArrayFormula

Returns the last row in the range

getLastRow() - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the last row index of the cells range.

getLastRow() - Method in class ActiveXLS.ExcelDataGroup

Returns the last row index of the cells range where the data group is located.

getLastRow() - Method in class ActiveXLS.ExcelDataValidator

Returns the last row of the cell range where the validation will be applied.

getLastRow() - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

getLastSavedBy() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the last author property.

getLastSavedDate() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the date of last saved property.

getLeftColor_Border() - Method in class ActiveXLS.ExcelCell

Returns the color of the left border.

getLeftColor_Border() - Method in class ActiveXLS.ExcelColumn

Returns the color of the left border.

getLeftColor_Border() - Method in class ActiveXLS.ExcelCondition

Returns the color of the conditional formatting left border.

getLeftColor_Border() - Method in class ActiveXLS.ExcelRow

Returns the color of the left border.

getLeftColor_Border() - Method in class ActiveXLS.ExcelStyle

Returns the color of the left border.

getLeftColumnStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the left column.

getLeftMargin() - Method in class ActiveXLS.ExcelPageSetup

Returns the left margin of the paper.

getLeftStyle_Border() - Method in class ActiveXLS.ExcelCell

Returns the style of the left border.

getLeftStyle_Border() - Method in class ActiveXLS.ExcelColumn

Returns the style of the left border.

getLeftStyle_Border() - Method in class ActiveXLS.ExcelCondition

Returns the style of the conditional formatting left border.

getLeftStyle_Border() - Method in class ActiveXLS.ExcelRow

Returns the style of the left border.

getLeftStyle_Border() - Method in class ActiveXLS.ExcelStyle

Returns the style of the left border.

getLeftUpperCornerColumn() - Method in class ActiveXLS.Charts.ExcelChart

Returns the column number where the left upper corner of the chart is anchored
This method is applicable only to adding charts to ExcelWorksheet objects

getLeftUpperCornerColumn() - Method in class ActiveXLS.ExcelComment

Returns the column number where the left upper corner of the comment is anchored

getLeftUpperCornerColumn() - Method in class ActiveXLS.ExcelImage

Returns the column number where the left upper corner of the image is anchored
This method is applicable only to adding images to ExcelWorksheet objects

getLeftUpperCornerRow() - Method in class ActiveXLS.Charts.ExcelChart

Returns the row number where the left upper corner of the chart is anchored
This method is applicable only to adding charts to ExcelWorksheet objects

getLeftUpperCornerRow() - Method in class ActiveXLS.ExcelComment

Returns the row number where the left upper corner of the comment is anchored

getLeftUpperCornerRow() - Method in class ActiveXLS.ExcelImage

Returns the row number where the left upper corner of the image is anchored
This method is applicable only to adding images to ExcelWorksheet objects

getLettersFromColumnNumber(int) - Static method in class ActiveXLS.Formula

Returns the column name corresponding to the nColumnNumber index

getLineColor() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the line color of the chart axis.

getLineColor() - Method in class ActiveXLS.Charts.ExcelChartGridlines

Returns the line color of the chart gridlines.

getLineColor() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the line color of the chart data table.

getLineColor() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the line color of the chart series.

getLineStyle() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the line style of the chart axis.

getLineStyle() - Method in class ActiveXLS.Charts.ExcelChartGridlines

Returns the line style of the chart gridlines.

getLineStyle() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the line style of the chart data table.

getLineStyle() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the line style of the chart series.

getLineWeight() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the line weight of the chart axis.

getLineWeight() - Method in class ActiveXLS.Charts.ExcelChartGridlines

Returns the line weight of the chart gridlines.

getLineWeight() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the line weight of the chart data table.

getLineWeight() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the line weight of the chart series.

getLinkAt(int) - Method in class ActiveXLS.ExternalLinks

Returns the link on the specified position.

getLinkLocation() - Method in class ActiveXLS.Util.FormulaResult

Returns the link location (such as http://www.google.ro/) if the formula is a hyperlink.

getLinksDirty() - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns the links dirty property.

getMajorTickMarkType() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the type of the major tick mark.

getMajorUnit() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the major unit of the value Y axis scale.

getManager() - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns the manager property.

getMarkerType() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the marker type of the chart series.

getMaximumValue() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the maximun value of the value Y axis scale.

getMinimumValue() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the minimum value of the value Y axis scale.

getMinorTickMarkType() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the type of the minor tick mark.

getMinorUnit() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the minor unit of the value Y axis scale.

getName() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the name of the chart series.

getNameText() - Method in class ActiveXLS.ExcelName

Returns the title of the name.

getNumberFormat() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the chart axis number format.

getNumberFormat() - Method in class ActiveXLS.Util.FormulaResult

Returns the formula number format.

getOddColumnStripesStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the odd columns.

getOddRowStripesStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the odd rows.

getOperator() - Method in class ActiveXLS.ExcelCondition

Returns the conditional formatting operator.

getOperatorType() - Method in class ActiveXLS.ExcelDataValidator

Returns the operator type.

getOrientation() - Method in class ActiveXLS.ExcelPageSetup

Returns the page orientation.

getOutlineLevel() - Method in class ActiveXLS.ExcelColumn

Internal use only

getOutlineLevel() - Method in class ActiveXLS.ExcelRow

Internal use only

getPageOrder() - Method in class ActiveXLS.ExcelPageSetup

Returns the print page order.

getPaperSize() - Method in class ActiveXLS.ExcelPageSetup

Returns the paper size.

getPattern() - Method in class ActiveXLS.ExcelCell

Returns the pattern of the cell.

getPattern() - Method in class ActiveXLS.ExcelColumn

Returns the pattern of the column.

getPattern() - Method in class ActiveXLS.ExcelRow

Returns the pattern of the row.

getPattern() - Method in class ActiveXLS.ExcelStyle

Returns the pattern of the style.

getPatternColor() - Method in class ActiveXLS.ExcelCell

Returns the pattern color of the cell.

getPatternColor() - Method in class ActiveXLS.ExcelColumn

Returns the pattern color of the column.

getPatternColor() - Method in class ActiveXLS.ExcelRow

Returns the pattern color of the row.

getPatternColor() - Method in class ActiveXLS.ExcelStyle

Returns the pattern color of the style.

getPlacement() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the position of the chart legend within the chart area.

getPosition() - Method in class ActiveXLS.ExcelFooter

Returns the position of the footer.

getPosition() - Method in class ActiveXLS.ExcelHeader

Returns the position of the header.

getPrintArea() - Method in class ActiveXLS.ExcelPageSetup

Internal use only

getPrintComments() - Method in class ActiveXLS.ExcelPageSetup

Returns the print comments option for the page.

getRange() - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the range where the conditional formatting will be aplied.

getRange() - Method in class ActiveXLS.ExcelDataValidator

Returns the range where the validation will be aplied.

getRefersTo() - Method in class ActiveXLS.ExcelName

Returns the formula of the range.

getRevisionNumber() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the revision number property.

getRightColor_Border() - Method in class ActiveXLS.ExcelCell

Returns the color of the right border.

getRightColor_Border() - Method in class ActiveXLS.ExcelColumn

Returns the color of the right border.

getRightColor_Border() - Method in class ActiveXLS.ExcelCondition

Returns the color of the conditional formatting right border.

getRightColor_Border() - Method in class ActiveXLS.ExcelRow

Returns the color of the right border.

getRightColor_Border() - Method in class ActiveXLS.ExcelStyle

Returns the color of the right border.

getRightColumnStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the right column.

getRightMargin() - Method in class ActiveXLS.ExcelPageSetup

Returns the right margin of the paper.

getRightStyle_Border() - Method in class ActiveXLS.ExcelCell

Returns the style of the right border.

getRightStyle_Border() - Method in class ActiveXLS.ExcelColumn

Returns the style of the right border.

getRightStyle_Border() - Method in class ActiveXLS.ExcelCondition

Returns the style of the conditional formatting right border.

getRightStyle_Border() - Method in class ActiveXLS.ExcelRow

Returns the style of the right border.

getRightStyle_Border() - Method in class ActiveXLS.ExcelStyle

Returns the style of the right border.

getRotationDegrees() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the rotation degrees of the chart axis.

getRowHeight() - Method in class ActiveXLS.ExcelTable

Returns the default height of the rows.

getRowHeight(int) - Method in class ActiveXLS.ExcelTable

Returns the height of the specified row.

getRowMaxOutlineLevel() - Method in class ActiveXLS.ExcelWorksheet

Returns the highest number of outline levels for rows in this sheet.

getRowsNumber() - Method in class ActiveXLS.ExcelArrayFormula

Returns the number of rows in the range

getScale() - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Returns the scale property.

getScalingFactor() - Method in class ActiveXLS.ExcelPageSetup

Returns the scaling factor.

getSecondFormula() - Method in class ActiveXLS.ExcelCondition

Returns the conditional formatting second formula

getSecondFormula() - Method in class ActiveXLS.ExcelDataValidator

Returns the expression of the second formula.

getSheetIndex() - Method in class ActiveXLS.ExcelName

Returns the sheet index of the name.

getSheetName() - Method in class ActiveXLS.ExcelSheet

Returns the name of the sheet.

getShowLegendKeyNextToLabel() - Method in class ActiveXLS.Charts.ExcelSeries

Returns a value representing the visibility of the legend key.

getStatus() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the status property.

getStyle() - Method in class ActiveXLS.ExcelCell

Returns the style of the cell.

getStyle() - Method in class ActiveXLS.ExcelColumn

Returns the style of the column.

getStyle() - Method in class ActiveXLS.ExcelRow

Returns the style of the row.

getSubject() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the subject property.

getSummaryInformation() - Method in class ActiveXLS.ExcelDocument

Returns the summary information of an Excel document.

getTabColor() - Method in class ActiveXLS.ExcelSheet

Returns the tab color.

getTableStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the table.

getText() - Method in class ActiveXLS.ExcelComment

Returns the text of the comment.

getTextMark() - Method in class ActiveXLS.ExcelHyperlink

Returns the text mark value.

getTextRotation() - Method in class ActiveXLS.ExcelCell

Returns the text rotation of the cell.

getTextRotation() - Method in class ActiveXLS.ExcelColumn

Returns the text rotation of the column.

getTextRotation() - Method in class ActiveXLS.ExcelRow

Returns the text rotation of the row.

getTextRotation() - Method in class ActiveXLS.ExcelStyle

Returns the text rotation of the style.

getTickMarkLabel() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the label of the tick mark.

getTickMarksFrequency() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the number of categories between tick marks.

getTitle() - Method in class ActiveXLS.FileProperties.SummaryInformation

Returns the title property.

getToolTip() - Method in class ActiveXLS.ExcelHyperlink

Returns the tool tip text.

getTopColor_Border() - Method in class ActiveXLS.ExcelCell

Returns the color of the top border.

getTopColor_Border() - Method in class ActiveXLS.ExcelColumn

Returns the color of the top border.

getTopColor_Border() - Method in class ActiveXLS.ExcelCondition

Returns the color of the conditional formatting top border.

getTopColor_Border() - Method in class ActiveXLS.ExcelRow

Returns the color of the top border.

getTopColor_Border() - Method in class ActiveXLS.ExcelStyle

Returns the color of the top border.

getTopLeftCellStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the top left cell.

getTopMargin() - Method in class ActiveXLS.ExcelPageSetup

Returns the top margin of the paper.

getTopRightCellStyle() - Method in class ActiveXLS.ExcelAutoFormat

Returns the style applied to the top right cell.

getTopStyle_Border() - Method in class ActiveXLS.ExcelCell

Returns the style of the top border.

getTopStyle_Border() - Method in class ActiveXLS.ExcelColumn

Returns the style of the top border.

getTopStyle_Border() - Method in class ActiveXLS.ExcelCondition

Returns the style of the conditional formatting top border.

getTopStyle_Border() - Method in class ActiveXLS.ExcelRow

Returns the style of the top border.

getTopStyle_Border() - Method in class ActiveXLS.ExcelStyle

Returns the style of the top border.

getURL() - Method in class ActiveXLS.ExcelHyperlink

Return the URL value.

getUnderlineStyle() - Method in class ActiveXLS.Charts.ExcelAxis

Returns the underline style of the chart axis.

getUnderlineStyle() - Method in class ActiveXLS.Charts.ExcelChartArea

Returns the underline style of the chart area text.

getUnderlineStyle() - Method in class ActiveXLS.Charts.ExcelChartLegend

Returns the underline style of the chart legend text.

getUnderlineStyle() - Method in class ActiveXLS.Charts.ExcelDataTable

Returns the underline style of the chart data table text.

getUnderlineStyle() - Method in class ActiveXLS.ExcelCell

Returns the underline style of the cell font.

getUnderlineStyle() - Method in class ActiveXLS.ExcelColumn

Returns the underline style of the column font.

getUnderlineStyle() - Method in class ActiveXLS.ExcelComment

Returns the underline style of the comment text.

getUnderlineStyle() - Method in class ActiveXLS.ExcelCondition

Returns the underline style of the conditional formatting font.

getUnderlineStyle() - Method in class ActiveXLS.ExcelRow

Returns the underline style of the row font.

getUnderlineStyle() - Method in class ActiveXLS.ExcelStyle

Returns the underline style of the style font.

getValidationType() - Method in class ActiveXLS.ExcelDataValidator

Returns the validation type.

getValue() - Method in class ActiveXLS.ExcelCell

Returns the value of the cell.

getValues() - Method in class ActiveXLS.Charts.ExcelSeries

Returns the values of the chart series.

getVerticalAlignment() - Method in class ActiveXLS.ExcelCell

Returns the vertical alignment of the cell.

getVerticalAlignment() - Method in class ActiveXLS.ExcelColumn

Returns the vertical alignment of the column.

getVerticalAlignment() - Method in class ActiveXLS.ExcelRow

Returns the vertical alignment of the row.

getVerticalAlignment() - Method in class ActiveXLS.ExcelStyle

Returns the vertical alignment of the style.

getVerticalOffset() - Method in class ActiveXLS.Charts.ExcelChart

Returns the chart vertical offset This method is applicable only to adding charts to ExcelWorksheet objects

getVerticalOffset() - Method in class ActiveXLS.ExcelComment

Returns the comment vertical offset (the distance - in pixels - between the top border of the left upper corner cell to the top border of the comment).

getVerticalOffset() - Method in class ActiveXLS.ExcelImage

Returns the image vertical offset

getVerticalPageBreaks() - Method in class ActiveXLS.ExcelTable

Returns a list with all vertical page breaks

getWidth() - Method in class ActiveXLS.Charts.ExcelAxis

Internal use only

getWidth() - Method in class ActiveXLS.Charts.ExcelChart

Returns the chart width.

getWidth() - Method in class ActiveXLS.ExcelColumn

Returns the width of the column.

getWidth() - Method in class ActiveXLS.ExcelComment

Returns the comment width.

getWidth() - Method in class ActiveXLS.ExcelImage

Returns the image width.

getXF() - Method in class ActiveXLS.ExcelCell

Internal use only

getXF() - Method in class ActiveXLS.ExcelColumn

Internal use only

getXF() - Method in class ActiveXLS.ExcelRow

Internal use only

getXPosition() - Method in class ActiveXLS.Charts.ExcelAxis

Internal use only

getYPosition() - Method in class ActiveXLS.Charts.ExcelAxis

Internal use only

getZoom() - Method in class ActiveXLS.ExcelSheet

Returns the zoom of the sheet.