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

S

SERIES_DATA_LABELS_NONE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series data labels show type is none.

SERIES_DATA_LABELS_SHOW_BUBBLE_SIZE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series data labels show type is bubble size.

SERIES_DATA_LABELS_SHOW_LABEL - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series data labels show type is label.

SERIES_DATA_LABELS_SHOW_LABEL_AND_PERCENT - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series data labels show type is label and percent.

SERIES_DATA_LABELS_SHOW_PERCENT - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series data labels show type is percent.

SERIES_DATA_LABELS_SHOW_VALUE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series data labels show type is value.

SERIES_IN_COLUMNS - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series is in columns.

SERIES_IN_ROWS - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series is in rows.

SERIES_MARKER_AUTOMATIC - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is automatic.

SERIES_MARKER_CIRCLE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is circle.

SERIES_MARKER_DIAMOND - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is diamond.

SERIES_MARKER_DOW_JONES - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is Dow Jones.

SERIES_MARKER_NONE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is none.

SERIES_MARKER_PLUS_SIGN - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is plus sign.

SERIES_MARKER_SQUARE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is square.

SERIES_MARKER_STANDARD_DEVIATION - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is standard deviation.

SERIES_MARKER_STAR - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is star.

SERIES_MARKER_TRIANGLE - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is triangle.

SERIES_MARKER_X - Constant in class ActiveXLS.Constants.Chart

A constant indicating that the series marker type is X.

STRING - Constant in class ActiveXLS.Constants.DataType

A constant indicating the string data type.

STYLE_ACCOUNTING2_FOOTER - Constant in class ActiveXLS.Constants.Styles

The footer style of the Accounting 2 autoformat.

STYLE_ACCOUNTING2_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the Accounting 2 autoformat.

STYLE_ACTIVEXLS1_FOOTER - Constant in class ActiveXLS.Constants.Styles

The footer style of the ActiveXLS 1 autoformat.

STYLE_ACTIVEXLS1_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the ActiveXLS 1 autoformat.

STYLE_ACTIVEXLS2_FOOTER - Constant in class ActiveXLS.Constants.Styles

The footer style of the ActiveXLS 2 autoformat.

STYLE_ACTIVEXLS2_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the ActiveXLS 2 autoformat.

STYLE_ACTIVEXLS_DATA - Constant in class ActiveXLS.Constants.Styles

The cell style of the ActiveXLS 1,2,3 autoformats.

STYLE_CLASSIC1_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the Classic 1 autoformat.

STYLE_CLASSIC2_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the Classic 2 autoformat.

STYLE_CLASSIC3_FOOTER - Constant in class ActiveXLS.Constants.Styles

The footer style of the Classic 3 autoformat.

STYLE_CLASSIC3_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the Classic 3 autoformat.

STYLE_DEFAULT - Constant in class ActiveXLS.Constants.Styles

The default style for the columns and cells.

STYLE_LIST2_FOOTER - Constant in class ActiveXLS.Constants.Styles

The footer style of the List 2 autoformat.

STYLE_LIST2_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the List 2 autoformat.

STYLE_SIMPLE_FOOTER - Constant in class ActiveXLS.Constants.Styles

The footer style of the simple autoformat.

STYLE_SIMPLE_HEADER - Constant in class ActiveXLS.Constants.Styles

The header style of the simple autoformat.

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

Returns the number of series in the chart.

SheetCount() - Method in class ActiveXLS.ExcelDocument

Returns the number of sheets in the workbook.

SheetNameFromCanonicalExpression(String) - Static method in class ActiveXLS.Formula

Returns the original sheet name from a string that represents the sheet name in canonical expression.

SheetNameToCanonicalExpression(String) - Static method in class ActiveXLS.Formula

Returns the sheet name in canonical expression.

Styles - class ActiveXLS.Constants.Styles.

This class contains predefined styles for formatting cells.

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

SummaryInformation - class ActiveXLS.FileProperties.SummaryInformation.

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 ActiveXLS.FileProperties.SummaryInformation

Defines an instance of the summary information with the following default properties: author, last author, application name, create date, comments.

