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

C

CELL - Constant in class ActiveXLS.Constants.HyperlinkType

A constant indicating an internal hyperlink.

CHART_TYPE_AREA - Constant in class ActiveXLS.Constants.Chart

A constant indicating an Area chart.

CHART_TYPE_AREA_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% Stacked Area chart.

CHART_TYPE_AREA_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating an Area with a 3D visual effect chart.

CHART_TYPE_AREA_3D_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% Stacked Area chart with a 3D visual effect.

CHART_TYPE_AREA_3D_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a Stacked Area with a 3D visual effect chart.

CHART_TYPE_AREA_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a Stacked Area chart.

CHART_TYPE_BAR_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked bar chart.

CHART_TYPE_BAR_3D_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked bar chart with a 3D visual effect.

CHART_TYPE_BAR_3D_CLUSTERED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a clustered bar chart with a 3D visual effect.

CHART_TYPE_BAR_3D_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked bar chart with a 3D visual effect.

CHART_TYPE_BAR_CLUSTERED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a clustered bar chart.

CHART_TYPE_BAR_OF_PIE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a bar of pie chart.

CHART_TYPE_BAR_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked bar chart.

CHART_TYPE_BUBBLE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a bubble chart.

CHART_TYPE_BUBBLE_3D_EFFECT - Constant in class ActiveXLS.Constants.Chart

A constant indicating a bubble chart with a 3D visual effect.

CHART_TYPE_COLUMN_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked column chart.

CHART_TYPE_COLUMN_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 3D column chart.

CHART_TYPE_COLUMN_3D_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked column chart with a 3D visual effect.

CHART_TYPE_COLUMN_3D_CLUSTERED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a clustered column chart with a 3D visual effect.

CHART_TYPE_COLUMN_3D_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked column chart with a 3D visual effect.

CHART_TYPE_COLUMN_CLUSTERED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a clustered column chart.

CHART_TYPE_COLUMN_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked column chart.

CHART_TYPE_CONE_BAR - Constant in class ActiveXLS.Constants.Chart

A constant indicating a bar chart with a conical shape.

CHART_TYPE_CONE_BAR_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked bar chart with a conical shape.

CHART_TYPE_CONE_BAR_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked bar chart with a conical shape.

CHART_TYPE_CONE_COLUMN - Constant in class ActiveXLS.Constants.Chart

A constant indicating a column chart with a conical shape.

CHART_TYPE_CONE_COLUMN_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked column chart with a conical shape.

CHART_TYPE_CONE_COLUMN_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 3D column chart with a conical shape.

CHART_TYPE_CONE_COLUMN_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked column chart with a conical shape.

CHART_TYPE_CYLINDER_BAR - Constant in class ActiveXLS.Constants.Chart

A constant indicating a bar chart with a cylindrical shape.

CHART_TYPE_CYLINDER_BAR_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked bar chart with a cylindrical shape.

CHART_TYPE_CYLINDER_BAR_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked bar chart with a cylindrical shape.

CHART_TYPE_CYLINDER_COLUMN - Constant in class ActiveXLS.Constants.Chart

A constant indicating a column chart with a cylindrical shape.

CHART_TYPE_CYLINDER_COLUMN_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked column chart with a cylindrical shape.

CHART_TYPE_CYLINDER_COLUMN_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 3D column chart with a cylindrical shape.

CHART_TYPE_CYLINDER_COLUMN_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked column chart with a cylindrical shape.

CHART_TYPE_DOUGHNUT - Constant in class ActiveXLS.Constants.Chart

A constant indicating a doughnut chart.

CHART_TYPE_DOUGHNUT_EXPLODED - Constant in class ActiveXLS.Constants.Chart

A constant indicating an exploded doughnut chart.

CHART_TYPE_LINE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a line chart.

CHART_TYPE_LINE_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked line chart.

CHART_TYPE_LINE_100_PERCENT_STACKED_MARKERS - Constant in class ActiveXLS.Constants.Chart

A constant indicating an 100% stacked line chart with markers displayed at each data value.

CHART_TYPE_LINE_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 3D line chart.

