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

E

ERROR - Constant in class ActiveXLS.Constants.DataType

A constant indicating the "error" data type.

ERROR_INFO - Constant in class ActiveXLS.Constants.DataValidator

A constant indicating the "Error message" box type.

ERROR_STOP - Constant in class ActiveXLS.Constants.DataValidator

A constant indicating the "Error message" box type.

ERROR_WARNING - Constant in class ActiveXLS.Constants.DataValidator

A constant indicating the "Error message" box type.

ErrorType - class ActiveXLS.Constants.ErrorType.

This class contains the constants for possible errors.

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

ExcelArrayFormula - class ActiveXLS.ExcelArrayFormula.

This class describes a formula that was array-entered into a range of cells.

ExcelArrayFormula() - Constructor for class ActiveXLS.ExcelArrayFormula

Defines an empty instance of the array formula

ExcelArrayFormula(int, int, int, int, String) - Constructor for class ActiveXLS.ExcelArrayFormula

Defines an instance of the array formula

ExcelArrayFormula(String, String) - Constructor for class ActiveXLS.ExcelArrayFormula

Defines an instance of the array formula having the specified range and formula restrictions.

ExcelAutoFormat - class ActiveXLS.ExcelAutoFormat.

This class stores the table autoformat information like font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, cell locked or hidden, shrink, border type, border color.

ExcelAutoFormat() - Constructor for class ActiveXLS.ExcelAutoFormat

Defines a table autoformat that is initialized with the default style.

ExcelAutoFormat(int) - Constructor for class ActiveXLS.ExcelAutoFormat

Defines a table autoformat that is one of the predefined autoformats.

ExcelAutoFormat(ExcelStyle) - Constructor for class ActiveXLS.ExcelAutoFormat

Defines a table autoformat that is initialized with a specific style.

ExcelAutoFormat(ExcelStyle, ExcelStyle, ExcelStyle) - Constructor for class ActiveXLS.ExcelAutoFormat

Defines a table autoformat that is initialized with a specific style and has a specific header row and footer row style.

ExcelAutoFormat(ExcelStyle, ExcelStyle, ExcelStyle, ExcelStyle) - Constructor for class ActiveXLS.ExcelAutoFormat

Defines a table autoformat that is initialized with a specific striped style and has a specific header row and footer row style.

ExcelAutoFormat(ExcelAutoFormat) - Constructor for class ActiveXLS.ExcelAutoFormat

Defines a table autoformat based on a predefined autoformat.

ExcelAxis - class ActiveXLS.Charts.ExcelAxis.

This class stores the chart axis information like extends label, font name, font size, font bold, font italic, font underline style, font subscript, font superscript, font strikethrough, foreground color, style line, weight line, color line, type of major and minor tick mark, tick mark label, number format, rotation of the axis, visibility.

ExcelAxis() - Constructor for class ActiveXLS.Charts.ExcelAxis

Defines an instance of the excel axis.

ExcelCell - class ActiveXLS.ExcelCell.

This class stores the cell information like value, format (font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, cell locked or hidden, shrink, border type, border color) and comment.

ExcelCell() - Constructor for class ActiveXLS.ExcelCell

Defines an instance of the Excel cell.

ExcelChart - class ActiveXLS.Charts.ExcelChart.

This class stores chart information like series, legend, axis, plot area, chart area, data table, title, series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.

ExcelChart() - Constructor for class ActiveXLS.Charts.ExcelChart

Defines an instance of the chart.

ExcelChart(int, int) - Constructor for class ActiveXLS.Charts.ExcelChart

Defines an instance of the chart having the specified location
This constructor is applicable only to adding charts to ExcelWorksheet objects

ExcelChart(int, int, int, int) - Constructor for class ActiveXLS.Charts.ExcelChart

Defines an instance of the chart having the specified location and size
This constructor is applicable only to adding charts to ExcelWorksheet objects

ExcelChart(String) - Constructor for class ActiveXLS.Charts.ExcelChart

Defines an instance of the chart having the specified location
This constructor is applicable only to adding charts to ExcelWorksheet objects

ExcelChart(String, int, int) - Constructor for class ActiveXLS.Charts.ExcelChart

Defines an instance of the chart having the specified location and size
This constructor is applicable only to adding charts to ExcelWorksheet objects

ExcelChartArea - class ActiveXLS.Charts.ExcelChartArea.

This class stores the chart area information like font name, font size, font bold, font italic, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, border style, border color, border weight, shadow presence.

ExcelChartArea() - Constructor for class ActiveXLS.Charts.ExcelChartArea

Defines an instance of the chart area.

ExcelChartGridlines - class ActiveXLS.Charts.ExcelChartGridlines.

This class stores the chart gridlines information like line style, line color, line weight, visibility.

ExcelChartGridlines() - Constructor for class ActiveXLS.Charts.ExcelChartGridlines

Defines an instance of the chart gridlines.

ExcelChartLegend - class ActiveXLS.Charts.ExcelChartLegend.

This class stores the ChartLegend information like border style, border color, border weight, shadow presence, background color, font name, font size, font bold, font italic, font underline style, font subscript, font superscript, font strikethrough, foreground color, legend position, keys arrangement direction, visibility .

ExcelChartLegend() - Constructor for class ActiveXLS.Charts.ExcelChartLegend

Defines an instance of the excel legend.

ExcelChartSheet - class ActiveXLS.ExcelChartSheet.

This class stores chart information like series, legend, axis, plot area, chart area, data table, title, series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.

ExcelChartSheet() - Constructor for class ActiveXLS.ExcelChartSheet

Defines an instance of a sheet that contains a chart.

ExcelChartSheet(String) - Constructor for class ActiveXLS.ExcelChartSheet

Defines an instance of a sheet that has the sheet name defined and contains a chart.

ExcelColumn - class ActiveXLS.ExcelColumn.

This class stores the column information extends width and format (font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, column cells locked or hidden, shrink, border type, border color).

ExcelColumn() - Constructor for class ActiveXLS.ExcelColumn

Defines an instance of the Excel column.

ExcelComment - class ActiveXLS.ExcelComment.

This class stores the comment information extends text, font name, font size, font style, foreground and comment position.

ExcelComment() - Constructor for class ActiveXLS.ExcelComment

Defines an instance of the Excel comment.

ExcelComment(String) - Constructor for class ActiveXLS.ExcelComment

Defines an instance of the Excel comment having the specified text.

ExcelComment(String, int, int) - Constructor for class ActiveXLS.ExcelComment

Defines an instance of the Excel comment having the specified text and size.

ExcelComment(String, String, int, bool, bool, Color) - Constructor for class ActiveXLS.ExcelComment

Defines an instance of the Excel comment having the specified text and font settings.

ExcelCondition - class ActiveXLS.ExcelCondition.

