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

C

calculateFormula(ExcelDocument, ExcelWorksheet, ExcelWorksheet, int, int, int, int, bool) - Method in class EasyXLS.ExcelCell
Calculates the cell formula if the cell value is a formula
CalculateFormulas() - Method in class EasyXLS.ExcelOptions
Returns the flag that stores if the formulas are calculated when the document is saved.
CAP_TYPE_FLAT - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the flat cap type.
CAP_TYPE_ROUND - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the round cap type.
CAP_TYPE_SQUARE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the square cap type.
Cell - Class in EasyXLS.Util
This class stores the cell location.
Cell() - Constructor for class EasyXLS.Util.Cell
 
CELL - Constant in class EasyXLS.Constants.HyperlinkType
A constant indicating an internal hyperlink.
CenterHorizontally() - Method in class EasyXLS.ExcelPageSetup
Returns the center horizontally option for the page.
CenterVertically() - Method in class EasyXLS.ExcelPageSetup
Returns the center vertically option for the page.
Chart - Class in EasyXLS.Constants
This class contains the constants used for creating charts.
Chart() - Constructor for class EasyXLS.Constants.Chart
 
CHART_TYPE_AREA - Constant in class EasyXLS.Constants.Chart
A constant indicating an Area chart.
CHART_TYPE_AREA_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% Stacked Area chart.
CHART_TYPE_AREA_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating an Area with a 3D visual effect chart.
CHART_TYPE_AREA_3D_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% Stacked Area chart with a 3D visual effect.
CHART_TYPE_AREA_3D_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a Stacked Area with a 3D visual effect chart.
CHART_TYPE_AREA_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a Stacked Area chart.
CHART_TYPE_BAR_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked bar chart.
CHART_TYPE_BAR_3D_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked bar chart with a 3D visual effect.
CHART_TYPE_BAR_3D_CLUSTERED - Constant in class EasyXLS.Constants.Chart
A constant indicating a clustered bar chart with a 3D visual effect.
CHART_TYPE_BAR_3D_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked bar chart with a 3D visual effect.
CHART_TYPE_BAR_CLUSTERED - Constant in class EasyXLS.Constants.Chart
A constant indicating a clustered bar chart.
CHART_TYPE_BAR_OF_PIE - Constant in class EasyXLS.Constants.Chart
A constant indicating a bar of pie chart.
CHART_TYPE_BAR_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked bar chart.
CHART_TYPE_BUBBLE - Constant in class EasyXLS.Constants.Chart
A constant indicating a bubble chart.
CHART_TYPE_BUBBLE_3D_EFFECT - Constant in class EasyXLS.Constants.Chart
A constant indicating a bubble chart with a 3D visual effect.
CHART_TYPE_COLUMN_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked column chart.
CHART_TYPE_COLUMN_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a 3D column chart.
CHART_TYPE_COLUMN_3D_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked column chart with a 3D visual effect.
CHART_TYPE_COLUMN_3D_CLUSTERED - Constant in class EasyXLS.Constants.Chart
A constant indicating a clustered column chart with a 3D visual effect.
CHART_TYPE_COLUMN_3D_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked column chart with a 3D visual effect.
CHART_TYPE_COLUMN_CLUSTERED - Constant in class EasyXLS.Constants.Chart
A constant indicating a clustered column chart.
CHART_TYPE_COLUMN_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked column chart.
CHART_TYPE_CONE_BAR - Constant in class EasyXLS.Constants.Chart
A constant indicating a bar chart with a conical shape.
CHART_TYPE_CONE_BAR_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked bar chart with a conical shape.
CHART_TYPE_CONE_BAR_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked bar chart with a conical shape.
CHART_TYPE_CONE_COLUMN - Constant in class EasyXLS.Constants.Chart
A constant indicating a column chart with a conical shape.
CHART_TYPE_CONE_COLUMN_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked column chart with a conical shape.
CHART_TYPE_CONE_COLUMN_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a 3D column chart with a conical shape.
CHART_TYPE_CONE_COLUMN_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked column chart with a conical shape.
CHART_TYPE_CYLINDER_BAR - Constant in class EasyXLS.Constants.Chart
A constant indicating a bar chart with a cylindrical shape.
CHART_TYPE_CYLINDER_BAR_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked bar chart with a cylindrical shape.
CHART_TYPE_CYLINDER_BAR_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked bar chart with a cylindrical shape.
CHART_TYPE_CYLINDER_COLUMN - Constant in class EasyXLS.Constants.Chart
A constant indicating a column chart with a cylindrical shape.
CHART_TYPE_CYLINDER_COLUMN_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked column chart with a cylindrical shape.
CHART_TYPE_CYLINDER_COLUMN_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a 3D column chart with a cylindrical shape.
CHART_TYPE_CYLINDER_COLUMN_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked column chart with a cylindrical shape.
CHART_TYPE_DOUGHNUT - Constant in class EasyXLS.Constants.Chart
A constant indicating a doughnut chart.
CHART_TYPE_DOUGHNUT_EXPLODED - Constant in class EasyXLS.Constants.Chart
A constant indicating an exploded doughnut chart.
CHART_TYPE_LINE - Constant in class EasyXLS.Constants.Chart
A constant indicating a line chart.
CHART_TYPE_LINE_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked line chart.
CHART_TYPE_LINE_100_PERCENT_STACKED_MARKERS - Constant in class EasyXLS.Constants.Chart
A constant indicating an 100% stacked line chart with markers displayed at each data value.
CHART_TYPE_LINE_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a 3D line chart.
CHART_TYPE_LINE_MARKERS - Constant in class EasyXLS.Constants.Chart
A constant indicating a line chart with markers displayed at each data value.
CHART_TYPE_LINE_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked line chart.
CHART_TYPE_LINE_STACKED_MARKERS - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked line chart with markers displayed at each data value.
CHART_TYPE_PIE - Constant in class EasyXLS.Constants.Chart
A constant indicating a pie chart.
CHART_TYPE_PIE_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a pie chart with a 3D visual effect.
CHART_TYPE_PIE_3D_EXPLODED - Constant in class EasyXLS.Constants.Chart
A constant indicating an exploded pie chart with a 3D visual effect.
CHART_TYPE_PIE_EXPLODED - Constant in class EasyXLS.Constants.Chart
A constant indicating an exploded pie chart.
CHART_TYPE_PIE_OF_PIE - Constant in class EasyXLS.Constants.Chart
A constant indicating a pie of pie chart.
CHART_TYPE_PYRAMID_BAR - Constant in class EasyXLS.Constants.Chart
A constant indicating a bar chart with a pyramid shape.
CHART_TYPE_PYRAMID_BAR_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked bar chart with a pyramid shape.
CHART_TYPE_PYRAMID_BAR_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked bar chart with a pyramid shape.
CHART_TYPE_PYRAMID_COLUMN - Constant in class EasyXLS.Constants.Chart
A constant indicating a column chart with a pyramid shape.
CHART_TYPE_PYRAMID_COLUMN_100_PERCENT_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a 100% stacked column chart with a pyramid shape.
CHART_TYPE_PYRAMID_COLUMN_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a 3D column chart with a pyramid shape.
CHART_TYPE_PYRAMID_COLUMN_STACKED - Constant in class EasyXLS.Constants.Chart
A constant indicating a stacked column chart with a pyramid shape.
CHART_TYPE_RADAR - Constant in class EasyXLS.Constants.Chart
A constant indicating a radar chart.
CHART_TYPE_RADAR_FILLED - Constant in class EasyXLS.Constants.Chart
A constant indicating a filled radar chart.
CHART_TYPE_RADAR_MARKERS - Constant in class EasyXLS.Constants.Chart
A constant indicating a radar chart with markers at each data point.
CHART_TYPE_SCATTER - Constant in class EasyXLS.Constants.Chart
A constant indicating a scatter chart.
CHART_TYPE_SCATTER_LINES - Constant in class EasyXLS.Constants.Chart
A constant indicating a scatter chart with data points connected by lines without markers.
CHART_TYPE_SCATTER_LINES_MARKERS - Constant in class EasyXLS.Constants.Chart
A constant indicating a scatter chart with data points connected by lines with markers.
CHART_TYPE_SCATTER_SMOOTHED_LINES - Constant in class EasyXLS.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 EasyXLS.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 EasyXLS.Constants.Chart
A constant indicating a stock high-low-close chart.
CHART_TYPE_STOCK_OPEN_HIGH_LOW_CLOSE - Constant in class EasyXLS.Constants.Chart
A constant indicating a stock open-high-low-close chart.
CHART_TYPE_STOCK_VOLUME_HIGH_LOW_CLOSE - Constant in class EasyXLS.Constants.Chart
A constant indicating a stock volume-high-low-close chart.
CHART_TYPE_STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE - Constant in class EasyXLS.Constants.Chart
A constant indicating a stock volume-open-high-low-close chart.
CHART_TYPE_SURFACE_3D - Constant in class EasyXLS.Constants.Chart
A constant indicating a 3D surface chart.
CHART_TYPE_SURFACE_3D_WIREFRAME - Constant in class EasyXLS.Constants.Chart
A constant indicating a wireframe 3D surface chart.
CHART_TYPE_SURFACE_CONTOUR - Constant in class EasyXLS.Constants.Chart
A constant indicating a contour chart.
CHART_TYPE_SURFACE_CONTOUR_WIREFRAME - Constant in class EasyXLS.Constants.Chart
A constant indicating a wireframe contour chart without color.
ChartCount() - Method in class EasyXLS.ExcelWorksheet
Returns the number of charts in the worksheet.
clear() - Method in class EasyXLS.Util.List
Removes all the elements from this list
clearBackgroundSettings() - Method in class EasyXLS.ExcelCondition
Removes all the background settings.
clearBorderSettings() - Method in class EasyXLS.ExcelCondition
Removes all the border settings.
clearFontSettings() - Method in class EasyXLS.ExcelCondition
Removes all the font settings.
Clone() - Method in class EasyXLS.Charts.ExcelAxis
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelChart
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelChartArea
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelChartGridlines
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelChartLegend
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelDataTable
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelPlotArea
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelSeries
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Charts.ExcelTitle
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.ExcelComment
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.ExcelImage
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.AlignmentFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.FillFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.FontFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.Format3D
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.LineColorFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.Rotation3D
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.Drawings.Formatting.ShadowFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelArrayFormula
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelAutoFormat
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelCell
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelChartSheet
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelColumn
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelCondition
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelConditionalFormatting
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelDataGroup
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelDataValidator
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelDocument
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelFooter
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelHeader
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelHyperlink
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelName
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelOptions
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelRow
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelSheet
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelStyle
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelTable
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.ExcelWorksheet
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.PivotTables.ExcelCalculatedField
 
