ExcelDocument (ActiveXLS)

Overview

Namespace

Class

Use

Tree

Deprecated

Index

Help

ActiveXLS v6.4.0 API Documentation

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | CONST | CONSTR | METHOD

DETAIL: CONST | CONSTR | METHOD

ActiveXLS
Class ExcelDocument

System.Object
  ActiveXLS.ExcelDocument

public class ExcelDocument
extends System.Object

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

Constructor Summary
`ExcelDocument()` Defines an instance of the object that reads/writes Excel files.
`ExcelDocument(int worksheetCount)` Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets.
`ExcelDocument(int worksheetCount, int chartsheetCount)` Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets and chart sheets.

Method Summary
`ExcelDocument`	`Clone()` Creates and returns a copy of this object.
`void`	`Dispose()` Disposes any resources that it has allocated.
`void`	`esd_addChart(ExcelChartSheet xlsChartSheet)` Adds a chart to the sheet list.
`void`	`esd_addChart(System.String sheetName)` Adds a chart sheet having the specified sheet name to the sheet list.
`void`	`esd_addChart(System.String sheetName, bool isSelected)` Adds a chart sheet having the sheet name and selected option specified.
`void`	`esd_addChart(System.String sheetName, bool isSelected, System.String formulaDataRange, int seriesType)` Adds a chart sheet to the sheet list.
`void`	`esd_addChart(System.String sheetName, System.String formulaDataRange, int seriesType)` Adds a chart sheet to the sheet list.
`void`	`esd_addWorksheet(ExcelWorksheet xlsWorksheet)` Adds a worksheet to the sheet list.
`void`	`esd_addWorksheet(System.String sheetName)` Adds a worksheet having the specified worksheet name to the sheet list.
`void`	`esd_addWorksheet(System.String sheetName, bool isSelected)` Adds a worksheet having the worksheet name and selected option specified.
`System.String`	`esd_getError()` Returns the error generated during processing the file.
`ExcelOptions`	`esd_getOptions()` Returns the options of an Excel document, available in the main menu Tools/Options window.
`ExcelSheet`	`esd_getSheet(System.String sheetName)` Returns the sheet that has the specified name.
`ExcelSheet`	`esd_getSheetAt(int index)` Returns the sheet on the specified position.
`int`	`esd_getSheetPosition(System.String sheetName)` Returns the position in the sheet list of the sheet that has the specified name.
`void`	`esd_insertChart(int index, ExcelChartSheet xlsChartSheet)` Inserts a chart sheet in the sheet list on the specified position.
`void`	`esd_insertChart(int index, System.String sheetName)` Inserts a chart sheet having the specified sheet name in the sheet list on the specified position.
`void`	`esd_insertChart(int index, System.String sheetName, bool isSelected)` Inserts a chart sheet having the sheet name and selected option specified.
`void`	`esd_insertChart(int index, System.String sheetName, bool isSelected, System.String formulaDataRange, int seriesType)` Inserts a chart sheet in the sheet list on the specified position.
`void`	`esd_insertChart(int index, System.String sheetName, System.String formulaDataRange, int seriesType)` Inserts a chart sheet in the sheet list on the specified position.
`void`	`esd_insertWorksheet(int index, ExcelWorksheet xlsWorksheet)` Inserts a worksheet to the sheet list on the specified position.
`void`	`esd_insertWorksheet(int index, System.String sheetName)` Inserts a worksheet having the specified worksheet name to the sheet list on the specified position.
`void`	`esd_insertWorksheet(int index, System.String sheetName, bool isSelected)` Inserts a worksheet having the worksheet name and selected option specified.
`bool`	`esd_IsExcel(System.IO.Stream f)` Checks if the specified file is a Microsoft Excel document.
`bool`	`esd_IsExcel(System.String sPath)` Checks if the specified file is a Microsoft Excel document.
`bool`	`esd_LoadCSVFile(System.IO.Stream f)` Generates the document at the specified stream `Available for: Professional, Reader`
`bool`	`esd_LoadCSVFile(System.String sPath)` Loads a specified CSV document `Available for: Professional, Reader`
`bool`	`esd_LoadHTMLFile(System.IO.Stream f)` Loads the specified HTML file `Available for: Professional, Reader`
`bool`	`esd_LoadHTMLFile(System.String sPath)` Loads the specified HTML file `Available for: Professional, Reader`
`bool`	`esd_LoadTemplateFile(System.IO.Stream f)` Deprecated. As of ActiveXLS version 6.1, replaced by esd_LoadXLSFile(InputStream).
`bool`	`esd_LoadTemplateFile(System.String sPath)` Deprecated. As of ActiveXLS version 6.1, replaced by esd_LoadXLSFile(String).
`bool`	`esd_LoadTXTFile(System.IO.Stream f, System.String sRowDelimiter, System.String sColumnDelimiter)` Generates the document at the specified stream `Available for: Professional, Reader`
`bool`	`esd_LoadTXTFile(System.String sPath, System.String sRowDelimiter, System.String sColumnDelimiter)` Loads a specified document `Available for: Professional, Reader`
`bool`	`esd_LoadXLSBFile(System.IO.Stream f)` Loads the specified Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`bool`	`esd_LoadXLSBFile(System.String sPath)` Loads the specified Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`bool`	`esd_LoadXLSFile(System.IO.Stream f)` Loads a specified Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`bool`	`esd_LoadXLSFile(System.String sPath)` Loads a specified Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`bool`	`esd_LoadXLSXFile(System.IO.Stream f)` Loads the specified Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`bool`	`esd_LoadXLSXFile(System.String sPath)` Loads the specified Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`bool`	`esd_LoadXMLSpreadsheetFile(System.IO.Stream f)` Loads a specified XML Spreadsheet document `Available for: Professional, Reader`
`bool`	`esd_LoadXMLSpreadsheetFile(System.String sPath)` Loads a specified XML Spreadsheet document `Available for: Professional, Reader`
`List`	`esd_ReadCSVFile_AsList(System.IO.Stream f)` Reads the cell values from the specified CSV document `Available for: Professional, Reader`
`List`	`esd_ReadCSVFile_AsList(System.String sPath)` Reads the cell values from the specified CSV document `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadCSVFile_AsDataSet(System.IO.Stream f)` Reads the cell values from the specified CSV document `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadCSVFile_AsDataSet(System.String sPath)` Reads the cell values from the specified CSV document `Available for: Professional, Reader`
`List`	`esd_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object `Available for: Professional, Reader`
`List`	`esd_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object `Available for: Professional, Reader`
`List`	`esd_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object `Available for: Professional, Reader`
`List`	`esd_ReadExcelWorksheet_AsList(System.String sheetName)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object `Available for: Professional, Reader`
`List`	`esd_ReadExcelWorksheet_AsList(System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object `Available for: Professional, Reader`
`List`	`esd_ReadExcelWorksheet_AsList(System.String sheetName, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a List object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadExcelWorksheet_AsDataSet(System.String sheetName)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadExcelWorksheet_AsDataSet(System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadExcelWorksheet_AsDataSet(System.String sheetName, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument into a DataSet object `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.IO.Stream f, ExcelWorksheet xlsWorksheet)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.IO.Stream f, ExcelWorksheet xlsWorksheet, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.IO.Stream f, ExcelWorksheet xlsWorksheet, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.IO.Stream f, System.String sheetName, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.String XMLFilePath, ExcelWorksheet xlsWorksheet)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.String XMLFilePath, ExcelWorksheet xlsWorksheet, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.String XMLFilePath, ExcelWorksheet xlsWorksheet, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.String XMLFilePath, System.String sheetName)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.String XMLFilePath, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`bool`	`esd_ReadExcelWorksheet_AsXML(System.String XMLFilePath, System.String sheetName, System.String sRangeReference)` Reads the cell values from the specified ExcelWorksheet of the ActiveXLS ExcelDocument and writes them into an XML document `Available for: Professional, Reader`
`List`	`esd_ReadTXTFile_AsList(System.IO.Stream f, System.String sRowDelimiter, System.String sColumnDelimiter)` Reads the cell values from the specified TXT document `Available for: Professional, Reader`
`List`	`esd_ReadTXTFile_AsList(System.String sPath, System.String sRowDelimiter, System.String sColumnDelimiter)` Reads the cell values from the specified TXT document `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadTXTFile_AsDataSet(System.IO.Stream f, System.String sRowDelimiter, System.String sColumnDelimiter)` Reads the cell values from the specified TXT document `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadTXTFile_AsDataSet(System.String sPath, System.String sRowDelimiter, System.String sColumnDelimiter)` Reads the cell values from the specified TXT document `Available for: Professional, Reader`
`List`	`esd_ReadXLSActiveSheet_AsList(System.IO.Stream f)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`List`	`esd_ReadXLSActiveSheet_AsList(System.String sPath)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSActiveSheet_AsDataSet(System.IO.Stream f)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSActiveSheet_AsDataSet(System.String sPath)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`List`	`esd_ReadXLSBActiveSheet_AsList(System.IO.Stream f)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSBActiveSheet_AsList(System.String sPath)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSBActiveSheet_AsDataSet(System.IO.Stream f)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSBActiveSheet_AsDataSet(System.String path)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSBSheet_AsList(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSBSheet_AsList(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`List`	`esd_ReadXLSBSheet_AsList(System.IO.Stream f, System.String sheetName, System.String rangeReference)` 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`
`List`	`esd_ReadXLSBSheet_AsList(System.String path, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSBSheet_AsList(System.String path, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`List`	`esd_ReadXLSBSheet_AsList(System.String path, System.String sheetName, System.String rangeReference)` 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`
`System.Data.DataSet`	`esd_ReadXLSBSheet_AsDataSet(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSBSheet_AsDataSet(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`System.Data.DataSet`	`esd_ReadXLSBSheet_AsDataSet(System.IO.Stream f, System.String sheetName, System.String sRangeReference)` 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`
`System.Data.DataSet`	`esd_ReadXLSBSheet_AsDataSet(System.String path, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSBSheet_AsDataSet(System.String path, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`System.Data.DataSet`	`esd_ReadXLSBSheet_AsDataSet(System.String path, System.String sheetName, System.String sRangeReference)` 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`
`bool`	`esd_ReadXLSBSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB, System.String sheetName)` 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`
`bool`	`esd_ReadXLSBSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`bool`	`esd_ReadXLSBSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB, System.String sheetName, System.String sRangeReference)` 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`
`bool`	`esd_ReadXLSBSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath, System.String sheetName)` 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`
`bool`	`esd_ReadXLSBSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`bool`	`esd_ReadXLSBSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath, System.String sheetName, System.String sRangeReference)` 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`
`List`	`esd_ReadXLSSheet_AsList(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`List`	`esd_ReadXLSSheet_AsList(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object `Available for: Professional, Reader`
`List`	`esd_ReadXLSSheet_AsList(System.IO.Stream f, System.String sheetName, System.String rangeReference)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object `Available for: Professional, Reader`
`List`	`esd_ReadXLSSheet_AsList(System.String path, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`List`	`esd_ReadXLSSheet_AsList(System.String path, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object `Available for: Professional, Reader`
`List`	`esd_ReadXLSSheet_AsList(System.String path, System.String sheetName, System.String rangeReference)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSSheet_AsDataSet(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSSheet_AsDataSet(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSSheet_AsDataSet(System.IO.Stream f, System.String sheetName, System.String sRangeReference)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSSheet_AsDataSet(System.String path, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSSheet_AsDataSet(System.String path, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSSheet_AsDataSet(System.String path, System.String sheetName, System.String sRangeReference)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object `Available for: Professional, Reader`
`bool`	`esd_ReadXLSSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS, System.String sheetName)` 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`
`bool`	`esd_ReadXLSSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`bool`	`esd_ReadXLSSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS, System.String sheetName, System.String sRangeReference)` 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`
`bool`	`esd_ReadXLSSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath, System.String sheetName)` 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`
`bool`	`esd_ReadXLSSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`bool`	`esd_ReadXLSSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath, System.String sheetName, System.String sRangeReference)` 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`
`List`	`esd_ReadXLSXActiveSheet_AsList(System.IO.Stream f)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSXActiveSheet_AsList(System.String sPath)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSXActiveSheet_AsDataSet(System.IO.Stream f)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSXActiveSheet_AsDataSet(System.String path)` Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSXSheet_AsList(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSXSheet_AsList(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`List`	`esd_ReadXLSXSheet_AsList(System.IO.Stream f, System.String sheetName, System.String rangeReference)` 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`
`List`	`esd_ReadXLSXSheet_AsList(System.String path, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`List`	`esd_ReadXLSXSheet_AsList(System.String path, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`List`	`esd_ReadXLSXSheet_AsList(System.String path, System.String sheetName, System.String rangeReference)` 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`
`System.Data.DataSet`	`esd_ReadXLSXSheet_AsDataSet(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSXSheet_AsDataSet(System.IO.Stream f, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`System.Data.DataSet`	`esd_ReadXLSXSheet_AsDataSet(System.IO.Stream f, System.String sheetName, System.String sRangeReference)` 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`
`System.Data.DataSet`	`esd_ReadXLSXSheet_AsDataSet(System.String path, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXLSXSheet_AsDataSet(System.String path, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`System.Data.DataSet`	`esd_ReadXLSXSheet_AsDataSet(System.String path, System.String sheetName, System.String sRangeReference)` 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`
`bool`	`esd_ReadXLSXSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX, System.String sheetName)` 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`
`bool`	`esd_ReadXLSXSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`bool`	`esd_ReadXLSXSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX, System.String sheetName, System.String sRangeReference)` 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`
`bool`	`esd_ReadXLSXSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath, System.String sheetName)` 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`
`bool`	`esd_ReadXLSXSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath, System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)` 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`
`bool`	`esd_ReadXLSXSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath, System.String sheetName, System.String sRangeReference)` 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`
`List`	`esd_ReadXMLSpreadsheet_AsList(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a List object `Available for: Professional, Reader`
`List`	`esd_ReadXMLSpreadsheet_AsList(System.String sPath, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXMLSpreadsheet_AsDataSet(System.IO.Stream f, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object `Available for: Professional, Reader`
`System.Data.DataSet`	`esd_ReadXMLSpreadsheet_AsDataSet(System.String sPath, System.String sheetName)` Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object `Available for: Professional, Reader`
`void`	`esd_removeSheet(int index)` Removes a sheet from the sheet list on the specified position.
`void`	`esd_removeSheet(System.String sheetName)` Removes the sheet that has the specified name from the sheet list.
`void`	`esd_removeVBMacros()` Removes the VB project and macros if any.
`void`	`esd_setOptions(ExcelOptions xlsOptions)` Sets the options of an Excel document, available in the main menu Tools/Options window.
`void`	`esd_WriteCSVFile(System.IO.Stream f, System.String sSheetName)` Generates the CSV at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteCSVFile(System.String sPath, System.String sSheetName)` Generates the CSV document at the specified path `Available for: Professional, Writer`
`void`	`esd_WriteExcelFile(System.IO.Stream f)` Deprecated. As of ActiveXLS version 6.1, replaced by esd_WriteXLSFile(OutputStream).
`void`	`esd_WriteExcelFile(System.String sPath)` Deprecated. As of ActiveXLS version 6.1, replaced by esd_WriteXLSFile(String).
`void`	`esd_WriteHTMLFile(System.IO.Stream f, System.String sSheetName)` Generates the HTML at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteHTMLFile(System.String sPath, System.String sSheetName)` Generates the HTML document at the specified path `Available for: Professional, Writer`
`void`	`esd_WriteTXTFile(System.IO.Stream f, System.String sSheetName, System.String sRowDelimiter, System.String sColumnDelimiter)` Generates the document at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteTXTFile(System.String sPath, System.String sSheetName, System.String sRowDelimiter, System.String sColumnDelimiter)` Generates the TXT document at the specified path `Available for: Professional, Writer`
`void`	`esd_WriteXLSBFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromList(System.String sPath, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromList(System.String sPath, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromList(System.String sPath, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromDataSet(System.String sPath, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromDataSet(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile_FromDataSet(System.String sPath, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSBFile(System.IO.Stream f)` Generates the Microsoft Excel document (Office 2007 binary file format) at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteXLSBFile(System.String sPath)` Generates the Microsoft Excel Office2007 binary document at the specified path `Available for: Professional, Writer`
`void`	`esd_WriteXLSFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromList(System.String sPath, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromList(System.String sPath, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromList(System.String sPath, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromDataSet(System.String sPath, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromDataSet(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile_FromDataSet(System.String sPath, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSFile(System.IO.Stream f)` Generates the Microsoft Excel document (Office 97-2003) at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteXLSFile(System.String sPath)` Generates the Microsoft Excel document (Office 97-2003) at the specified path `Available for: Professional, Writer`
`void`	`esd_WriteXLSXFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromList(System.String sPath, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromList(System.String sPath, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromList(System.String sPath, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromDataSet(System.String sPath, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromDataSet(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile_FromDataSet(System.String sPath, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)` Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data `Available for: Professional, Writer, Express Writer`
`void`	`esd_WriteXLSXFile(System.IO.Stream f)` Generates the Microsoft Excel document (Office 2007 file format) at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteXLSXFile(System.String sPath)` Generates the Microsoft Excel Office2007 document at the specified path `Available for: Professional, Writer`
`void`	`esd_WriteXMLFile(System.IO.Stream f)` Generates the XML document at the specified stream `Available for: Professional, Writer`
`void`	`esd_WriteXMLFile(System.String sPath)` Generates the XML document at the specified path `Available for: Professional, Writer`
`int`	`getCurrentSheet()` Returns the current sheet displayed when the document is loaded in Microsoft Excel.
`DocumentSummaryInformation`	`getDocumentSummaryInformation()` Returns the document summary information of an Excel document.
`ExternalLinks`	`getExternalLinks()` Returns the list of the external links from the formulas inside the Excel document.
`SummaryInformation`	`getSummaryInformation()` Returns the summary information of an Excel document.
`void`	`setCurrentSheet(int tabIndex)` Sets the current sheet displayed when the document is loaded in Microsoft Excel.
`void`	`setDocumentSummaryInformation(DocumentSummaryInformation documentSummaryInformation)` Sets the document summary information of an Excel document.
`void`	`setSummaryInformation(SummaryInformation summaryInformation)` Sets the summary information of an Excel document.
`int`	`SheetCount()` Returns the number of sheets in the workbook.

Constructor Detail

ExcelDocument

public ExcelDocument()

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

ExcelDocument

public ExcelDocument(int worksheetCount)

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

ExcelDocument

public ExcelDocument(int worksheetCount,
                     int chartsheetCount)

Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets and chart sheets.
Parameters:: worksheetCount - the number of worksheets.; chartsheetCount - the number of chart sheets.

Method Detail

esd_getError

public System.String esd_getError()

Returns the error generated during processing the file.

Returns:: the error generated during processing the file.

SheetCount

public int SheetCount()

Returns the number of sheets in the workbook.

Returns:: the number of sheets in the workbook
See Also:: esd_addWorksheet(ActiveXLS.ExcelWorksheet), esd_removeSheet(int), esd_getSheetAt(int), esd_getSheet(System.String)

esd_IsExcel

public bool esd_IsExcel(System.String sPath)

Checks if the specified file is a Microsoft Excel document.

Parameters:: sPath - the path of the file.
Returns:: true if the file is an Excel document, false otherwise
Throws:: System.Exception

esd_IsExcel

public bool esd_IsExcel(System.IO.Stream f)

Checks if the specified file is a Microsoft Excel document.

Parameters:: f - the stream that points the file.
Returns:: true if the file is an Excel document, false otherwise
Throws:: System.Exception

esd_LoadTemplateFile

public bool esd_LoadTemplateFile(System.String sPath)

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

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

Parameters:: sPath - the path to the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadXLSFile

public bool esd_LoadXLSFile(System.String sPath)

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

Parameters:: sPath - the path to the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadTemplateFile

public bool esd_LoadTemplateFile(System.IO.Stream f)

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

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

Parameters:: f - the stream that points the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadXLSFile

public bool esd_LoadXLSFile(System.IO.Stream f)

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

Parameters:: f - the stream that points the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadXLSXFile

public bool esd_LoadXLSXFile(System.String sPath)

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

Parameters:: sPath - the path to the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadXLSXFile

public bool esd_LoadXLSXFile(System.IO.Stream f)

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

Parameters:: f - the stream that points the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadXLSBFile

public bool esd_LoadXLSBFile(System.String sPath)

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

Parameters:: sPath - the path to the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_LoadXLSBFile

public bool esd_LoadXLSBFile(System.IO.Stream f)

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

Parameters:: f - the stream that points the Excel document.
Returns:: true if the load operation is successful, false otherwise.
Throws:: System.Exception

esd_ReadTXTFile_AsList

public List esd_ReadTXTFile_AsList(System.String sPath,
                                   System.String sRowDelimiter,
                                   System.String sColumnDelimiter)

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

Parameters:: sPath - the path to the TXT document.; sRowDelimiter - the row delimiter.; sColumnDelimiter - the column delimiter.
Returns:: a List that contains the cell values
Throws:: System.Exception

esd_ReadTXTFile_AsList

public List esd_ReadTXTFile_AsList(System.IO.Stream f,
                                   System.String sRowDelimiter,
                                   System.String sColumnDelimiter)

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

Parameters:: f - the stream that points to the TXT document.; sRowDelimiter - the row delimiter.; sColumnDelimiter - the column delimiter.
Returns:: a List that contains the cell values
Throws:: System.Exception

esd_ReadCSVFile_AsList

public List esd_ReadCSVFile_AsList(System.String sPath)

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

Parameters:: sPath - the path to the CSV document.
Returns:: a List that contains the cell values
Throws:: System.Exception

esd_ReadCSVFile_AsList

public List esd_ReadCSVFile_AsList(System.IO.Stream f)

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

Parameters:: f - the stream that points to the CSV document.
Returns:: a List that contains the cell values
Throws:: System.Exception

esd_ReadXLSSheet_AsXML

public bool esd_ReadXLSSheet_AsXML(System.String XMLFilePath,
                                      System.String XLSFilePath,
                                      System.String sheetName,
                                      int startRow,
                                      int startColumn,
                                      int endRow,
                                      int endColumn)

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

Parameters:: XMLFilePath - the path to the XML document.; XLSFilePath - the path to the Excel document.; sheetName - the name of the worksheet that will be read.; startRow - first row index of the cells that will be read.; startColumn - first column index of the cells that will be read.; endRow - last row index of the cells that will be read.; endColumn - last column index of the cells that will be read.
Returns:: true if the read operation is successful, false otherwise.
Throws:: System.Exception

esd_ReadXLSSheet_AsXML

public bool esd_ReadXLSSheet_AsXML(System.String XMLFilePath,
                                      System.String XLSFilePath,
                                      System.String sheetName)

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

Parameters:: XMLFilePath - the path to the XML document.; XLSFilePath - the path to the Excel document.; sheetName - the name of the worksheet that will be read.
Returns:: true if the read operation is successful, false otherwise.
Throws:: System.Exception

esd_ReadXLSSheet_AsXML

public bool esd_ReadXLSSheet_AsXML(System.String XMLFilePath,
                                      System.String XLSFilePath,
                                      System.String sheetName,
                                      System.String sRangeReference)

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

Parameters:: XMLFilePath - the path to the XML document.; XLSFilePath - the path to the Excel document.; sheetName - the name of the worksheet that will be read.; sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
Returns:: true if the read operation is successful, false otherwise.
Throws:: System.Exception

esd_ReadXLSSheet_AsXML

public bool esd_ReadXLSSheet_AsXML(System.IO.Stream fXML,
                                      System.IO.Stream fXLS,
                                      System.String sheetName,
                                      int startRow,
                                      int startColumn,
                                      int endRow,
                                      int endColumn)

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

Parameters:: fXML - the stream that points to the XML document.; fXLS - the stream that points to the Excel document.; sheetName - the name of the worksheet that will be read.; startRow - first row index of the cells that will be read.; startColumn - first column index of the cells that will be read.; endRow - last row index of the cells that will be read.; endColumn - last column index of the cells that will be read.
Returns:: true if the read operation is successful, false otherwise.
Throws:: System.Exception

esd_ReadXLSSheet_AsXML

public bool esd_ReadXLSSheet_AsXML(System.IO.Stream fXML,
                                      System.IO.Stream fXLS,
                                      System.String sheetName)

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

Parameters:: fXML - the stream that points to the XML document.; fXLS - the stream that points to the Excel document.; sheetName - the name of the worksheet that will be read.
Returns:: true if the read operation is successful, false otherwise.
Throws:: System.Exception

esd_ReadXLSSheet_AsXML

public bool esd_ReadXLSSheet_AsXML(System.IO.Stream fXML,
                                      System.IO.Stream fXLS,
                                      System.String sheetName,
                                      System.String sRangeReference)

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

Parameters:: fXML - the stream that points to the XML document.; fXLS - the stream that points to the Excel document.; sheetName - the name of the worksheet that will be read.; sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
Returns:: true if the read operation is successful, false otherwise.
Throws:: System.Exception