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

I

IgnoreBlank() - Method in class ActiveXLS.ExcelDataValidator

Returns the ignore blank option.

ImageCount() - Method in class ActiveXLS.ExcelChartSheet

Returns the number of images in the chart sheet.

ImageCount() - Method in class ActiveXLS.ExcelWorksheet

Returns the number of images in the worksheet.

InitAs(int) - Method in class ActiveXLS.ExcelAutoFormat

Initializes the table autoformat that is one of the predefined autoformats.

InsertBold() - Method in class ActiveXLS.ExcelFooter

Sets the bold style for the values that will follow the insertion.

InsertBold() - Method in class ActiveXLS.ExcelHeader

Sets the bold style for the values that will follow the insertion.

InsertDate() - Method in class ActiveXLS.ExcelFooter

Appends the date to footer expression.

InsertDate() - Method in class ActiveXLS.ExcelHeader

Appends the date to header expression.

InsertDoubleUnderline() - Method in class ActiveXLS.ExcelFooter

Sets the double underline style for the values that will follow the insertion.

InsertDoubleUnderline() - Method in class ActiveXLS.ExcelHeader

Sets the double underline style for the values that will follow the insertion.

InsertEnter() - Method in class ActiveXLS.ExcelFooter

Appends the enter character to footer expression.

InsertEnter() - Method in class ActiveXLS.ExcelHeader

Appends the enter character to header expression.

InsertFile() - Method in class ActiveXLS.ExcelFooter

Appends the file name to footer expression.

InsertFile() - Method in class ActiveXLS.ExcelHeader

Appends the file name to header expression.

InsertFont(String) - Method in class ActiveXLS.ExcelFooter

Sets the font type for the values that will follow the font insertion.

InsertFont(String) - Method in class ActiveXLS.ExcelHeader

Sets the font type for the values that will follow the font insertion.

InsertFontSize(int) - Method in class ActiveXLS.ExcelFooter

Sets the font size for the values that will follow the font size insertion.

InsertFontSize(int) - Method in class ActiveXLS.ExcelHeader

Sets the font size for the values that will follow the font size insertion.

InsertItalic() - Method in class ActiveXLS.ExcelFooter

Sets the italic style for the values that will follow the insertion.

InsertItalic() - Method in class ActiveXLS.ExcelHeader

Sets the italic style for the values that will follow the insertion.

InsertPage() - Method in class ActiveXLS.ExcelFooter

Appends the page number to footer expression.

InsertPage() - Method in class ActiveXLS.ExcelHeader

Appends the page number to header expression.

InsertPages() - Method in class ActiveXLS.ExcelFooter

Appends the total number of pages to footer expression.

InsertPages() - Method in class ActiveXLS.ExcelHeader

Appends the total number of pages to header expression.

InsertSingleUnderline() - Method in class ActiveXLS.ExcelFooter

Sets the single underline style for the values that will follow the insertion.

InsertSingleUnderline() - Method in class ActiveXLS.ExcelHeader

Sets the single underline style for the values that will follow the insertion.

InsertStrikethrough() - Method in class ActiveXLS.ExcelFooter

Sets the strikethrough style for the values that will follow the insertion.

InsertStrikethrough() - Method in class ActiveXLS.ExcelHeader

Sets the strikethrough style for the values that will follow the insertion.

InsertSubscript() - Method in class ActiveXLS.ExcelFooter

Sets the subscript style for the values that will follow the insertion.

InsertSubscript() - Method in class ActiveXLS.ExcelHeader

Sets the subscript style for the values that will follow the insertion.

InsertSuperscript() - Method in class ActiveXLS.ExcelFooter

Sets the superscript style for the values that will follow the insertion.

InsertSuperscript() - Method in class ActiveXLS.ExcelHeader

Sets the superscript style for the values that will follow the insertion.

InsertTab() - Method in class ActiveXLS.ExcelFooter

Appends the tab character to footer expression.

InsertTab() - Method in class ActiveXLS.ExcelHeader

Appends the tab character to header expression.

InsertTime() - Method in class ActiveXLS.ExcelFooter

Appends the date time to footer expression.

InsertTime() - Method in class ActiveXLS.ExcelHeader

Appends the date time to header expression.

