Index

A B C D E F G H I J K L M N O P R S T U V
All Classes|All Namespaces|Constant Field Values|Deprecated API

I

IAlignDrawingObject - Interface in EasyXLS.Drawings

Interface of the class stores a drawing shape having an alignment formatting.

IEffectDrawingObject - Interface in EasyXLS.Drawings

Interface of the class that stores a drawing shape having a 3D-formatting.

IFontDrawingObject - Interface in EasyXLS.Drawings

Interface of the class that stores a drawing shape having a font formatting.

IgnoreBlank() - Method in class EasyXLS.ExcelDataValidator

Returns the ignore blank option.

ImageCount() - Method in class EasyXLS.ExcelSheet

Returns the number of images in the sheet.

InitAs(int) - Method in class EasyXLS.ExcelAutoFormat

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

InitAs(String) - Method in class EasyXLS.Themes.ExcelColorScheme

Initializes a color scheme with the specified built-in theme colors.

InitAs(String) - Method in class EasyXLS.Themes.ExcelEffectScheme

Initializes a font scheme with the specified built-in theme effects.

InitAs(String) - Method in class EasyXLS.Themes.ExcelFontScheme

Initializes a font scheme with the specified built-in theme fonts.

InitAs(String) - Method in class EasyXLS.Themes.ExcelTheme

Initializes the theme that is one of the built-in themes.

InsertBold() - Method in class EasyXLS.ExcelFooter

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

InsertBold() - Method in class EasyXLS.ExcelHeader

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

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

Inserts a new condition.

InsertDate() - Method in class EasyXLS.ExcelFooter

Appends the date to footer expression.

InsertDate() - Method in class EasyXLS.ExcelHeader

Appends the date to header expression.

InsertDoubleUnderline() - Method in class EasyXLS.ExcelFooter

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

InsertDoubleUnderline() - Method in class EasyXLS.ExcelHeader

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

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

Inserts a new element at the specified index.

InsertEnter() - Method in class EasyXLS.ExcelFooter

Appends the enter character to footer expression.

InsertEnter() - Method in class EasyXLS.ExcelHeader

Appends the enter character to header expression.

InsertFile() - Method in class EasyXLS.ExcelFooter

Appends the file name to footer expression.

InsertFile() - Method in class EasyXLS.ExcelHeader

Appends the file name to header expression.

InsertFont(String) - Method in class EasyXLS.ExcelFooter

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

InsertFont(String) - Method in class EasyXLS.ExcelHeader

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

InsertFontSize(int) - Method in class EasyXLS.ExcelFooter

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

InsertFontSize(int) - Method in class EasyXLS.ExcelHeader

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

InsertItalic() - Method in class EasyXLS.ExcelFooter

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

InsertItalic() - Method in class EasyXLS.ExcelHeader

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

InsertPage() - Method in class EasyXLS.ExcelFooter

Appends the page number to footer expression.

InsertPage() - Method in class EasyXLS.ExcelHeader

Appends the page number to header expression.

InsertPages() - Method in class EasyXLS.ExcelFooter

Appends the total number of pages to footer expression.

InsertPages() - Method in class EasyXLS.ExcelHeader

Appends the total number of pages to header expression.

InsertSingleUnderline() - Method in class EasyXLS.ExcelFooter

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

InsertSingleUnderline() - Method in class EasyXLS.ExcelHeader

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

InsertStrikethrough() - Method in class EasyXLS.ExcelFooter

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

InsertStrikethrough() - Method in class EasyXLS.ExcelHeader

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

InsertSubscript() - Method in class EasyXLS.ExcelFooter

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

InsertSubscript() - Method in class EasyXLS.ExcelHeader

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

InsertSuperscript() - Method in class EasyXLS.ExcelFooter

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

InsertSuperscript() - Method in class EasyXLS.ExcelHeader

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

InsertTab() - Method in class EasyXLS.ExcelFooter

Appends the tab character to footer expression.

InsertTab() - Method in class EasyXLS.ExcelHeader

Appends the tab character to header expression.

InsertTime() - Method in class EasyXLS.ExcelFooter

Appends the date time to footer expression.

InsertTime() - Method in class EasyXLS.ExcelHeader

Appends the date time to header expression.

InsertValue(String) - Method in class EasyXLS.ExcelFooter

Appends a string to footer expression.

InsertValue(String) - Method in class EasyXLS.ExcelHeader

Appends a string to header expression.

INSIDE_BOTTOM - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside bottom shadow.

INSIDE_CENTER - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside center shadow.

INSIDE_DIAGONAL_BOTTOM_LEFT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside diagonal bottom left shadow.