This class stores the condition of the conditional formatting information like type, operator, first and second formula, font, border and pattern style.

ExcelCondition() - Constructor for class ActiveXLS.ExcelCondition

Defines an instance of the condition.

ExcelCondition(int, String, String) - Constructor for class ActiveXLS.ExcelCondition

Defines an instance of the condition, having the specified operator and formula restrictions.

ExcelCondition(int, String, String, Color) - Constructor for class ActiveXLS.ExcelCondition

Defines an instance of the condition, having the specified operator, formula restrictions and background.

ExcelCondition(int, String, String, bool, bool, Color) - Constructor for class ActiveXLS.ExcelCondition

Defines an instance of the condition, having the specified operator, formula restrictions and font settings.

ExcelCondition(int, String, String, bool, bool, Color, Color) - Constructor for class ActiveXLS.ExcelCondition

Defines an instance of the condition, having the specified operator, formula restrictions, font settings and background.

ExcelConditionalFormatting - class ActiveXLS.ExcelConditionalFormatting.

This class stores the conditional formatting information like cells range and conditions.

ExcelConditionalFormatting() - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting.

ExcelConditionalFormatting(int, int, int, int, List) - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting having the specified range.

ExcelConditionalFormatting(String, List) - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting on the specified range.

ExcelConditionalFormatting(String, int, String, String) - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting having the specified position, operator and formula restrictions.

ExcelConditionalFormatting(String, int, String, String, bool, bool, Color) - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting having the specified position, operator, formula restrictions and font settings.

ExcelConditionalFormatting(String, int, String, String, bool, bool, Color, Color) - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting having the specified position, operator, formula restrictions, font settings and background.

ExcelConditionalFormatting(String, int, String, String, Color) - Constructor for class ActiveXLS.ExcelConditionalFormatting

Defines an instance of the conditional formatting having the specified position, operator, formula restrictions and background.

ExcelDataGroup - class ActiveXLS.ExcelDataGroup.

This class allows to group and outline the cell ranges.

ExcelDataGroup() - Constructor for class ActiveXLS.ExcelDataGroup

Defines an instance of a data group.

ExcelDataGroup(String, int, bool) - Constructor for class ActiveXLS.ExcelDataGroup

Defines an instance of a data group having the specified position, group per rows or columns and collapse options.

ExcelDataGroup(int, int, int, int, int, bool) - Constructor for class ActiveXLS.ExcelDataGroup

Defines an instance of a data group having the specified position, group per rows or columns and collapse options.

ExcelDataGroup(String, int, bool, ExcelAutoFormat) - Constructor for class ActiveXLS.ExcelDataGroup

Defines an instance of a data group having the specified position, group per rows or columns and collapse options.

ExcelDataGroup(int, int, int, int, int, bool, ExcelAutoFormat) - Constructor for class ActiveXLS.ExcelDataGroup

Defines an instance of a data group having the specified position, group per rows or columns and collapse options.

ExcelDataTable - class ActiveXLS.Charts.ExcelDataTable.

This class stores the data table information like line style, line color, line weight, legend key visibility, horizontal lines visibility, vertical lines visibility, outlines visibility, font name, font size, font bold, font italic, font underline style, font subscript, font superscript, font strikethrough, foreground color, visibility .

ExcelDataTable() - Constructor for class ActiveXLS.Charts.ExcelDataTable

Defines an instance of the excel data table.

ExcelDataValidator - class ActiveXLS.ExcelDataValidator.

This class restricts the cell entries to a specific data type (integers, decimal numbers, or text) and sets limits on the valid entries.

ExcelDataValidator() - Constructor for class ActiveXLS.ExcelDataValidator

Defines an instance of the validator.

ExcelDataValidator(String, int, int, String, String) - Constructor for class ActiveXLS.ExcelDataValidator

Defines an instance of the validator having the specified position, validation type, operator and formula restrictions.

ExcelDataValidator(int, int, int, int, int, int, String, String) - Constructor for class ActiveXLS.ExcelDataValidator

Defines an instance of the validator having the specified position, validation type, operator and formula restrictions.

ExcelDocument - class ActiveXLS.ExcelDocument.

The ExcelDocument class is the main class that contains methods to generate or read a Microsoft Excel file.

ExcelDocument() - Constructor for class ActiveXLS.ExcelDocument

Defines an instance of the object that reads/writes Excel files.

ExcelDocument(int) - Constructor for class ActiveXLS.ExcelDocument

Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets.

ExcelDocument(int, int) - Constructor for class ActiveXLS.ExcelDocument

Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets and chart sheets.

ExcelFooter - class ActiveXLS.ExcelFooter.

This class stores the footer information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.

ExcelFooter() - Constructor for class ActiveXLS.ExcelFooter

Defines an instance of the footer.

ExcelFooter(String, String) - Constructor for class ActiveXLS.ExcelFooter

Defines an instance of the footer having the specified text and position.

ExcelFooter(String, String, String, int, bool, bool) - Constructor for class ActiveXLS.ExcelFooter

Defines an instance of the footer having the specified text, position and font settings.

ExcelHeader - class ActiveXLS.ExcelHeader.

This class stores the header information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.

ExcelHeader() - Constructor for class ActiveXLS.ExcelHeader

Defines an instance of the header.

ExcelHeader(String, String) - Constructor for class ActiveXLS.ExcelHeader

Defines an instance of the header having the specified text and position.

ExcelHeader(String, String, String, int, bool, bool) - Constructor for class ActiveXLS.ExcelHeader

Defines an instance of the header having the specified text, position and font settings.

ExcelHyperlink - class ActiveXLS.ExcelHyperlink.

This class stores the hyperlink information like position (first row, first column, last row, last column), hyperlink type, description, URL, target frame, text mark and tool tip.

ExcelHyperlink() - Constructor for class ActiveXLS.ExcelHyperlink

Defines an instance of the Excel hyperlink.

ExcelHyperlink(String, String, String) - Constructor for class ActiveXLS.ExcelHyperlink

Defines an instance of the Excel hyperlink with the specified type, url and position.

ExcelHyperlink(String, String, String, String) - Constructor for class ActiveXLS.ExcelHyperlink

Defines an instance of the Excel hyperlink with the specified type, url, tooltip and position.

ExcelImage - class ActiveXLS.ExcelImage.

This class stores image information like image path and position in worksheet.

ExcelImage() - Constructor for class ActiveXLS.ExcelImage

Defines an instance of the image.

ExcelImage(String) - Constructor for class ActiveXLS.ExcelImage

Defines an instance of the image having the specified path.

ExcelImage(String, int, int) - Constructor for class ActiveXLS.ExcelImage

Defines an instance of the image having the specified path and location
This constructor is applicable only to adding images to ExcelWorksheet objects

ExcelImage(String, int, int, int, int) - Constructor for class ActiveXLS.ExcelImage