InsertValue(String) - Method in class ActiveXLS.ExcelFooter

Appends a string to footer expression.

InsertValue(String) - Method in class ActiveXLS.ExcelHeader

Appends a string to header expression.

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

Returns true if the sValue is a simple cell reference (e.g. A1).

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

Returns true if the sValue is a simple cell reference in R1C1 reference style(e.g.

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

Returns true if the sRange is a column range.

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

Returns true if the sValue is a simple column range reference in R1C1 reference style(e.g. C[1]:C[2]).

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

Returns true if the sValue is a simple range reference (e.g. A1:B9).

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

Returns true if the sValue is a simple range reference in R1C1 reference style (e.g. R1C1:R9C2).

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

Returns true if the sRange is a simple row range (e.g. 4:6)

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

Returns true if the sRange is a simple row range in R1C1 reference style (e.g. R4:R6).

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

Returns true if the sValue is a complex cell reference (e.g. Sheet1!A1).

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

Returns true if the sValue is a complex cell reference in (e.g. Sheet1!R1C1).

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

Returns true if the sValue is a complex column range reference in R1C1 reference style(e.g. Sheet1!C[1]:C[2]).

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

Returns true if the sValue is a complex range reference (e.g. Sheet1!A1:B9).

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

Returns true if the sValue is a complex range reference in R1C1 reference style (e.g. Sheet1!R1C1:R9C2).

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

Returns true if the sRange is a complex row range in R1C1 reference style (e.g. Sheet1!R4:R6).

IsArray(String) - Method in class ActiveXLS.Formula

Returns true if the sValue represents an Excel array (e.g. {1,2,3} )

IsArrayFormula() - Method in class ActiveXLS.ExcelCell

Returns whether or not the cell formula has been entered as an array formula

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

Returns the automatic option of the crosses value of the category X axis.

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

Returns the automatic option of the major unit of the value Y axis scale.

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

Returns the automatic option of the maximum value of the value Y axis scale.

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

Returns the automatic option of the minimum value of the value Y axis scale.

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

Returns the automatic option of the minor unit of the value Y axis scale.

IsBackgroundModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the background of the cell font, false otherwise.

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

Returns the bold setting of the chart axis font.

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

Returns the bold setting of the chart area font.

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

Returns the bold setting of the chart legend font.

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

Returns the bold setting of the chart data table font.

IsBold() - Method in class ActiveXLS.ExcelCell

Returns the bold setting of the cell font.

IsBold() - Method in class ActiveXLS.ExcelColumn

Returns the bold setting of the column font.

IsBold() - Method in class ActiveXLS.ExcelComment

Returns the bold setting of the comment text.

IsBold() - Method in class ActiveXLS.ExcelCondition

Returns the bold setting of the conditional formatting font.

IsBold() - Method in class ActiveXLS.ExcelRow

Returns the bold setting of the row font.

IsBold() - Method in class ActiveXLS.ExcelStyle

Returns the bold setting of the style font.

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

Returns true if the sValue represents a bool value.

IsBottomBorderModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the bottom border style of the cell, false otherwise.

IsBuildInName() - Method in class ActiveXLS.ExcelName

Returns true if the name is a build-in name like print area, print titles.

IsCollapsed() - Method in class ActiveXLS.ExcelColumn

Internal use only

IsCollapsed() - Method in class ActiveXLS.ExcelDataGroup

Returns true if the data group is collapsed, false if the data group is expanded.

IsCollapsed() - Method in class ActiveXLS.ExcelRow

Internal use only

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

Returns true if the value Y axis crosses between categories, false otherwise.

IsDataGroupAutomaticStyles() - Method in class ActiveXLS.ExcelWorksheet

Returns the automatic style option when grouping data.

IsDataGroupSummaryColumnsRight() - Method in class ActiveXLS.ExcelWorksheet

Returns true if the summary columns to right of detail option is set when grouping data, false otherwise.

IsDataGroupSummaryRowsBelow() - Method in class ActiveXLS.ExcelWorksheet

Returns true if the summary rows below detail option is set when grouping data, false otherwise.

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

Returns true if the sValue represents a double value.

IsEqual(ExcelStyle) - Method in class ActiveXLS.ExcelStyle

Compares two styles.

IsFirstCellInRange(int, int) - Method in class ActiveXLS.ExcelArrayFormula

Internal use only.

IsFontBoldItalicModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the style property of the cell font, false otherwise.

IsFontColorModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the color of the cell font, false otherwise.

IsFontStrikethroughModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the strikethrough property of the cell font, false otherwise.

IsFontUnderlineModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the underline property of the cell font, false otherwise.

IsFreezePaneSet() - Method in class ActiveXLS.ExcelTable

Returns true if the row/columns are frozen, false otherwise.

IsFunction(String) - Method in class ActiveXLS.Formula

Returns true if the token represents a name of a function recognized by Microsoft Excel

IsHTMLUsed() - Method in class ActiveXLS.ExcelCell

Returns true if the cell contains rich text format.

IsHidden() - Method in class ActiveXLS.ExcelName

Returns the hidden setting of the name.

IsHidden() - Method in class ActiveXLS.ExcelSheet

Returns the hidden option of the sheet.

IsHiddenColumn() - Method in class ActiveXLS.ExcelColumn

Returns the hidden option of the column.

IsHiddenFormula() - Method in class ActiveXLS.ExcelCell

Returns the hidden setting of the cell.

IsHiddenFormula() - Method in class ActiveXLS.ExcelColumn

Returns the hidden setting of the column.

IsHiddenFormula() - Method in class ActiveXLS.ExcelRow

Returns the hidden setting of the row.

IsHiddenFormula() - Method in class ActiveXLS.ExcelStyle

Returns the hidden setting of the style.

IsHiddenRow() - Method in class ActiveXLS.ExcelRow

Returns the hidden option of the row.

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

Returns true if the sValue represents an integer value.

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

Returns the italic setting of the chart axis font.

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

Returns the italic setting of the chart area font.

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

Returns the italic setting of the chart legend font.

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

Returns the italic setting of the chart data table font.

IsItalic() - Method in class ActiveXLS.ExcelCell

Returns the italic setting of the cell font.

IsItalic() - Method in class ActiveXLS.ExcelColumn

Returns the italic setting of the column font.

IsItalic() - Method in class ActiveXLS.ExcelComment

Returns the italic setting of the comment text.

IsItalic() - Method in class ActiveXLS.ExcelCondition

Returns the italic setting of the conditional formatting font.

IsItalic() - Method in class ActiveXLS.ExcelRow

Returns the italic setting of the row font.

IsItalic() - Method in class ActiveXLS.ExcelStyle

Returns the italic setting of the style font.

IsLeftBorderModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the left border style of the cell, false otherwise.

IsLocked() - Method in class ActiveXLS.ExcelCell

Returns the locked setting of the cell.

IsLocked() - Method in class ActiveXLS.ExcelColumn

Returns the locked setting of the column.

IsLocked() - Method in class ActiveXLS.ExcelRow

Returns the locked setting of the row.

IsLocked() - Method in class ActiveXLS.ExcelStyle

Returns the locked setting of the style.

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

Returns true if the logarithmic scale is applied, false otherwise The property is applicable only to value Y axis.

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

Returns true if the axis crosses at maximum value, false otherwise.

IsMergeCell() - Method in class ActiveXLS.ExcelCell

Returns the merge cell option of the cell

IsMergeCell() - Method in class ActiveXLS.ExcelStyle

Returns the merge cell option of the style

IsName(String) - Method in class ActiveXLS.Formula

Returns true if the string represents an Excel Name.

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

Returns true, if the number format of the labels is the same as the number format of the data source, false otherwise.

IsPageBreakPreview() - Method in class ActiveXLS.ExcelWorksheet

Returns the page break preview option of the worksheet.

IsR1C1ReferenceStyle() - Method in class ActiveXLS.ExcelOptions

Returns the R1C1 reference style of the document.

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

Returns true if the values are in reverse order, false otherwise

IsRightBorderModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the right border style of the cell, false otherwise.

IsRowHeightSet() - Method in class ActiveXLS.ExcelTable

Returns true if the default row height was set, false otherwise.

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

Returns the shadow setting of the chart area.

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

Returns the shadow setting of the chart legend.

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

Returns the shadow setting of the chart series.

IsSheetProtected() - Method in class ActiveXLS.ExcelSheet

Returns the protected option of the sheet.

IsSheetSelected() - Method in class ActiveXLS.ExcelSheet

Returns the selected option of the sheet.

IsShowErrorBox() - Method in class ActiveXLS.ExcelDataValidator

Returns the show "Error Alert" box option.

IsShowInputBox() - Method in class ActiveXLS.ExcelDataValidator

Returns the show "Input Message" box option.

IsShrink() - Method in class ActiveXLS.ExcelCell

Returns the shrink setting of the cell.

IsShrink() - Method in class ActiveXLS.ExcelColumn

Returns the shrink setting of the column.

IsShrink() - Method in class ActiveXLS.ExcelRow

Returns the shrink setting of the row.

IsShrink() - Method in class ActiveXLS.ExcelStyle

Returns the shrink setting of the style.

IsSplitSet() - Method in class ActiveXLS.ExcelTable

Returns true if the row/columns are split, false otherwise.

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

Returns the strikethrough setting of the chart axis font.

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

Returns the strikethrough setting of the chart area font.

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

Returns the strikethrough setting of the chart legend font.

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

Returns the strikethrough setting of the chart data table font.

IsStrikethrough() - Method in class ActiveXLS.ExcelCell

Returns the strikethrough setting of the cell font.

IsStrikethrough() - Method in class ActiveXLS.ExcelColumn

Returns the strikethrough setting of the column font.

IsStrikethrough() - Method in class ActiveXLS.ExcelCondition

Returns the strikethrough setting of the conditional formatting font.

IsStrikethrough() - Method in class ActiveXLS.ExcelRow

Returns the strikethrough setting of the row font.

IsStrikethrough() - Method in class ActiveXLS.ExcelStyle

Returns the strikethrough setting of the style font.

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

Returns true if the sValue represents a string value.

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

Returns the subscript setting of the chart axis font.

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

Returns the subscript setting of the chart area font.

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

Returns the subscript setting of the chart legend font.

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

Returns the subscript setting of the chart data table font.

IsSubscript() - Method in class ActiveXLS.ExcelCell

Returns the subscript setting of the cell font.

IsSubscript() - Method in class ActiveXLS.ExcelColumn

Returns the subscript setting of the column font.

IsSubscript() - Method in class ActiveXLS.ExcelRow

Returns the subscript setting of the row font.

IsSubscript() - Method in class ActiveXLS.ExcelStyle

Returns the subscript setting of the style font.

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

Returns the superscript setting of the chart axis font.

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

Returns the superscript setting of the chart area font.

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

Returns the superscript setting of the chart legend font.

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

Returns the superscript setting of the chart data table font.

IsSuperscript() - Method in class ActiveXLS.ExcelCell

Returns the superscript setting of the cell font.

IsSuperscript() - Method in class ActiveXLS.ExcelColumn

Returns the superscript setting of the column font.

IsSuperscript() - Method in class ActiveXLS.ExcelRow

Returns the superscript setting of the row font.

IsSuperscript() - Method in class ActiveXLS.ExcelStyle

Returns the superscript setting of the style font.

IsTopBorderModified() - Method in class ActiveXLS.ExcelCondition

Returns true if the condition modifies the top border style of the cell, false otherwise.

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

Returns the visible setting of the chart axis.

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

Returns the visible setting of the chart gridlines.

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

Returns the visible setting of the chart legend.

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

Returns the visible setting of the chart data table.

IsWrap() - Method in class ActiveXLS.ExcelCell

Returns the wrap setting of the cell.

IsWrap() - Method in class ActiveXLS.ExcelColumn

Returns the wrap setting of the column.

IsWrap() - Method in class ActiveXLS.ExcelRow

Returns the wrap setting of the row.

IsWrap() - Method in class ActiveXLS.ExcelStyle

Returns the wrap setting of the style.

insertCondition(int, ExcelCondition) - Method in class ActiveXLS.ExcelConditionalFormatting

Inserts a new condition.

insertElementAt(Object, int) - Method in class ActiveXLS.Util.List

Inserts a new element at the specified index.

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

Returns whether or not sValue is one of the errors recognized by Excel

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

Returns whether the formula result is a hyperlink.