CHART_TYPE_LINE_MARKERS - Constant in class ActiveXLS.Constants.Chart

A constant indicating a line chart with markers displayed at each data value.

CHART_TYPE_LINE_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked line chart.

CHART_TYPE_LINE_STACKED_MARKERS - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked line chart with markers displayed at each data value.

CHART_TYPE_PIE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a pie chart.

CHART_TYPE_PIE_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a pie chart with a 3D visual effect.

CHART_TYPE_PIE_3D_EXPLODED - Constant in class ActiveXLS.Constants.Chart

A constant indicating an exploded pie chart with a 3D visual effect.

CHART_TYPE_PIE_EXPLODED - Constant in class ActiveXLS.Constants.Chart

A constant indicating an exploded pie chart.

CHART_TYPE_PIE_OF_PIE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a pie of pie chart.

CHART_TYPE_PYRAMID_BAR - Constant in class ActiveXLS.Constants.Chart

A constant indicating a bar chart with a pyramid shape.

CHART_TYPE_PYRAMID_BAR_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked bar chart with a pyramid shape.

CHART_TYPE_PYRAMID_BAR_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked bar chart with a pyramid shape.

CHART_TYPE_PYRAMID_COLUMN - Constant in class ActiveXLS.Constants.Chart

A constant indicating a column chart with a pyramid shape.

CHART_TYPE_PYRAMID_COLUMN_100_PERCENT_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 100% stacked column chart with a pyramid shape.

CHART_TYPE_PYRAMID_COLUMN_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 3D column chart with a pyramid shape.

CHART_TYPE_PYRAMID_COLUMN_STACKED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stacked column chart with a pyramid shape.

CHART_TYPE_RADAR - Constant in class ActiveXLS.Constants.Chart

A constant indicating a radar chart.

CHART_TYPE_RADAR_FILLED - Constant in class ActiveXLS.Constants.Chart

A constant indicating a filled radar chart.

CHART_TYPE_RADAR_MARKERS - Constant in class ActiveXLS.Constants.Chart

A constant indicating a radar chart with markers at each data point.

CHART_TYPE_SCATTER - Constant in class ActiveXLS.Constants.Chart

A constant indicating a scatter chart.

CHART_TYPE_SCATTER_LINES - Constant in class ActiveXLS.Constants.Chart

A constant indicating a scatter chart with data points connected by lines without markers.

CHART_TYPE_SCATTER_LINES_MARKERS - Constant in class ActiveXLS.Constants.Chart

A constant indicating a scatter chart with data points connected by lines with markers.

CHART_TYPE_SCATTER_SMOOTHED_LINES - Constant in class ActiveXLS.Constants.Chart

A constant indicating a scatter chart with data points connected by smoothed lines without markers.

CHART_TYPE_SCATTER_SMOOTHED_LINES_MARKERS - Constant in class ActiveXLS.Constants.Chart

A constant indicating a scatter chart with data points connected by smoothed lines with markers.

CHART_TYPE_STOCK_HIGH_LOW_CLOSE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stock high-low-close chart.

CHART_TYPE_STOCK_OPEN_HIGH_LOW_CLOSE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stock open-high-low-close chart.

CHART_TYPE_STOCK_VOLUME_HIGH_LOW_CLOSE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stock volume-high-low-close chart.

CHART_TYPE_STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE - Constant in class ActiveXLS.Constants.Chart

A constant indicating a stock volume-open-high-low-close chart.

CHART_TYPE_SURFACE_3D - Constant in class ActiveXLS.Constants.Chart

A constant indicating a 3D surface chart.

CHART_TYPE_SURFACE_3D_WIREFRAME - Constant in class ActiveXLS.Constants.Chart

A constant indicating a wireframe 3D surface chart.

CHART_TYPE_SURFACE_CONTOUR - Constant in class ActiveXLS.Constants.Chart

A constant indicating a contour chart.

CHART_TYPE_SURFACE_CONTOUR_WIREFRAME - Constant in class ActiveXLS.Constants.Chart

A constant indicating a wireframe contour chart without color.

COLOR_NONE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the color is none.

