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

A

addCalculatedField(String, String) - Method in class EasyXLS.PivotTables.ExcelPivotTable
Add a calculated field to pivot table.
addCondition(int, String, String) - Method in class EasyXLS.ExcelConditionalFormatting
Adds a new condition with the specified operation and formula restrictions.
This method is overridden as addCondition_2 in COM+ version of EasyXLS.
addCondition(int, String, String, bool, bool, Color) - Method in class EasyXLS.ExcelConditionalFormatting
Adds a new condition with the specified operation, formula restrictions and font settings.
This method is overridden as addCondition_3 in COM+ version of EasyXLS.
addCondition(int, String, String, bool, bool, Color, Color) - Method in class EasyXLS.ExcelConditionalFormatting
Adds a new condition with the specified operation, formula restrictions, font settings and background.
This method is overridden as addCondition_4 in COM+ version of EasyXLS.
addCondition(int, String, String, Color) - Method in class EasyXLS.ExcelConditionalFormatting
Adds a new condition with the specified operation, formula restrictions, background.
This method is overridden as addCondition_5 in COM+ version of EasyXLS.
addCondition(ExcelCondition) - Method in class EasyXLS.ExcelConditionalFormatting
Adds a new condition.
addElement(Object) - Method in class EasyXLS.Util.List
Adds a new element to the list.
addField(ExcelField) - Method in class EasyXLS.PivotTables.ExcelPivotTable
Internal use only
addFieldToColumnLabels(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable
Adds the field to column labels area.
addFieldToReportFilter(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable
Adds the field to report filter area.
addFieldToRowLabels(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable
Adds the field to row labels area.
addFieldToValues(String, String, int) - Method in class EasyXLS.PivotTables.ExcelPivotTable
Adds the field to values area.
addGradientStop(int, ThemeColor, int) - Method in class EasyXLS.Drawings.Formatting.FillFormat
Adds a gradient stop to the shape fill that is set as gradient fill, having a specified position, color and transparency.
This method is overridden as addGradientStop_2 in COM+ version of EasyXLS.
addGradientStop(int, ThemeColor, int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat
Adds a gradient stop to the line color that is set as gradient line, having a specified position, color and transparency.
This method is overridden as addGradientStop_2 in COM+ version of EasyXLS.
addGradientStop(int, Color, int) - Method in class EasyXLS.Drawings.Formatting.FillFormat
Adds a gradient stop to the shape fill that is set as gradient fill, having a specified position, color and transparency.
addGradientStop(int, Color, int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat
Adds a gradient stop to the line color that is set as gradient line, having a specified position, color and transparency.
addGradientStop(GradientStop) - Method in class EasyXLS.Drawings.Formatting.FillFormat
Adds a gradient stop to the shape fill that is set as gradient fill.
This method is overridden as addGradientStop_3 in COM+ version of EasyXLS.
addGradientStop(GradientStop) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat
Adds a gradient stop to the line color that is set as gradient line.
This method is overridden as addGradientStop_3 in COM+ version of EasyXLS.
addLink(String) - Method in class EasyXLS.ExternalLinks
Adds an external link to the document.
addSubtotal(int) - Method in class EasyXLS.PivotTables.ExcelField
Adds a subtotal for the pivot table field.
AlignDrawingObject - Class in EasyXLS.Drawings
This class stores a drawing shape having an alignment formatting.
AlignDrawingObject() - Constructor for class EasyXLS.Drawings.AlignDrawingObject
Defines an instance of a drawing shape having an alignment formatting.
Alignment - Class in EasyXLS.Constants
This class contains the constants for vertical and horizontal text alignment when formatting cells.
Alignment() - Constructor for class EasyXLS.Constants.Alignment
 
ALIGNMENT_BOTTOM - Constant in class EasyXLS.Constants.Alignment
A constant indicating bottom vertical text alignment.
ALIGNMENT_BOTTOM - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the bottom alignment.
ALIGNMENT_BOTTOM_LEFT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the bottom left alignment.
ALIGNMENT_BOTTOM_RIGHT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the bottom right alignment.
ALIGNMENT_CENTER - Constant in class EasyXLS.Constants.Alignment
A constant indicating center horizontal text alignment.
ALIGNMENT_CENTER - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the center alignment.
ALIGNMENT_CENTER_ACROSS_SELECTION - Constant in class EasyXLS.Constants.Alignment
A constant indicating center across selection horizontal text alignment.
ALIGNMENT_DISTRIBUTED - Constant in class EasyXLS.Constants.Alignment
A constant indicating distributed horizontal or vertical text alignment.
ALIGNMENT_FILL - Constant in class EasyXLS.Constants.Alignment
A constant indicating fill horizontal text alignment.
ALIGNMENT_GENERAL - Constant in class EasyXLS.Constants.Alignment
A constant indicating general horizontal text alignment.
ALIGNMENT_JUSTIFY - Constant in class EasyXLS.Constants.Alignment
A constant indicating justify horizontal or vertical text alignment.
ALIGNMENT_LEFT - Constant in class EasyXLS.Constants.Alignment
A constant indicating left horizontal text alignment.
ALIGNMENT_LEFT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the left alignment.
ALIGNMENT_MIDDLE - Constant in class EasyXLS.Constants.Alignment
A constant indicating middle vertical text alignment.
ALIGNMENT_RIGHT - Constant in class EasyXLS.Constants.Alignment
A constant indicating right horizontal text alignment.
ALIGNMENT_RIGHT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the right alignment.
ALIGNMENT_TOP - Constant in class EasyXLS.Constants.Alignment
A constant indicating top vertical text alignment.
ALIGNMENT_TOP - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the top alignment.
ALIGNMENT_TOP_LEFT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the top left alignment.
ALIGNMENT_TOP_RIGHT - Constant in class EasyXLS.Drawings.Formatting.ShadowFormat
A constant indicating the top right alignment.
AlignmentFormat - Class in EasyXLS.Drawings.Formatting
This class stores the text alignment for drawing objects.
AlignmentFormat() - Constructor for class EasyXLS.Drawings.Formatting.AlignmentFormat
Defines an instance of the alignment format.
AllowDeleteColumns() - Method in class EasyXLS.ExcelWorksheet
Returns true if deleting columns is allowed when the sheet is protected, false otherwise.
AllowDeleteRows() - Method in class EasyXLS.ExcelWorksheet
Returns true if deleting rows is allowed when the sheet is protected, false otherwise.
AllowEditObjects() - Method in class EasyXLS.ExcelWorksheet
Returns true if editing objects is allowed when the sheet is protected, false otherwise.
AllowEditScenarios() - Method in class EasyXLS.ExcelWorksheet
Returns true if editing scenarios is allowed when the sheet is protected, false otherwise.
AllowFormatCells() - Method in class EasyXLS.ExcelWorksheet
Returns true if formatting cells is allowed when the sheet is protected, false otherwise.
AllowFormatColumns() - Method in class EasyXLS.ExcelWorksheet
Returns true if formatting columns is allowed when the sheet is protected, false otherwise.
AllowFormatRows() - Method in class EasyXLS.ExcelWorksheet
Returns true if formatting rows is allowed when the sheet is protected, false otherwise.
AllowInsertColumns() - Method in class EasyXLS.ExcelWorksheet
Returns true if inserting columns is allowed when the sheet is protected, false otherwise.
AllowInsertHyperlinks() - Method in class EasyXLS.ExcelWorksheet
Returns true if inserting hyperlinks is allowed when the sheet is protected, false otherwise.
AllowInsertRows() - Method in class EasyXLS.ExcelWorksheet
Returns true if inserting rows is allowed when the sheet is protected, false otherwise.
AllowMultipleFiltersPerField() - Method in class EasyXLS.PivotTables.ExcelPivotTable
Returns true if all values, including those hidden by filtering, are included when the subtotals and the grand total are calculated, false otherwise.
AllowSelectLockedCells() - Method in class EasyXLS.ExcelWorksheet
Returns true if the selection of locked cells is allowed when the sheet is protected, false otherwise.
AllowSelectUnlockedCells() - Method in class EasyXLS.ExcelWorksheet
Returns true if the selection of unlocked cells is allowed when the sheet is protected, false otherwise.
AllowSort() - Method in class EasyXLS.ExcelWorksheet
Returns true if sorting is allowed when the sheet is protected, false otherwise.
AllowUseAutofilter() - Method in class EasyXLS.ExcelWorksheet
Returns true if autofilter is allowed when the sheet is protected, false otherwise.
AllowUsePivots() - Method in class EasyXLS.ExcelWorksheet
Returns true if using pivot tables and pivot charts is allowed when the sheet is protected, false otherwise.
ApplyToRange(int, int, int, int) - Method in class EasyXLS.ExcelDataValidator
Sets the cell range where the validation will be applied.
ApplyToRange(String) - Method in class EasyXLS.ExcelDataValidator
Sets the cell range where the validation will be applied.
This method is overridden as ApplyToRange_2 in COM+ version of EasyXLS.
AREA_COLUMN_LABELS - Constant in class EasyXLS.Constants.PivotTable
A constant indicating that the pivot table field is added to column labels area.
AREA_NONE - Constant in class EasyXLS.Constants.PivotTable
A constant indicating that the pivot table field is not added to any area.
AREA_REPORT_FILTER - Constant in class EasyXLS.Constants.PivotTable
A constant indicating that the pivot table field is added to report filter area.
AREA_ROW_LABELS - Constant in class EasyXLS.Constants.PivotTable
A constant indicating that the pivot table field is added to row labels area.
ArrayFormulasCount() - Method in class EasyXLS.ExcelWorksheet
Returns the number of array formulas in the worksheet.
ARROW_TYPE_DIAMOND - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the diamond arrow type.
ARROW_TYPE_NONE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating that no arrow is set.
ARROW_TYPE_OPEN - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the open arrow type.
ARROW_TYPE_OVAL - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the oval arrow type.
ARROW_TYPE_STEALTH - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the stealth arrow type.
ARROW_TYPE_TRIANGLE - Constant in class EasyXLS.Drawings.Formatting.LineStyleFormat
A constant indicating the triangle arrow type.
ASCII - Constant in class EasyXLS.Constants.Encoding
A constant indicating the ASCII encoding.
AUTOFORMAT_3D_EFFECTS1 - Constant in class EasyXLS.Constants.Styles
The 3D Effects 1 autoformat.
AUTOFORMAT_3D_EFFECTS1_RIGHT_TOTAL - Constant in class EasyXLS.Constants.Styles
The 3D Effects 1 autoformat with special formatting for right total.
AUTOFORMAT_3D_EFFECTS1_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The 3D Effects 1 autoformat with special formatting for subtotal.
AUTOFORMAT_3D_EFFECTS1_TOTALS - Constant in class EasyXLS.Constants.Styles
The 3D Effects 1 autoformat with special formatting for subtotal and right total.
AUTOFORMAT_3D_EFFECTS2 - Constant in class EasyXLS.Constants.Styles
The 3D Effects 2 autoformat.
AUTOFORMAT_3D_EFFECTS2_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The 3D Effects 2 autoformat with special formatting for subtotal.
AUTOFORMAT_ACCOUNTING1 - Constant in class EasyXLS.Constants.Styles
The Accounting 1 autoformat.
AUTOFORMAT_ACCOUNTING1_RIGHT_TOTAL - Constant in class EasyXLS.Constants.Styles
The Accounting 1 autoformat with special formatting for right total.
AUTOFORMAT_ACCOUNTING1_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Accounting 1 autoformat with special formatting for subtotal.
AUTOFORMAT_ACCOUNTING1_TOTALS - Constant in class EasyXLS.Constants.Styles
The Accounting 1 autoformat with special formatting for subtotal and right total.
AUTOFORMAT_ACCOUNTING2 - Constant in class EasyXLS.Constants.Styles
The Accounting 2 autoformat.
AUTOFORMAT_ACCOUNTING2_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Accounting 2 autoformat with special formatting for subtotal.
AUTOFORMAT_ACCOUNTING3 - Constant in class EasyXLS.Constants.Styles
The Accounting 3 autoformat.
AUTOFORMAT_ACCOUNTING3_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Accounting 3 autoformat with special formatting for subtotal.
AUTOFORMAT_ACCOUNTING4 - Constant in class EasyXLS.Constants.Styles
The Accounting 4 autoformat.
AUTOFORMAT_ACCOUNTING4_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Accounting 4 autoformat with special formatting for subtotal.
AUTOFORMAT_CLASSIC1 - Constant in class EasyXLS.Constants.Styles
The Classic 1 autoformat.
AUTOFORMAT_CLASSIC1_RIGHT_TOTAL - Constant in class EasyXLS.Constants.Styles
The Classic 1 autoformat with special formatting for right total.
AUTOFORMAT_CLASSIC1_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Classic 1 autoformat with special formatting for subtotal.
AUTOFORMAT_CLASSIC1_TOTALS - Constant in class EasyXLS.Constants.Styles
The Classic 1 autoformat with special formatting for subtotal and right total.
AUTOFORMAT_CLASSIC2 - Constant in class EasyXLS.Constants.Styles
The Classic 2 autoformat.
AUTOFORMAT_CLASSIC2_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Classic 2 autoformat with special formatting for subtotal.
AUTOFORMAT_CLASSIC3 - Constant in class EasyXLS.Constants.Styles
The Classic 3 autoformat.
AUTOFORMAT_CLASSIC3_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Classic 3 autoformat with special formatting for subtotal.
AUTOFORMAT_COLORFUL1 - Constant in class EasyXLS.Constants.Styles
The Colorful 1 autoformat.
AUTOFORMAT_COLORFUL1_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Colorful 1 autoformat with special formatting for subtotal.
AUTOFORMAT_COLORFUL2 - Constant in class EasyXLS.Constants.Styles
The Colorful 2 autoformat.
AUTOFORMAT_COLORFUL2_RIGHT_TOTAL - Constant in class EasyXLS.Constants.Styles
The Colorful 2 autoformat with special formatting for right total.
AUTOFORMAT_COLORFUL2_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Colorful 2 autoformat with special formatting for subtotal.
AUTOFORMAT_COLORFUL2_TOTALS - Constant in class EasyXLS.Constants.Styles
The Colorful 2 autoformat with special formatting for subtotal and right total.
AUTOFORMAT_COLORFUL3 - Constant in class EasyXLS.Constants.Styles
The Colorful 3 autoformat.
AUTOFORMAT_COLORFUL3_RIGHT_TOTAL - Constant in class EasyXLS.Constants.Styles
The Colorful 3 autoformat with special formatting for right total.
AUTOFORMAT_COLORFUL3_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Colorful 3 autoformat with special formatting for subtotal.
AUTOFORMAT_COLORFUL3_TOTALS - Constant in class EasyXLS.Constants.Styles
The Colorful 3 autoformat with special formatting for subtotal and right total.
AUTOFORMAT_EASYXLS1 - Constant in class EasyXLS.Constants.Styles
The EasyXLS 1 autoformat.
AUTOFORMAT_EASYXLS1_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The EasyXLS 1 autoformat with special formatting for subtotal.
AUTOFORMAT_EASYXLS2 - Constant in class EasyXLS.Constants.Styles
The EasyXLS 2 autoformat.
AUTOFORMAT_EASYXLS2_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The EasyXLS 2 autoformat with special formatting for subtotal.
AUTOFORMAT_EASYXLS3 - Constant in class EasyXLS.Constants.Styles
The EasyXLS 3 autoformat.
AUTOFORMAT_EASYXLS3_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The EasyXLS 3 autoformat with special formatting for subtotal.
AUTOFORMAT_LIST1 - Constant in class EasyXLS.Constants.Styles
The List 1 autoformat.
AUTOFORMAT_LIST1_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The List 1 autoformat with special formatting for subtotal.
AUTOFORMAT_LIST2 - Constant in class EasyXLS.Constants.Styles
The List 2 autoformat.
AUTOFORMAT_LIST2_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The List 2 autoformat with special formatting for subtotal.
AUTOFORMAT_LIST3 - Constant in class EasyXLS.Constants.Styles
The List 3 autoformat.
AUTOFORMAT_LIST3_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The List 3 autoformat with special formatting for subtotal.
AUTOFORMAT_NONE - Constant in class EasyXLS.Constants.PivotTable
A constant indicating that no autoformat is applied for the pivot table.
AUTOFORMAT_NONE - Constant in class EasyXLS.Constants.Styles
The None autoformat.
AUTOFORMAT_PIVOTTABLE_CLASIC - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Pivot Table Clasic for a pivot table.
AUTOFORMAT_REPORT_1 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 1 for a pivot table.
AUTOFORMAT_REPORT_10 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 10 for a pivot table.
AUTOFORMAT_REPORT_2 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 2 for a pivot table.
AUTOFORMAT_REPORT_3 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 3 for a pivot table.
AUTOFORMAT_REPORT_4 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 4 for a pivot table.
AUTOFORMAT_REPORT_5 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 5 for a pivot table.
AUTOFORMAT_REPORT_6 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 6 for a pivot table.
AUTOFORMAT_REPORT_7 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 7 for a pivot table.
AUTOFORMAT_REPORT_8 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 8 for a pivot table.
AUTOFORMAT_REPORT_9 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Report 9 for a pivot table.
AUTOFORMAT_SIMPLE - Constant in class EasyXLS.Constants.Styles
The Simple autoformat.
AUTOFORMAT_SIMPLE_SUBTOTAL - Constant in class EasyXLS.Constants.Styles
The Simple autoformat with special formatting for subtotal.
AUTOFORMAT_TABLE_1 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 1 for a pivot table.
AUTOFORMAT_TABLE_10 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 10 for a pivot table.
AUTOFORMAT_TABLE_2 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 2 for a pivot table.
AUTOFORMAT_TABLE_3 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 3 for a pivot table.
AUTOFORMAT_TABLE_4 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 4 for a pivot table.
AUTOFORMAT_TABLE_5 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 5 for a pivot table.
AUTOFORMAT_TABLE_6 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 6 for a pivot table.
AUTOFORMAT_TABLE_7 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 7 for a pivot table.
AUTOFORMAT_TABLE_8 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 8 for a pivot table.
AUTOFORMAT_TABLE_9 - Constant in class EasyXLS.Constants.PivotTable
Pivot style (Autoformat) Table 9 for a pivot table.
AUTOMATIC - Constant in class EasyXLS.Constants.DataType
A constant indicating that the data type is determined automatically.
AutoResize() - Method in class EasyXLS.ExcelRow
Returns true if the row height will be automatically computed.
AXIS_TICK_MARK_LABEL_HIGH - Constant in class EasyXLS.Constants.Chart
A constant indicating that the tick mark labels are situated above of the chart for X axis or on the right side of the chart for Y axis.
AXIS_TICK_MARK_LABEL_LOW - Constant in class EasyXLS.Constants.Chart
A constant indicating that the tick mark labels are situated on bottom of the chart for X axis or on the left side of the chart for Y axis.
AXIS_TICK_MARK_LABEL_NEXT_TO_AXIS - Constant in class EasyXLS.Constants.Chart
A constant indicating that the tick mark labels are situated next to the axis.
AXIS_TICK_MARK_LABEL_NONE - Constant in class EasyXLS.Constants.Chart
A constant indicating that there are no tick mark labels for axis.
AXIS_TICK_MARK_TYPE_CROSS - Constant in class EasyXLS.Constants.Chart
A constant indicating that the tick mark is present both inside and outside.
AXIS_TICK_MARK_TYPE_INSIDE - Constant in class EasyXLS.Constants.Chart
A constant indicating that the tick mark is present only inside.
AXIS_TICK_MARK_TYPE_NONE - Constant in class EasyXLS.Constants.Chart
A constant indicating that there are no tick marks for axis.
AXIS_TICK_MARK_TYPE_OUTSIDE - Constant in class EasyXLS.Constants.Chart
A constant indicating that the tick mark is present only outside.
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