S-Index (EasyXLS API Documentation)

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

S

SERIES_DATA_LABELS_NONE - Constant in class EasyXLS.Constants.Chart: Deprecated.
As of version 8.5
SERIES_DATA_LABELS_SHOW_BUBBLE_SIZE - Constant in class EasyXLS.Constants.Chart: Deprecated.
As of version 8.5
SERIES_DATA_LABELS_SHOW_LABEL - Constant in class EasyXLS.Constants.Chart: Deprecated.
As of version 8.5
SERIES_DATA_LABELS_SHOW_LABEL_AND_PERCENT - Constant in class EasyXLS.Constants.Chart: Deprecated.
As of version 8.5
SERIES_DATA_LABELS_SHOW_PERCENT - Constant in class EasyXLS.Constants.Chart: Deprecated.
As of version 8.5
SERIES_DATA_LABELS_SHOW_VALUE - Constant in class EasyXLS.Constants.Chart: Deprecated.
As of version 8.5
SERIES_IN_COLUMNS - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series is in columns.
SERIES_IN_ROWS - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series is in rows.
SERIES_MARKER_AUTOMATIC - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is automatic.
SERIES_MARKER_CIRCLE - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is circle.
SERIES_MARKER_DIAMOND - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is diamond.
SERIES_MARKER_DOW_JONES - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is Dow Jones.
SERIES_MARKER_NONE - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is none.
SERIES_MARKER_PLUS_SIGN - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is plus sign.
SERIES_MARKER_SQUARE - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is square.
SERIES_MARKER_STANDARD_DEVIATION - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is standard deviation.
SERIES_MARKER_STAR - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is star.
SERIES_MARKER_TRIANGLE - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is triangle.
SERIES_MARKER_X - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series marker type is X.
SeriesCount() - Method in class EasyXLS.Charts.ExcelChart: Returns the number of series in the chart.
set3DFormat(Format3D) - Method in class EasyXLS.Drawings.EffectDrawingObject: Sets the 3D-format of the drawing shape.
set3DFormat(Format3D) - Method in interface EasyXLS.Drawings.IEffectDrawingObject: Sets the 3D-format of the drawing shape.
setAccent1Color(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Accent 1 color.
setAccent2Color(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Accent 2 color.
setAccent3Color(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Accent 3 color.
setAccent4Color(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Accent 4 color.
setAccent5Color(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Accent 5 color.
setAccent6Color(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Accent 6 color.
setAdvancedFilter(String, String, String) - Method in class EasyXLS.ExcelFilter: Sets the advanced filter.
setAlignmentFormat(AlignmentFormat) - Method in class EasyXLS.Drawings.AlignDrawingObject: Sets the alignment format of the drawing shape.
setAlignmentFormat(AlignmentFormat) - Method in interface EasyXLS.Drawings.IAlignDrawingObject: Sets the alignment format of the drawing shape.
setAllCaps(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the all caps setting of the font.
setAllowDeleteColumns(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if deleting columns is allowed when the sheet is protected.
setAllowDeleteRows(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if deleting rows is allowed when the sheet is protected.
setAllowEditObjects(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if editing objects is allowed when the sheet is protected.
setAllowEditScenarios(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if editing scenarios is allowed when the sheet is protected.
setAllowFormatCells(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if formatting cells is allowed when the sheet is protected.
setAllowFormatColumns(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if formatting columns is allowed when the sheet is protected.
setAllowFormatRows(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if formatting rows is allowed when the sheet is protected.
setAllowInsertColumns(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if inserting columns is allowed when the sheet is protected.
setAllowInsertHyperlinks(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if inserting hyperlinks is allowed when the sheet is protected.
setAllowInsertRows(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if inserting rows is allowed when the sheet is protected.
setAllowMultipleFiltersPerField(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if all values, including those hidden by filtering, are included when the subtotals and the grand total are calculated.
setAllowSelectLockedCells(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if the selection of locked cells is allowed when the sheet is protected.
setAllowSelectUnlockedCells(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if the selection of unlocked cells is allowed when the sheet is protected.
setAllowSort(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if sorting is allowed when the sheet is protected.
setAllowUseAutofilter(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if autofilter is allowed when the sheet is protected.
setAllowUsePivots(bool) - Method in class EasyXLS.ExcelWorksheet: Sets if using pivot tables and pivot charts is allowed when the sheet is protected.
setAngle(float) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the angle of the shadow.
setApplicationName(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the application name property.
setArrowSettings(String, int, String, int) - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat: Sets the arrow options of the line.
setAuthor(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the author property.
setAutoFilter(bool) - Method in class EasyXLS.ExcelFilter: Set if the auto-filter is applied.
setAutoFilter(String) - Method in class EasyXLS.ExcelFilter: Sets the list range where the auto-filter is applied.
This method is overridden as setAutoFilter_2 in COM+ version of EasyXLS.
setAutofitColumnWidthsOnUpdate(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the pivot table columns are adjusted automatically to fit the cell content or the current width is kept.
setAutoFormat(ExcelAutoFormat) - Method in class EasyXLS.ExcelDataGroup: Sets the autoformat to be applied for the data group.
setAutomatic(bool) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the automatic option of the shape.
setAutomatic(bool) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets an automatic line.
setAutomaticCategoryAxisCrossesValue(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the automatic option of the crosses value of the category X axis.
setAutomaticForeground(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the foreground as automatic.
setAutomaticMajorUnit(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the automatic option of the major unit of the value Y axis scale.
setAutomaticMaximumValue(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the automatic option of the maximum value of the value Y axis scale.
setAutomaticMinimumValue(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the automatic option of the minimum value of the value Y axis scale.
setAutomaticMinorUnit(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the automatic option of the minor unit of the value Y axis scale.
setAutomaticTextBackgroundDark1(bool) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the automatic color for the Text/Background-Dark 1 color.
setAutomaticTextBackgroundLight1(bool) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the automatic color for the Text/Background-Light 1 color.
setAutoResize(bool) - Method in class EasyXLS.ExcelRow: Sets the automatic calculation of the row height.
setAxisTitle(ExcelTitle) - Method in class EasyXLS.Charts.ExcelAxis: Sets the chart axis title.
setBackground(ThemeColor) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the background color of the shape.
This method is overridden as setBackground_2 in COM+ version of EasyXLS.
setBackground(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the background color of the cell.
setBackground(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the background color of the column.
This method is overridden as setBackground_2 in COM+ version of EasyXLS.
setBackground(ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting background.
This method is overridden as setBackground_2 in COM+ version of EasyXLS.
setBackground(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the background color of the row.
This method is overridden as setBackground_2 in COM+ version of EasyXLS.
setBackground(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the background color of the style.
This method is overridden as setBackground_2 in COM+ version of EasyXLS.
setBackground(Color) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FillFormat.setBackground(Color)
setBackground(Color) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FillFormat.setBackground(Color)
setBackground(Color) - Method in class EasyXLS.Charts.ExcelPlotArea: Deprecated.
As of version 8.3, replaced by FillFormat.setBackground(Color)
setBackground(Color) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.3, replaced by FillFormat.setBackground(Color)
setBackground(Color) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the background color of the shape.
setBackground(Color) - Method in class EasyXLS.ExcelCell: Sets the background color of the cell.
setBackground(Color) - Method in class EasyXLS.ExcelColumn: Sets the background color of the column.
setBackground(Color) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting background.
setBackground(Color) - Method in class EasyXLS.ExcelRow: Sets the background color of the row.
setBackground(Color) - Method in class EasyXLS.ExcelStyle: Sets the background color of the style.
setBasicColor(int) - Method in class EasyXLS.Themes.ThemeColor: Sets the color of the theme, color that is one of the basic colors.
setBlur(float) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the blur of the shadow.
setBodyFont() - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the body font.
setBodyFont() - Method in class EasyXLS.ExcelCell: Sets the body font.
setBodyFont() - Method in class EasyXLS.ExcelColumn: Sets the body font.
setBodyFont() - Method in class EasyXLS.ExcelRow: Sets the body font.
setBodyFont() - Method in class EasyXLS.ExcelStyle: Sets the body font.
setBodyFont(String) - Method in class EasyXLS.Themes.ExcelFontScheme: Sets the name of the body font.
setBold(bool) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setBold(bool)
setBold(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setBold(bool)
setBold(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setBold(bool)
setBold(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setBold(bool)
setBold(bool) - Method in class EasyXLS.Drawings.ExcelComment: Sets the bold option of the comment text.
setBold(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the bold setting of the font.
setBold(bool) - Method in class EasyXLS.ExcelCell: Sets the bold option of the cell font.
setBold(bool) - Method in class EasyXLS.ExcelColumn: Sets the bold option of the column font.
setBold(bool) - Method in class EasyXLS.ExcelCondition: Sets the bold setting of the conditional formatting font.
setBold(bool) - Method in class EasyXLS.ExcelRow: Sets the bold option of the row font.
setBold(bool) - Method in class EasyXLS.ExcelStyle: Sets the bold option of the style font.
setBorderColor(Color) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setBorderColor(Color) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setBorderColor(Color) - Method in class EasyXLS.Charts.ExcelPlotArea: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setBorderColors(ThemeColor, ThemeColor, ThemeColor, ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the border colors of the style.
setBorderColors(ThemeColor, ThemeColor, ThemeColor, ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the border colors of the style.
This method is overridden as setBorderColors_2 in COM+ version of EasyXLS.
setBorderColors(ThemeColor, ThemeColor, ThemeColor, ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting borders.
This method is overridden as setBorderColors_2 in COM+ version of EasyXLS.
setBorderColors(ThemeColor, ThemeColor, ThemeColor, ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the border colors of the style.
This method is overridden as setBorderColors_2 in COM+ version of EasyXLS.
setBorderColors(ThemeColor, ThemeColor, ThemeColor, ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the border colors of the style.
This method is overridden as setBorderColors_2 in COM+ version of EasyXLS.
setBorderColors(Color, Color, Color, Color) - Method in class EasyXLS.ExcelCell: Sets the border colors of the cell.
setBorderColors(Color, Color, Color, Color) - Method in class EasyXLS.ExcelColumn: Sets the border colors of the column.
setBorderColors(Color, Color, Color, Color) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting borders.
setBorderColors(Color, Color, Color, Color) - Method in class EasyXLS.ExcelRow: Sets the border colors of the row.
setBorderColors(Color, Color, Color, Color) - Method in class EasyXLS.ExcelStyle: Sets the border colors of the style.
setBorderStyle(int) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(System.String)
setBorderStyle(int) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(System.String)
setBorderStyle(int) - Method in class EasyXLS.Charts.ExcelPlotArea: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(System.String)
setBorderStyles(int, int, int, int) - Method in class EasyXLS.ExcelCell: Sets the border styles of the cell.
setBorderStyles(int, int, int, int) - Method in class EasyXLS.ExcelColumn: Sets the border styles of the column.
setBorderStyles(int, int, int, int) - Method in class EasyXLS.ExcelCondition: Sets the style of the conditional formatting borders.
setBorderStyles(int, int, int, int) - Method in class EasyXLS.ExcelRow: Sets the border styles of the row.
setBorderStyles(int, int, int, int) - Method in class EasyXLS.ExcelStyle: Sets the border styles of the style.
setBorderWeight(int) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setBorderWeight(int) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setBorderWeight(int) - Method in class EasyXLS.Charts.ExcelPlotArea: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setBottomBevel(String) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the type of the bottom bevel.
setBottomBevelHeight(float) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the height of the bottom bevel.
setBottomBevelWidth(float) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the width of the bottom bevel.
setBottomColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the color of the bottom border.
setBottomColor_Border(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the color of the bottom border.
This method is overridden as setBottomColor_Border_2 in COM+ version of EasyXLS.
setBottomColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting bottom border.
This method is overridden as setBottomColor_Border_2 in COM+ version of EasyXLS.
setBottomColor_Border(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the color of the bottom border.
This method is overridden as setBottomColor_Border_2 in COM+ version of EasyXLS.
setBottomColor_Border(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the color of the bottom border.
This method is overridden as setBottomColor_Border_2 in COM+ version of EasyXLS.
setBottomColor_Border(Color) - Method in class EasyXLS.ExcelCell: Sets the color of the bottom border.
setBottomColor_Border(Color) - Method in class EasyXLS.ExcelColumn: Sets the color of the bottom border.
setBottomColor_Border(Color) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting bottom border.
setBottomColor_Border(Color) - Method in class EasyXLS.ExcelRow: Sets the color of the bottom border.
setBottomColor_Border(Color) - Method in class EasyXLS.ExcelStyle: Sets the color of the bottom border.
setBottomLeftCellStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the bottom left cell.
setBottomMargin(double) - Method in class EasyXLS.ExcelPageSetup: Sets the bottom margin of the paper.
setBottomRightCellStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the bottom right cell.
setBottomStyle_Border(int) - Method in class EasyXLS.ExcelCell: Sets the style of the bottom border.
setBottomStyle_Border(int) - Method in class EasyXLS.ExcelColumn: Sets the style of the bottom border.
setBottomStyle_Border(int) - Method in class EasyXLS.ExcelCondition: Sets the style of the conditional formatting bottom border.
setBottomStyle_Border(int) - Method in class EasyXLS.ExcelRow: Sets the style of the bottom border.
setBottomStyle_Border(int) - Method in class EasyXLS.ExcelStyle: Sets the style of the bottom border.
setBSEImage(BSE) - Method in class EasyXLS.Drawings.ExcelImage: Internal use only.
setBubbleScale(int) - Method in class EasyXLS.Charts.ExcelChart: Sets the scale of the bubble size compared to chart in general.
setBubbleSize(int) - Method in class EasyXLS.Charts.ExcelChart: Sets if the scale represents the area of bubbles or the width of bubbles.
setBuildInName(bool) - Method in class EasyXLS.ExcelName: Internal use only
setCalculateFormulas(bool) - Method in class EasyXLS.ExcelOptions: Sets the flag that stores if the formulas are calculated when the document is saved.
setCapacity(int) - Method in class EasyXLS.Util.List: Increases the capacity of this list, if necessary, to ensure that it can hold at least the number of components specified by the minimum capacity argument.
setCapType(String) - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat: Sets the cap type of the line.
setCategory(String) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Sets the category property.
setCenterHorizontally(bool) - Method in class EasyXLS.ExcelPageSetup: Sets the center horizontally option for the page.
setCenterVertically(bool) - Method in class EasyXLS.ExcelPageSetup: Sets the center vertically option for the page.
setCharacterSpacing(String, float) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the character spacing of the font.
setChartTitle(ExcelTitle) - Method in class EasyXLS.Charts.ExcelChart: Sets the chart title.
setClassicLayout(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the classic layout is selected.
setCollapsed(bool) - Method in class EasyXLS.ExcelColumn: Internal use only
setCollapsed(bool) - Method in class EasyXLS.ExcelDataGroup: Sets if the data group is collapsed or expanded.
setCollapsed(bool) - Method in class EasyXLS.ExcelRow: Internal use only
setColor(int, int) - Method in class EasyXLS.Themes.ThemeColor: Sets the color of the theme, color that is altered from one of the basic colors.
setColor(ThemeColor) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the shadow color.
This method is overridden as setColor_2 in COM+ version of EasyXLS.
setColor(Color) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the shadow color.
setColorScheme(ExcelColorScheme) - Method in class EasyXLS.Themes.ExcelTheme: Sets the color scheme of the theme.
setColumnCount(int) - Method in class EasyXLS.ExcelTable: Sets the number of columns for the table.
setColumnHeaderTitle(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the value to be displayed in column header in compact mode.
setColumnMaxOutlineLevel(int) - Method in class EasyXLS.ExcelWorksheet: Sets the highest number of outline levels for columns in this sheet.
setColumnWidth(int) - Method in class EasyXLS.ExcelTable: Sets the default width of the columns.
setColumnWidth(int, int) - Method in class EasyXLS.ExcelTable: Sets the width for the specified column.
This method is overridden as setColumnWidth_2 in COM+ version of EasyXLS.
setComment(ExcelComment) - Method in class EasyXLS.ExcelCell: Sets the comment of the cell.
setComment(String) - Method in class EasyXLS.ExcelCell: Sets the comment of the cell having the specified text.
setComment(String, int, int) - Method in class EasyXLS.ExcelCell: Sets the comment of the cell having the specified text and size.
setComment(String, String, int, bool, bool, Color) - Method in class EasyXLS.ExcelCell: Sets the comment of the cell having the specified text and font settings.
setComments(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the comments property.
setCompactForm() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the compact form for all the fields of the pivot table.
setCompanyName(String) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Sets the company name property.
setCompoundType(String) - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat: Sets the compound type of the line.
setConditionType(int) - Method in class EasyXLS.ExcelCondition: Sets the conditional formatting type.
setCopyTo(String) - Method in class EasyXLS.ExcelFilter: Sets the range where the matching rows of the criteria will be copied.
setCriteriaRange(String) - Method in class EasyXLS.ExcelFilter: Sets the criteria range.
setCrossedBetweenCategories(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the flag true if the axis crosses between categories, or false if it does not.
setCrossValue(double) - Method in class EasyXLS.Charts.ExcelAxis: Sets the crosses value of the axis.
setCurrentSheet(int) - Method in class EasyXLS.ExcelDocument: Sets the current sheet displayed when the document is loaded in Microsoft Excel.
setCustomName(String) - Method in class EasyXLS.PivotTables.ExcelField: Sets the name of the pivot table field.
setCustomName(String) - Method in class EasyXLS.PivotTables.ExcelValueField: Sets the name of the pivot table value field.
setCustomProperty(String, long, String) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Adds or sets a custom property.
setDashType(String) - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat: Sets the dash type of the line.
setDataGroupAutomaticStyles(bool) - Method in class EasyXLS.ExcelWorksheet: Sets the automatic style option when grouping data.
setDataGroupSummaryColumnsRight(bool) - Method in class EasyXLS.ExcelWorksheet: Sets the summary columns to right of detail option when grouping data.
setDataGroupSummaryRowsBelow(bool) - Method in class EasyXLS.ExcelWorksheet: Sets the summary rows below detail option when grouping data.
setDataHeaderTitle(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the value to be displayed in value area header.
setDataLabels(int) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.5, replaced by ExcelSeries.setDataLabels(ExcelDataLabels)
setDataLabels(ExcelDataLabels) - Method in class EasyXLS.Charts.ExcelSeries: Sets the data labels settings of the chart series.
This method is overridden as setDataLabels_2 in COM+ version of EasyXLS.
setDataType(String) - Method in class EasyXLS.ExcelCell: Sets the data type of the cell.
setDataType(String) - Method in class EasyXLS.ExcelColumn: Sets the data type of the column.
setDataType(String) - Method in class EasyXLS.ExcelRow: Sets the data type of the row.
setDataType(String) - Method in class EasyXLS.ExcelStyle: Sets the data type of the style.
setDescription(String) - Method in class EasyXLS.ExcelHyperlink: Sets the text that is shown in the table instead of the URL.
setDiagonalBorder(bool, bool, int, ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the diagonal borders.
setDiagonalBorder(bool, bool, int, ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the diagonal borders.
This method is overridden as setDiagonalBorder_2 in COM+ version of EasyXLS.
setDiagonalBorder(bool, bool, int, ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the diagonal borders.
This method is overridden as setDiagonalBorder_2 in COM+ version of EasyXLS.
setDiagonalBorder(bool, bool, int, ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the diagonal borders.
This method is overridden as setDiagonalBorder_2 in COM+ version of EasyXLS.
setDiagonalBorder(bool, bool, int, Color) - Method in class EasyXLS.ExcelCell: Sets the diagonal borders.
setDiagonalBorder(bool, bool, int, Color) - Method in class EasyXLS.ExcelColumn: Sets the diagonal borders.
setDiagonalBorder(bool, bool, int, Color) - Method in class EasyXLS.ExcelRow: Sets the diagonal borders.
setDiagonalBorder(bool, bool, int, Color) - Method in class EasyXLS.ExcelStyle: Sets the diagonal borders.
setDisplayErrors(bool) - Method in class EasyXLS.ExcelOptions: Sets the flag that stores if the errors or the warnings are displayed on the console.
setDistance(float) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the distance of the shadow.
setDocumentSummaryInformation(DocumentSummaryInformation) - Method in class EasyXLS.ExcelDocument: Sets the document summary information of an Excel document.
setDoubleStrikethrough(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the double strikethrough setting of the font.
setDoughnutHoleSize(int) - Method in class EasyXLS.Charts.ExcelChart: Sets the size of the doughnut hole.
setEffectScheme(ExcelEffectScheme) - Method in class EasyXLS.Themes.ExcelTheme: Sets the effect scheme of the theme.
setElementAt(Object, int) - Method in class EasyXLS.Util.List: Sets the element at the specified index to be the specified object The previous element at that position is discarded
setEmptyCellValue(bool, String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the text that is displayed in a cell instead of a blank cell.
setEnableShowDetails(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the drilling down to detail data from the data source, and then displaying the data on a new worksheet is enabled.
setEncryptionOptions(int, String) - Method in class EasyXLS.ExcelOptions: Sets the encryption options when a file is written and the document is encrypted.
setEqualizeCharacterHeight(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the equalize character height setting of the font.
setErrorAlert(String, String) - Method in class EasyXLS.ExcelDataValidator: Sets the title and the message of the "Error Alert"
setErrorStyle(int) - Method in class EasyXLS.ExcelDataValidator: Sets the "Error Alert" box style.
setErrorText(String) - Method in class EasyXLS.ExcelDataValidator: Sets the message of the "Error Alert"
setErrorTitle(String) - Method in class EasyXLS.ExcelDataValidator: Sets the title of the "Error Alert"
setErrorValue(bool, String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the text that is displayed in a cell instead of the error message.
setEvenColumnStripesStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the even columns.
setEvenRowStripesStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the even rows.
setFillFormat(FillFormat) - Method in class EasyXLS.Drawings.FillDrawingObject: Sets the fill format of the drawing shape.
setFirstColumn(int) - Method in class EasyXLS.ExcelConditionalFormatting: Sets the first column of the cell range where the conditional formatting will be applied.
setFirstColumn(int) - Method in class EasyXLS.ExcelDataGroup: Sets the first column of the cell range where the data group is located.
setFirstColumn(int) - Method in class EasyXLS.ExcelDataValidator: Sets the first column of the cell range where the validation will be applied.
setFirstColumn(int) - Method in class EasyXLS.ExcelHyperlink: A hyperlink is set on a rectangular area that can contain more than one cell and this method sets the index of the first column of the hyperlink area
setFirstFormula(String) - Method in class EasyXLS.ExcelCondition: Sets the conditional formatting first formula.
setFirstFormula(String) - Method in class EasyXLS.ExcelDataValidator: Sets the expression of the first formula.
setFirstPageNumber(int) - Method in class EasyXLS.ExcelPageSetup: Sets the starting page number.
setFirstRow(int) - Method in class EasyXLS.ExcelConditionalFormatting: Sets the first row of the cell range where the conditional formatting will be applied.
setFirstRow(int) - Method in class EasyXLS.ExcelDataGroup: Sets the first row of the cell range where the data group is located.
setFirstRow(int) - Method in class EasyXLS.ExcelDataValidator: Sets the first row of the cell range where the validation will be applied.
setFirstRow(int) - Method in class EasyXLS.ExcelHyperlink: A hyperlink is set on a rectangular area that can contain more than one cell and this method sets the index of the first row of the hyperlink area
setFirstSliceAngle(int) - Method in class EasyXLS.Charts.ExcelChart: Sets the angle of the first slice.
setFitToPagesHeight(int) - Method in class EasyXLS.ExcelPageSetup: Sets the number of pages to fit in the page height.
setFitToPagesWidth(int) - Method in class EasyXLS.ExcelPageSetup: Sets the number of pages to fit in the page width.
setFollowedHyperlinkColor(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Followed Hyperlink color.
setFont(String) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setFont(System.String)
setFont(String) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setFont(System.String)
setFont(String) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setFont(System.String)
setFont(String) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setFont(System.String)
setFont(String) - Method in class EasyXLS.Drawings.ExcelComment: Sets the font name of the comment text.
setFont(String) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the font name.
setFont(String) - Method in class EasyXLS.ExcelCell: Sets the name of the cell font.
setFont(String) - Method in class EasyXLS.ExcelColumn: Sets the name of the column font.
setFont(String) - Method in class EasyXLS.ExcelRow: Sets the name of the row font.
setFont(String) - Method in class EasyXLS.ExcelStyle: Sets the name of the style font.
setFontFormat(FontFormat) - Method in class EasyXLS.Drawings.FontDrawingObject: Sets the font format of the drawing shape.
setFontFormat(FontFormat) - Method in interface EasyXLS.Drawings.IFontDrawingObject: Sets the font format of the drawing shape.
setFontScheme(ExcelFontScheme) - Method in class EasyXLS.Themes.ExcelTheme: Sets the font scheme of the theme.
setFontSettings(String, int, bool, bool, ThemeColor) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the font settings.
This method is overridden as setFontSettings_2 in COM+ version of EasyXLS.
setFontSettings(String, int, bool, bool, Color) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSettings(String,int,bool,bool,Color)
setFontSettings(String, int, bool, bool, Color) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSettings(String,int,bool,bool,Color)
setFontSettings(String, int, bool, bool, Color) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSettings(String,int,bool,bool,Color)
setFontSettings(String, int, bool, bool, Color) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSettings(String,int,bool,bool,Color)
setFontSettings(String, int, bool, bool, Color) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the font settings.
setFontSize(float) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the size of the font.
setFontSize(int) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSize(float)
setFontSize(int) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSize(float))
setFontSize(int) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSize(float)
setFontSize(int) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setFontSize(float)
setFontSize(int) - Method in class EasyXLS.Drawings.ExcelComment: Sets the font size of the comment text.
setFontSize(int) - Method in class EasyXLS.ExcelCell: Sets the size of the cell font.
setFontSize(int) - Method in class EasyXLS.ExcelColumn: Sets the size of the column font.
setFontSize(int) - Method in class EasyXLS.ExcelRow: Sets the size of the row font.
setFontSize(int) - Method in class EasyXLS.ExcelStyle: Sets the size of the style font.
setFooterMargin(double) - Method in class EasyXLS.ExcelPageSetup: Sets the footer margin of the paper.
setFooterRowStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the footer row.
setFooterString(String) - Method in class EasyXLS.ExcelFooter: Sets the footer expression.
setForeground(ThemeColor) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the font color.
This method is overridden as setForeground_2 in COM+ version of EasyXLS.
setForeground(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the foreground color of the cell.
setForeground(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the foreground color of the column.
This method is overridden as setForeground_2 in COM+ version of EasyXLS.
setForeground(ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the foreground of the conditional formatting font.
This method is overridden as setForeground_2 in COM+ version of EasyXLS.
setForeground(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the foreground color of the row.
This method is overridden as setForeground_2 in COM+ version of EasyXLS.
setForeground(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the foreground color of the style.
This method is overridden as setForeground_2 in COM+ version of EasyXLS.
setForeground(Color) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setForeground(Color)
setForeground(Color) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setForeground(Color)
setForeground(Color) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setForeground(Color)
setForeground(Color) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setForeground(Color)
setForeground(Color) - Method in class EasyXLS.Drawings.ExcelComment: Sets the foreground of the comment text.
setForeground(Color) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the foreground color.
setForeground(Color) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the font color.
setForeground(Color) - Method in class EasyXLS.ExcelCell: Sets the foreground color of the cell.
setForeground(Color) - Method in class EasyXLS.ExcelColumn: Sets the foreground color of the column.
setForeground(Color) - Method in class EasyXLS.ExcelCondition: Sets the foreground of the conditional formatting font.
setForeground(Color) - Method in class EasyXLS.ExcelRow: Sets the foreground color of the row.
setForeground(Color) - Method in class EasyXLS.ExcelStyle: Sets the foreground color of the style.
setFormat(String) - Method in class EasyXLS.ExcelCell: Sets the number/date format of the cell.
setFormat(String) - Method in class EasyXLS.ExcelColumn: Sets the number/date format of the column.
setFormat(String) - Method in class EasyXLS.ExcelRow: Sets the number/date format of the row.
setFormat(String) - Method in class EasyXLS.ExcelStyle: Sets the number/date format of the style.
setFormat(String) - Method in class EasyXLS.PivotTables.ExcelValueField: Sets the number format of the value field.
setFormula(String) - Method in class EasyXLS.ExcelArrayFormula: Sets the formula of the array.
setFormula(String) - Method in class EasyXLS.PivotTables.ExcelCalculatedField: Sets the formula of the pivot table field.
setFreezePaneSet(bool) - Method in class EasyXLS.ExcelTable: Internal use only
setGradientAngle(float) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the angle of the gradient.
setGradientAngle(float) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the angle of the gradient.
setGradientColor1(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the first color of the gradient fill.
setGradientColor1(Color) - Method in class EasyXLS.ExcelStyle: Sets the first color of the gradient fill.
setGradientColor2(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the second color of the gradient fill.
setGradientColor2(Color) - Method in class EasyXLS.ExcelStyle: Sets the second color of the gradient fill.
setGradientDirection(int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the direction for the gradient fill.
setGradientDirection(int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the direction for the gradient line.
setGradientFill(int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets a predefined subset of colors for the gradient.
setGradientFill(ThemeColor, ThemeColor, int) - Method in class EasyXLS.ExcelCell: Sets the gradient fill for the style.
setGradientFill(ThemeColor, ThemeColor, int) - Method in class EasyXLS.ExcelColumn: Sets the gradient fill for the style.
setGradientFill(ThemeColor, ThemeColor, int) - Method in class EasyXLS.ExcelRow: Sets the gradient fill for the style.
setGradientFill(ThemeColor, ThemeColor, int) - Method in class EasyXLS.ExcelStyle: Sets the gradient fill for the style.
setGradientFill(Color, Color, int) - Method in class EasyXLS.ExcelCell: Sets the gradient fill for the style.
setGradientFill(Color, Color, int) - Method in class EasyXLS.ExcelColumn: Sets the gradient fill for the style.
setGradientFill(Color, Color, int) - Method in class EasyXLS.ExcelRow: Sets the gradient fill for the style.
setGradientFill(Color, Color, int) - Method in class EasyXLS.ExcelStyle: Sets the gradient fill for the style.
setGradientLine(int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets a predefined subset of colors for the gradient.
setGradientShadingStyle(int) - Method in class EasyXLS.ExcelStyle: Sets the shading style of the gradient fill.
setGradientType(int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the gradient type of the gradient fill.
setGradientType(int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the gradient type of the gradient line.
setGrandTotalTitle(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the value to be displayed for grand totals.
setGroupType(int) - Method in class EasyXLS.ExcelDataGroup: Sets the group per rows or columns option.
setHashedPassword(String) - Method in class EasyXLS.ExcelSheet: Sets the password hash used to verify the sheet password.
setHeaderMargin(double) - Method in class EasyXLS.ExcelPageSetup: Sets the header margin of the paper.
setHeaderRowStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the header row.
setHeaderString(String) - Method in class EasyXLS.ExcelHeader: Sets the header expression.
setHeadingFont(String) - Method in class EasyXLS.Themes.ExcelFontScheme: Sets the name of the heading font.
setHeadingsFont() - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the headings font.
setHeadingsFont() - Method in class EasyXLS.ExcelCell: Sets the headings font.
setHeadingsFont() - Method in class EasyXLS.ExcelColumn: Sets the headings font.
setHeadingsFont() - Method in class EasyXLS.ExcelRow: Sets the headings font.
setHeadingsFont() - Method in class EasyXLS.ExcelStyle: Sets the headings font.
setHeight(int) - Method in class EasyXLS.ExcelRow: Sets the height of the row.
setHidden(bool) - Method in class EasyXLS.ExcelName: Sets the hidden option of the name.
setHidden(bool) - Method in class EasyXLS.ExcelSheet: Sets the hidden option of the sheet.
setHiddenColumn(bool) - Method in class EasyXLS.ExcelColumn: Sets the hidden option of the column.
setHiddenFormula(bool) - Method in class EasyXLS.ExcelCell: Sets the hidden option of the cell.
setHiddenFormula(bool) - Method in class EasyXLS.ExcelColumn: Sets the hidden option of the column.
setHiddenFormula(bool) - Method in class EasyXLS.ExcelRow: Sets the hidden option of the row.
setHiddenFormula(bool) - Method in class EasyXLS.ExcelStyle: Sets the hidden option of the style.
setHiddenRow(bool) - Method in class EasyXLS.ExcelRow: Sets the hidden option of the row.
setHorizontalAlignment(String) - Method in class EasyXLS.ExcelCell: Sets the horizontal alignment of the cell.
setHorizontalAlignment(String) - Method in class EasyXLS.ExcelColumn: Sets the horizontal alignment of the column.
setHorizontalAlignment(String) - Method in class EasyXLS.ExcelRow: Sets the horizontal alignment of the row.
setHorizontalAlignment(String) - Method in class EasyXLS.ExcelStyle: Sets the horizontal alignment of the style.
setHorizontalLines(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Sets the visible value of the horizontal data table grid lines.
setHTMLText(String) - Method in class EasyXLS.Drawings.ExcelComment: Sets the value of the comment using html tags.
setHTMLValue(String) - Method in class EasyXLS.ExcelCell: Sets the value of the cell using html tags.The html tags are used to set the rich text format in cells.
setHyperlink(String, String) - Method in class EasyXLS.ExcelHyperlink: Sets the type of the hyperlink and the URL value.
setHyperlinkBase(String) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Sets the hyperlink base property.
setHyperlinkColor(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Hyperlink color.
setHyperlinkType(String) - Method in class EasyXLS.ExcelHyperlink: Sets the type of the hyperlink.
setIgnoreBlank(bool) - Method in class EasyXLS.ExcelDataValidator: Sets the ignore blank option.
setImagePath(String) - Method in class EasyXLS.Drawings.ExcelImage: Sets the file path to image file.
setIndent(int) - Method in class EasyXLS.ExcelCell: Sets the indent of the cell.
setIndent(int) - Method in class EasyXLS.ExcelColumn: Sets the indent of the column.
setIndent(int) - Method in class EasyXLS.ExcelRow: Sets the indent of the row.
setIndent(int) - Method in class EasyXLS.ExcelStyle: Sets the indent of the style.
setInnerShadow(int, float, float, float) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the inner shadow option of the shape.
setInputMessage(String, String) - Method in class EasyXLS.ExcelDataValidator: Sets the title and the message of the "Input Message"
setInputText(String) - Method in class EasyXLS.ExcelDataValidator: Sets the message of the "Input Message"
setInputTitle(String) - Method in class EasyXLS.ExcelDataValidator: Sets the title of the "Input Message"
setInsertBlankLine(bool) - Method in class EasyXLS.PivotTables.ExcelField: Sets if a blank line is inserted after each item label.
setInsertPageBreak(bool) - Method in class EasyXLS.PivotTables.ExcelField: Sets if a blank line is inserted after each item.
setInvertIfNegative(bool) - Method in class EasyXLS.Charts.ExcelSeries: Sets the "invert if negative" option for the chart series.
setIsShowErrorBox(bool) - Method in class EasyXLS.ExcelDataValidator: Sets the show "Error Alert" box option.
setIsShowInputBox(bool) - Method in class EasyXLS.ExcelDataValidator: Sets the show "Input Message" box option.
setItalic(bool) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setItalic(bool)
setItalic(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setItalic(bool)
setItalic(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setItalic(bool)
setItalic(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setItalic(bool)
setItalic(bool) - Method in class EasyXLS.Drawings.ExcelComment: Sets the italic option of the comment text.
setItalic(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the italic setting of the font.
setItalic(bool) - Method in class EasyXLS.ExcelCell: Sets the italic option of the cell font.
setItalic(bool) - Method in class EasyXLS.ExcelColumn: Sets the italic option of the column font.
setItalic(bool) - Method in class EasyXLS.ExcelCondition: Sets the italic setting of the conditional formatting font.
setItalic(bool) - Method in class EasyXLS.ExcelRow: Sets the italic option of the row font.
setItalic(bool) - Method in class EasyXLS.ExcelStyle: Sets the italic option of the style font.
setIterativeCalculation(bool, int, double) - Method in class EasyXLS.ExcelOptions: Sets the iterative calculation option for circular references.
setJoinType(String) - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat: Sets the join type of the line.
setJustifyDistributed(bool) - Method in class EasyXLS.ExcelCell: Sets the justify distributed option of the cell.
setJustifyDistributed(bool) - Method in class EasyXLS.ExcelColumn: Sets the justify distributed option of the column.
setJustifyDistributed(bool) - Method in class EasyXLS.ExcelRow: Sets the justify distributed option of the row.
setJustifyDistributed(bool) - Method in class EasyXLS.ExcelStyle: Sets the justify distributed option of the style font.
setKerningForFonts(float) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the kerning for fonts in points.
setKeysArrangementDirection(int) - Method in class EasyXLS.Charts.ExcelChartLegend: Sets the direction in which the keys will be arranged: vertical or horizontal.
setKeywords(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the keywords property.
setLabel(String) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by ExcelTitle.setText(System.String)
setLabelFrequency(int) - Method in class EasyXLS.Charts.ExcelAxis: Sets the number of categories between tick-mark labels.
setLabelPosition(String) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets the label position.
setLastColumn(int) - Method in class EasyXLS.ExcelConditionalFormatting: Sets the last column of the cell range where the conditional formatting will be applied.
setLastColumn(int) - Method in class EasyXLS.ExcelDataGroup: Sets the last column of the cell range where the data group is located.
setLastColumn(int) - Method in class EasyXLS.ExcelDataValidator: Sets the last column of the cell range where the validation will be applied.
setLastColumn(int) - Method in class EasyXLS.ExcelHyperlink: A hyperlink is set on a rectangular area that can contain more than one cell and this method sets the index of the last column of the hyperlink area
setLastPrinted(DateTime) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the last printed property.
setLastRow(int) - Method in class EasyXLS.ExcelConditionalFormatting: Sets the last row of the cell range where the conditional formatting will be applied.
setLastRow(int) - Method in class EasyXLS.ExcelDataGroup: Sets the last row of the cell range where the data group is located.
setLastRow(int) - Method in class EasyXLS.ExcelDataValidator: Sets the last row of the cell range where the validation will be applied.
setLastRow(int) - Method in class EasyXLS.ExcelHyperlink: A hyperlink is set on a rectangular area that can contain more than one cell and this method sets the index of the last row of the hyperlink area
setLastSavedBy(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the last author property.
setLastSavedDate(DateTime) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the date of last saved property.
setLeftColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the color of the left border.
setLeftColor_Border(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the color of the left border.
This method is overridden as setLeftColor_Border_2 in COM+ version of EasyXLS.
setLeftColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting left border.
This method is overridden as setLeftColor_Border_2 in COM+ version of EasyXLS.
setLeftColor_Border(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the color of the left border.
This method is overridden as setLeftColor_Border_2 in COM+ version of EasyXLS.
setLeftColor_Border(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the color of the left border.
This method is overridden as setLeftColor_Border_2 in COM+ version of EasyXLS.
setLeftColor_Border(Color) - Method in class EasyXLS.ExcelCell: Sets the color of the left border.
setLeftColor_Border(Color) - Method in class EasyXLS.ExcelColumn: Sets the color of the left border.
setLeftColor_Border(Color) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting left border.
setLeftColor_Border(Color) - Method in class EasyXLS.ExcelRow: Sets the color of the left border.
setLeftColor_Border(Color) - Method in class EasyXLS.ExcelStyle: Sets the color of the left border.
setLeftColumnStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the left column.
setLeftMargin(double) - Method in class EasyXLS.ExcelPageSetup: Sets the left margin of the paper.
setLeftStyle_Border(int) - Method in class EasyXLS.ExcelCell: Sets the style of the left border.
setLeftStyle_Border(int) - Method in class EasyXLS.ExcelColumn: Sets the style of the left border.
setLeftStyle_Border(int) - Method in class EasyXLS.ExcelCondition: Sets the style of the conditional formatting left border.
setLeftStyle_Border(int) - Method in class EasyXLS.ExcelRow: Sets the style of the left border.
setLeftStyle_Border(int) - Method in class EasyXLS.ExcelStyle: Sets the style of the left border.
setLeftUpperCorner(int, int) - Method in class EasyXLS.Drawings.DrawingObject2D: Sets the left upper corner of the drawing object
This method is applicable only to adding drawing objects to an ExcelWorksheet
setLeftUpperCorner(String) - Method in class EasyXLS.Drawings.DrawingObject2D: Sets the left upper corner of the drawing object
This method is applicable only to adding drawing objects to an ExcelWorksheet
This method is overridden as setLeftUpperCorner_2 in COM+ version of EasyXLS.
setLeftUpperOffset(int, int) - Method in class EasyXLS.Drawings.DrawingObject: Sets the left upper corner offsets of the drawing object.
setLegendKey(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Sets the visibility of the data table legend key.
setLicenseFile(String) - Method in class EasyXLS.License: Sets the license file name.
setLicenseFilePath(String) - Method in class EasyXLS.License: Sets the license file path.
setLicenseFromXMLString(String) - Method in class EasyXLS.License: Sets the license file path.
setLicenseStream(InputStream) - Method in class EasyXLS.License: Sets the license file as stream.
setLightAngle(float) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the angle of the lights.
setLighting(String) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the lighting of the shape.
setLineColor(ThemeColor) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the line color.
This method is overridden as setLineColor_2 in COM+ version of EasyXLS.
setLineColor(Color) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setLineColor(Color) - Method in class EasyXLS.Charts.ExcelChartGridlines: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setLineColor(Color) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setLineColor(Color) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.3, replaced by LineColorFormat.setLineColor(Color)
setLineColor(Color) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the line color.
setLineColorFormat(LineColorFormat) - Method in class EasyXLS.Drawings.LineDrawingObject: Sets the line color format of the drawing shape.
setLineStyle(int) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(System.String)
setLineStyle(int) - Method in class EasyXLS.Charts.ExcelChartGridlines: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(System.String)
setLineStyle(int) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(System.String)
setLineStyle(int) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setDashType(String)
setLineStyleFormat(LineStyleFormat) - Method in class EasyXLS.Drawings.LineDrawingObject: Sets the line style format of the drawing shape.
setLineWeight(int) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setLineWeight(int) - Method in class EasyXLS.Charts.ExcelChartGridlines: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setLineWeight(int) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setLineWeight(int) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.3, replaced by LineStyleFormat.setWidth(float)
setLinksDirty(bool) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Sets the links dirty property.
setListRange(String) - Method in class EasyXLS.ExcelFilter: Sets the list range.
setLocation(int, int, int, int) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the location of the pivot table and must be a formula, that represents a range or a cell reference.
setLocation(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the location of the pivot table and must be a formula, that represents a range or a cell reference
This method is overridden as setLocation_2 in COM+ version of EasyXLS.
setLocked(bool) - Method in class EasyXLS.ExcelCell: Sets the locked option of the cell.
setLocked(bool) - Method in class EasyXLS.ExcelColumn: Sets the locked option of the column.
setLocked(bool) - Method in class EasyXLS.ExcelRow: Sets the locked option of the row.
setLocked(bool) - Method in class EasyXLS.ExcelStyle: Sets the locked option of the style.
setLogarithmicScale(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the logarithmic scale.
setMajorTickMarkType(int) - Method in class EasyXLS.Charts.ExcelAxis: Sets the type of the major tick mark.
setMajorUnit(double) - Method in class EasyXLS.Charts.ExcelAxis: Sets the major unit of the value Y axis scale.
setManager(String) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Sets the manager property.
setMarkerFillFormat(FillFormat) - Method in class EasyXLS.Charts.ExcelSeries: Sets the fill formatting of the marker.
setMarkerLineColorFormat(LineColorFormat) - Method in class EasyXLS.Charts.ExcelSeries: Sets the line color formatting of the marker.
setMarkerLineStyleFormat(LineStyleFormat) - Method in class EasyXLS.Charts.ExcelSeries: Sets the line style formatting of the marker.
setMarkerSize(int) - Method in class EasyXLS.Charts.ExcelSeries: Sets the marker size of the chart series.
setMarkerType(int) - Method in class EasyXLS.Charts.ExcelSeries: Sets the marker type of the chart series.
setMaterial(String) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the material of the shape.
setMaximumCross(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the flag true if the axis crosses at maximum value, or false if it does not.
setMaximumValue(double) - Method in class EasyXLS.Charts.ExcelAxis: Sets the maximum value of the value Y axis scale.
setMergeAndCenterCellsWithLabels(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the cells are merged for outer row and column items.
setMinimumValue(double) - Method in class EasyXLS.Charts.ExcelAxis: Sets the minimum value of the value Y axis scale.
setMinorTickMarkType(int) - Method in class EasyXLS.Charts.ExcelAxis: Sets the type of the minor tick mark.
setMinorUnit(double) - Method in class EasyXLS.Charts.ExcelAxis: Sets the minor unit of the value Y axis scale.
setName(String) - Method in class EasyXLS.Charts.ExcelSeries: Returns the name of the chart series.
setName(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the pivot table name.
setName(String) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the name of the color scheme.
setName(String) - Method in class EasyXLS.Themes.ExcelFontScheme: Sets the name of the font scheme.
setName(String) - Method in class EasyXLS.Themes.ExcelTheme: Sets the name of the theme.
setNameText(String) - Method in class EasyXLS.ExcelName: Sets the title of the name.
setNewItemsInFilter(bool) - Method in class EasyXLS.PivotTables.ExcelField: Sets if any new items in the pivot table having a filter are included.
setNoFill(bool) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets no fill for the shape.
setNoLine(bool) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets no line for the shape.
setNoShadow(bool) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the no shadow option of the shape.
setNumberFormat(String) - Method in class EasyXLS.Charts.ExcelAxis: Sets the chart axis number format.
setNumberFormat(String) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets the data label number format.
setNumberFormat(String) - Method in class EasyXLS.PivotTables.ExcelField: Sets the field number format.
setNumberFormatLinked(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets if the number format of the chart axis is linked to the number format of the data source.
setNumberFormatLinked(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the number format of the data label is linked to the number format of the data source.
setOddColumnStripesStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the odd columns.
setOddRowStripesStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the odd rows.
setOperator(int) - Method in class EasyXLS.ExcelCondition: Sets the conditional formatting operator.
setOperatorType(int) - Method in class EasyXLS.ExcelDataValidator: Sets the operator type.
setOrientation(String) - Method in class EasyXLS.ExcelPageSetup: Sets the page orientation.
setOriginalName(String) - Method in class EasyXLS.PivotTables.ExcelField: Sets the original name of the pivot table field.
setOuterShadow(int, float, float, float, float, String) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the outer shadow option of the shape.
setOutlineForm() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the outline form for all the fields of the pivot table.
setOutlineLevel(int) - Method in class EasyXLS.ExcelColumn: Internal use only
setOutlineLevel(int) - Method in class EasyXLS.ExcelRow: Internal use only
setOutlineLines(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Sets the visibility of the data table outline lines.
setPageBreakPreview(bool) - Method in class EasyXLS.ExcelWorksheet: Sets the page break preview option for the worksheet.
setPageOrder(int) - Method in class EasyXLS.ExcelPageSetup: Sets the print page order.
setPageOverThenDown(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if first are displayed the fields in the report filter area from left to right, or if first are displayed the fields in the report filter area from top to bottom
setPageWrap(int) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the number of fields to display before taking up another column or row.
setPaperSize(int) - Method in class EasyXLS.ExcelPageSetup: Sets the paper size.
setPasswordToModify(String) - Method in class EasyXLS.ExcelOptions: Sets the password required for modifying the document.
setPasswordToOpen(String) - Method in class EasyXLS.ExcelOptions: Sets the password required for opening the document.
setPattern(int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the pattern fill.
setPattern(int) - Method in class EasyXLS.ExcelCell: Sets the pattern of the cell.
setPattern(int) - Method in class EasyXLS.ExcelColumn: Sets the pattern of the column.
setPattern(int) - Method in class EasyXLS.ExcelRow: Sets the pattern of the row.
setPattern(int) - Method in class EasyXLS.ExcelStyle: Sets the pattern of the style.
setPatternColor(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the pattern color of the cell.
setPatternColor(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the pattern color of the column.
This method is overridden as setPatternColor_2 in COM+ version of EasyXLS.
setPatternColor(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the pattern color of the row.
This method is overridden as setPatternColor_2 in COM+ version of EasyXLS.
setPatternColor(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the pattern color of the style.
This method is overridden as setPatternColor_2 in COM+ version of EasyXLS.
setPatternColor(Color) - Method in class EasyXLS.ExcelCell: Sets the pattern color of the cell.
setPatternColor(Color) - Method in class EasyXLS.ExcelColumn: Sets the pattern color of the column.
setPatternColor(Color) - Method in class EasyXLS.ExcelRow: Sets the pattern color of the row.
setPatternColor(Color) - Method in class EasyXLS.ExcelStyle: Sets the pattern color of the style.
setPatternLine(int, Color) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the pattern of the line.
setPerspective(float) - Method in class EasyXLS.Drawings.Formatting.Rotation3D: Sets the perspective of the camera.
setPerspectiveShadow(int, float, float, float, float, String, bool) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the perspective shadow option of the shape.
setPictureFill(ExcelImage, int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the picture fill for the shape.
This method is overridden as setPictureFill_2 in COM+ version of EasyXLS.
setPictureFill(String, int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the picture fill for the shape.
setPieExplosion(int) - Method in class EasyXLS.Charts.ExcelChart: Sets the pie explosion.
setPivotTable(ExcelPivotTable) - Method in class EasyXLS.PivotTables.ExcelPivotChart: Sets the pivot table source of the chart.
setPlacement(int) - Method in class EasyXLS.Charts.ExcelChartLegend: Sets the placement setting (position) of the chart legend within the chart area.
setPosition(int, int, int, int) - Method in class EasyXLS.ExcelHyperlink: A hyperlink is set on a rectangular area that can contain more than one cell and this method sets the hyperlink area position and dimension.
setPosition(String) - Method in class EasyXLS.ExcelFooter: Sets the position of the footer.
setPosition(String) - Method in class EasyXLS.ExcelHeader: Sets the position of the header.
setPosition(String) - Method in class EasyXLS.ExcelHyperlink: A hyperlink is set on a rectangular area that can contain more than one cell and this method sets the hyperlink area position
This method is overridden as setPosition_2 in COM+ version of EasyXLS.
setPreserveCellFormattingOnUpdate(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the layout and format is preserved each time an operation is performed on the pivot table.
setPrintBlackAndWhite(bool) - Method in class EasyXLS.ExcelPageSetup: Sets the print black and white option for the page.
setPrintComments(int) - Method in class EasyXLS.ExcelPageSetup: Sets the print comments option for the page.
setPrintDraftQuality(bool) - Method in class EasyXLS.ExcelPageSetup: Sets the print draft quality option for the page.
setPrintDrillButtons(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the expand/collapse buttons are visible when the pivot table is printed.
setPrintGridlines(bool) - Method in class EasyXLS.ExcelPageSetup: Sets the print gridlines option for the page.
setPrintRowAndColumnHeadings(bool) - Method in class EasyXLS.ExcelPageSetup: Sets the print row and column headings option for the page.
setPrintTitles(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the row and column field headers and column item labels are replicated on each printed page.
setProductName(String) - Method in class EasyXLS.License: Sets the product name for the OEM license key
setProtectContents(bool) - Method in class EasyXLS.ExcelChartSheet: Sets if the contents are protected when the sheet is protected.
setProtectionPassword(String) - Method in class EasyXLS.ExcelSheet: Sets the password to protect the sheet.
setProtectObjects(bool) - Method in class EasyXLS.ExcelChartSheet: Sets if the objects are protected when the sheet is protected.
setR1C1ReferenceStyle(bool) - Method in class EasyXLS.ExcelOptions: Sets the R1C1 reference style of the document.
setRange(int, int, int, int) - Method in class EasyXLS.ExcelConditionalFormatting: Sets the range where the conditional formatting is applied.
setRange(int, int, int, int) - Method in class EasyXLS.ExcelDataGroup: Sets the area location of the data group.
setRange(String) - Method in class EasyXLS.ExcelConditionalFormatting: Sets the range where the conditional formatting is applied.
This method is overridden as setRange_2 in COM+ version of EasyXLS.
setRange(String) - Method in class EasyXLS.ExcelDataGroup: Sets the area location of the data group.
This method is overridden as setRange_2 in COM+ version of EasyXLS.
setRefersTo(String) - Method in class EasyXLS.ExcelName: Sets the formula of the range.
setRelativeLeftUpperOffset(double, double) - Method in class EasyXLS.Drawings.DrawingObject: Internal use only
setRelativeSize(double, double) - Method in class EasyXLS.Drawings.DrawingObject: Internal use only
setRepeatRowLabels(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the row labels are replicated on each printed page.
setReverseOrder(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the values in reverse order.
setRevisionNumber(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the revision number property.
setRightColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the color of the right border.
setRightColor_Border(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the color of the right border.
This method is overridden as setRightColor_Border_2 in COM+ version of EasyXLS.
setRightColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting right border.
This method is overridden as setRightColor_Border_2 in COM+ version of EasyXLS.
setRightColor_Border(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the color of the right border.
This method is overridden as setRightColor_Border_2 in COM+ version of EasyXLS.
setRightColor_Border(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the color of the right border.
This method is overridden as setRightColor_Border_2 in COM+ version of EasyXLS.
setRightColor_Border(Color) - Method in class EasyXLS.ExcelCell: Sets the color of the right border.
setRightColor_Border(Color) - Method in class EasyXLS.ExcelColumn: Sets the color of the right border.
setRightColor_Border(Color) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting right border.
setRightColor_Border(Color) - Method in class EasyXLS.ExcelRow: Sets the color of the right border.
setRightColor_Border(Color) - Method in class EasyXLS.ExcelStyle: Sets the color of the right border.
setRightColumnStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the right column.
setRightMargin(double) - Method in class EasyXLS.ExcelPageSetup: Sets the right margin of the paper.
setRightStyle_Border(int) - Method in class EasyXLS.ExcelCell: Sets the style of the right border.
setRightStyle_Border(int) - Method in class EasyXLS.ExcelColumn: Sets the style of the right border.
setRightStyle_Border(int) - Method in class EasyXLS.ExcelCondition: Sets the style of the conditional formatting right border.
setRightStyle_Border(int) - Method in class EasyXLS.ExcelRow: Sets the style of the right border.
setRightStyle_Border(int) - Method in class EasyXLS.ExcelStyle: Sets the style of the right border.
setRotateWithShape(bool) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the rotate with shape option of the shape.
setRotation(String) - Method in class EasyXLS.Drawings.Formatting.Rotation3D: Sets the rotation of the shape.
setRotationDegrees(int) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by AlignmentFormat.setTextDirectionHorizontal(System.String, int)
setRoundedCorners(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Sets rounded corners for the border.
setRowCount(int) - Method in class EasyXLS.ExcelTable: Sets the number of rows for the table.
setRowHeaderTitle(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the value to be displayed in row header in compact mode.
setRowHeight(int) - Method in class EasyXLS.ExcelTable: Sets the default height of the rows.
setRowHeight(int, int) - Method in class EasyXLS.ExcelTable: Sets the height for the specified row.
This method is overridden as setRowHeight_2 in COM+ version of EasyXLS.
setRowHeightSet(bool) - Method in class EasyXLS.ExcelTable: Internal use only
setRowLabelsIndent(int) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the indent of the rows in the row labels area when the pivot table report is in compact format.
setRowMaxOutlineLevel(int) - Method in class EasyXLS.ExcelWorksheet: Sets the highest number of outline levels for rows in this sheet.
setScale(bool) - Method in class EasyXLS.FileProperties.DocumentSummaryInformation: Sets the scale property.
setScalingFactor(int) - Method in class EasyXLS.ExcelPageSetup: Sets the scaling factor.
setSecondFormula(String) - Method in class EasyXLS.ExcelCondition: Sets the conditional formatting second formula.
setSecondFormula(String) - Method in class EasyXLS.ExcelDataValidator: Sets the expression of the second formula.
setSecondPlotSize(int) - Method in class EasyXLS.Charts.ExcelChart: Sets the size of the second plot.
setSeparator(String) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets the label separator.
setShadow(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by ShadowFormat.setShadow(int)
setShadow(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by ShadowFormat.setShadow(int)
setShadow(bool) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.3, replaced by ShadowFormat.setShadow(int)
setShadow(int) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the shadow of the shape.
setShadowFormat(ShadowFormat) - Method in class EasyXLS.Drawings.LineDrawingObject: Sets the shadow format of the drawing shape.
setSheetIndex(int) - Method in class EasyXLS.ExcelName: Internal use only
setSheetName(String) - Method in class EasyXLS.ExcelSheet: Sets the name of the sheet.
setSheetProtected(bool) - Method in class EasyXLS.ExcelSheet: Sets the protected option of the sheet.
setSheetSelected(bool) - Method in class EasyXLS.ExcelSheet: Sets the selected option of the sheet.
setShowBubbleSize(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the bubble size is visible in the data label.
setShowCategoryName(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the category name is visible in the data label.
setShowColumnHeaders(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the column headers in the banding style are displayed.
setShowColumnStripes(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the column headers in the banding style are displayed.
setShowContextualTooltips(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the tooltips that show value, row, or column information for a field or data value are visible.
setShowDataInHiddenRowColumns(bool) - Method in class EasyXLS.Charts.ExcelChart: Sets if data in hidden rows and columns is visible.
setShowDataLabels(bool) - Method in class EasyXLS.Charts.ExcelSeries: Sets the data labels visible or not visible.
setShowDrillButtons(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the expand/collapse buttons are visible.
setShowEmptyRows(int) - Method in class EasyXLS.Charts.ExcelChart: Sets how the data points for the hidden cells are displayed for the chart series.
setShowGrandTotalsForColumns(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the pivot table contains grand totals for columns.
setShowGrandTotalsForRows(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the pivot table contains grand totals for rows.
setShowGridlines(bool) - Method in class EasyXLS.ExcelWorksheet: Sets the visibility option for the gridlines of the worksheet.
setShowHeaders(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the captions at the top of the pivot table report and filter drop-down arrows on column and row labels are visible.
setShowItemLabelsInOutlineForm(bool, bool, bool) - Method in class EasyXLS.PivotTables.ExcelField: Sets if the field items are displayed in outline form.
setShowItemLabelsInTabularForm(bool) - Method in class EasyXLS.PivotTables.ExcelField: Sets if the field items are displayed in tabular form.
setShowItemsWithNoData(bool) - Method in class EasyXLS.PivotTables.ExcelField: Sets if the items with no data are displayed.
setShowLeaderLines(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the leader lines are visible.
setShowLegendKeyNextToLabel(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets the visibility of the legend key next to label of the series.
setShowLegendKeyNextToLabel(bool) - Method in class EasyXLS.Charts.ExcelSeries: Deprecated.
As of version 8.5, replaced by ExcelDataLabels.setShowLegendKeyNextToLabel(bool)
setShowNegativeBubbles(bool) - Method in class EasyXLS.Charts.ExcelChart: Sets if the negative bubbles are visible.
setShowPercentage(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the percentage is visible in the data label.
setShowRowHeaders(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the row headers in the banding style are displayed.
setShowRowStripes(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the row headers in the banding style are displayed.
setShowSeriesName(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the series name is visible in the data label.
setShowValue(bool) - Method in class EasyXLS.Charts.ExcelDataLabels: Sets if the value is visible in the data label.
setShrink(bool) - Method in class EasyXLS.ExcelCell: Sets the shrink option of the cell.
setShrink(bool) - Method in class EasyXLS.ExcelColumn: Sets the shrink option of the column.
setShrink(bool) - Method in class EasyXLS.ExcelRow: Sets the shrink option of the row.
setShrink(bool) - Method in class EasyXLS.ExcelStyle: Sets the shrink option of the style.
setSize(float) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the size of the shadow.
setSize(int, int) - Method in class EasyXLS.Drawings.DrawingObject: Sets the drawing object size.
setSmallCaps(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the small caps setting of the font.
setSmoothedLine(bool) - Method in class EasyXLS.Charts.ExcelSeries: Sets the smoothed line for line based charts.
setSolidFill(ThemeColor, int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the solid fill for the shape.
This method is overridden as setSolidFill_2 in COM+ version of EasyXLS.
setSolidFill(Color, int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the solid fill for the shape.
setSolidLine(ThemeColor, int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the solid line options.
This method is overridden as setSolidLine_2 in COM+ version of EasyXLS.
setSolidLine(Color, int) - Method in class EasyXLS.Drawings.Formatting.LineColorFormat: Sets the solid line options.
setSortOrder(int) - Method in class EasyXLS.PivotTables.ExcelField: Sets the sort order of the field data.
setSortOrder(int) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the sort order of the fields in pivot table.
setSourceRange(String, ExcelDocument) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the data source for the pivot table.
setSplitSet(bool) - Method in class EasyXLS.ExcelTable: Internal use only
setStackScale(float) - Method in class EasyXLS.Charts.ExcelSeries: Sets the stack option and scale.
setStatus(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the status property.
setStretchOptions(float, float, float, float) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the stretch options for the texture.
setStrikethrough(bool) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setStrikethrough(bool)
setStrikethrough(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setStrikethrough(bool)
setStrikethrough(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setStrikethrough(bool)
setStrikethrough(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setStrikethrough(bool)
setStrikethrough(bool) - Method in class EasyXLS.Drawings.ExcelComment: Sets the strikethrough option of the comment.
setStrikethrough(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the strikethrough setting of the font.
setStrikethrough(bool) - Method in class EasyXLS.ExcelCell: Sets the strikethrough option of the cell font.
setStrikethrough(bool) - Method in class EasyXLS.ExcelColumn: Sets the strikethrough option of the column font.
setStrikethrough(bool) - Method in class EasyXLS.ExcelCondition: Sets the strikethrough setting of the conditional formatting font.
setStrikethrough(bool) - Method in class EasyXLS.ExcelRow: Sets the strikethrough option of the row font.
setStrikethrough(bool) - Method in class EasyXLS.ExcelStyle: Sets the strikethrough option of the style font.
setStyle(int) - Method in class EasyXLS.Charts.ExcelChart: Sets the style of the chart.
setStyle(ExcelStyle) - Method in class EasyXLS.ExcelCell: Sets the style of the cell.
setStyle(ExcelStyle) - Method in class EasyXLS.ExcelColumn: Sets the style of the column.
setStyle(ExcelStyle) - Method in class EasyXLS.ExcelRow: Sets the style of the row.
setStyle(String) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the style of the pivot table.
setSubject(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the subject property.
setSubscript(bool) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setSubscript(bool)
setSubscript(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setSubscript(bool)
setSubscript(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setSubscript(bool)
setSubscript(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setSubscript(bool)
setSubscript(bool) - Method in class EasyXLS.Drawings.ExcelComment: Sets the subscript option of the comment.
setSubscript(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the subscript setting of the font.
setSubscript(bool) - Method in class EasyXLS.ExcelCell: Sets the subscript option of the cell font.
setSubscript(bool) - Method in class EasyXLS.ExcelColumn: Sets the subscript option of the column font.
setSubscript(bool) - Method in class EasyXLS.ExcelRow: Sets the subscript option of the row font.
setSubscript(bool) - Method in class EasyXLS.ExcelStyle: Sets the subscript option of the style font.
setSubscript(bool, int) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the subscript setting of the font.
This method is overridden as setSubscript_2 in COM+ version of EasyXLS.
setSubtotal(int) - Method in class EasyXLS.PivotTables.ExcelValueField: Sets the subtotal applied on the value field.
setSubtotalFilteredPageItems(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the pivot table includes or excludes report-filtered items in subtotal.
setSummaryInformation(SummaryInformation) - Method in class EasyXLS.ExcelDocument: Sets the summary information of an Excel document.
setSuperscript(bool) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setSuperscript(bool)
setSuperscript(bool) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setSuperscript(bool)
setSuperscript(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setSuperscript(bool)
setSuperscript(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setSuperscript(bool)
setSuperscript(bool) - Method in class EasyXLS.Drawings.ExcelComment: Sets the superscript option of the comment.
setSuperscript(bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the superscript setting of the font.
setSuperscript(bool) - Method in class EasyXLS.ExcelCell: Sets the superscript option of the cell font.
setSuperscript(bool) - Method in class EasyXLS.ExcelColumn: Sets the superscript option of the column font.
setSuperscript(bool) - Method in class EasyXLS.ExcelRow: Sets the superscript option of the row font.
setSuperscript(bool) - Method in class EasyXLS.ExcelStyle: Sets the superscript option of the style font.
setSuperscript(bool, int) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the superscript setting of the font.
This method is overridden as setSuperscript_2 in COM+ version of EasyXLS.
setTabColor(ThemeColor) - Method in class EasyXLS.ExcelSheet: Sets the tab color.
This method is overridden as setTabColor_2 in COM+ version of EasyXLS.
setTabColor(Color) - Method in class EasyXLS.ExcelSheet: Sets the tab color.
setTableStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the table.
setTabularForm() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets the outline form for all the fields of the pivot table.
setText(String) - Method in class EasyXLS.Charts.ExcelTitle: Sets the text of the title.
setText(String) - Method in class EasyXLS.Drawings.ExcelComment: Sets the text of the comment.
setTextBackgroundDark1(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Text/Background-Dark 1 color.
setTextBackgroundDark2(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Text/Background-Dark 2 color.
setTextBackgroundLight1(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Text/Background-Light 1 color.
setTextBackgroundLight2(Color) - Method in class EasyXLS.Themes.ExcelColorScheme: Sets the Text/Background-Light 2 color.
setTextDirection(int) - Method in class EasyXLS.ExcelCell: Sets the text direction of the cell.
setTextDirection(int) - Method in class EasyXLS.ExcelColumn: Sets the text direction of the column.
setTextDirection(int) - Method in class EasyXLS.ExcelRow: Sets the text direction of the row.
setTextDirection(int) - Method in class EasyXLS.ExcelStyle: Sets the text direction of the style.
setTextDirectionHorizontal(String, int) - Method in class EasyXLS.Drawings.Formatting.AlignmentFormat: Sets a horizontal text direction having the specified vertical alignment and text angle.
setTextDirectionRotate270Degrees(String) - Method in class EasyXLS.Drawings.Formatting.AlignmentFormat: Sets a rotation of 270 degrees and the horizontal alignment for the text.
setTextDirectionRotate90Degrees(String) - Method in class EasyXLS.Drawings.Formatting.AlignmentFormat: Sets a rotation of 90 degrees and the horizontal alignment for the text.
setTextDirectionStacked(String, bool) - Method in class EasyXLS.Drawings.Formatting.AlignmentFormat: Sets a stacked text direction having the specified horizontal alignment.
setTextMark(String) - Method in class EasyXLS.ExcelHyperlink: Sets the text mark value.
setTextRotation(int) - Method in class EasyXLS.ExcelCell: Sets the text rotation of the cell.
setTextRotation(int) - Method in class EasyXLS.ExcelColumn: Sets the text rotation of the column.
setTextRotation(int) - Method in class EasyXLS.ExcelRow: Sets the text rotation of the row.
setTextRotation(int) - Method in class EasyXLS.ExcelStyle: Sets the text rotation of the style.
setTextureFill(int) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets a predefined texture for the shape.
setTheme(ExcelTheme) - Method in class EasyXLS.ExcelDocument: Sets the theme for an Office 2007 or later Excel document.
setTheme(String) - Method in class EasyXLS.ExcelDocument: Sets a built-in theme for an Office 2007 or later Excel document.
setTickMarkLabel(int) - Method in class EasyXLS.Charts.ExcelAxis: Sets the label of the tick mark.
setTickMarksFrequency(int) - Method in class EasyXLS.Charts.ExcelAxis: Sets the number of categories between tick marks.
setTilingOptions(float, float, float, float, String, String) - Method in class EasyXLS.Drawings.Formatting.FillFormat: Sets the tiling options for the picture fill.
setTitle(String) - Method in class EasyXLS.FileProperties.SummaryInformation: Sets the title property.
setToolTip(String) - Method in class EasyXLS.ExcelHyperlink: Sets the tool tip text.
setTopBevel(String) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the type of the top bevel.
setTopBevelHeight(float) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the height of the top bevel.
setTopBevelWidth(float) - Method in class EasyXLS.Drawings.Formatting.Format3D: Sets the width of the top bevel.
setTopColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCell: Sets the color of the top border.
setTopColor_Border(ThemeColor) - Method in class EasyXLS.ExcelColumn: Sets the color of the top border.
This method is overridden as setTopColor_Border_2 in COM+ version of EasyXLS.
setTopColor_Border(ThemeColor) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting top border.
This method is overridden as setTopColor_Border_2 in COM+ version of EasyXLS.
setTopColor_Border(ThemeColor) - Method in class EasyXLS.ExcelRow: Sets the color of the top border.
This method is overridden as setTopColor_Border_2 in COM+ version of EasyXLS.
setTopColor_Border(ThemeColor) - Method in class EasyXLS.ExcelStyle: Sets the color of the top border.
This method is overridden as setTopColor_Border_2 in COM+ version of EasyXLS.
setTopColor_Border(Color) - Method in class EasyXLS.ExcelCell: Sets the color of the top border.
setTopColor_Border(Color) - Method in class EasyXLS.ExcelColumn: Sets the color of the top border.
setTopColor_Border(Color) - Method in class EasyXLS.ExcelCondition: Sets the color of the conditional formatting top border.
setTopColor_Border(Color) - Method in class EasyXLS.ExcelRow: Sets the color of the top border.
setTopColor_Border(Color) - Method in class EasyXLS.ExcelStyle: Sets the color of the top border.
setTopLeftCellStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the top left cell.
setTopMargin(double) - Method in class EasyXLS.ExcelPageSetup: Sets the top margin of the paper.
setTopRightCellStyle(ExcelStyle) - Method in class EasyXLS.ExcelAutoFormat: Sets the style of the top right cell.
setTopStyle_Border(int) - Method in class EasyXLS.ExcelCell: Sets the style of the top border.
setTopStyle_Border(int) - Method in class EasyXLS.ExcelColumn: Sets the style of the top border.
setTopStyle_Border(int) - Method in class EasyXLS.ExcelCondition: Sets the style of the conditional formatting top border.
setTopStyle_Border(int) - Method in class EasyXLS.ExcelRow: Sets the style of the top border.
setTopStyle_Border(int) - Method in class EasyXLS.ExcelStyle: Sets the style of the top border.
setTransparency(int) - Method in class EasyXLS.Drawings.Formatting.ShadowFormat: Sets the transparency of the shadow.
setUnderlineSettings(String, bool) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the underline settings of the text.
setUnderlineSettings(String, ThemeColor) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the underline settings of the text.
This method is overridden as setUnderlineSettings_3 in COM+ version of EasyXLS.
setUnderlineSettings(String, Color) - Method in class EasyXLS.Drawings.Formatting.FontFormat: Sets the underline settings of the text.
This method is overridden as setUnderlineSettings_2 in COM+ version of EasyXLS.
setUnderlineStyle(int) - Method in class EasyXLS.Charts.ExcelAxis: Deprecated.
As of version 8.3, replaced by FontFormat.setUnderlineSettings(String,bool)
setUnderlineStyle(int) - Method in class EasyXLS.Charts.ExcelChartArea: Deprecated.
As of version 8.3, replaced by FontFormat.setUnderlineSettings(String,bool)
setUnderlineStyle(int) - Method in class EasyXLS.Charts.ExcelChartLegend: Deprecated.
As of version 8.3, replaced by FontFormat.setUnderlineSettings(String,bool)
setUnderlineStyle(int) - Method in class EasyXLS.Charts.ExcelDataTable: Deprecated.
As of version 8.3, replaced by FontFormat.setUnderlineSettings(String,bool)
setUnderlineStyle(int) - Method in class EasyXLS.Drawings.ExcelComment: Sets the underline style of the comment text.
setUnderlineStyle(int) - Method in class EasyXLS.ExcelCell: Sets the underline style of the cell font.
setUnderlineStyle(int) - Method in class EasyXLS.ExcelColumn: Sets the underline style of the column font.
setUnderlineStyle(int) - Method in class EasyXLS.ExcelCondition: Sets the underline style of the conditional formatting font.
setUnderlineStyle(int) - Method in class EasyXLS.ExcelRow: Sets the underline style of the row font.
setUnderlineStyle(int) - Method in class EasyXLS.ExcelStyle: Sets the underline style of the style font.
setURL(String) - Method in class EasyXLS.ExcelHyperlink: Sets the URL value.
setUseCustomListsWhenSorting(bool) - Method in class EasyXLS.PivotTables.ExcelPivotTable: Sets if the custom lists are used when Excel sorts lists.
setValidationType(int) - Method in class EasyXLS.ExcelDataValidator: Sets the validation type.
setValue(String) - Method in class EasyXLS.ExcelCell: Sets the value of the cell.
setValues(String) - Method in class EasyXLS.Charts.ExcelSeries: Sets the values of the chart series.
setVariableColorsBySlice(bool) - Method in class EasyXLS.Charts.ExcelChart: Sets the color of slices to be variable.
setVerticalAlignment(String) - Method in class EasyXLS.ExcelCell: Sets the vertical alignment of the cell.
setVerticalAlignment(String) - Method in class EasyXLS.ExcelColumn: Sets the vertical alignment of the column.
setVerticalAlignment(String) - Method in class EasyXLS.ExcelRow: Sets the vertical alignment of the row.
setVerticalAlignment(String) - Method in class EasyXLS.ExcelStyle: Sets the vertical alignment of the style.
setVerticalLines(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Sets the visible value of the vertical data table grid lines.
setVisible(bool) - Method in class EasyXLS.Charts.ExcelAxis: Sets the visible setting of the chart axis.
setVisible(bool) - Method in class EasyXLS.Charts.ExcelChartGridlines: Sets the visible setting of the chart gridlines.
setVisible(bool) - Method in class EasyXLS.Charts.ExcelChartLegend: Sets the visible setting of the chart legend.
setVisible(bool) - Method in class EasyXLS.Charts.ExcelDataTable: Sets the visible setting of the chart data table.
setWidth(float) - Method in class EasyXLS.Drawings.Formatting.LineStyleFormat: Sets the width of the line.
setWidth(int) - Method in class EasyXLS.ExcelColumn: Sets the width of the column.
setWorkbookPassword(String) - Method in class EasyXLS.ExcelDocument: Sets the password of the document workbook.
setWorkbookProtection(bool, bool, String) - Method in class EasyXLS.ExcelDocument: Sets the protection options of the document workbook.
setWrap(bool) - Method in class EasyXLS.ExcelCell: Sets the wrap option of the cell.
setWrap(bool) - Method in class EasyXLS.ExcelColumn: Sets the wrap option of the column.
setWrap(bool) - Method in class EasyXLS.ExcelRow: Sets the wrap option of the row.
setWrap(bool) - Method in class EasyXLS.ExcelStyle: Sets the wrap option of the style.
setXAxisRotation(float) - Method in class EasyXLS.Drawings.Formatting.Rotation3D: Sets the rotation of the X axis.
setXF(int) - Method in class EasyXLS.ExcelCell: Internal use only
setXF(int) - Method in class EasyXLS.ExcelColumn: Internal use only
setXF(int) - Method in class EasyXLS.ExcelRow: Internal use only
setYAxisRotation(float) - Method in class EasyXLS.Drawings.Formatting.Rotation3D: Sets the rotation of the Y axis.
setZAxisRotation(float) - Method in class EasyXLS.Drawings.Formatting.Rotation3D: Sets the rotation of the Z axis.
setZoom(int) - Method in class EasyXLS.ExcelSheet: Sets the zoom of the sheet.
ShadowFormat - Class in EasyXLS.Drawings.Formatting: This class stores the shadow options for images, shapes and other drawing objects.
ShadowFormat() - Constructor for class EasyXLS.Drawings.Formatting.ShadowFormat: Defines an instance of the shadow formatting.
SheetCount() - Method in class EasyXLS.ExcelDocument: Returns the number of sheets in the workbook.
SheetNameFromCanonicalExpression(String) - Static method in class EasyXLS.Formula: Returns the original sheet name from a string that represents the sheet name in canonical expression.
SheetNameToCanonicalExpression(String) - Static method in class EasyXLS.Formula: Returns the sheet name in canonical expression.
SHOW_EMPTY_CELLS_AS_DATA_POINTS_CONNECTED_WITH_LINES - Constant in class EasyXLS.Constants.Chart: A constant indicating that the empty cells and its corresponding data points are connected with lines (interpolated) when the chart series is displayed.
SHOW_EMPTY_CELLS_AS_GAPS - Constant in class EasyXLS.Constants.Chart: A constant indicating that the empty cells are shown with gaps when the chart series is displayed.
SHOW_EMPTY_CELLS_AS_ZERO - Constant in class EasyXLS.Constants.Chart: A constant indicating that the empty cells are shown as zero when the chart series is displayed.
ShowBubbleSize() - Method in class EasyXLS.Charts.ExcelDataLabels: Returns true if the bubble size is shown in the data label, false otherwise.
ShowCategoryName() - Method in class EasyXLS.Charts.ExcelDataLabels: Returns true if the category name is shown in the data label, false otherwise.
ShowColumnHeaders() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the column headers in the banding style are displayed, false otherwise.
ShowColumnStripes() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if each column is alternated with a lighter and darker color, false otherwise.
ShowCompactForm() - Method in class EasyXLS.PivotTables.ExcelField: Returns true if the labels from the next field in the same column or compact form are displayed, false otherwise.
ShowContextualTooltips() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the tooltips that show value, row, or column information for a field or data value are visible, false otherwise.
ShowDataInHiddenRowColumns() - Method in class EasyXLS.Charts.ExcelChart: Returns true if data in hidden rows and columns is visible, false otherwise.
ShowDataLabels() - Method in class EasyXLS.Charts.ExcelSeries: Returns true if data labels are attached to the series, false otherwise.
ShowDrillButtons() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the expand/collapse buttons are visible, false otherwise.
ShowEmptyCells() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if a specific text is displayed in a cell instead of a blank cell, false otherwise.
ShowError() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if a specific text is displayed in a cell instead of the error message, false otherwise.
ShowGrandTotalsForColumns() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the pivot table contains grand totals for columns, false otherwise.
ShowGrandTotalsForRows() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the pivot table contains grand totals for rows, false otherwise.
ShowGridlines() - Method in class EasyXLS.ExcelWorksheet: Returns true if the gridlines are visible in a worksheet, false otherwise.
ShowHeaders() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the captions at the top of the pivot table report and filter drop-down arrows on column and row labels are visible, false otherwise.
ShowItemLabelsInOutlineForm() - Method in class EasyXLS.PivotTables.ExcelField: Returns true if the field items are displayed in outline form, false if the field items are displayed in tabular form.
ShowItemLabelsInTabularForm() - Method in class EasyXLS.PivotTables.ExcelField: Returns true if the field items are displayed in tabular form, false if the field items are displayed in outline form.
ShowItemsWithNoData() - Method in class EasyXLS.PivotTables.ExcelField: Returns true if the items with no data are displayed, false otherwise.
ShowLeaderLines() - Method in class EasyXLS.Charts.ExcelDataLabels: Returns true if the leader lines are shown, false otherwise.
ShowNegativeBubbles() - Method in class EasyXLS.Charts.ExcelChart: Returns true if the negative bubbles are visible, false otherwise.
ShowPercentage() - Method in class EasyXLS.Charts.ExcelDataLabels: Returns true if the percentage is shown in the data label, false otherwise.
ShowRowHeaders() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the row headers in the banding style are displayed, false otherwise.
ShowRowStripes() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if each row is alternated with a lighter and darker color, false otherwise.
ShowSeriesName() - Method in class EasyXLS.Charts.ExcelDataLabels: Returns true if the series name is shown in the data label, false otherwise.
ShowSubtotalFilteredPageItems() - Method in class EasyXLS.PivotTables.ExcelPivotTable: Returns true if the pivot table includes or excludes report-filtered items in subtotals, false otherwise.
ShowSubtotalsOnTop() - Method in class EasyXLS.PivotTables.ExcelField: Returns true if the subtotals at the top of each group are displayed, false otherwise.
ShowValue() - Method in class EasyXLS.Charts.ExcelDataLabels: Returns true if the value is shown in the data label, false otherwise.
size() - Method in class EasyXLS.Util.List: Returns the number of elements in this list
SORT_A_TO_Z - Constant in class EasyXLS.Constants.PivotTable: Ascending order from A to Z.
SORT_IN_DATA_SOURCE_ORDER - Constant in class EasyXLS.Constants.PivotTable: Sort order according to data source order.
SORT_MANUAL - Constant in class EasyXLS.Constants.PivotTable: Manual order.
SORT_Z_TO_A - Constant in class EasyXLS.Constants.PivotTable: Descending order from Z to A.
SPACING_TYPE_CONDENSED - Constant in class EasyXLS.Drawings.Formatting.FontFormat: A constant indicating a condensed character spacing.
SPACING_TYPE_EXPANDED - Constant in class EasyXLS.Drawings.Formatting.FontFormat: A constant indicating an extended character spacing.
SPACING_TYPE_NORMAL - Constant in class EasyXLS.Drawings.Formatting.FontFormat: A constant indicating a normal character spacing.
SPLIT_BY_PERCENTAGE_VALUE - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series is splited by percentage value.
SPLIT_BY_POSITION - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series is splited by position.
SPLIT_BY_VALUE - Constant in class EasyXLS.Constants.Chart: A constant indicating that the series is splited by value.
splitSeriesByPercentageValue(int) - Method in class EasyXLS.Charts.ExcelChart: Splits the series by a percentage value and sets that the second plot contains all values less than the specified percentage value.
splitSeriesByPosition(int) - Method in class EasyXLS.Charts.ExcelChart: Splits the series by position and sets the number of last values for the second plot.
splitSeriesByValue(double) - Method in class EasyXLS.Charts.ExcelChart: Splits the series by value and sets that the second plot contains all values less than the specified value.
STRING - Constant in class EasyXLS.Constants.DataType: A constant indicating the string data type.
STYLE_ACCOUNTING2_FOOTER - Constant in class EasyXLS.Constants.Styles: The footer style of the Accounting 2 autoformat.
STYLE_ACCOUNTING2_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the Accounting 2 autoformat.
STYLE_CLASSIC1_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the Classic 1 autoformat.
STYLE_CLASSIC2_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the Classic 2 autoformat.
STYLE_CLASSIC3_FOOTER - Constant in class EasyXLS.Constants.Styles: The footer style of the Classic 3 autoformat.
STYLE_CLASSIC3_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the Classic 3 autoformat.
STYLE_DEFAULT - Constant in class EasyXLS.Constants.Styles: The default style for the columns and cells.
STYLE_EASYXLS_DATA - Constant in class EasyXLS.Constants.Styles: The cell style of the EasyXLS 1,2,3 autoformats.
STYLE_EASYXLS1_FOOTER - Constant in class EasyXLS.Constants.Styles: The footer style of the EasyXLS 1 autoformat.
STYLE_EASYXLS1_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the EasyXLS 1 autoformat.
STYLE_EASYXLS2_FOOTER - Constant in class EasyXLS.Constants.Styles: The footer style of the EasyXLS 2 autoformat.
STYLE_EASYXLS2_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the EasyXLS 2 autoformat.
STYLE_LIST2_FOOTER - Constant in class EasyXLS.Constants.Styles: The footer style of the List 2 autoformat.
STYLE_LIST2_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the List 2 autoformat.
STYLE_SIMPLE_FOOTER - Constant in class EasyXLS.Constants.Styles: The footer style of the simple autoformat.
STYLE_SIMPLE_HEADER - Constant in class EasyXLS.Constants.Styles: The header style of the simple autoformat.
Styles - Class in EasyXLS.Constants: This class contains predefined styles for formatting cells.
Styles() - Constructor for class EasyXLS.Constants.Styles
SUBTOTAL_AUTOMATIC - Constant in class EasyXLS.Constants.PivotTable: Automatic subtotal for a pivot table field.
SUBTOTAL_AVERAGE - Constant in class EasyXLS.Constants.PivotTable: Average subtotal for a pivot table field.
SUBTOTAL_COUNT - Constant in class EasyXLS.Constants.PivotTable: Count subtotal for a pivot table field.
SUBTOTAL_COUNTA - Constant in class EasyXLS.Constants.PivotTable: CountA subtotal for a pivot table field.
SUBTOTAL_MAX - Constant in class EasyXLS.Constants.PivotTable: Max subtotal for a pivot table field.
SUBTOTAL_MIN - Constant in class EasyXLS.Constants.PivotTable: Min subtotal for a pivot table field.
SUBTOTAL_NONE - Constant in class EasyXLS.Constants.PivotTable: A constant indicating that no subtotal is applied for a pivot table field.
SUBTOTAL_PRODUCT - Constant in class EasyXLS.Constants.PivotTable: Product subtotal for a pivot table field.
SUBTOTAL_STDEV - Constant in class EasyXLS.Constants.PivotTable: StdDev subtotal for a pivot table field.
SUBTOTAL_STDEVP - Constant in class EasyXLS.Constants.PivotTable: StdDevP subtotal for a pivot table field.
SUBTOTAL_SUM - Constant in class EasyXLS.Constants.PivotTable: Sum subtotal for a pivot table field.
SUBTOTAL_VAR - Constant in class EasyXLS.Constants.PivotTable: Var subtotal for a pivot table field.
SUBTOTAL_VARP - Constant in class EasyXLS.Constants.PivotTable: VarP subtotal for a pivot table field.
SubtotalCount() - Method in class EasyXLS.PivotTables.ExcelField: Returns the number of subtotals for the pivot table field.
SUM_VALUES_FIELD - Constant in class EasyXLS.Constants.PivotTable: A constant indicating the summarization special field.
SummaryInformation - Class in EasyXLS.FileProperties: This class stores the properties of the summary information of the document like author, last author, application name, create date, comments, keywords, revision number, subject, title.
SummaryInformation() - Constructor for class EasyXLS.FileProperties.SummaryInformation: Defines an instance of the summary information with the following default properties: author, last author, application name, create date, comments.

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