setApplicationName(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the application name property.

setAuthor(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the author property.

setAutoFormat(ExcelAutoFormat) - Method in class ActiveXLS.ExcelDataGroup

Sets the autoformat to be applied for the data group.

setAutoResize(bool) - Method in class ActiveXLS.ExcelRow

Sets the automatic calculation of the row height.

setAutomaticCategoryAxisCrossesValue(bool) - Method in class ActiveXLS.Charts.ExcelAxis

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

setAutomaticMajorUnit(bool) - Method in class ActiveXLS.Charts.ExcelAxis

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

setAutomaticMaximumValue(bool) - Method in class ActiveXLS.Charts.ExcelAxis

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

setAutomaticMinimumValue(bool) - Method in class ActiveXLS.Charts.ExcelAxis

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

setAutomaticMinorUnit(bool) - Method in class ActiveXLS.Charts.ExcelAxis

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

setBSEImage(BSE) - Method in class ActiveXLS.ExcelImage

Internal use only Sets the BSE record.

setBackground(Color) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the background color of the chart area.

setBackground(Color) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the background color of the chart legend.

setBackground(Color) - Method in class ActiveXLS.Charts.ExcelPlotArea

Sets the background color of the chart plot area.

setBackground(Color) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the background color of the chart series.

setBackground(Color) - Method in class ActiveXLS.ExcelCell

Sets the background color of the cell.

setBackground(Color) - Method in class ActiveXLS.ExcelColumn

Sets the background color of the column.

setBackground(Color) - Method in class ActiveXLS.ExcelCondition

Sets the color of the conditional formatting background.

setBackground(Color) - Method in class ActiveXLS.ExcelRow

Sets the background color of the row.

setBackground(Color) - Method in class ActiveXLS.ExcelStyle

Sets the background color of the style.

setBold(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the bold setting of the chart axis font.

setBold(bool) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the bold setting of the chart area font.

setBold(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the bold setting of the chart legend font.

setBold(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the bold setting of the chart axis data table.

setBold(bool) - Method in class ActiveXLS.ExcelCell

Sets the bold option of the cell font.

setBold(bool) - Method in class ActiveXLS.ExcelColumn

Sets the bold option of the column font.

setBold(bool) - Method in class ActiveXLS.ExcelComment

Sets the bold option of the comment text.

setBold(bool) - Method in class ActiveXLS.ExcelCondition

Sets the bold setting of the conditional formatting font.

setBold(bool) - Method in class ActiveXLS.ExcelRow

Sets the bold option of the row font.

setBold(bool) - Method in class ActiveXLS.ExcelStyle

Sets the bold option of the style font.

setBorderColor(Color) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the color of the chart area border.

setBorderColor(Color) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the color of the chart legend border.

setBorderColor(Color) - Method in class ActiveXLS.Charts.ExcelPlotArea

Sets the color of the chart plot area border.

setBorderColors(Color, Color, Color, Color) - Method in class ActiveXLS.ExcelCell

Sets the border colors of the cell.

setBorderColors(Color, Color, Color, Color) - Method in class ActiveXLS.ExcelColumn

Sets the border colors of the column.

setBorderColors(Color, Color, Color, Color) - Method in class ActiveXLS.ExcelCondition

Sets the color of the conditional formatting borders.

setBorderColors(Color, Color, Color, Color) - Method in class ActiveXLS.ExcelRow

Sets the border colors of the row.

setBorderColors(Color, Color, Color, Color) - Method in class ActiveXLS.ExcelStyle

Sets the border colors of the style.

setBorderStyle(int) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the style of the chart area border.

setBorderStyle(int) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the style of the chart legend border.

setBorderStyle(int) - Method in class ActiveXLS.Charts.ExcelPlotArea

Sets the style of the chart plot area border.

setBorderStyles(int, int, int, int) - Method in class ActiveXLS.ExcelCell

Sets the border styles of the cell.

setBorderStyles(int, int, int, int) - Method in class ActiveXLS.ExcelColumn

Sets the border styles of the column.

setBorderStyles(int, int, int, int) - Method in class ActiveXLS.ExcelCondition

Sets the style of the conditional formatting borders.

setBorderStyles(int, int, int, int) - Method in class ActiveXLS.ExcelRow

Sets the border styles of the row.

setBorderStyles(int, int, int, int) - Method in class ActiveXLS.ExcelStyle

Sets the border styles of the style.

setBorderWeight(int) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the weight of the chart area border.

setBorderWeight(int) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the weight of the chart legend border.

setBorderWeight(int) - Method in class ActiveXLS.Charts.ExcelPlotArea

Sets the weight of the chart plot area border.

setBottomColor_Border(Color) - Method in class ActiveXLS.ExcelCell

Sets the color of the bottom border.

setBottomColor_Border(Color) - Method in class ActiveXLS.ExcelColumn

Sets the color of the bottom border.

setBottomColor_Border(Color) - Method in class ActiveXLS.ExcelCondition

Sets the color of the conditional formatting bottom border.

setBottomColor_Border(Color) - Method in class ActiveXLS.ExcelRow

Sets the color of the bottom border.

setBottomColor_Border(Color) - Method in class ActiveXLS.ExcelStyle

Sets the color of the bottom border.

setBottomLeftCellStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the bottom left cell.

setBottomMargin(double) - Method in class ActiveXLS.ExcelPageSetup

Sets the bottom margin of the paper.

setBottomRightCellStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the bottom right cell.

setBottomStyle_Border(int) - Method in class ActiveXLS.ExcelCell

Sets the style of the bottom border.

setBottomStyle_Border(int) - Method in class ActiveXLS.ExcelColumn

Sets the style of the bottom border.

setBottomStyle_Border(int) - Method in class ActiveXLS.ExcelCondition

Sets the style of the conditional formatting bottom border.

setBottomStyle_Border(int) - Method in class ActiveXLS.ExcelRow

Sets the style of the bottom border.

setBottomStyle_Border(int) - Method in class ActiveXLS.ExcelStyle

Sets the style of the bottom border.

setBuildInName(bool) - Method in class ActiveXLS.ExcelName

Internal use only

setCalculateFormulas(bool) - Method in class ActiveXLS.ExcelOptions

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

setCapacity(int) - Method in class ActiveXLS.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.

setCategory(String) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Sets the category property.

setCenterHorizontally(bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the center horizontally option for the page.

setCenterVertically(bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the center vertically option for the page.

setCollapsed(bool) - Method in class ActiveXLS.ExcelColumn

Internal use only

setCollapsed(bool) - Method in class ActiveXLS.ExcelDataGroup

Sets if the data group is collapsed or expanded.

setCollapsed(bool) - Method in class ActiveXLS.ExcelRow

Internal use only

setColumnCount(int) - Method in class ActiveXLS.ExcelTable

Sets the number of columns for the table.

setColumnMaxOutlineLevel(int) - Method in class ActiveXLS.ExcelWorksheet

Sets the the highest number of outline levels for columns in this sheet.

setColumnWidth(int) - Method in class ActiveXLS.ExcelTable

Sets the default width of the columns.

setColumnWidth(int, int) - Method in class ActiveXLS.ExcelTable

Sets the width for the specified column.

setComment(ExcelComment) - Method in class ActiveXLS.ExcelCell

Sets the comment of the cell.

setComment(String) - Method in class ActiveXLS.ExcelCell

Sets the comment of the cell having the specified text.

setComment(String, int, int) - Method in class ActiveXLS.ExcelCell

Sets the comment of the cell having the specified text and size.

setComment(String, String, int, bool, bool, Color) - Method in class ActiveXLS.ExcelCell

Sets the comment of the cell having the specified text and font settings.

setComments(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the comments property.

setCompanyName(String) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Sets the company name property.

setConditionType(int) - Method in class ActiveXLS.ExcelCondition

Sets the conditional formatting type.

setCrossValue(double) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the crosses value of the axis.

setCrossedBetweenCategories(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the flag true if the axis crosses between categories, or false if it does not.

setCurrentSheet(int) - Method in class ActiveXLS.ExcelDocument

Sets the current sheet displayed when the document is loaded in Microsoft Excel.

setCustomProperty(String, long, String) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Adds or sets a custom property.

setDataGroupAutomaticStyles(bool) - Method in class ActiveXLS.ExcelWorksheet

Sets the automatic style option when grouping data.

setDataGroupSummaryColumnsRight(bool) - Method in class ActiveXLS.ExcelWorksheet

Sets the summary columns to right of detail option when grouping data.

setDataGroupSummaryRowsBelow(bool) - Method in class ActiveXLS.ExcelWorksheet

Sets the summary rows below detail option when grouping data.

setDataLabels(int) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the data labels type of the chart series.

setDataType(String) - Method in class ActiveXLS.ExcelCell

Sets the data type of the cell.

setDataType(String) - Method in class ActiveXLS.ExcelColumn

Sets the data type of the column.

setDataType(String) - Method in class ActiveXLS.ExcelRow

Sets the data type of the row.

setDataType(String) - Method in class ActiveXLS.ExcelStyle

Sets the data type of the style.

setDescription(String) - Method in class ActiveXLS.ExcelHyperlink

Sets the text that is shown in the table instead of the URL.

setDocumentSummaryInformation(DocumentSummaryInformation) - Method in class ActiveXLS.ExcelDocument

Sets the document summary information of an Excel document.

setElementAt(Object, int) - Method in class ActiveXLS.Util.List

Sets the element at the specified index to be the specified object The previous element at that position is discarded

setErrorAlert(String, String) - Method in class ActiveXLS.ExcelDataValidator

Sets the title and the message of the "Error Alert"

setErrorStyle(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the "Error Alert" box style.

setErrorText(String) - Method in class ActiveXLS.ExcelDataValidator

Sets the message of the "Error Alert"

setErrorTitle(String) - Method in class ActiveXLS.ExcelDataValidator

Sets the title of the "Error Alert"

setEvenColumnStripesStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the even columns.

setEvenRowStripesStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the even rows.

setFirstColumn(int) - Method in class ActiveXLS.ExcelConditionalFormatting

Sets the first column of the cell range where the conditional formatting will be applied.

setFirstColumn(int) - Method in class ActiveXLS.ExcelDataGroup

Sets the first column of the cell range where the data group is located.

setFirstColumn(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the first column of the cell range where the validation will be applied.

setFirstColumn(int) - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

setFirstFormula(String) - Method in class ActiveXLS.ExcelCondition

Sets the conditional formatting first formula.

setFirstFormula(String) - Method in class ActiveXLS.ExcelDataValidator

Sets the expression of the first formula.

setFirstPageNumber(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the starting page number.

setFirstRow(int) - Method in class ActiveXLS.ExcelConditionalFormatting

Sets the first row of the cell range where the conditional formatting will be applied.

setFirstRow(int) - Method in class ActiveXLS.ExcelDataGroup

Sets the first row of the cell range where the data group is located.

setFirstRow(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the first row of the cell range where the validation will be applied.

setFirstRow(int) - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

setFitToPagesHeight(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the number of pages to fit in the page height.

setFitToPagesWidth(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the number of pages to fit in the page width.

setFont(String) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the chart axis font name.

setFont(String) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the chart area font name.

setFont(String) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the chart legend font name.

setFont(String) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the chart data table font name.

setFont(String) - Method in class ActiveXLS.ExcelCell

Sets the name of the cell font.

setFont(String) - Method in class ActiveXLS.ExcelColumn

Sets the name of the column font.

setFont(String) - Method in class ActiveXLS.ExcelComment

Sets the font name of the comment text.

setFont(String) - Method in class ActiveXLS.ExcelRow

Sets the name of the row font.

setFont(String) - Method in class ActiveXLS.ExcelStyle

Sets the name of the style font.

setFontSettings(String, int, bool, bool, Color) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the font settings.

setFontSettings(String, int, bool, bool, Color) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the font settings.

setFontSettings(String, int, bool, bool, Color) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the font settings.

setFontSettings(String, int, bool, bool, Color) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the font settings.

setFontSize(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the size of the chart axis font.

setFontSize(int) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the size of the chart area font.

setFontSize(int) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the size of the chart legend font.

setFontSize(int) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the size of the chart data table font.

setFontSize(int) - Method in class ActiveXLS.ExcelCell

Sets the size of the cell font.

setFontSize(int) - Method in class ActiveXLS.ExcelColumn

Sets the size of the column font.

setFontSize(int) - Method in class ActiveXLS.ExcelComment

Sets the font size of the comment text.

setFontSize(int) - Method in class ActiveXLS.ExcelRow

Sets the size of the row font.

setFontSize(int) - Method in class ActiveXLS.ExcelStyle

Sets the size of the style font.

setFooterMargin(double) - Method in class ActiveXLS.ExcelPageSetup

Sets the footer margin of the paper.

setFooterRowStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the footer row.

setFooterString(String) - Method in class ActiveXLS.ExcelFooter

Sets the footer expression.

setForeground(Color) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the foreground color of the chart axis.

setForeground(Color) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the foreground color of the chart area.

setForeground(Color) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the foreground color of the chart legend.

setForeground(Color) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the font color of the chart data table.

setForeground(Color) - Method in class ActiveXLS.ExcelCell

Sets the foreground color of the cell.

setForeground(Color) - Method in class ActiveXLS.ExcelColumn

Sets the foreground color of the column.

setForeground(Color) - Method in class ActiveXLS.ExcelComment

Sets the foreground of the comment text.

setForeground(Color) - Method in class ActiveXLS.ExcelCondition

Sets the foreground of the conditional formatting font.

setForeground(Color) - Method in class ActiveXLS.ExcelRow

Sets the foreground color of the row.

setForeground(Color) - Method in class ActiveXLS.ExcelStyle

Sets the foreground color of the style.

setFormat(String) - Method in class ActiveXLS.ExcelCell

Sets the number/date format of the cell.

setFormat(String) - Method in class ActiveXLS.ExcelColumn

Sets the number/date format of the column.

setFormat(String) - Method in class ActiveXLS.ExcelRow

Sets the number/date format of the row.

setFormat(String) - Method in class ActiveXLS.ExcelStyle

Sets the number/date format of the style.

setFormula(String) - Method in class ActiveXLS.ExcelArrayFormula

Sets the formula of the array.

setFreezePaneSet(bool) - Method in class ActiveXLS.ExcelTable

Internal use only

setGroupType(int) - Method in class ActiveXLS.ExcelDataGroup

Sets the group per rows or columns option.

setHTMLValue(String) - Method in class ActiveXLS.ExcelCell

Sets the value of the cell using html tags.The html tags are used to set the rich text format in cells.

setHeaderMargin(double) - Method in class ActiveXLS.ExcelPageSetup

Sets the header margin of the paper.

setHeaderRowStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the header row.

setHeaderString(String) - Method in class ActiveXLS.ExcelHeader

Sets the header expression.

setHeight(int) - Method in class ActiveXLS.ExcelRow

Sets the height of the row.

setHidden(bool) - Method in class ActiveXLS.ExcelName

Sets the hidden option of the name.

setHidden(bool) - Method in class ActiveXLS.ExcelSheet

Sets the hidden option of the sheet.

setHiddenColumn(bool) - Method in class ActiveXLS.ExcelColumn

Sets the hidden option of the column.

setHiddenFormula(bool) - Method in class ActiveXLS.ExcelCell

Sets the hidden option of the cell.

setHiddenFormula(bool) - Method in class ActiveXLS.ExcelColumn

Sets the hidden option of the column.

setHiddenFormula(bool) - Method in class ActiveXLS.ExcelRow

Sets the hidden option of the row.

setHiddenFormula(bool) - Method in class ActiveXLS.ExcelStyle

Sets the hidden option of the style.

setHiddenRow(bool) - Method in class ActiveXLS.ExcelRow

Sets the hidden option of the row.

setHorizontalAlignment(String) - Method in class ActiveXLS.ExcelCell

Sets the horizontal alignment of the cell.

setHorizontalAlignment(String) - Method in class ActiveXLS.ExcelColumn

Sets the horizontal alignment of the column.

setHorizontalAlignment(String) - Method in class ActiveXLS.ExcelRow

Sets the horizontal alignment of the row.

setHorizontalAlignment(String) - Method in class ActiveXLS.ExcelStyle

Sets the horizontal alignment of the style.

setHorizontalLines(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the visible value of the horizontal data table grid lines.

setHyperlink(String, String) - Method in class ActiveXLS.ExcelHyperlink

Sets the type of the hyperlink and the URL value.

setHyperlinkBase(String) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Sets the hyperlink base property.

setHyperlinkType(String) - Method in class ActiveXLS.ExcelHyperlink

Sets the type of the hyperlink.

setIgnoreBlank(bool) - Method in class ActiveXLS.ExcelDataValidator

Sets the ignore blank option.

setImagePath(String) - Method in class ActiveXLS.ExcelImage

Sets the file path to image file.

setIndent(int) - Method in class ActiveXLS.ExcelCell

Sets the the indent of the cell.

setIndent(int) - Method in class ActiveXLS.ExcelColumn

Sets the the indent of the column.

setIndent(int) - Method in class ActiveXLS.ExcelRow

Sets the the indent of the row.

setIndent(int) - Method in class ActiveXLS.ExcelStyle

Sets the the indent of the style.

setInputMessage(String, String) - Method in class ActiveXLS.ExcelDataValidator

Sets the title and the message of the "Input Message"

setInputText(String) - Method in class ActiveXLS.ExcelDataValidator

Sets the message of the "Input Message"

setInputTitle(String) - Method in class ActiveXLS.ExcelDataValidator

Sets the title of the "Input Message"

setIsShowErrorBox(bool) - Method in class ActiveXLS.ExcelDataValidator

Sets the show "Error Alert" box option.

setIsShowInputBox(bool) - Method in class ActiveXLS.ExcelDataValidator

Sets the show "Input Message" box option.

setItalic(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the italic setting of the chart axis font.

setItalic(bool) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the italic setting of the chart area font.

setItalic(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the italic setting of the chart legend font.

setItalic(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the italic setting of the chart data table font.

setItalic(bool) - Method in class ActiveXLS.ExcelCell

Sets the italic option of the cell font.

setItalic(bool) - Method in class ActiveXLS.ExcelColumn

Sets the italic option of the column font.

setItalic(bool) - Method in class ActiveXLS.ExcelComment

Sets the italic option of the comment text.

setItalic(bool) - Method in class ActiveXLS.ExcelCondition

Sets the italic setting of the conditional formatting font.

setItalic(bool) - Method in class ActiveXLS.ExcelRow

Sets the italic option of the row font.

setItalic(bool) - Method in class ActiveXLS.ExcelStyle

Sets the italic option of the style font.

setKeysArrangementDirection(int) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the direction in which the keys will be arranged: vertical or horizontal.

setKeywords(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the keywords property.

setLabel(String) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the chart axis title.

setLabelFrequency(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the number of categories between tick-mark labels.

setLastColumn(int) - Method in class ActiveXLS.ExcelConditionalFormatting

Sets the last column of the cell range where the conditional formatting will be applied.

setLastColumn(int) - Method in class ActiveXLS.ExcelDataGroup

Sets the last column of the cell range where the data group is located.

setLastColumn(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the last column of the cell range where the validation will be applied.

setLastColumn(int) - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

setLastPrinted(Date) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the last printed property.

setLastRow(int) - Method in class ActiveXLS.ExcelConditionalFormatting

Sets the last row of the cell range where the conditional formatting will be applied.

setLastRow(int) - Method in class ActiveXLS.ExcelDataGroup

Sets the last row of the cell range where the data group is located.

setLastRow(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the last row of the cell range where the validation will be applied.

setLastRow(int) - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

setLastSavedBy(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the last author property.

setLastSavedDate(Date) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the date of last saved property.

setLeftColor_Border(Color) - Method in class ActiveXLS.ExcelCell

Sets the color of the left border.

setLeftColor_Border(Color) - Method in class ActiveXLS.ExcelColumn

Sets the color of the left border.

setLeftColor_Border(Color) - Method in class ActiveXLS.ExcelCondition

Sets the color of the conditional formatting left border.

setLeftColor_Border(Color) - Method in class ActiveXLS.ExcelRow

Sets the color of the left border.

setLeftColor_Border(Color) - Method in class ActiveXLS.ExcelStyle

Sets the color of the left border.

setLeftColumnStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the left column.

setLeftMargin(double) - Method in class ActiveXLS.ExcelPageSetup

Sets the left margin of the paper.

setLeftStyle_Border(int) - Method in class ActiveXLS.ExcelCell

Sets the style of the left border.

setLeftStyle_Border(int) - Method in class ActiveXLS.ExcelColumn

Sets the style of the left border.

setLeftStyle_Border(int) - Method in class ActiveXLS.ExcelCondition

Sets the style of the conditional formatting left border.

setLeftStyle_Border(int) - Method in class ActiveXLS.ExcelRow

Sets the style of the left border.

setLeftStyle_Border(int) - Method in class ActiveXLS.ExcelStyle

Sets the style of the left border.

setLeftUpperCorner(int, int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the left upper corner of the chart
This method is applicable only to adding charts to ExcelWorksheet objects

setLeftUpperCorner(String) - Method in class ActiveXLS.Charts.ExcelChart

Sets the left upper corner of the chart
This method is applicable only to adding charts to ExcelWorksheet objects

setLeftUpperCorner(int, int) - Method in class ActiveXLS.ExcelComment

Sets the left upper corner of the comment.

setLeftUpperCorner(String) - Method in class ActiveXLS.ExcelComment

Sets the left upper corner of the comment.

setLeftUpperCorner(int, int) - Method in class ActiveXLS.ExcelImage

Sets the left upper corner of the image
This method is applicable only to adding images to ExcelWorksheet objects

setLeftUpperCorner(String) - Method in class ActiveXLS.ExcelImage

Sets the left upper corner of the image
This method is applicable only to adding images to ExcelWorksheet objects

setLeftUpperOffset(int, int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the left upper corner offsets of the chart.

setLeftUpperOffset(int, int) - Method in class ActiveXLS.ExcelComment

Sets the left upper corner offsets of the comment.

setLeftUpperOffset(int, int) - Method in class ActiveXLS.ExcelImage

Sets the left upper corner offsets of the image.

setLegendKey(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the visibility of the data table legend key.

setLineColor(Color) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the line color of the chart axis.

setLineColor(Color) - Method in class ActiveXLS.Charts.ExcelChartGridlines

Sets the line color of the chart gridlines.

setLineColor(Color) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the color of the chart data table line.

setLineColor(Color) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the line color of the chart series.

setLineStyle(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the line style of the chart axis.

setLineStyle(int) - Method in class ActiveXLS.Charts.ExcelChartGridlines

Sets the line style of the chart gridlines.

setLineStyle(int) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the style of the chart data table line.

setLineStyle(int) - Method in class ActiveXLS.Charts.ExcelSeries

Returns the line style of the chart series.

setLineWeight(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the line weight of the chart axis.

setLineWeight(int) - Method in class ActiveXLS.Charts.ExcelChartGridlines

Sets the line weight of the chart gridlines.

setLineWeight(int) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the line weight of the chart data table.

setLineWeight(int) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the line weight of the chart series.

setLinksDirty(bool) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Sets the links dirty property.

setLocked(bool) - Method in class ActiveXLS.ExcelCell

Sets the locked option of the cell.

setLocked(bool) - Method in class ActiveXLS.ExcelColumn

Sets the locked option of the column.

setLocked(bool) - Method in class ActiveXLS.ExcelRow

Sets the locked option of the row.

setLocked(bool) - Method in class ActiveXLS.ExcelStyle

Sets the locked option of the style.

setLogarithmicScale(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the logarithmic scale.

setMajorTickMarkType(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the type of the major tick mark.

setMajorUnit(double) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the major unit of the value Y axis scale.

setManager(String) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Sets the manager property.

setMarkerType(int) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the marker type of the chart series.

setMaximumCross(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the flag true if the axis crosses at maximum value, or false if it does not.

setMaximumValue(double) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the maximum value of the value Y axis scale.

setMinimumValue(double) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the minimum value of the value Y axis scale.

setMinorTickMarkType(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the type of the minor tick mark.

setMinorUnit(double) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the minor unit of the value Y axis scale.

setName(String) - Method in class ActiveXLS.Charts.ExcelSeries

Returns the name of the chart series.

setNameText(String) - Method in class ActiveXLS.ExcelName

Sets the title of the name.

setNumberFormat(String) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the chart axis number format.

setNumberFormatLinked(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets if the number format of the chart axis is linked to the number format of the data source.

setOddColumnStripesStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the odd columns.

setOddRowStripesStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the odd rows.

setOperator(int) - Method in class ActiveXLS.ExcelCondition

Sets the conditional formatting operator.

setOperatorType(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the operator type.

setOrientation(String) - Method in class ActiveXLS.ExcelPageSetup

Sets the page orientation.

setOutlineLevel(int) - Method in class ActiveXLS.ExcelColumn

Internal use only

setOutlineLevel(int) - Method in class ActiveXLS.ExcelRow

Internal use only

setOutlineLines(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the visibility of the data table outline lines.

setPageBreakPreview(bool) - Method in class ActiveXLS.ExcelWorksheet

Sets the page break preview option for the worksheet.

setPageOrder(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the print page order.

setPaperSize(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the paper size.

setPattern(int) - Method in class ActiveXLS.ExcelCell

Sets the pattern of the cell.

setPattern(int) - Method in class ActiveXLS.ExcelColumn

Sets the pattern of the column.

setPattern(int) - Method in class ActiveXLS.ExcelRow

Sets the pattern of the row.

setPattern(int) - Method in class ActiveXLS.ExcelStyle

Sets the pattern of the style.

setPatternColor(Color) - Method in class ActiveXLS.ExcelCell

Sets the pattern color of the cell.

setPatternColor(Color) - Method in class ActiveXLS.ExcelColumn

Sets the pattern color of the column.

setPatternColor(Color) - Method in class ActiveXLS.ExcelRow

Sets the pattern color of the row.

setPatternColor(Color) - Method in class ActiveXLS.ExcelStyle

Sets the pattern color of the style.

setPlacement(int) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the placement setting (position) of the chart legend within the chart area.

setPosition(long, long, long, long) - Method in class ActiveXLS.Charts.ExcelAxis

Internal use only

setPosition(String) - Method in class ActiveXLS.ExcelFooter

Sets the position of the footer.

setPosition(String) - Method in class ActiveXLS.ExcelHeader

Sets the position of the header.

setPosition(int, int, int, int) - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

setPosition(String) - Method in class ActiveXLS.ExcelHyperlink

A hyperlink is set on a rectangular area that can contain more than one cell.

setPrintBlackAndWhite(bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the print black and white option for the page.

setPrintComments(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the print comments option for the page.

setPrintDraftQuality(bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the print draft quality option for the page.

setPrintGridlines(bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the print gridlines option for the page.

setPrintRowAndColumnHeadings(bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the print row and column headings option for the page.

setR1C1ReferenceStyle(bool) - Method in class ActiveXLS.ExcelOptions

Sets the R1C1 reference style of the document.

setRange(int, int, int, int) - Method in class ActiveXLS.ExcelConditionalFormatting

Sets the range where the conditional formatting is applied.

setRange(String) - Method in class ActiveXLS.ExcelConditionalFormatting

Sets the range where the conditional formatting is applied.

setRange(int, int, int, int) - Method in class ActiveXLS.ExcelDataGroup

Sets the area location of the data group.

setRange(String) - Method in class ActiveXLS.ExcelDataGroup

Sets the area location of the data group.

setRefersTo(String) - Method in class ActiveXLS.ExcelName

Sets the formula of the range.

setReverseOrder(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the values in reverse order.

setRevisionNumber(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the revision number property.

setRightColor_Border(Color) - Method in class ActiveXLS.ExcelCell

Sets the color of the right border.

setRightColor_Border(Color) - Method in class ActiveXLS.ExcelColumn

Sets the color of the right border.

setRightColor_Border(Color) - Method in class ActiveXLS.ExcelCondition

Sets the color of the conditional formatting right border.

setRightColor_Border(Color) - Method in class ActiveXLS.ExcelRow

Sets the color of the right border.

setRightColor_Border(Color) - Method in class ActiveXLS.ExcelStyle

Sets the color of the right border.

setRightColumnStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the right column.

setRightMargin(double) - Method in class ActiveXLS.ExcelPageSetup

Sets the right margin of the paper.

setRightStyle_Border(int) - Method in class ActiveXLS.ExcelCell

Sets the style of the right border.

setRightStyle_Border(int) - Method in class ActiveXLS.ExcelColumn

Sets the style of the right border.

setRightStyle_Border(int) - Method in class ActiveXLS.ExcelCondition

Sets the style of the conditional formatting right border.

setRightStyle_Border(int) - Method in class ActiveXLS.ExcelRow

Sets the style of the right border.

setRightStyle_Border(int) - Method in class ActiveXLS.ExcelStyle

Sets the style of the right border.

setRotationDegrees(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the rotation degrees of the chart axis.

setRowCount(int) - Method in class ActiveXLS.ExcelTable

Sets the number of rows for the table.

setRowHeight(int) - Method in class ActiveXLS.ExcelTable

Sets the default height of the rows.

setRowHeight(int, int) - Method in class ActiveXLS.ExcelTable

Sets the height for the specified row.

setRowHeightSet(bool) - Method in class ActiveXLS.ExcelTable

Internal use only

setRowMaxOutlineLevel(int) - Method in class ActiveXLS.ExcelWorksheet

Sets the the highest number of outline levels for rows in this sheet.

setScale(bool) - Method in class ActiveXLS.FileProperties.DocumentSummaryInformation

Sets the scale property.

setScalingFactor(int) - Method in class ActiveXLS.ExcelPageSetup

Sets the scaling factor.

setSecondFormula(String) - Method in class ActiveXLS.ExcelCondition

Sets the conditional formatting second formula.

setSecondFormula(String) - Method in class ActiveXLS.ExcelDataValidator

Sets the expression of the second formula.

setShadow(bool) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the shadow setting of the chart area.

setShadow(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the shadow setting of the chart legend.

setShadow(bool) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the shadow setting of the chart series.

setSheetIndex(int) - Method in class ActiveXLS.ExcelName

Internal use only

setSheetName(String) - Method in class ActiveXLS.ExcelSheet

Sets the name of the sheet.

setSheetProtected(bool) - Method in class ActiveXLS.ExcelSheet

Sets the protected option of the sheet.

setSheetSelected(bool) - Method in class ActiveXLS.ExcelSheet

Sets the selected option of the sheet.

setShowLegendKeyNextToLabel(bool) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the visibility of the legend key next to label of the series.

setShrink(bool) - Method in class ActiveXLS.ExcelCell

Sets the shrink option of the cell.

setShrink(bool) - Method in class ActiveXLS.ExcelColumn

Sets the shrink option of the column.

setShrink(bool) - Method in class ActiveXLS.ExcelRow

Sets the shrink option of the row.

setShrink(bool) - Method in class ActiveXLS.ExcelStyle

Sets the shrink option of the style.

setSize(int, int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart size.

setSize(int, int) - Method in class ActiveXLS.ExcelComment

Sets the comment size.

setSize(int, int) - Method in class ActiveXLS.ExcelImage

Sets the image size.

setSplitSet(bool) - Method in class ActiveXLS.ExcelTable

Internal use only

setStatus(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the status property.

setStrikethrough(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the strikethrough setting of the chart axis font.

setStrikethrough(bool) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the strikethrough setting of the chart area font.

setStrikethrough(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the strikethrough setting of the chart legend font.

setStrikethrough(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the strikethrough setting of the chart data table font.

setStrikethrough(bool) - Method in class ActiveXLS.ExcelCell

Sets the strikethrough option of the cell font.

setStrikethrough(bool) - Method in class ActiveXLS.ExcelColumn

Sets the strikethrough option of the column font.

setStrikethrough(bool) - Method in class ActiveXLS.ExcelCondition

Sets the strikethrough setting of the conditional formatting font.

setStrikethrough(bool) - Method in class ActiveXLS.ExcelRow

Sets the strikethrough option of the row font.

setStrikethrough(bool) - Method in class ActiveXLS.ExcelStyle

Sets the strikethrough option of the style font.

setStyle(ExcelStyle) - Method in class ActiveXLS.ExcelCell

Sets the style of the cell.

setStyle(ExcelStyle) - Method in class ActiveXLS.ExcelColumn

Sets the style of the column.

setStyle(ExcelStyle) - Method in class ActiveXLS.ExcelRow

Sets the style of the row.

setSubject(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the subject property.

setSubscript(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the subscript setting of the chart axis font.

setSubscript(bool) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the subscript setting of the chart area font.

setSubscript(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the subscript setting of the chart legend font.

setSubscript(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the subscript setting of the chart data table font.

setSubscript(bool) - Method in class ActiveXLS.ExcelCell

Sets the subscript option of the cell font.

setSubscript(bool) - Method in class ActiveXLS.ExcelColumn

Sets the subscript option of the column font.

setSubscript(bool) - Method in class ActiveXLS.ExcelRow

Sets the subscript option of the row font.

setSubscript(bool) - Method in class ActiveXLS.ExcelStyle

Sets the subscript option of the style font.

setSummaryInformation(SummaryInformation) - Method in class ActiveXLS.ExcelDocument

Sets the summary information of an Excel document.

setSuperscript(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the superscript setting of the chart axis font.

setSuperscript(bool) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the superscript setting of the chart area font.

setSuperscript(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the superscript setting of the chart legend font.

setSuperscript(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the superscript setting of the chart data table font.

setSuperscript(bool) - Method in class ActiveXLS.ExcelCell

Sets the superscript option of the cell font.

setSuperscript(bool) - Method in class ActiveXLS.ExcelColumn

Sets the superscript option of the column font.

setSuperscript(bool) - Method in class ActiveXLS.ExcelRow

Sets the superscript option of the row font.

setSuperscript(bool) - Method in class ActiveXLS.ExcelStyle

Sets the superscript option of the style font.

setTabColor(Color) - Method in class ActiveXLS.ExcelSheet

Sets the tab color.

setTableStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the table.

setText(String) - Method in class ActiveXLS.ExcelComment

Sets the text of the comment.

setTextMark(String) - Method in class ActiveXLS.ExcelHyperlink

Sets the text mark value.

setTextRotation(int) - Method in class ActiveXLS.ExcelCell

Sets the text rotation of the cell.

setTextRotation(int) - Method in class ActiveXLS.ExcelColumn

Sets the text rotation of the column.

setTextRotation(int) - Method in class ActiveXLS.ExcelRow

Sets the text rotation of the row.

setTextRotation(int) - Method in class ActiveXLS.ExcelStyle

Sets the text rotation of the style.

setTickMarkLabel(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the label of the tick mark.

setTickMarksFrequency(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the number of categories between tick marks.

setTitle(String) - Method in class ActiveXLS.FileProperties.SummaryInformation

Sets the title property.

setToolTip(String) - Method in class ActiveXLS.ExcelHyperlink

Sets the tool tip text.

setTopColor_Border(Color) - Method in class ActiveXLS.ExcelCell

Sets the color of the top border.

setTopColor_Border(Color) - Method in class ActiveXLS.ExcelColumn

Sets the color of the top border.

setTopColor_Border(Color) - Method in class ActiveXLS.ExcelCondition

Sets the color of the conditional formatting top border.

setTopColor_Border(Color) - Method in class ActiveXLS.ExcelRow

Sets the color of the top border.

setTopColor_Border(Color) - Method in class ActiveXLS.ExcelStyle

Sets the color of the top border.

setTopLeftCellStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the top left cell.

setTopMargin(double) - Method in class ActiveXLS.ExcelPageSetup

Sets the top margin of the paper.

setTopRightCellStyle(ExcelStyle) - Method in class ActiveXLS.ExcelAutoFormat

Sets the style of the top right cell.

setTopStyle_Border(int) - Method in class ActiveXLS.ExcelCell

Sets the style of the top border.

setTopStyle_Border(int) - Method in class ActiveXLS.ExcelColumn

Sets the style of the top border.

setTopStyle_Border(int) - Method in class ActiveXLS.ExcelCondition

Sets the style of the conditional formatting top border.

setTopStyle_Border(int) - Method in class ActiveXLS.ExcelRow

Sets the style of the top border.

setTopStyle_Border(int) - Method in class ActiveXLS.ExcelStyle

Sets the style of the top border.

setURL(String) - Method in class ActiveXLS.ExcelHyperlink

Sets the URL value.

setUnderlineStyle(int) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the underline style of the chart axis.

setUnderlineStyle(int) - Method in class ActiveXLS.Charts.ExcelChartArea

Sets the underline style of the chart area.

setUnderlineStyle(int) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the underline style of the chart legend text.

setUnderlineStyle(int) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the underline style of the chart data table text.

setUnderlineStyle(int) - Method in class ActiveXLS.ExcelCell

Sets the underline style of the cell font.

setUnderlineStyle(int) - Method in class ActiveXLS.ExcelColumn

Sets the underline style of the column font.

setUnderlineStyle(int) - Method in class ActiveXLS.ExcelComment

Sets the underline style of the comment text.

setUnderlineStyle(int) - Method in class ActiveXLS.ExcelCondition

Sets the underline style of the conditional formatting font.

setUnderlineStyle(int) - Method in class ActiveXLS.ExcelRow

Sets the underline style of the row font.

setUnderlineStyle(int) - Method in class ActiveXLS.ExcelStyle

Sets the underline style of the style font.

setValidationType(int) - Method in class ActiveXLS.ExcelDataValidator

Sets the validation type.

setValue(String) - Method in class ActiveXLS.ExcelCell

Sets the value of the cell.

setValues(String) - Method in class ActiveXLS.Charts.ExcelSeries

Sets the values of the chart series.

setVerticalAlignment(String) - Method in class ActiveXLS.ExcelCell

Sets the vertical alignment of the cell.

setVerticalAlignment(String) - Method in class ActiveXLS.ExcelColumn

Sets the vertical alignment of the column.

setVerticalAlignment(String) - Method in class ActiveXLS.ExcelRow

Sets the vertical alignment of the row.

setVerticalAlignment(String) - Method in class ActiveXLS.ExcelStyle

Sets the vertical alignment of the style.

setVerticalLines(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the visible value of the vertical data table grid lines.

setVisible(bool) - Method in class ActiveXLS.Charts.ExcelAxis

Sets the visible setting of the chart axis.

setVisible(bool) - Method in class ActiveXLS.Charts.ExcelChartGridlines

Sets the visible setting of the chart gridlines.

setVisible(bool) - Method in class ActiveXLS.Charts.ExcelChartLegend

Sets the visible setting of the chart legend.

setVisible(bool) - Method in class ActiveXLS.Charts.ExcelDataTable

Sets the visible setting of the chart data table.

setWidth(int) - Method in class ActiveXLS.ExcelColumn

Sets the width of the column.

setWrap(bool) - Method in class ActiveXLS.ExcelCell

Sets the wrap option of the cell.

setWrap(bool) - Method in class ActiveXLS.ExcelColumn

Sets the wrap option of the column.

setWrap(bool) - Method in class ActiveXLS.ExcelRow

Sets the wrap option of the row.

setWrap(bool) - Method in class ActiveXLS.ExcelStyle

Sets the wrap option of the style.

setXF(int) - Method in class ActiveXLS.ExcelCell

Internal use only

setXF(int) - Method in class ActiveXLS.ExcelColumn

Internal use only

setXF(int) - Method in class ActiveXLS.ExcelRow

Internal use only

setZoom(int) - Method in class ActiveXLS.ExcelSheet

Sets the zoom of the sheet.

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

Returns the number of elements in this list