Clone() - Method in class EasyXLS.PivotTables.ExcelField
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.PivotTables.ExcelPivotChart
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.PivotTables.ExcelPivotTable
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.PivotTables.ExcelValueField
Creates and returns a copy of this object.
Clone() - Method in class EasyXLS.UnknownSheet
 
Clone() - Method in class EasyXLS.Util.List
Creates a clone of this list
Color - Variable in class EasyXLS.Drawings.Formatting.GradientStop
The gradient color.
COLOR_NONE - Constant in class EasyXLS.Constants.Chart
A constant indicating that the color is none.
Column - Variable in class EasyXLS.Util.Cell
The column index of the cell
ColumnCount() - Method in class EasyXLS.ExcelTable
Returns the number of columns from the table.
ColumnLabelsCount() - Method in class EasyXLS.PivotTables.ExcelPivotTable
Returns the number of fields in the column labels area.
COMMENTS_AS_DISPLAYED_ON_SHEET - Constant in class EasyXLS.Constants.PageSetup
A constant indicating that the comments will be printed as displayed on worksheet.
COMMENTS_AT_END_OF_SHEET - Constant in class EasyXLS.Constants.PageSetup
A constant indicating that the comments will be printed at the end of worksheet.
COMMENTS_NONE - Constant in class EasyXLS.Constants.PageSetup
A constant indicating that the comments will not be printed.
COMPOUND_TYPE_DOUBLE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the double compound type.
COMPOUND_TYPE_NONE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating that no compound type is set.
COMPOUND_TYPE_SIMPLE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the simple compound type.
COMPOUND_TYPE_THICK_THIN - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the thick thin compound type.
COMPOUND_TYPE_THIN_THICK - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the thin thick compound type.
COMPOUND_TYPE_TRIPLE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the triple compound type.
computeFormula(String, ExcelWorksheet, ExcelWorksheet, int, int) - Method in class EasyXLS.Formula
Returns the result of an Excel formula; the formula should not start with the = (equal) sign like in Excel.
CONDITIONAL_FORMATTING_TYPE_COMPARE_CELL_VALUE - Constant in class EasyXLS.Constants.ConditionalFormatting
A constant indicating that the condition compares the cell value.
CONDITIONAL_FORMATTING_TYPE_EVALUATE_FORMULA - Constant in class EasyXLS.Constants.ConditionalFormatting
A constant indicating that the condition compares a formula.
ConditionalFormatting - Class in EasyXLS.Constants
This class contains the constants used for creating a conditional formatting cell range.
ConditionalFormatting() - Constructor for class EasyXLS.Constants.ConditionalFormatting
 
ConditionalFormattingCount() - Method in class EasyXLS.ExcelWorksheet
Returns the number of conditional formatting ranges in the worksheet.
ConditionCount() - Method in class EasyXLS.ExcelConditionalFormatting
Returns the number of conditions.
ContainsBorderFormatting() - Method in class EasyXLS.ExcelCondition
Internal use only
ContainsFontFormatting() - Method in class EasyXLS.ExcelCondition
Internal use only
containsFormula() - Method in class EasyXLS.ExcelCell
Returns whether or not the cell contains a formula as value (its value starts with "=" (equal sign))
ContainsPatternFormatting() - Method in class EasyXLS.ExcelCondition
Internal use only
Count() - Method in class EasyXLS.ExcelColumn
Returns the number of cells contained by the column.
Count() - Method in class EasyXLS.ExcelRow
Returns the number of cells on a row.
Count() - Method in class EasyXLS.ExternalLinks
Returns the number of links in the document.
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