INSIDE_DIAGONAL_BOTTOM_RIGHT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside diagonal bottom right shadow.

INSIDE_DIAGONAL_TOP_LEFT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside diagonal top left shadow.

INSIDE_DIAGONAL_TOP_RIGHT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside diagonal top right shadow.

INSIDE_LEFT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside left shadow.

INSIDE_RIGHT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside right shadow.

INSIDE_TOP - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat

A constant indicating the inside top shadow.

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

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

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

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

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

Returns true if the sRange is a column range.

Is2DColumnRangeR1C1style(String) - Static method in class EasyXLS.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 EasyXLS.Formula

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

Is2DRangeR1C1style(String) - Static method in class EasyXLS.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 EasyXLS.Formula

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

Is2DRowRangeR1C1style(String) - Static method in class EasyXLS.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 EasyXLS.Formula

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

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

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

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

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

Is3DName(String) - Method in class EasyXLS.Formula

Returns true if the value represents an Excel name having a specified scope.

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

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

Is3DRangeR1C1style(String) - Static method in class EasyXLS.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 EasyXLS.Formula

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

IsAllCaps() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the all caps setting of the font.

IsArray(String) - Method in class EasyXLS.Formula

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

IsArrayFormula() - Method in class EasyXLS.ExcelCell

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

IsAutoFilter() - Method in class EasyXLS.ExcelFilter

Returns true if the auto-filter is applied, false otherwise.

IsAutofitColumnWidthsOnUpdate() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if the pivot table columns are adjusted automatically to fit the cell content, false if the current width is kept.

IsAutomatic() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if automatic fill is set, false otherwise.

IsAutomatic() - Method in class EasyXLS.Drawings.Formatting.LineColorFormat

Returns true if an automatic line is set, false otherwise.

IsAutomaticCaps() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the caps are automatic, false otherwise.

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

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

IsAutomaticCharacterSpacing() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the character spacing is automatic, false otherwise.

IsAutomaticEqualizeCharacterHeight() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the character height is automatic, false otherwise.

IsAutomaticFont() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font is automatic, false otherwise.

IsAutomaticFontSize() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font size is automatic, false otherwise.

IsAutomaticFontStyle() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font style is automatic, false otherwise.

IsAutomaticForeground() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if automatic foreground is set, false otherwise.

IsAutomaticKerningForFonts() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the kerning for fonts is automatic, false otherwise.

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

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

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

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

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

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

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

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

IsAutomaticStrikethrough() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the strikethrough is automatic, false otherwise.

IsAutomaticSuperscriptSubscript() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the superscript/subscript is automatic, false otherwise.

IsAutomaticTextBackgroundDark1() - Method in class EasyXLS.Themes.ExcelColorScheme

Returns true if the Text/Background Dark 1 color is set automatically, false otherwise.

IsAutomaticTextBackgroundLight1() - Method in class EasyXLS.Themes.ExcelColorScheme

Returns true if the Text/Background Light 1 color is set automatically, false otherwise.

IsAutomaticUnderline() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the underline is automatic, false otherwise.

IsAutomaticUnderlineColor() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if underline color is automatic, false otherwise.

IsBackgroundModified() - Method in class EasyXLS.ExcelCondition

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

IsBodyFont() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font is the body font, false otherwise.

IsBodyFont() - Method in class EasyXLS.ExcelCell

Returns true if the font is the body font, false otherwise.

IsBodyFont() - Method in class EasyXLS.ExcelColumn

Returns true if the font is the body font, false otherwise.

IsBodyFont() - Method in class EasyXLS.ExcelRow

Returns true if the font is the body font, false otherwise.

IsBodyFont() - Method in class EasyXLS.ExcelStyle

Returns true if the font is the body font, false otherwise.

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsBold()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsBold()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsBold()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsBold()

IsBold() - Method in class EasyXLS.Drawings.ExcelComment

Returns the bold setting of the comment text.

IsBold() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font is bold, false otherwise.

IsBold() - Method in class EasyXLS.ExcelCell

Returns the bold setting of the cell font.

IsBold() - Method in class EasyXLS.ExcelColumn

Returns the bold setting of the column font.

IsBold() - Method in class EasyXLS.ExcelCondition

Returns the bold setting of the conditional formatting font.

IsBold() - Method in class EasyXLS.ExcelRow

Returns the bold setting of the row font.

IsBold() - Method in class EasyXLS.ExcelStyle

Returns the bold setting of the style font.

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

Returns true if the sValue represents a bool value.

IsBottomBorderModified() - Method in class EasyXLS.ExcelCondition

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