Defines an instance of the image having the specified path, location and size
This constructor is applicable only to adding images to ExcelWorksheet objects

ExcelImage(String, String) - Constructor for class ActiveXLS.ExcelImage

Defines an instance of the image having the specified path and location
This constructor is applicable only to adding images to ExcelWorksheet objects

ExcelImage(String, String, int, int) - Constructor for class ActiveXLS.ExcelImage

Defines an instance of the image having the specified path, location and size
This constructor is applicable only to adding images to ExcelWorksheet objects

ExcelName - class ActiveXLS.ExcelName.

This class stores names with its information like title and formula.

ExcelName() - Constructor for class ActiveXLS.ExcelName

Defines an instance of a name.

ExcelName(String, String) - Constructor for class ActiveXLS.ExcelName

Defines an instance of a name with the specified title and formula.

ExcelOptions - class ActiveXLS.ExcelOptions.

This class stores some of the options of an Excel document, available in the main menu Tools/Options window.

ExcelOptions() - Constructor for class ActiveXLS.ExcelOptions

Defines an instance of the ExcelOption class.

ExcelPageSetup - class ActiveXLS.ExcelPageSetup.

This class stores page setup settings like print area, the rows to be repeated at top, columns to be repeated at left, page orientation (portrait, landscape), paper size, scaling factor, fit to pages width/height, paper margins, print order, horizontal and vertical page breaks and other customizations like: print gridlines, print black and white, print draft quality, print row and column headings, print comments.

ExcelPageSetup(ExcelWorksheet) - Constructor for class ActiveXLS.ExcelPageSetup

Internal use only Defines an instance of page setup.

ExcelPlotArea - class ActiveXLS.Charts.ExcelPlotArea.

This class stores the plot area information like border style, border weight, border color, background color.

ExcelPlotArea() - Constructor for class ActiveXLS.Charts.ExcelPlotArea

Defines an instance of the excel plot area.

ExcelRow - class ActiveXLS.ExcelRow.

This class is a collection of cells.

ExcelRow() - Constructor for class ActiveXLS.ExcelRow

Defines an instance of the row.

ExcelSeries - class ActiveXLS.Charts.ExcelSeries.

This class stores the series information like values, name, line style, line weight, line color, shadow visibility, background color, data labels type, legend key visibility next to label, marker type.

ExcelSeries() - Constructor for class ActiveXLS.Charts.ExcelSeries

Defines an instance of the excel series.

ExcelSeries(String, String) - Constructor for class ActiveXLS.Charts.ExcelSeries

Defines an instance of the excel series that has the name and the values defined.

ExcelSheet - class ActiveXLS.ExcelSheet.

This class simulates a sheet.

ExcelSheet() - Constructor for class ActiveXLS.ExcelSheet

Defines an instance of the sheet.

ExcelStyle - class ActiveXLS.ExcelStyle.

This class stores the style information like font name, font size, font bold, font italic, word wrap, font underline style, font subscript, font superscript, font strikethrough, background color, foreground color, horizontal alignment, vertical alignment, number or date format, cell locked or hidden, shrink, border type, border color.

ExcelStyle() - Constructor for class ActiveXLS.ExcelStyle

Defines an instance of the style.

ExcelStyle(Color) - Constructor for class ActiveXLS.ExcelStyle

Defines an instance of the style that is initialized with background color.

ExcelStyle(String, int, bool, bool, Color) - Constructor for class ActiveXLS.ExcelStyle

Defines an instance of the style that is initialized with font settings.

ExcelStyle(String, int, bool, bool, Color, Color) - Constructor for class ActiveXLS.ExcelStyle

Defines an instance of the style that is initialized with font and background settings.

ExcelTable - class ActiveXLS.ExcelTable.

This class simulates a worksheet table.

ExcelTable() - Constructor for class ActiveXLS.ExcelTable

Defines an instance of the worksheet table.

ExcelWorksheet - class ActiveXLS.ExcelWorksheet.

This class simulates a worksheet.

ExcelWorksheet() - Constructor for class ActiveXLS.ExcelWorksheet

Defines an instance of the worksheet.

ExcelWorksheet(String) - Constructor for class ActiveXLS.ExcelWorksheet

Defines an instance of the worksheet that has the worksheet name defined.

ExternalLinks - class ActiveXLS.ExternalLinks.

This class contains the external links from the formulas inside the document.

ExternalLinks() - Constructor for class ActiveXLS.ExternalLinks

elementAt(int) - Method in class ActiveXLS.Util.List

Returns the element from the specified index

esd_IsExcel(String) - Method in class ActiveXLS.ExcelDocument

Checks if the specified file is a Microsoft Excel document.

esd_IsExcel(InputStream) - Method in class ActiveXLS.ExcelDocument

Checks if the specified file is a Microsoft Excel document.

esd_LoadCSVFile(String) - Method in class ActiveXLS.ExcelDocument

Loads a specified CSV document
Available for: Professional, Reader

esd_LoadCSVFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Generates the document at the specified stream
Available for: Professional, Reader

esd_LoadHTMLFile(String) - Method in class ActiveXLS.ExcelDocument

Loads the specified HTML file
Available for: Professional, Reader

esd_LoadHTMLFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Loads the specified HTML file
Available for: Professional, Reader

esd_LoadTXTFile(String, String, String) - Method in class ActiveXLS.ExcelDocument

Loads a specified document
Available for: Professional, Reader