COMMENTS_AS_DISPLAYED_ON_SHEET - Constant in class ActiveXLS.Constants.PageSetup

A constant indicating that the comments will be printed as displayed on worksheet.

COMMENTS_AT_END_OF_SHEET - Constant in class ActiveXLS.Constants.PageSetup

A constant indicating that the comments will be printed at the end of worksheet.

COMMENTS_NONE - Constant in class ActiveXLS.Constants.PageSetup

A constant indicating that the comments will not be printed.

CONDITIONAL_FORMATTING_TYPE_COMPARE_CELL_VALUE - Constant in class ActiveXLS.Constants.ConditionalFormatting

A constant indicating that the condition compares the cell value.

CONDITIONAL_FORMATTING_TYPE_EVALUATE_FORMULA - Constant in class ActiveXLS.Constants.ConditionalFormatting

A constant indicating that the condition compares a formula.

CalculateFormulas() - Method in class ActiveXLS.ExcelOptions

Returns the flag that stores if the formulas are calculated when the document is saved.

CenterHorizontally() - Method in class ActiveXLS.ExcelPageSetup

Returns the center horizontally option for the page.

CenterVertically() - Method in class ActiveXLS.ExcelPageSetup

Returns the center vertically option for the page.

Chart - class ActiveXLS.Constants.Chart.

This class contains the constants used for creating charts.

Chart() - Constructor for class ActiveXLS.Constants.Chart

ChartCount() - Method in class ActiveXLS.ExcelWorksheet

Returns the number of charts in the worksheet.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

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

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelArrayFormula

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelAutoFormat

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelCell

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelChartSheet

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelColumn

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelComment

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelCondition

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelConditionalFormatting

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelDataGroup

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelDataValidator

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelDocument

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelFooter

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelHeader

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelHyperlink

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelImage

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelName

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelOptions

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelRow

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelSheet

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelStyle

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelTable

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.ExcelWorksheet

Creates and returns a copy of this object.

Clone() - Method in class ActiveXLS.UnknownSheet

Clone() - Method in class ActiveXLS.Util.List

Creates a clone of this list

ColumnCount() - Method in class ActiveXLS.ExcelTable

Returns the number of columns from the table.

ConditionCount() - Method in class ActiveXLS.ExcelConditionalFormatting

Returns the number of conditions.

ConditionalFormatting - class ActiveXLS.Constants.ConditionalFormatting.

This class contains the constants used for creating a conditional formatting cell range.

ConditionalFormatting() - Constructor for class ActiveXLS.Constants.ConditionalFormatting

ConditionalFormattingCount() - Method in class ActiveXLS.ExcelWorksheet

Returns the number of conditional formatting ranges in the worksheet.

ContainsBorderFormatting() - Method in class ActiveXLS.ExcelCondition

Internal use only

ContainsFontFormatting() - Method in class ActiveXLS.ExcelCondition

Internal use only

ContainsPatternFormatting() - Method in class ActiveXLS.ExcelCondition

Internal use only

Count() - Method in class ActiveXLS.ExcelColumn

Returns the number of cells contained by the column.

Count() - Method in class ActiveXLS.ExcelRow

Returns the number of cells on a row.

Count() - Method in class ActiveXLS.ExternalLinks

Returns the number of links in the document.

calculateFormula(ExcelDocument, ExcelWorksheet, ExcelWorksheet, int, int, int, int, bool) - Method in class ActiveXLS.ExcelCell

Calculates the cell formula if the cell value is a formula

clear() - Method in class ActiveXLS.Util.List

Removes all the elements from this list

clearBackgroundSettings() - Method in class ActiveXLS.ExcelCondition

Removes all the background settings.

clearBorderSettings() - Method in class ActiveXLS.ExcelCondition

Removes all the border settings.

clearFontSettings() - Method in class ActiveXLS.ExcelCondition

Removes all the font settings.

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

Returns the result of an Excel formula; the formula should not start with the = (equal) sign like in Excel.

containsFormula() - Method in class ActiveXLS.ExcelCell

Returns whether or not the cell contains a formula as value (its value starts with "=" (equal sign))