IsBuildInName() - Method in class EasyXLS.ExcelName

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

IsClassicLayout() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if the classic layout is selected, false otherwise.

IsCollapsed() - Method in class EasyXLS.ExcelColumn

Internal use only

IsCollapsed() - Method in class EasyXLS.ExcelDataGroup

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

IsCollapsed() - Method in class EasyXLS.ExcelRow

Internal use only

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

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

IsDataGroupAutomaticStyles() - Method in class EasyXLS.ExcelWorksheet

Returns the automatic style option when grouping data.

IsDataGroupSummaryColumnsRight() - Method in class EasyXLS.ExcelWorksheet

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

IsDataGroupSummaryRowsBelow() - Method in class EasyXLS.ExcelWorksheet

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

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

Returns true if the sValue represents a double value.

IsDoubleStrikethrough() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the double strikethrough setting of the font.

IsEnabledShowDetails() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if the drilling down to detail data from the data source, and then displaying the data on a new worksheet is enabled, false otherwise.

IsEqual(ExcelStyle) - Method in class EasyXLS.ExcelStyle

Compares two styles.

IsEqual(ThemeColor) - Method in class EasyXLS.Themes.ThemeColor

Compares two theme colors.

IsEqualizeCharacterHeight() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the equalize character height setting of the font.

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

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

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

Internal use only.

IsFontBoldItalicModified() - Method in class EasyXLS.ExcelCondition

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

IsFontColorModified() - Method in class EasyXLS.ExcelCondition

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

IsFontStrikethroughModified() - Method in class EasyXLS.ExcelCondition

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

IsFontUnderlineModified() - Method in class EasyXLS.ExcelCondition

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

IsFreezePaneSet() - Method in class EasyXLS.ExcelTable

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

IsFunction(String) - Method in class EasyXLS.Formula

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

IsGradientFill() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if gradient fill is set, false otherwise.

IsGradientLine() - Method in class EasyXLS.Drawings.Formatting.LineColorFormat

Returns true if a gradient line is set, false otherwise.

IsGroupAutoEnd() - Method in class EasyXLS.PivotTables.ExcelField

Returns true if the group end value is automatic, false otherwise.

IsGroupAutoStart() - Method in class EasyXLS.PivotTables.ExcelField

Returns true if the group start value is automatic, false otherwise.

IsHeadingsFont() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font is the headings font, false otherwise.

IsHeadingsFont() - Method in class EasyXLS.ExcelCell

Returns true if the font is the headings font, false otherwise.

IsHeadingsFont() - Method in class EasyXLS.ExcelColumn

Returns true if the font is the headings font, false otherwise.

IsHeadingsFont() - Method in class EasyXLS.ExcelRow

Returns true if the font is the headings font, false otherwise.

IsHeadingsFont() - Method in class EasyXLS.ExcelStyle

Returns true if the font is the headings font, false otherwise.

IsHidden() - Method in class EasyXLS.ExcelName

Returns the hidden setting of the name.

IsHidden() - Method in class EasyXLS.ExcelSheet

Returns the hidden option of the sheet.

IsHiddenColumn() - Method in class EasyXLS.ExcelColumn

Returns the hidden option of the column.

IsHiddenFormula() - Method in class EasyXLS.ExcelCell

Returns the hidden setting of the cell.

IsHiddenFormula() - Method in class EasyXLS.ExcelColumn

Returns the hidden setting of the column.

IsHiddenFormula() - Method in class EasyXLS.ExcelRow

Returns the hidden setting of the row.

IsHiddenFormula() - Method in class EasyXLS.ExcelStyle

Returns the hidden setting of the style.

IsHiddenRow() - Method in class EasyXLS.ExcelRow

Returns the hidden option of the row.

IsHTMLUsed() - Method in class EasyXLS.Drawings.ExcelComment

Returns true if the comment contains rich text format.

IsHTMLUsed() - Method in class EasyXLS.ExcelCell

Returns true if the cell contains rich text format.

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

Returns whether the formula result is a hyperlink.

IsInsertBlankLine() - Method in class EasyXLS.PivotTables.ExcelField

Returns true if a blank line is inserted after each item label, false otherwise.

IsInsertPageBreak() - Method in class EasyXLS.PivotTables.ExcelField

Returns true if a blank line is inserted after each item, false otherwise.

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

Returns true if the sValue represents an integer value.

IsInvertIfNegative() - Method in class EasyXLS.Charts.ExcelSeries

Returns true if the color is inverted for negative values of the chart series, false otherwise.

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsItalic()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsItalic()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsItalic()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsItalic()

IsItalic() - Method in class EasyXLS.Drawings.ExcelComment