esd_LoadTXTFile(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Generates the document at the specified stream
Available for: Professional, Reader

esd_LoadTemplateFile(String) - Method in class ActiveXLS.ExcelDocument

Deprecated. As of ActiveXLS version 6.1, replaced by esd_LoadXLSFile(String).

esd_LoadTemplateFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Deprecated. As of ActiveXLS version 6.1, replaced by esd_LoadXLSFile(InputStream).

esd_LoadXLSBFile(String) - Method in class ActiveXLS.ExcelDocument

Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_LoadXLSBFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_LoadXLSFile(String) - Method in class ActiveXLS.ExcelDocument

Loads a specified Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_LoadXLSFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Loads a specified Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_LoadXLSXFile(String) - Method in class ActiveXLS.ExcelDocument

Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_LoadXLSXFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Loads the specified Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_LoadXMLSpreadsheetFile(String) - Method in class ActiveXLS.ExcelDocument

Loads a specified XML Spreadsheet document
Available for: Professional, Reader

esd_LoadXMLSpreadsheetFile(InputStream) - Method in class ActiveXLS.ExcelDocument

Loads a specified XML Spreadsheet document
Available for: Professional, Reader

esd_ReadCSVFile_AsList(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified CSV document
Available for: Professional, Reader

esd_ReadCSVFile_AsList(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified CSV document
Available for: Professional, Reader

esd_ReadCSVFile_AsDataSet(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified CSV document
Available for: Professional, Reader

esd_ReadCSVFile_AsDataSet(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified CSV document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsList(ExcelWorksheet, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsList(ExcelWorksheet) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsList(ExcelWorksheet, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsList(String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsList(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsList(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsDataSet(ExcelWorksheet, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsDataSet(ExcelWorksheet) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsDataSet(ExcelWorksheet, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsDataSet(String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsDataSet(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsDataSet(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(OutputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(OutputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(OutputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(OutputStream, ExcelWorksheet, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(String, ExcelWorksheet, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(OutputStream, ExcelWorksheet) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(String, ExcelWorksheet) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(OutputStream, ExcelWorksheet, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadExcelWorksheet_AsXML(String, ExcelWorksheet, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document
Available for: Professional, Reader

esd_ReadTXTFile_AsList(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified TXT document
Available for: Professional, Reader

esd_ReadTXTFile_AsList(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified TXT document
Available for: Professional, Reader

esd_ReadTXTFile_AsDataSet(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified TXT document
Available for: Professional, Reader

esd_ReadTXTFile_AsDataSet(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified TXT document
Available for: Professional, Reader

esd_ReadXLSActiveSheet_AsList(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSActiveSheet_AsList(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSActiveSheet_AsDataSet(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSActiveSheet_AsDataSet(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSBActiveSheet_AsList(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBActiveSheet_AsList(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBActiveSheet_AsDataSet(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBActiveSheet_AsDataSet(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBSheet_AsList(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBSheet_AsList(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBSheet_AsList(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsList(InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsList(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsList(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsDataSet(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsDataSet(InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsDataSet(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsDataSet(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSBSheet_AsDataSet(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBSheet_AsDataSet(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSBSheet_AsXML(String, String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSBSheet_AsXML(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSBSheet_AsXML(String, String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSBSheet_AsXML(OutputStream, InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSBSheet_AsXML(OutputStream, InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSBSheet_AsXML(OutputStream, InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSSheet_AsList(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSSheet_AsList(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSSheet_AsList(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader

esd_ReadXLSSheet_AsList(InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader

esd_ReadXLSSheet_AsList(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader

esd_ReadXLSSheet_AsList(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
Available for: Professional, Reader

esd_ReadXLSSheet_AsDataSet(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSSheet_AsDataSet(InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSSheet_AsDataSet(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSSheet_AsDataSet(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSSheet_AsDataSet(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSSheet_AsDataSet(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader

esd_ReadXLSSheet_AsXML(String, String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSSheet_AsXML(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSSheet_AsXML(String, String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSSheet_AsXML(OutputStream, InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSSheet_AsXML(OutputStream, InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSSheet_AsXML(OutputStream, InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSXActiveSheet_AsList(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXActiveSheet_AsList(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXActiveSheet_AsDataSet(String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXActiveSheet_AsDataSet(InputStream) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXSheet_AsList(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXSheet_AsList(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXSheet_AsList(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsList(InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsList(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsList(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsDataSet(String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsDataSet(InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsDataSet(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsDataSet(InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
Available for: Professional, Reader

esd_ReadXLSXSheet_AsDataSet(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXSheet_AsDataSet(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader

esd_ReadXLSXSheet_AsXML(String, String, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSXSheet_AsXML(String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSXSheet_AsXML(String, String, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSXSheet_AsXML(OutputStream, InputStream, String, int, int, int, int) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSXSheet_AsXML(OutputStream, InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXLSXSheet_AsXML(OutputStream, InputStream, String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
Available for: Professional, Reader

esd_ReadXMLSpreadsheet_AsList(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
Available for: Professional, Reader

esd_ReadXMLSpreadsheet_AsList(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a List object
Available for: Professional, Reader

esd_ReadXMLSpreadsheet_AsDataSet(String, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
Available for: Professional, Reader

esd_ReadXMLSpreadsheet_AsDataSet(InputStream, String) - Method in class ActiveXLS.ExcelDocument

Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
Available for: Professional, Reader

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

Returns if the 3D perspective of the chart is used

esd_WriteCSVFile(String, String) - Method in class ActiveXLS.ExcelDocument

Generates the CSV document at the specified path
Available for: Professional, Writer

esd_WriteCSVFile(OutputStream, String) - Method in class ActiveXLS.ExcelDocument

Generates the CSV at the specified stream
Available for: Professional, Writer

esd_WriteExcelFile(String) - Method in class ActiveXLS.ExcelDocument

Deprecated. As of ActiveXLS version 6.1, replaced by esd_WriteXLSFile(String).

esd_WriteExcelFile(OutputStream) - Method in class ActiveXLS.ExcelDocument

Deprecated. As of ActiveXLS version 6.1, replaced by esd_WriteXLSFile(OutputStream).

esd_WriteHTMLFile(String, String) - Method in class ActiveXLS.ExcelDocument

Generates the HTML document at the specified path
Available for: Professional, Writer

esd_WriteHTMLFile(OutputStream, String) - Method in class ActiveXLS.ExcelDocument

Generates the HTML at the specified stream
Available for: Professional, Writer

esd_WriteTXTFile(String, String, String, String) - Method in class ActiveXLS.ExcelDocument

Generates the TXT document at the specified path
Available for: Professional, Writer

esd_WriteTXTFile(OutputStream, String, String, String) - Method in class ActiveXLS.ExcelDocument

Generates the document at the specified stream
Available for: Professional, Writer

esd_WriteXLSBFile(String) - Method in class ActiveXLS.ExcelDocument

Generates the Microsoft Excel Office2007 binary document at the specified path
Available for: Professional, Writer

esd_WriteXLSBFile(OutputStream) - Method in class ActiveXLS.ExcelDocument

Generates the Microsoft Excel document (Office 2007 binary file format) at the specified stream
Available for: Professional, Writer

esd_WriteXLSBFile_FromList(OutputStream, List, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromList(OutputStream, List, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromList(OutputStream, List, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromList(String, List, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromList(String, List, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromList(String, List, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromDataSet(OutputStream, DataSet, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromDataSet(OutputStream, DataSet, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromDataSet(OutputStream, DataSet, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromDataSet(String, DataSet, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromDataSet(String, DataSet, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSBFile_FromDataSet(String, DataSet, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile(String) - Method in class ActiveXLS.ExcelDocument

Generates the Microsoft Excel document (Office 97-2003) at the specified path
Available for: Professional, Writer

esd_WriteXLSFile(OutputStream) - Method in class ActiveXLS.ExcelDocument

Generates the Microsoft Excel document (Office 97-2003) at the specified stream
Available for: Professional, Writer

esd_WriteXLSFile_FromList(OutputStream, List, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromList(OutputStream, List, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromList(OutputStream, List, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromList(String, List, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromList(String, List, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromList(String, List, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromDataSet(OutputStream, DataSet, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromDataSet(OutputStream, DataSet, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromDataSet(OutputStream, DataSet, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromDataSet(String, DataSet, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromDataSet(String, DataSet, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSFile_FromDataSet(String, DataSet, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile(String) - Method in class ActiveXLS.ExcelDocument

Generates the Microsoft Excel Office2007 document at the specified path
Available for: Professional, Writer

esd_WriteXLSXFile(OutputStream) - Method in class ActiveXLS.ExcelDocument

Generates the Microsoft Excel document (Office 2007 file format) at the specified stream
Available for: Professional, Writer

esd_WriteXLSXFile_FromList(OutputStream, List, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromList(OutputStream, List, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromList(OutputStream, List, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromList(String, List, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromList(String, List, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromList(String, List, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromDataSet(OutputStream, DataSet, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromDataSet(OutputStream, DataSet, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromDataSet(OutputStream, DataSet, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromDataSet(String, DataSet, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromDataSet(String, DataSet, String, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXLSXFile_FromDataSet(String, DataSet, int, int, ExcelAutoFormat, String) - Method in class ActiveXLS.ExcelDocument

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
Available for: Professional, Writer, Express Writer

esd_WriteXMLFile(String) - Method in class ActiveXLS.ExcelDocument

Generates the XML document at the specified path
Available for: Professional, Writer

esd_WriteXMLFile(OutputStream) - Method in class ActiveXLS.ExcelDocument

Generates the XML document at the specified stream
Available for: Professional, Writer

esd_addArrayFormula(String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds an array formula at the specified range to worksheet.

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

Adds an array formula at the specified range to worksheet.

esd_addCell(ExcelCell) - Method in class ActiveXLS.ExcelRow

Adds the specified cell to row.

esd_addChart(ExcelChartSheet) - Method in class ActiveXLS.ExcelDocument

Adds a chart to the sheet list.

esd_addChart(String) - Method in class ActiveXLS.ExcelDocument

Adds a chart sheet having the specified sheet name to the sheet list.

esd_addChart(String, String, int) - Method in class ActiveXLS.ExcelDocument

Adds a chart sheet to the sheet list.

esd_addChart(String, bool) - Method in class ActiveXLS.ExcelDocument

Adds a chart sheet having the sheet name and selected option specified.

esd_addChart(String, bool, String, int) - Method in class ActiveXLS.ExcelDocument

Adds a chart sheet to the sheet list.

esd_addChart(ExcelChart) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified chart to worksheet.

esd_addChart(ExcelChart, int, int) - Method in class ActiveXLS.ExcelWorksheet

Adds a chart that has the specified location to worksheet.

esd_addChart(ExcelChart, int, int, int, int) - Method in class ActiveXLS.ExcelWorksheet

Adds a chart that has the specified location and size to worksheet.

esd_addChart(ExcelChart, String) - Method in class ActiveXLS.ExcelWorksheet

Adds a chart that has the specified location to worksheet.

esd_addChart(ExcelChart, String, int, int) - Method in class ActiveXLS.ExcelWorksheet

Adds a chart that has the specified location and size to worksheet.

esd_addColumn() - Method in class ActiveXLS.ExcelTable

Adds a column to table.

esd_addColumn(ExcelColumn) - Method in class ActiveXLS.ExcelTable

Adds the specified column to table.

esd_addConditionalFormatting(ExcelConditionalFormatting) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified conditional formatting range to worksheet.

esd_addConditionalFormatting(int, int, int, int, List) - Method in class ActiveXLS.ExcelWorksheet

Adds a conditional formatting at the specified range to worksheet.

esd_addConditionalFormatting(String, List) - Method in class ActiveXLS.ExcelWorksheet

Adds a conditional formatting at the specified range to worksheet.

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

Adds a conditional formatting having the specified range, operator and formula restrictions to worksheet.

esd_addConditionalFormatting(String, int, String, String, bool, bool, Color) - Method in class ActiveXLS.ExcelWorksheet

Adds a conditional formatting having the specified range, operator, formulas restrictions and font settings to worksheet.

esd_addConditionalFormatting(String, int, String, String, bool, bool, Color, Color) - Method in class ActiveXLS.ExcelWorksheet

Adds a conditional formatting having the specified range, operator, formulas restrictions, font settings and background to worksheet.

esd_addConditionalFormatting(String, int, String, String, Color) - Method in class ActiveXLS.ExcelWorksheet

Adds a conditional formatting having the specified range, operator, formulas restrictions and background to worksheet.

esd_addDataGroup(ExcelDataGroup) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified data group to worksheet.

esd_addDataGroup(String, int, bool) - Method in class ActiveXLS.ExcelWorksheet

Adds a data group having the specified position, grouping per rows or colums and collapse option to worksheet.

esd_addDataGroup(int, int, int, int, int, bool) - Method in class ActiveXLS.ExcelWorksheet

Adds a data group having the specified position, grouping per rows or colums and collapse option to worksheet.

esd_addDataGroup(String, int, bool, ExcelAutoFormat) - Method in class ActiveXLS.ExcelWorksheet

Adds a data group having the specified position, grouping per rows or colums and collapse option to worksheet.

esd_addDataGroup(int, int, int, int, int, bool, ExcelAutoFormat) - Method in class ActiveXLS.ExcelWorksheet

Adds a data group having the specified position, grouping per rows or colums and collapse option to worksheet.

esd_addDataValidator(ExcelDataValidator) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified data validator to worksheet.

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

Adds a data validator having the specified position, validation type, operator and formula restrictions to worksheet.

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

Adds a data validator having the specified position, validation type, operator and formulas restrictions to worksheet.

esd_addFooter(ExcelFooter) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified footer to worksheet.

esd_addFooter(String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds the footer having the specified text and position to worksheet.

esd_addFooter(String, String, String, int, bool, bool) - Method in class ActiveXLS.ExcelWorksheet

Adds the footer having the specified text, position and font settings to worksheet.

esd_addHeader(ExcelHeader) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified header to worksheet.

esd_addHeader(String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds the header having the specified text and position to worksheet.

esd_addHeader(String, String, String, int, bool, bool) - Method in class ActiveXLS.ExcelWorksheet

Adds the header having the specified text, position and font settings to worksheet.

esd_addHyperlink(ExcelHyperlink) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified hyperlink to worksheet.

esd_addHyperlink(String, String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds a hyperlink having the specified type, url and position to worksheet.

esd_addHyperlink(String, String, String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds a hyperlink having the specified type, url, tooltip and position to worksheet.

esd_addImage(ExcelImage) - Method in class ActiveXLS.ExcelChartSheet

Adds the specified image to chart sheet.

esd_addImage(String) - Method in class ActiveXLS.ExcelChartSheet

Adds an image that has the specified path to chart sheet.

esd_addImage(String, int, int) - Method in class ActiveXLS.ExcelChartSheet

Adds an image that has the specified path and location to chart sheet.

esd_addImage(String, int, int, int, int) - Method in class ActiveXLS.ExcelChartSheet

Adds an image that has the specified path, location and size to chart sheet.

esd_addImage(ExcelImage) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified image to worksheet.

esd_addImage(String) - Method in class ActiveXLS.ExcelWorksheet

Adds an image that has the specified path to worksheet.

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

Adds an image that has the specified path and location to worksheet.

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

Adds an image that has the specified path, location and size to worksheet.

esd_addImage(String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds an image that has the specified path and location to worksheet.

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

Adds an image that has the specified path, location and size to worksheet.

esd_addName(ExcelName) - Method in class ActiveXLS.ExcelWorksheet

Adds the specified name to worksheet.

esd_addName(String, String) - Method in class ActiveXLS.ExcelWorksheet

Adds a name having the specified title and formula to worksheet.

esd_addRow() - Method in class ActiveXLS.ExcelTable

Adds a row to table.

esd_addRow(ExcelRow) - Method in class ActiveXLS.ExcelTable

Adds the specified row to table.

esd_addSeries(ExcelSeries) - Method in class ActiveXLS.Charts.ExcelChart

Adds a new series to the chart.

esd_addSeries(String, String) - Method in class ActiveXLS.Charts.ExcelChart

Adds a new series to the chart.

esd_addWorksheet(ExcelWorksheet) - Method in class ActiveXLS.ExcelDocument

Adds a worksheet to the sheet list.

esd_addWorksheet(String) - Method in class ActiveXLS.ExcelDocument

Adds a worksheet having the specified worksheet name to the sheet list.

esd_addWorksheet(String, bool) - Method in class ActiveXLS.ExcelDocument

Adds a worksheet having the worksheet name and selected option specified.

esd_computeFormulas(ExcelDocument, bool) - Method in class ActiveXLS.ExcelWorksheet

Calculates all formulas existing in the cells of this ExcelWorksheet

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

Sets the freeze panes for the table.

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

Set the freeze panes for the table.

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

Returns the 3D elevation setting of the chart.

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

Returns the 3D height setting of the chart.

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

Returns the 3D perspective setting of the chart.

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

Returns the 3D rotation setting of the chart.

esd_getArrayFormulaAt(int, int) - Method in class ActiveXLS.ExcelWorksheet

Returns the array formula located at the specified row number and row column.

esd_getArrayFormulaAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the array formula located at the specified range.

esd_getArrayFormulaAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the array formula from the specified index.

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

Returns the chart category X axis.

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

Returns the labels of category X axis.

esd_getCell(int) - Method in class ActiveXLS.ExcelRow

If a cell does not exist at the specified index, it creates a cell, and returns the cell from the specified index.

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

If a cell does not exist at the specified position, it creates one, and returns the cell.

esd_getCell(String) - Method in class ActiveXLS.ExcelTable

Returns the cell at the specified reference.

esd_getCellAt(int) - Method in class ActiveXLS.ExcelRow

Returns the cell from the specified index.

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

Returns the cell at the specified row and column.

esd_getCellMergingFirstCol(int) - Method in class ActiveXLS.ExcelTable

Returns the first column of the specified cell merging range.

esd_getCellMergingFirstRow(int) - Method in class ActiveXLS.ExcelTable

Returns the first row of the specified cell merging range.

esd_getCellMergingLastCol(int) - Method in class ActiveXLS.ExcelTable

Returns the last column of the specified cell merging range.

esd_getCellMergingLastRow(int) - Method in class ActiveXLS.ExcelTable

Returns the last row of the specified cell merging range.

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

Returns the chart area.

esd_getChartAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the chart from the specified index.

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

Returns the chart data table.

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

Returns the type of the chart.

esd_getColumnAt(int) - Method in class ActiveXLS.ExcelTable

Returns the column at the specified position.

esd_getColumnsToRepeatAtLeft() - Method in class ActiveXLS.ExcelPageSetup

Returns the columns to repeat at left.

esd_getConditionalFormattingAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the conditional formatting range from the specified index.

esd_getConditionalFormattingAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the conditional formatting from the specified range.

esd_getDataGroupAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the data group from the specified index.

esd_getDataGroupAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the data group from the specified range.

esd_getDataValidatorAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the data validator from the specified index.

esd_getDataValidatorAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the data validator from the specified range.

esd_getError() - Method in class ActiveXLS.ExcelDocument

Returns the error generated during processing the file.

esd_getExcelChart() - Method in class ActiveXLS.ExcelChartSheet

Returns the chart of the sheet.

esd_getExcelTable() - Method in class ActiveXLS.ExcelWorksheet

Returns the table of the worksheet.

esd_getFooterAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the footer from the specified index.

esd_getFooterAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the footer from the specified position.

esd_getHeaderAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the header from the specified index.

esd_getHeaderAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the header from the specified position.

esd_getHyperlinkAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the hyperlink from the specified index.

esd_getHyperlinkAt(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the hyperlink from the specified index.

esd_getHyperlinkAt(int, int) - Method in class ActiveXLS.ExcelWorksheet

Returns the hyperlink at the specified row index and column index.

esd_getImage(String) - Method in class ActiveXLS.ExcelChartSheet

Returns the image that has the specified path.

esd_getImage(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the image that has the specified path.

esd_getImageAt(int) - Method in class ActiveXLS.ExcelChartSheet

Returns the image from the specified index.

esd_getImageAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the image from the specified index.

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

Returns the chart legend.

esd_getMergingRangeAsA1Reference(int) - Method in class ActiveXLS.ExcelTable

Internal use only Returns the cell merging range at the specified range as A1 reference (e.g.

esd_getName(String) - Method in class ActiveXLS.ExcelWorksheet

Returns the name having the specified title.

esd_getNameAt(int) - Method in class ActiveXLS.ExcelWorksheet

Returns the name from the specified index.

esd_getOptions() - Method in class ActiveXLS.ExcelDocument

Returns the options of an Excel document, available in the main menu Tools/Options window.

esd_getPageSetup() - Method in class ActiveXLS.ExcelWorksheet

Returns the page setup options for the worksheet.

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

Returns the chart plot area.

esd_getPrintArea() - Method in class ActiveXLS.ExcelPageSetup

Returns the print area.

esd_getRowAt(int) - Method in class ActiveXLS.ExcelTable

Returns the row at specified position.

esd_getRowsToRepeatAtTop() - Method in class ActiveXLS.ExcelPageSetup

Returns the rows to repeat at top.

esd_getSeriesAt(int) - Method in class ActiveXLS.Charts.ExcelChart

Returns the series from the specified index.

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

Returns the gap of the chart series.

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

Returns the overlap of the chart series.

esd_getSheet(String) - Method in class ActiveXLS.ExcelDocument

Returns the sheet that has the specified name.

esd_getSheetAt(int) - Method in class ActiveXLS.ExcelDocument

Returns the sheet on the specified position.

esd_getSheetPosition(String) - Method in class ActiveXLS.ExcelDocument

Returns the position in the sheet list of the sheet that has the specified name.

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

Returns the chart title.

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

Returns the chart value Y axis.

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

Returns the style of the major gridlines for the X axis.

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

Returns the style of the minor gridlines for the X axis.

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

Returns the style of the major gridlines for the Y axis.

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

Returns the style of the minor gridlines for the Y axis.

esd_insertCellAt(ExcelCell, int) - Method in class ActiveXLS.ExcelRow

Inserts the specified cell at the specified index.

esd_insertChart(int, ExcelChartSheet) - Method in class ActiveXLS.ExcelDocument

Inserts a chart sheet in the sheet list on the specified position.

esd_insertChart(int, String) - Method in class ActiveXLS.ExcelDocument

Inserts a chart sheet having the specified sheet name in the sheet list on the specified position.

esd_insertChart(int, String, String, int) - Method in class ActiveXLS.ExcelDocument

Inserts a chart sheet in the sheet list on the specified position.

esd_insertChart(int, String, bool) - Method in class ActiveXLS.ExcelDocument

Inserts a chart sheet having the sheet name and selected option specified.

esd_insertChart(int, String, bool, String, int) - Method in class ActiveXLS.ExcelDocument

Inserts a chart sheet in the sheet list on the specified position.

esd_insertColumn(int, ExcelColumn) - Method in class ActiveXLS.ExcelTable

Inserts the specified column to table into the specified position.

esd_insertList(List) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified List object into this ExcelWorksheet starting from the first row and first column of the worksheet data table.

esd_insertList(List, ExcelAutoFormat) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified List object into this ExcelWorksheet starting from the first row and first column of the worksheet data table.

esd_insertList(List, int, int) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified List object into this ExcelWorksheet starting from the startRow row index and startCol column index.

esd_insertList(List, int, int, ExcelAutoFormat) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified List object into this ExcelWorksheet starting from the startRow row index and startCol column index.

esd_insertList(List, String) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified List object into this ExcelWorksheet starting with the specified cell.

esd_insertList(List, String, ExcelAutoFormat) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified List object into this ExcelWorksheet starting with the specified cell.

esd_insertPageBreakAtColumn(int) - Method in class ActiveXLS.ExcelTable

Inserts a page break after the specified column.

esd_insertPageBreakAtRow(int) - Method in class ActiveXLS.ExcelTable

Inserts a page break after the specified row.

esd_insertDataSet(DataSet, bool) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified DataSet object into this ExcelWorksheet starting from first row and first column of the worksheet data table

esd_insertDataSet(DataSet, ExcelAutoFormat, bool) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified DataSet object into this ExcelWorksheet starting from first row and first column of the worksheet data table.

esd_insertDataSet(DataSet, int, int, bool) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified DataSet object into this ExcelWorksheet starting from the nStartRow row index and nStartCol column index

esd_insertDataSet(DataSet, int, int, ExcelAutoFormat, bool) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified DataSet object into this ExcelWorksheet starting from the nStartRow row index and nStartCol column index

esd_insertDataSet(DataSet, String, bool) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified DataSet object into this ExcelWorksheet starting with the specified cell

esd_insertDataSet(DataSet, String, ExcelAutoFormat, bool) - Method in class ActiveXLS.ExcelWorksheet

Inserts the data from the specified DataSet object into this ExcelWorksheet starting with the specified cell

esd_insertRow(int, ExcelRow) - Method in class ActiveXLS.ExcelTable

Inserts the specified row to table into the specified position.

esd_insertWorksheet(int, ExcelWorksheet) - Method in class ActiveXLS.ExcelDocument

Inserts a worksheet to the sheet list on the specified position.

esd_insertWorksheet(int, String) - Method in class ActiveXLS.ExcelDocument

Inserts a worksheet having the specified worksheet name to the sheet list on the specified position.

esd_insertWorksheet(int, String, bool) - Method in class ActiveXLS.ExcelDocument

Inserts a worksheet having the worksheet name and selected option specified.

esd_insertXMLFromFile(String) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified XML file into this ExcelWorksheet starting from first row and first column of the worksheet data table

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

Inserts the XML data from the specified XML file into this ExcelWorksheet starting from the nStartRow row index and nStartCol column index

esd_insertXMLFromFile(String, String) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified XML file into this ExcelWorksheet starting with the specified cell

esd_insertXMLFromFile(InputStream) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified stream into this ExcelWorksheet starting from first row and first column of the worksheet data table

esd_insertXMLFromFile(InputStream, int, int) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified stream into this ExcelWorksheet starting from the nStartRow row index and nStartCol column index

esd_insertXMLFromFile(InputStream, String) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified stream into this ExcelWorksheet starting with the specified cell

esd_insertXMLFromString(String) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified string into this ExcelWorksheet starting from first row and first column of the worksheet data table

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

Inserts the XML data from the specified string into this ExcelWorksheet starting from the nStartRow row index and nStartCol column index

esd_insertXMLFromString(String, String) - Method in class ActiveXLS.ExcelWorksheet

Inserts the XML data from the specified XML file into this ExcelWorksheet starting with the specified cell

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

esd_mergeCells(String) - Method in class ActiveXLS.ExcelTable

Merging the cells inside the specified range.

esd_mergeCells(String, String) - Method in class ActiveXLS.ExcelTable

Merging the cells inside the range limited by the specified cell references.

esd_removeArrayFormula(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the array formula from the specified index.

esd_removeArrayFormula(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the array formula located at the specified reference.

esd_removeArrayFormula(int, int, int, int) - Method in class ActiveXLS.ExcelWorksheet

Removes the array formula located at the specified reference.

esd_removeCellAt(int) - Method in class ActiveXLS.ExcelRow

Removes the cell from the specified index

esd_removeCellMerging(int) - Method in class ActiveXLS.ExcelTable

Removes the cell merging area at the specified index from the table

esd_removeChart(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the chart from the specified index.

esd_removeColumn(int) - Method in class ActiveXLS.ExcelTable

Removes the column at the specified index from the table

esd_removeConditionalFormatting(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the conditional formatting range from the specified index.

esd_removeConditionalFormatting(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the conditional formatting from the specified range.

esd_removeDataGroup(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the data group from the specified index.

esd_removeDataGroup(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the data group from the specified range.

esd_removeDataValidator(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the data validator from the specified index.

esd_removeDataValidator(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the data validator from the specified range.

esd_removeFooter(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the footer from the specified index.

esd_removeFooter(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the footer from the specified position.

esd_removeHeader(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the header from the specified index.

esd_removeHeader(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the header from the specified position.

esd_removeHyperlink(int, bool) - Method in class ActiveXLS.ExcelWorksheet

Removes the hyperlink from the specified index.

esd_removeHyperlink(String, bool) - Method in class ActiveXLS.ExcelWorksheet

Removes the hyperlink from the specified position.

esd_removeImage(int) - Method in class ActiveXLS.ExcelChartSheet

Removes the image from the specified index.

esd_removeImage(String) - Method in class ActiveXLS.ExcelChartSheet

Removes the image that has the specified path from the chart sheet.

esd_removeImage(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the image from the specified index.

esd_removeImage(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the image that has the specified path from the worksheet.

esd_removeName(int) - Method in class ActiveXLS.ExcelWorksheet

Removes the name from the specified index.

esd_removeName(String) - Method in class ActiveXLS.ExcelWorksheet

Removes the name having the specified title.

esd_removePrintArea() - Method in class ActiveXLS.ExcelPageSetup

Removes the print area.

esd_removeRow(int) - Method in class ActiveXLS.ExcelTable

Removes the row at the specified index from the table

esd_removeSeries(int) - Method in class ActiveXLS.Charts.ExcelChart

Removes the series from the specified index.

esd_removeSheet(int) - Method in class ActiveXLS.ExcelDocument

Removes a sheet from the sheet list on the specified position.

esd_removeSheet(String) - Method in class ActiveXLS.ExcelDocument

Removes the sheet that has the specified name from the sheet list.

esd_removeSplit() - Method in class ActiveXLS.ExcelTable

Removes the split option for the table.

esd_removeVBMacros() - Method in class ActiveXLS.ExcelDocument

Removes the VB project and macros if any.

esd_resetAllPageBreaks() - Method in class ActiveXLS.ExcelTable

Resets all the defined page breaks.

esd_set3DElevation(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the 3D elevation setting of the chart.

esd_set3DHeight(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the 3D height of the chart.

esd_set3DPerspective(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the 3D perspective of the chart.

esd_set3DRotation(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the 3D rotation of the chart.

esd_setCategoryXAxis(ExcelAxis) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart category X axis.

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

Sets the labels of category X axis.

esd_setCellAt(ExcelCell, int) - Method in class ActiveXLS.ExcelRow

Sets the specified cell at the specified index.

esd_setCellAt(ExcelCell, int, int) - Method in class ActiveXLS.ExcelTable

Sets the cell at the specified position.

esd_setChartArea(ExcelChartArea) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart area.

esd_setChartDataTable(ExcelDataTable) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart data table.

esd_setChartType(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the type of the chart.

esd_setColumnsToRepeatAtLeft(int, int, bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the columns to repeat at left.

esd_setColumnsToRepeatAtLeft(int, int) - Method in class ActiveXLS.ExcelPageSetup

Sets the columns to repeat at left.

esd_setColumnsToRepeatAtLeft(String) - Method in class ActiveXLS.ExcelPageSetup

Sets the columns to repeat at left.

esd_setExcelChart(ExcelChart) - Method in class ActiveXLS.ExcelChartSheet

Sets the chart of the sheet.

esd_setExcelTable(ExcelTable) - Method in class ActiveXLS.ExcelWorksheet

Sets the table of the worksheet.

esd_setLegend(ExcelChartLegend) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart legend.

esd_setOptions(ExcelOptions) - Method in class ActiveXLS.ExcelDocument

Sets the options of an Excel document, available in the main menu Tools/Options window.

esd_setPlotArea(ExcelPlotArea) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart plot area.

esd_setPrintArea(int, int, int, int, bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the print area.

esd_setPrintArea(int, int, int, int) - Method in class ActiveXLS.ExcelPageSetup

Sets the print area.

esd_setPrintArea(String) - Method in class ActiveXLS.ExcelPageSetup

Sets the print area.

esd_setRangeAutoFormat(int, int, int, int, ExcelAutoFormat) - Method in class ActiveXLS.ExcelTable

Sets the specified autoformat for the range.

esd_setRangeAutoFormat(String, ExcelAutoFormat) - Method in class ActiveXLS.ExcelTable

Sets the specified autoformat for the range.

esd_setRangeAutoFormat(String, String, ExcelAutoFormat) - Method in class ActiveXLS.ExcelTable

Sets the specified autoformat for the range limited by the specified cell references.

esd_setRangeStyle(int, int, int, int, ExcelStyle) - Method in class ActiveXLS.ExcelTable

Sets the specified style for the range limited by the rows and columns.

esd_setRangeStyle(String, ExcelStyle) - Method in class ActiveXLS.ExcelTable

Sets the specified style for the range.

esd_setRangeStyle(String, String, ExcelStyle) - Method in class ActiveXLS.ExcelTable

Sets the specified style for the range limited by the specified cell references.

esd_setRowsToRepeatAtTop(int, int, bool) - Method in class ActiveXLS.ExcelPageSetup

Sets the rows to repeat at top.

esd_setRowsToRepeatAtTop(int, int) - Method in class ActiveXLS.ExcelPageSetup

Sets the rows to repeat at top.

esd_setRowsToRepeatAtTop(String) - Method in class ActiveXLS.ExcelPageSetup

Sets the rows to repeat at top.

esd_setSeriesGap(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the gap of the chart series.

esd_setSeriesOverlap(int) - Method in class ActiveXLS.Charts.ExcelChart

Sets the overlap of the chart series.

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

Sets the chart title.

esd_setUse3DPerspective(bool) - Method in class ActiveXLS.Charts.ExcelChart

Sets if the 3D setting of the chart is used.

esd_setValueYAxis(ExcelAxis) - Method in class ActiveXLS.Charts.ExcelChart

Sets the chart value Y axis.

esd_setXAxisMajorGridlines(ExcelChartGridlines) - Method in class ActiveXLS.Charts.ExcelChart

Sets the style of the major gridlines for the X axis.

esd_setXAxisMinorGridlines(ExcelChartGridlines) - Method in class ActiveXLS.Charts.ExcelChart

Sets the style of the minor gridlines for the X axis.

esd_setYAxisMajorGridlines(ExcelChartGridlines) - Method in class ActiveXLS.Charts.ExcelChart

Sets the style of the major gridlines for the Y axis.

esd_setYAxisMinorGridlines(ExcelChartGridlines) - Method in class ActiveXLS.Charts.ExcelChart

Sets the style of the major gridlines for the Y axis.

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

Sets the split option for the table.

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

Set the split option for the table.

esd_unfreezePanes() - Method in class ActiveXLS.ExcelTable

Unfreezes panes for the table.