Returns the italic setting of the comment text.

IsItalic() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns true if the font is italic, false otherwise.

IsItalic() - Method in class EasyXLS.ExcelCell

Returns the italic setting of the cell font.

IsItalic() - Method in class EasyXLS.ExcelColumn

Returns the italic setting of the column font.

IsItalic() - Method in class EasyXLS.ExcelCondition

Returns the italic setting of the conditional formatting font.

IsItalic() - Method in class EasyXLS.ExcelRow

Returns the italic setting of the row font.

IsItalic() - Method in class EasyXLS.ExcelStyle

Returns the italic setting of the style font.

IsIterativeCalculation() - Method in class EasyXLS.ExcelOptions

Returns true if the iterative calculation is enabled, false otherwise.

IsJustifyDistributed() - Method in class EasyXLS.ExcelCell

Returns the justify distributed setting of the cell.

IsJustifyDistributed() - Method in class EasyXLS.ExcelColumn

Returns the justify distributed setting of the column.

IsJustifyDistributed() - Method in class EasyXLS.ExcelRow

Returns the justify distributed setting of the row.

IsJustifyDistributed() - Method in class EasyXLS.ExcelStyle

Returns the justify distributed setting of the style font.

IsLeftBorderModified() - Method in class EasyXLS.ExcelCondition

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

IsLeftToRight() - Method in class EasyXLS.Drawings.Formatting.AlignmentFormat

Returns true if the order of lines is from left to right, false otherwise.

IsLocked() - Method in class EasyXLS.ExcelCell

Returns the locked setting of the cell.

IsLocked() - Method in class EasyXLS.ExcelColumn

Returns the locked setting of the column.

IsLocked() - Method in class EasyXLS.ExcelRow

Returns the locked setting of the row.

IsLocked() - Method in class EasyXLS.ExcelStyle

Returns the locked setting of the style.

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

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

IsLowerPerspective() - Method in class EasyXLS.Drawings.Formatting.ShadowFormat

Returns true if it is a perspective shadow displayed in front of the shape, false otherwise.

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

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

IsMergeAndCenterCellsWithLabels() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if the cells are merged for outer row and column items, false otherwise.

IsMergeCell() - Method in class EasyXLS.ExcelCell

Returns the merge cell option of the cell

IsMergeCell() - Method in class EasyXLS.ExcelStyle

Returns the merge cell option of the style

IsName(String) - Method in class EasyXLS.Formula

Returns true if the value represents an Excel Name.

IsNoFill() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if no fill is set, false otherwise.

IsNoLine() - Method in class EasyXLS.Drawings.Formatting.LineColorFormat

Returns true if no line is set, false otherwise.

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

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

IsNumberFormatLinked() - Method in class EasyXLS.Charts.ExcelDataLabels

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 EasyXLS.ExcelWorksheet

Returns the page break preview option of the worksheet.

IsPageOverThenDown() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if first are displayed the fields in the report filter area from left to right, false if first are displayed the fields in the report filter area from top to bottom

IsPatternFill() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if pattern fill is set, false otherwise.

IsPatternLine() - Method in class EasyXLS.Drawings.Formatting.LineColorFormat

Returns true if a pattern line is set, false otherwise.

IsPictureFill() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if picture fill is set, false otherwise.

IsPreserveCellFormattingOnUpdate() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if the layout and format is preserved each time an operation is performed on the pivot table, false otherwise.

IsR1C1ReferenceStyle() - Method in class EasyXLS.ExcelOptions

Returns the R1C1 reference style of the document.

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

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

IsRightBorderModified() - Method in class EasyXLS.ExcelCondition

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

IsRotateWithShape() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if rotate with shape is active, false otherwise.

IsRowHeightSet() - Method in class EasyXLS.ExcelTable

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

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

Deprecated.

As of version 8.3, replaced by ShadowFormat.HasShadow()

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

Deprecated.

As of version 8.3, replaced by ShadowFormat.HasShadow()

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

Deprecated.

As of version 8.3, replaced by ShadowFormat.HasShadow()

IsSheetProtected() - Method in class EasyXLS.ExcelSheet

Returns the protected option of the sheet.

IsSheetSelected() - Method in class EasyXLS.ExcelSheet

Returns the selected option of the sheet.

IsShowErrorBox() - Method in class EasyXLS.ExcelDataValidator

Returns the show "Error Alert" box option.

IsShowInputBox() - Method in class EasyXLS.ExcelDataValidator

Returns the show "Input Message" box option.

IsShrink() - Method in class EasyXLS.ExcelCell

Returns the shrink setting of the cell.

IsShrink() - Method in class EasyXLS.ExcelColumn

Returns the shrink setting of the column.

IsShrink() - Method in class EasyXLS.ExcelRow

Returns the shrink setting of the row.

IsShrink() - Method in class EasyXLS.ExcelStyle

Returns the shrink setting of the style.

IsSmallCaps() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the small caps setting of the font.

IsSmoothedLine() - Method in class EasyXLS.Charts.ExcelSeries

Returns true if the line is smoothed, false otherwise.

IsSolidFill() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if solid fill is set, false otherwise.

IsSolidLine() - Method in class EasyXLS.Drawings.Formatting.LineColorFormat

Returns true if a solid line is set, false otherwise.

IsSplitSet() - Method in class EasyXLS.ExcelTable

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

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsStrikethrough()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsStrikethrough()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsStrikethrough()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsStrikethrough()

IsStrikethrough() - Method in class EasyXLS.Drawings.ExcelComment

Returns the strikethrough setting of the comment.

IsStrikethrough() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the strikethrough setting of the font.

IsStrikethrough() - Method in class EasyXLS.ExcelCell

Returns the strikethrough setting of the cell font.

IsStrikethrough() - Method in class EasyXLS.ExcelColumn

Returns the strikethrough setting of the column font.

IsStrikethrough() - Method in class EasyXLS.ExcelCondition

Returns the strikethrough setting of the conditional formatting font.

IsStrikethrough() - Method in class EasyXLS.ExcelRow

Returns the strikethrough setting of the row font.

IsStrikethrough() - Method in class EasyXLS.ExcelStyle

Returns the strikethrough setting of the style font.

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

Returns true if the sValue represents a string value.

IsStructureProtected() - Method in class EasyXLS.ExcelDocument

Returns the protection option of the workbook structure.

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSubscript()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSubscript()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSubscript()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSubscript()

IsSubscript() - Method in class EasyXLS.Drawings.ExcelComment

Returns the subscript setting of the comment.

IsSubscript() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the subscript setting of the font.

IsSubscript() - Method in class EasyXLS.ExcelCell

Returns the subscript setting of the cell font.

IsSubscript() - Method in class EasyXLS.ExcelColumn

Returns the subscript setting of the column font.

IsSubscript() - Method in class EasyXLS.ExcelRow

Returns the subscript setting of the row font.

IsSubscript() - Method in class EasyXLS.ExcelStyle

Returns the subscript setting of the style font.

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSuperscript()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSuperscript()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSuperscript()

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

Deprecated.

As of version 8.3, replaced by FontFormat.IsSuperscript()

IsSuperscript() - Method in class EasyXLS.Drawings.ExcelComment

Returns the superscript setting of the comment.

IsSuperscript() - Method in class EasyXLS.Drawings.Formatting.FontFormat

Returns the superscript setting of the font.

IsSuperscript() - Method in class EasyXLS.ExcelCell

Returns the superscript setting of the cell font.

IsSuperscript() - Method in class EasyXLS.ExcelColumn

Returns the superscript setting of the column font.

IsSuperscript() - Method in class EasyXLS.ExcelRow

Returns the superscript setting of the row font.

IsSuperscript() - Method in class EasyXLS.ExcelStyle

Returns the superscript setting of the style font.

IsTilePictureAsTexture() - Method in class EasyXLS.Drawings.Formatting.FillFormat

Returns true if the picture is tiled as texture, false otherwise.

IsTopBorderModified() - Method in class EasyXLS.ExcelCondition

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

IsUnsignedInteger(String) - Static method in class EasyXLS.Util.FormulaParser

Returns true if the sValue represents an unsigned integer value.

IsUseCustomListsWhenSorting() - Method in class EasyXLS.PivotTables.ExcelPivotTable

Returns true if the custom lists are used when Excel sorts lists, false otherwise.

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

Returns the visible setting of the chart axis.

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

Returns the visible setting of the chart gridlines.

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

Returns the visible setting of the chart legend.

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

Returns the visible setting of the chart data table.

IsWindowsProtected() - Method in class EasyXLS.ExcelDocument

Returns the protection option of the workbook windows.

IsWrap() - Method in class EasyXLS.ExcelCell

Returns the wrap setting of the cell.

IsWrap() - Method in class EasyXLS.ExcelColumn

Returns the wrap setting of the column.

IsWrap() - Method in class EasyXLS.ExcelRow

Returns the wrap setting of the row.

IsWrap() - Method in class EasyXLS.ExcelStyle

Returns the wrap setting of the style.

A B C D E F G H I J K L M N O P R S T U V
All Classes|All Namespaces|Constant Field Values|Deprecated API