Namespace EasyXLS

Class ExcelDocument

System.Object

EasyXLS.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

Constructors

Constructor	Description
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

Modifier and Type	Method	Description
ExcelDocument	Clone()	Creates and returns a copy of this object.
void	Dispose()	Disposes any resources that it has allocated.
void	easy_addChart(ExcelChartSheet xlsChartSheet)	Adds a chart to the sheet list.
void	easy_addChart(System.String sheetName)	Adds a chart sheet having the specified sheet name to the sheet list This method is overridden as easy_addChart_2 in COM+ version of EasyXLS.
void	easy_addChart(System.String sheetName, bool isSelected)	Adds a chart sheet having the sheet name and selected option specified This method is overridden as easy_addChart_3 in COM+ version of EasyXLS.
void	easy_addChart(System.String sheetName, bool isSelected, System.String formulaDataRange, int seriesType)	Adds a chart sheet to the sheet list and the chart has the sheet name, the selected option, the data range and the type of the series specified This method is overridden as easy_addChart_4 in COM+ version of EasyXLS.
void	easy_addChart(System.String sheetName, System.String formulaDataRange, int seriesType)	Adds a chart sheet to the sheet list and the chart has the sheet name, the data range and the type of the series specified This method is overridden as easy_addChart_5 in COM+ version of EasyXLS.
void	easy_addWorksheet(ExcelWorksheet xlsWorksheet)	Adds a worksheet to the sheet list.
void	easy_addWorksheet(System.String sheetName)	Adds a worksheet having the specified worksheet name to the sheet list This method is overridden as easy_addWorksheet_2 in COM+ version of EasyXLS.
void	easy_addWorksheet(System.String sheetName, bool isSelected)	Adds a worksheet having the worksheet name and selected option specified This method is overridden as easy_addWorksheet_3 in COM+ version of EasyXLS.
System.String	easy_getError()	Returns the error generated during processing the file.
ExcelOptions	easy_getOptions()	Returns the options of an Excel document, available in the main menu Tools/Options window.
ExcelSheet	easy_getSheet(System.String sheetName)	Returns the sheet that has the specified name.
ExcelSheet	easy_getSheetAt(int index)	Returns the sheet on the specified position.
int	easy_getSheetPosition(System.String sheetName)	Returns the position in the sheet list of the sheet that has the specified name.
System.String	easy_getWarnings()	Returns the warnings occured during processing the file.
void	easy_insertChart(int index, ExcelChartSheet xlsChartSheet)	Inserts a chart sheet in the sheet list on the specified position.
void	easy_insertChart(int index, System.String sheetName)	Inserts a chart sheet having the specified sheet name in the sheet list on the specified position This method is overridden as easy_insertChart_2 in COM+ version of EasyXLS.
void	easy_insertChart(int index, System.String sheetName, bool isSelected)	Inserts a chart sheet having the sheet name and selected option specified This method is overridden as easy_insertChart_3 in COM+ version of EasyXLS.
void	easy_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 This method is overridden as easy_insertChart_4 in COM+ version of EasyXLS. The chart has the sheet name, the selected option, the data range and the type of the series specified.
void	easy_insertChart(int index, System.String sheetName, System.String formulaDataRange, int seriesType)	Inserts a chart sheet in the sheet list on the specified position and the chart has the sheet name, the data range and the type of the series specified This method is overridden as easy_insertChart_5 in COM+ version of EasyXLS.
void	easy_insertWorksheet(int index, ExcelWorksheet xlsWorksheet)	Inserts a worksheet to the sheet list on the specified position.
void	easy_insertWorksheet(int index, System.String sheetName)	Inserts a worksheet having the specified worksheet name to the sheet list on the specified position This method is overridden as easy_insertWorksheet_2 in COM+ version of EasyXLS.
void	easy_insertWorksheet(int index, System.String sheetName, bool isSelected)	Inserts a worksheet having the worksheet name and selected option specified This method is overridden as easy_insertWorksheet_3 in COM+ version of EasyXLS.
bool	easy_IsExcel(System.IO.Stream f)	Checks if the specified file is a Microsoft Excel document.
bool	easy_IsExcel(System.String path)	Checks if the specified file is a Microsoft Excel document.
bool	easy_LoadCSVFile(System.IO.Stream f)	Generates the document at the specified stream Available for: Professional, Reader
bool	easy_LoadCSVFile(System.IO.StreamReader f)	Generates the document at the specified stream Available for: Professional, Reader
bool	easy_LoadCSVFile(System.String path)	Loads a specified CSV document Available for: Professional, Reader
bool	easy_LoadCSVFile(System.String path, System.String encoding)	Loads the CSV file with specified encoding; most common values are available in Encoding class This method is overridden as easy_LoadCSVFile_4 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_LoadHTMLFile(System.IO.Stream f)	Loads the specified HTML file Available for: Professional, Reader
bool	easy_LoadHTMLFile(System.IO.StreamReader f)	Loads the specified HTML file and the character encoding can be set to the stream Available for: Professional, Reader
bool	easy_LoadHTMLFile(System.String path)	Loads the specified HTML file This method is overridden as easy_LoadHTMLFile_2 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_LoadHTMLFile(System.String path, System.String encoding)	Loads the HTML file with specified encoding; most common values are available in Encoding class This method is overridden as easy_LoadHTMLFile_4 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_LoadTXTFile(System.IO.StreamReader f, System.String rowDelimiter, System.String columnDelimiter)	Generates the document at the specified stream and the character encoding can be set to the stream Available for: Professional, Reader
bool	easy_LoadTXTFile(System.IO.Stream f, System.String rowDelimiter, System.String columnDelimiter)	Generates the document at the specified stream Available for: Professional, Reader
bool	easy_LoadTXTFile(System.String path, System.String rowDelimiter, System.String columnDelimiter)	Loads a specified document Available for: Professional, Reader
bool	easy_LoadTXTFile(System.String path, System.String encoding, System.String rowDelimiter, System.String columnDelimiter)	Loads the TXT file with specified encoding; most common values are available in Encoding class This method is overridden as easy_LoadTXTFile_4 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_LoadXLSBFile(System.IO.Stream f)	Loads the specified Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
bool	easy_LoadXLSBFile(System.String path)	Loads the specified Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
bool	easy_LoadXLSFile(System.IO.Stream f)	Loads a specified Microsoft Excel document (Office 97-2003) Available for: Professional, Reader
bool	easy_LoadXLSFile(System.String path)	Loads a specified Microsoft Excel document (Office 97-2003) Available for: Professional, Reader
bool	easy_LoadXLSXFile(System.IO.Stream f)	Loads the specified Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
bool	easy_LoadXLSXFile(System.String path)	Loads the specified Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
bool	easy_LoadXMLSpreadsheetFile(System.IO.Stream f)	Loads a specified XML Spreadsheet document Available for: Professional, Reader
bool	easy_LoadXMLSpreadsheetFile(System.String path)	Loads a specified XML Spreadsheet document Available for: Professional, Reader
List	easy_ReadCSVFile_AsList(System.IO.Stream f)	Reads the cell values from the specified CSV document Available for: Professional, Reader
List	easy_ReadCSVFile_AsList(System.IO.StreamReader f)	Reads the cell values from the specified CSV document Available for: Professional, Reader
List	easy_ReadCSVFile_AsList(System.String path)	Reads the cell values from the specified CSV document Available for: Professional, Reader
List	easy_ReadCSVFile_AsList(System.String path, System.String encoding)	Reads the cell values from the specified CSV file with specified encoding; most common values are available in Encoding class This method is overridden as easy_ReadCSVFile_AsList_4 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_ReadCSVFile_AsDataSet(System.IO.Stream f)	Reads the cell values from the specified CSV document Available for: Professional, Reader
System.Data.DataSet	easy_ReadCSVFile_AsDataSet(System.IO.StreamReader f)	Reads the cell values from the specified CSV document Available for: Professional, Reader
System.Data.DataSet	easy_ReadCSVFile_AsDataSet(System.String path)	Reads the cell values from the specified CSV document Available for: Professional, Reader
System.Data.DataSet	easy_ReadCSVFile_AsDataSet(System.String path, System.String encoding)	Reads the cell values from the CSV file with specified encoding; most common values are available in Encoding class Available for: Professional, Reader
List	easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object This method is overridden as easy_ReadExcelWorksheet_AsList_2 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object Available for: Professional, Reader
List	easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object This method is overridden as easy_ReadExcelWorksheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadExcelWorksheet_AsList(System.String sheetName)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object This method is overridden as easy_ReadExcelWorksheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadExcelWorksheet_AsList(System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object This method is overridden as easy_ReadExcelWorksheet_AsList_4 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadExcelWorksheet_AsList(System.String sheetName, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object This method is overridden as easy_ReadExcelWorksheet_AsList_6 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadExcelWorksheet_AsDataSet(System.String sheetName)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadExcelWorksheet_AsDataSet(System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadExcelWorksheet_AsDataSet(System.String sheetName, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.IO.Stream f, ExcelWorksheet xlsWorksheet)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_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 EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.IO.Stream f, ExcelWorksheet xlsWorksheet, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.IO.Stream f, System.String sheetName)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_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 EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.IO.Stream f, System.String sheetName, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath, ExcelWorksheet xlsWorksheet)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document This method is overridden as easy_ReadExcelWorksheet_AsXML_2 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_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 EasyXLS ExcelDocument and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath, ExcelWorksheet xlsWorksheet, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document This method is overridden as easy_ReadExcelWorksheet_AsXML_3 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath, System.String sheetName)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document This method is overridden as easy_ReadExcelWorksheet_AsXML_5 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_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 EasyXLS ExcelDocument and writes them into an XML document This method is overridden as easy_ReadExcelWorksheet_AsXML_4 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath, System.String sheetName, System.String rangeReference)	Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document This method is overridden as easy_ReadExcelWorksheet_AsXML_6 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadTXTFile_AsList(System.IO.StreamReader f, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the specified TXT document Available for: Professional, Reader
List	easy_ReadTXTFile_AsList(System.IO.Stream f, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the specified TXT document Available for: Professional, Reader
List	easy_ReadTXTFile_AsList(System.String path, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the specified TXT document Available for: Professional, Reader
List	easy_ReadTXTFile_AsList(System.String path, System.String encoding, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the TXT file with specified encoding; most common values are available in Encoding class This method is overridden as easy_ReadTXTFile_AsList_4 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_ReadTXTFile_AsDataSet(System.IO.StreamReader f, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the specified TXT document Available for: Professional, Reader
System.Data.DataSet	easy_ReadTXTFile_AsDataSet(System.IO.Stream f, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the specified TXT document Available for: Professional, Reader
System.Data.DataSet	easy_ReadTXTFile_AsDataSet(System.String path, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the specified TXT document Available for: Professional, Reader
System.Data.DataSet	easy_ReadTXTFile_AsDataSet(System.String path, System.String encoding, System.String rowDelimiter, System.String columnDelimiter)	Reads the cell values from the TXT file with specified encoding; most common values are available in Encoding class Available for: Professional, Reader
List	easy_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	easy_ReadXLSActiveSheet_AsList(System.IO.Stream f, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object Available for: Professional, Reader
List	easy_ReadXLSActiveSheet_AsList(System.IO.Stream f, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object Available for: Professional, Reader
List	easy_ReadXLSActiveSheet_AsList(System.String path)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) Available for: Professional, Reader
List	easy_ReadXLSActiveSheet_AsList(System.String path, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object This method is overridden as easy_ReadXLSActiveSheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadXLSActiveSheet_AsList(System.String path, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object This method is overridden as easy_ReadXLSActiveSheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_ReadXLSActiveSheet_AsDataSet(System.IO.Stream f, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSActiveSheet_AsDataSet(System.IO.Stream f, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSActiveSheet_AsDataSet(System.String path)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSActiveSheet_AsDataSet(System.String path, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSActiveSheet_AsDataSet(System.String path, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object Available for: Professional, Reader
bool	easy_ReadXLSActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified range of the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS, System.String rangeReference)	Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSActiveSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSActiveSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document This method is overridden as easy_ReadXLSActiveSheet_AsXML_5 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_ReadXLSActiveSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath, System.String rangeReference)	Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document This method is overridden as easy_ReadXLSActiveSheet_AsXML_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_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	easy_ReadXLSBActiveSheet_AsList(System.IO.Stream f, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
List	easy_ReadXLSBActiveSheet_AsList(System.IO.Stream f, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
List	easy_ReadXLSBActiveSheet_AsList(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	easy_ReadXLSBActiveSheet_AsList(System.String path, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) This method is overridden as easy_ReadXLSBActiveSheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadXLSBActiveSheet_AsList(System.String path, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) This method is overridden as easy_ReadXLSBActiveSheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_ReadXLSBActiveSheet_AsDataSet(System.IO.Stream f, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSBActiveSheet_AsDataSet(System.IO.Stream f, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
System.Data.DataSet	easy_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
System.Data.DataSet	easy_ReadXLSBActiveSheet_AsDataSet(System.String path, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSBActiveSheet_AsDataSet(System.String path, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
bool	easy_ReadXLSBActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSBActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified range of the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSBActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB, System.String rangeReference)	Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSBActiveSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSBActiveSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document This method is overridden as easy_ReadXLSBActiveSheet_AsXML_5 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_ReadXLSBActiveSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath, System.String rangeReference)	Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document This method is overridden as easy_ReadXLSBActiveSheet_AsXML_3 in of EasyXLS. Available for: Professional, Reader
System.String[]	easy_ReadXLSBFile_SheetNames(System.IO.Stream f)	Reads the sheet names of the Microsoft Excel document (XLSB file format) Available for: Professional, Reader
System.String[]	easy_ReadXLSBFile_SheetNames(System.String path)	Reads the sheet names of the Microsoft Excel document (XLSB file format) Available for: Professional, Reader
List	easy_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	easy_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	easy_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	easy_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) This method is overridden as easy_ReadXLSBSheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_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	easy_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 This method is overridden as easy_ReadXLSBSheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_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	easy_ReadXLSBSheet_AsDataSet(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 DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_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	easy_ReadXLSBSheet_AsDataSet(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 DataSet object Available for: Professional, Reader
bool	easy_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	easy_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	easy_ReadXLSBSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSB, System.String sheetName, System.String rangeReference)	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	easy_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 This method is overridden as easy_ReadXLSBSheet_AsXML_2 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_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	easy_ReadXLSBSheet_AsXML(System.String XMLFilePath, System.String XLSBFilePath, System.String sheetName, System.String rangeReference)	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 This method is overridden as easy_ReadXLSBSheet_AsXML_3 in COM+ version of EasyXLS. Available for: Professional, Reader
System.String[]	easy_ReadXLSFile_SheetNames(System.IO.Stream f)	Reads the sheet names of the Microsoft Excel document (XLS file format) Available for: Professional, Reader
System.String[]	easy_ReadXLSFile_SheetNames(System.String path)	Reads the sheet names of the Microsoft Excel document (XLS file format) Available for: Professional, Reader
List	easy_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	easy_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	easy_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	easy_ReadXLSSheet_AsList(System.String path, System.String sheetName)	Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) This method is overridden as easy_ReadXLSSheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_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	easy_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 This method is overridden as easy_ReadXLSSheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_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	easy_ReadXLSSheet_AsDataSet(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 DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_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	easy_ReadXLSSheet_AsDataSet(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 DataSet object Available for: Professional, Reader
bool	easy_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	easy_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	easy_ReadXLSSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLS, System.String sheetName, System.String rangeReference)	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	easy_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 This method is overridden as easy_ReadXLSSheet_AsXML_2 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_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	easy_ReadXLSSheet_AsXML(System.String XMLFilePath, System.String XLSFilePath, System.String sheetName, System.String rangeReference)	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 This method is overridden as easy_ReadXLSSheet_AsXML_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_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	easy_ReadXLSXActiveSheet_AsList(System.IO.Stream f, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
List	easy_ReadXLSXActiveSheet_AsList(System.IO.Stream f, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
List	easy_ReadXLSXActiveSheet_AsList(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	easy_ReadXLSXActiveSheet_AsList(System.String path, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) This method is overridden as easy_ReadXLSXActiveSheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_ReadXLSXActiveSheet_AsList(System.String path, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) This method is overridden as easy_ReadXLSXActiveSheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_ReadXLSXActiveSheet_AsDataSet(System.IO.Stream f, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSXActiveSheet_AsDataSet(System.IO.Stream f, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
System.Data.DataSet	easy_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
System.Data.DataSet	easy_ReadXLSXActiveSheet_AsDataSet(System.String path, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
System.Data.DataSet	easy_ReadXLSXActiveSheet_AsDataSet(System.String path, System.String rangeReference)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) Available for: Professional, Reader
bool	easy_ReadXLSXActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSXActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the specified range of the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSXActiveSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX, System.String rangeReference)	Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSXActiveSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document Available for: Professional, Reader
bool	easy_ReadXLSXActiveSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath, int startRow, int startColumn, int endRow, int endColumn)	Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document This method is overridden as easy_ReadXLSXActiveSheet_AsXML_5 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_ReadXLSXActiveSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath, System.String rangeReference)	Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document This method is overridden as easy_ReadXLSXActiveSheet_AsXML_3 in COM+ version of EasyXLS. Available for: Professional, Reader
System.String[]	easy_ReadXLSXFile_SheetNames(System.IO.Stream f)	Reads the sheet names of the Microsoft Excel document (XLSX file format) Available for: Professional, Reader
System.String[]	easy_ReadXLSXFile_SheetNames(System.String path)	Reads the sheet names of the Microsoft Excel document (XLSX file format) Available for: Professional, Reader
List	easy_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	easy_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	easy_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	easy_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) This method is overridden as easy_ReadXLSXSheet_AsList_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_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	easy_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 This method is overridden as easy_ReadXLSXSheet_AsList_5 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_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	easy_ReadXLSXSheet_AsDataSet(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 DataSet object Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_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	easy_ReadXLSXSheet_AsDataSet(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 DataSet object Available for: Professional, Reader
bool	easy_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	easy_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	easy_ReadXLSXSheet_AsXML(System.IO.Stream fXML, System.IO.Stream fXLSX, System.String sheetName, System.String rangeReference)	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	easy_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 This method is overridden as easy_ReadXLSXSheet_AsXML_2 in COM+ version of EasyXLS. Available for: Professional, Reader
bool	easy_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	easy_ReadXLSXSheet_AsXML(System.String XMLFilePath, System.String XLSXFilePath, System.String sheetName, System.String rangeReference)	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 This method is overridden as easy_ReadXLSXSheet_AsXML_3 in COM+ version of EasyXLS. Available for: Professional, Reader
List	easy_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	easy_ReadXMLSpreadsheet_AsList(System.String path, System.String sheetName)	Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object This method is overridden as easy_ReadXMLSpreadsheet_AsList_2 in COM+ version of EasyXLS. Available for: Professional, Reader
System.Data.DataSet	easy_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	easy_ReadXMLSpreadsheet_AsDataSet(System.String path, 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	easy_removeSheet(int index)	Removes a sheet from the sheet list on the specified position.
void	easy_removeSheet(System.String sheetName)	Removes the sheet that has the specified name from the sheet list This method is overridden as easy_removeSheet_2 in COM+ version of EasyXLS.
void	easy_removeVBMacros()	Removes the VB project and macros if any.
void	easy_setOptions(ExcelOptions xlsOptions)	Sets the options of an Excel document, available in the main menu Tools/Options window.
void	easy_WriteCSVFile(System.IO.Stream f, System.String sheetName)	Generates the CSV at the specified stream Available for: Professional, Writer
void	easy_WriteCSVFile(System.IO.StreamWriter f, System.String sheetName)	Generates the CSV at the specified stream and the character encoding can be set to the stream Available for: Professional, Writer
void	easy_WriteCSVFile(System.String path, System.String sheetName)	Generates the CSV document at the specified path Available for: Professional, Writer
void	easy_WriteCSVFile(System.String path, System.String encoding, System.String sheetName)	Generates the CSV file at the specified path with specified encoding; most common values are available in Encoding class This method is overridden as easy_WriteCSVFile_4 in COM+ version of EasyXLS. Available for: Professional, Writer
void	easy_WriteHTMLFile(System.IO.Stream f, System.String sheetName)	Generates the HTML at the specified stream Available for: Professional, Writer
void	easy_WriteHTMLFile(System.IO.StreamWriter f, System.String sheetName)	Generates the HTML at the specified stream and the character encoding can be set to the stream. Available for: Professional, Writer
void	easy_WriteHTMLFile(System.String path, System.String sheetName)	Generates the HTML document at the specified path This method is overridden as easy_WriteHTMLFile_3 in COM+ version of EasyXLS. Available for: Professional, Writer
void	easy_WriteHTMLFile(System.String path, System.String encoding, System.String sheetName)	Generates the HTML file at the specified path with specified encoding; most common values are available in Encoding class This method is overridden as easy_WriteHTMLFile_4 in COM+ version of EasyXLS. Available for: Professional, Writer
void	easy_WriteTXTFile(System.IO.Stream f, System.String sheetName, System.String rowDelimiter, System.String columnDelimiter)	Generates the document at the specified stream Available for: Professional, Writer
void	easy_WriteTXTFile(System.IO.StreamWriter f, System.String sheetName, System.String rowDelimiter, System.String columnDelimiter)	Generates the document at the specified stream and the character encoding can be set to the stream Available for: Professional, Writer
void	easy_WriteTXTFile(System.String path, System.String sheetName, System.String rowDelimiter, System.String columnDelimiter)	Generates the TXT document at the specified path Available for: Professional, Writer
void	easy_WriteTXTFile(System.String path, System.String encoding, System.String sheetName, System.String rowDelimiter, System.String columnDelimiter)	Generates the TXT file at the specified path with specified encoding; most common values are available in Encoding class This method is overridden as easy_WriteTXTFile_4 in COM+ version of EasyXLS. Available for: Professional, Writer
void	easy_WriteXLSBFile(System.IO.Stream f)	Generates the Microsoft Excel document (Office 2007 binary file format) at the specified stream Available for: Professional, Writer
void	easy_WriteXLSBFile(System.String path)	Generates the Microsoft Excel Office2007 binary document at the specified path Available for: Professional, Writer
void	easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data This method is overridden as easy_WriteXLSBFile_FromList_2 in COM+ version of EasyXLS. Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data This method is overridden as easy_WriteXLSBFile_FromList_3 in COM+ version of EasyXLS. Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromDataSet(System.String path, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromDataSet(System.String path, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSBFile_FromDataSet(System.String path, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile(System.IO.Stream f)	Generates the Microsoft Excel document (Office 97-2003) at the specified stream Available for: Professional, Writer
void	easy_WriteXLSFile(System.String path)	Generates the Microsoft Excel document (Office 97-2003) at the specified path Available for: Professional, Writer
void	easy_WriteXLSFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data This method is overridden as easy_WriteXLSFile_FromList_2 in COM+ version of EasyXLS. Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data This method is overridden as easy_WriteXLSFile_FromList_3 in COM+ version of EasyXLS. Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromDataSet(System.String path, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromDataSet(System.String path, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSFile_FromDataSet(System.String path, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile(System.IO.Stream f)	Generates the Microsoft Excel document (Office 2007 file format) at the specified stream Available for: Professional, Writer
void	easy_WriteXLSXFile(System.String path)	Generates the Microsoft Excel Office2007 document at the specified path Available for: Professional, Writer
void	easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data This method is overridden as easy_WriteXLSXFile_FromList_2 in COM+ version of EasyXLS. Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data This method is overridden as easy_WriteXLSXFile_FromList_3 in COM+ version of EasyXLS. Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromDataSet(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromDataSet(System.String path, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromDataSet(System.String path, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXLSXFile_FromDataSet(System.String path, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)	Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data Available for: Professional, Writer, Express Writer
void	easy_WriteXMLFile(System.IO.Stream f)	Generates the XML document at the specified stream Available for: Professional, Writer
void	easy_WriteXMLFile(System.String path)	Generates the XML document at the specified path Available for: Professional, Writer
List	getCircularReferences()	Returns a list of strings that contains information about the circular references inside the Excel document.
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.
int	getFirstSelectedSheet()	Returns the first selected sheet.
License	getLicenseSetup()	Returns the license settings for the library.
SummaryInformation	getSummaryInformation()	Returns the summary information of an Excel document.
ExcelTheme	getTheme()	Returns the theme of an Office 2007 or later Excel document.
bool	IsStructureProtected()	Returns the protection option of the workbook structure.
bool	IsWindowsProtected()	Returns the protection option of the workbook windows.
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.
void	setTheme(ExcelTheme xlsTheme)	Sets the theme for an Office 2007 or later Excel document.
void	setTheme(System.String builtInTheme)	Sets a built-in theme for an Office 2007 or later Excel document.
void	setWorkbookPassword(System.String password)	Sets the password of the document workbook.
void	setWorkbookProtection(bool protectStructure, bool protectWindows, System.String password)	Sets the protection options of the document workbook.
int	SheetCount()	Returns the number of sheets in the workbook.

Methods inherited from class System.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

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 Details

easy_getError

public System.String easy_getError()

Returns the error generated during processing the file.

Returns:

the error generated during processing the file.

easy_getWarnings

public System.String easy_getWarnings()

Returns the warnings occured during processing the file.

Returns:

the warnings occured during processing the file.

getLicenseSetup

public License getLicenseSetup()

Returns the license settings for the library.

Returns:

the license settings of the library

SheetCount

public int SheetCount()

Returns the number of sheets in the workbook.

Returns:

the number of sheets in the workbook

See Also:

easy_addWorksheet(EasyXLS.ExcelWorksheet), easy_removeSheet(int), easy_getSheetAt(int), easy_getSheet(System.String)

easy_IsExcel

public bool easy_IsExcel(System.String path)
                     throws System.Exception

Checks if the specified file is a Microsoft Excel document.

Parameters:

path - the path of the file.

Returns:

true if the file is an Excel document, false otherwise

Throws:

System.Exception - an error might be thrown

easy_IsExcel

public bool easy_IsExcel(System.IO.Stream f)
                     throws System.Exception

Checks if the specified file is a Microsoft Excel document.

Parameters:

f - the stream that points to the file.

Returns:

true if the file is an Excel document, false otherwise

Throws:

System.Exception - an error might be thrown

easy_LoadXLSFile

public bool easy_LoadXLSFile(System.String path)
                         throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXLSFile

public bool easy_LoadXLSFile(System.IO.Stream f)
                         throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXLSXFile

public bool easy_LoadXLSXFile(System.String path)
                          throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXLSXFile

public bool easy_LoadXLSXFile(System.IO.Stream f)
                          throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXLSBFile

public bool easy_LoadXLSBFile(System.String path)
                          throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXLSBFile

public bool easy_LoadXLSBFile(System.IO.Stream f)
                          throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsList

public List easy_ReadTXTFile_AsList(System.String path,
 System.String rowDelimiter,
 System.String columnDelimiter)
                             throws System.Exception

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

Parameters:

path - the path to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsList

public List easy_ReadTXTFile_AsList(System.IO.Stream f,
 System.String rowDelimiter,
 System.String columnDelimiter)
                             throws System.Exception

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

Parameters:

f - the stream that points to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsList

public List easy_ReadTXTFile_AsList(System.IO.StreamReader f,
 System.String rowDelimiter,
 System.String columnDelimiter)
                             throws System.Exception

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

Parameters:

f - the stream that points to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsList

public List easy_ReadTXTFile_AsList(System.String path,
 System.String encoding,
 System.String rowDelimiter,
 System.String columnDelimiter)
                             throws System.Exception

Reads the cell values from the TXT file with specified encoding; most common values are available in Encoding class
This method is overridden as easy_ReadTXTFile_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the TXT document.

encoding - the encoding for the HTML document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadCSVFile_AsList

public List easy_ReadCSVFile_AsList(System.String path)
                             throws System.Exception

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

Parameters:

path - the path to the CSV document.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadCSVFile_AsList

public List easy_ReadCSVFile_AsList(System.IO.Stream f)
                             throws System.Exception

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 - an error might be thrown

easy_ReadCSVFile_AsList

public List easy_ReadCSVFile_AsList(System.IO.StreamReader f)
                             throws System.Exception

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 - an error might be thrown

easy_ReadCSVFile_AsList

public List easy_ReadCSVFile_AsList(System.String path,
 System.String encoding)
                             throws System.Exception

Reads the cell values from the specified CSV file with specified encoding; most common values are available in Encoding class
This method is overridden as easy_ReadCSVFile_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the CSV file.

encoding - the encoding for the CSV document.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsXML

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

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 - an error might be thrown

easy_ReadXLSSheet_AsXML

public bool easy_ReadXLSSheet_AsXML(System.String XMLFilePath,
 System.String XLSFilePath,
 System.String sheetName)
                                throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSSheet_AsXML_2 in COM+ version of EasyXLS.
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 - an error might be thrown

easy_ReadXLSSheet_AsXML

public bool easy_ReadXLSSheet_AsXML(System.String XMLFilePath,
 System.String XLSFilePath,
 System.String sheetName,
 System.String rangeReference)
                                throws System.Exception

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
This method is overridden as easy_ReadXLSSheet_AsXML_3 in COM+ version of EasyXLS.
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.

rangeReference - 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 - an error might be thrown

easy_ReadXLSSheet_AsXML

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

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 - an error might be thrown

easy_ReadXLSSheet_AsXML

public bool easy_ReadXLSSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLS,
 System.String sheetName)
                                throws System.Exception

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 - an error might be thrown

easy_ReadXLSSheet_AsXML

public bool easy_ReadXLSSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLS,
 System.String sheetName,
 System.String rangeReference)
                                throws System.Exception

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.

rangeReference - 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 - an error might be thrown

easy_ReadXLSActiveSheet_AsXML

public bool easy_ReadXLSActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSFilePath,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                      throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSActiveSheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSFilePath - the path to the Excel document.

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 - an error might be thrown

easy_ReadXLSActiveSheet_AsXML

public bool easy_ReadXLSActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSFilePath)
                                      throws System.Exception

Reads the cell values from the current 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.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsXML

public bool easy_ReadXLSActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSFilePath,
 System.String rangeReference)
                                      throws System.Exception

Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
This method is overridden as easy_ReadXLSActiveSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSFilePath - the path to the Excel document.

rangeReference - 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 - an error might be thrown

easy_ReadXLSActiveSheet_AsXML

public bool easy_ReadXLSActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLS,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                      throws System.Exception

Reads the cell values from the specified range of the current 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.

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 - an error might be thrown

easy_ReadXLSActiveSheet_AsXML

public bool easy_ReadXLSActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLS)
                                      throws System.Exception

Reads the cell values from the current 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.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsXML

public bool easy_ReadXLSActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLS,
 System.String rangeReference)
                                      throws System.Exception

Reads the cell values from the specified range of current 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.

rangeReference - 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 - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the XML document.

sheetName - the name of the ExcelWorksheet 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 - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                      throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

sheetName - the name of the ExcelWorksheet 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 - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.IO.Stream f,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the XML document.

sheetName - the name of the ExcelWorksheet that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath,
 System.String sheetName)
                                      throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

sheetName - the name of the ExcelWorksheet that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the XML document.

sheetName - the name of the ExcelWorksheet that will be read.

rangeReference - the range of cells (from ExcelWorksheet named sheetName) that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath,
 System.String sheetName,
 System.String rangeReference)
                                      throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_6 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

sheetName - the name of the ExcelWorksheet that will be read.

rangeReference - the range of cells (from ExcelWorksheet named sheetName) that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.IO.Stream f,
 ExcelWorksheet xlsWorksheet,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the XML document.

xlsWorksheet - the ExcelWorksheet object 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 - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath,
 ExcelWorksheet xlsWorksheet,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                      throws System.Exception

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

Parameters:

XMLFilePath - the path to the XML document.

xlsWorksheet - the ExcelWorksheet object 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 - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.IO.Stream f,
 ExcelWorksheet xlsWorksheet)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the XML document.

xlsWorksheet - the ExcelWorksheet object that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath,
 ExcelWorksheet xlsWorksheet)
                                      throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

xlsWorksheet - the ExcelWorksheet object that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.IO.Stream f,
 ExcelWorksheet xlsWorksheet,
 System.String rangeReference)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the XML document.

xlsWorksheet - the ExcelWorksheet object that will be read.

rangeReference - the range of cells (from the xlsWorksheet object) that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsXML

public bool easy_ReadExcelWorksheet_AsXML(System.String XMLFilePath,
 ExcelWorksheet xlsWorksheet,
 System.String rangeReference)
                                      throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
This method is overridden as easy_ReadExcelWorksheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

xlsWorksheet - the ExcelWorksheet object that will be read.

rangeReference - the range of cells (from the xlsWorksheet object) that will be read.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsDataSet

public System.Data.DataSet easy_ReadTXTFile_AsDataSet(System.String path,
 System.String rowDelimiter,
 System.String columnDelimiter)
                                                throws System.Exception

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

Parameters:

path - the path to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsDataSet

public System.Data.DataSet easy_ReadTXTFile_AsDataSet(System.IO.Stream f,
 System.String rowDelimiter,
 System.String columnDelimiter)
                                                throws System.Exception

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

Parameters:

f - the stream that points to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsDataSet

public System.Data.DataSet easy_ReadTXTFile_AsDataSet(System.IO.StreamReader f,
 System.String rowDelimiter,
 System.String columnDelimiter)
                                                throws System.Exception

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

Parameters:

f - the stream that points to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadTXTFile_AsDataSet

public System.Data.DataSet easy_ReadTXTFile_AsDataSet(System.String path,
 System.String encoding,
 System.String rowDelimiter,
 System.String columnDelimiter)
                                                throws System.Exception

Reads the cell values from the TXT file with specified encoding; most common values are available in Encoding class
Available for: Professional, Reader

Parameters:

path - the path to the TXT document.

encoding - the encoding for the HTML document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadCSVFile_AsDataSet

public System.Data.DataSet easy_ReadCSVFile_AsDataSet(System.String path)
                                                throws System.Exception

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

Parameters:

path - the path to the CSV document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadCSVFile_AsDataSet

public System.Data.DataSet easy_ReadCSVFile_AsDataSet(System.IO.Stream f)
                                                throws System.Exception

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 DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadCSVFile_AsDataSet

public System.Data.DataSet easy_ReadCSVFile_AsDataSet(System.IO.StreamReader f)
                                                throws System.Exception

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 DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadCSVFile_AsDataSet

public System.Data.DataSet easy_ReadCSVFile_AsDataSet(System.String path,
 System.String encoding)
                                                throws System.Exception

Reads the cell values from the CSV file with specified encoding; most common values are available in Encoding class
Available for: Professional, Reader

Parameters:

path - the path to the CSV document.

encoding - the encoding for the HTML document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXMLSpreadsheet_AsDataSet

public System.Data.DataSet easy_ReadXMLSpreadsheet_AsDataSet(System.String path,
 System.String sheetName)
                                                       throws System.Exception

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

Parameters:

path - the path to the Microsoft Excel XML Spreadsheet.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXMLSpreadsheet_AsDataSet

public System.Data.DataSet easy_ReadXMLSpreadsheet_AsDataSet(System.IO.Stream f,
 System.String sheetName)
                                                       throws System.Exception

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

Parameters:

f - the stream that points to the Excel XML Spreadsheet document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXMLSpreadsheet_AsList

public List easy_ReadXMLSpreadsheet_AsList(System.String path,
 System.String sheetName)
                                    throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
This method is overridden as easy_ReadXMLSpreadsheet_AsList_2 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Microsoft Excel XML Spreadsheet.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXMLSpreadsheet_AsList

public List easy_ReadXMLSpreadsheet_AsList(System.IO.Stream f,
 System.String sheetName)
                                    throws System.Exception

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

Parameters:

f - the stream that points to the Excel XML Spreadsheet document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsDataSet

public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                       throws System.Exception

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

Parameters:

xlsWorksheet - the ExcelWorksheet object 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsDataSet

public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet)
                                                       throws System.Exception

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

Parameters:

xlsWorksheet - the ExcelWorksheet object that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsDataSet

public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet,
 System.String rangeReference)
                                                       throws System.Exception

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

Parameters:

xlsWorksheet - the ExcelWorksheet object that will be read.

rangeReference - the range of cells (from the xlsWorksheet object) that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsDataSet

public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet(System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                       throws System.Exception

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

Parameters:

sheetName - the name of the ExcelWorksheet 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsDataSet

public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet(System.String sheetName)
                                                       throws System.Exception

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

Parameters:

sheetName - the name of the ExcelWorksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsDataSet

public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet(System.String sheetName,
 System.String rangeReference)
                                                       throws System.Exception

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

Parameters:

sheetName - the name of the ExcelWorksheet that will be read.

rangeReference - the range of cells (from ExcelWorksheet named sheetName) that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsList

public List easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                    throws System.Exception

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

Parameters:

xlsWorksheet - the ExcelWorksheet object 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsList

public List easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet)
                                    throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_2 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

xlsWorksheet - the ExcelWorksheet object that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsList

public List easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet,
 System.String rangeReference)
                                    throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

xlsWorksheet - the ExcelWorksheet object that will be read.

rangeReference - the range of cells (from the xlsWorksheet object) that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsList

public List easy_ReadExcelWorksheet_AsList(System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                    throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

sheetName - the name of the ExcelWorksheet 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsList

public List easy_ReadExcelWorksheet_AsList(System.String sheetName)
                                    throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

sheetName - the name of the ExcelWorksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadExcelWorksheet_AsList

public List easy_ReadExcelWorksheet_AsList(System.String sheetName,
 System.String rangeReference)
                                    throws System.Exception

Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_6 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

sheetName - the name of the ExcelWorksheet that will be read.

rangeReference - the range of cells (from ExcelWorksheet named sheetName) that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsList

public List easy_ReadXLSSheet_AsList(System.String path,
 System.String sheetName)
                              throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
This method is overridden as easy_ReadXLSSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsList

public List easy_ReadXLSSheet_AsList(System.IO.Stream f,
 System.String sheetName)
                              throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsList

public List easy_ReadXLSSheet_AsList(System.String path,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                              throws System.Exception

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

Parameters:

path - 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsList

public List easy_ReadXLSSheet_AsList(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                              throws System.Exception

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

Parameters:

f - 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsList

public List easy_ReadXLSSheet_AsList(System.String path,
 System.String sheetName,
 System.String rangeReference)
                              throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsList

public List easy_ReadXLSSheet_AsList(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                              throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSSheet_AsDataSet(System.String path,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                 throws System.Exception

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

Parameters:

path - 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                 throws System.Exception

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

Parameters:

f - 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSSheet_AsDataSet(System.String path,
 System.String sheetName,
 System.String rangeReference)
                                                 throws System.Exception

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

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSSheet_AsDataSet(System.String path,
 System.String sheetName)
                                                 throws System.Exception

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

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName)
                                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsList

public List easy_ReadXLSActiveSheet_AsList(System.String path)
                                    throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsList

public List easy_ReadXLSActiveSheet_AsList(System.IO.Stream f)
                                    throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsList

public List easy_ReadXLSActiveSheet_AsList(System.String path,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                    throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsList

public List easy_ReadXLSActiveSheet_AsList(System.IO.Stream f,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                    throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsList

public List easy_ReadXLSActiveSheet_AsList(System.String path,
 System.String rangeReference)
                                    throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsList

public List easy_ReadXLSActiveSheet_AsList(System.IO.Stream f,
 System.String rangeReference)
                                    throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet(System.String path,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                       throws System.Exception

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

Parameters:

path - the path to the Excel document.

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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet(System.IO.Stream f,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                       throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet(System.String path,
 System.String rangeReference)
                                                       throws System.Exception

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

Parameters:

path - the path to the Excel document.

rangeReference - the range of cells from the sheetName current Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet(System.IO.Stream f,
 System.String rangeReference)
                                                       throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet(System.String path)
                                                       throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet(System.IO.Stream f)
                                                       throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSFile_SheetNames

public System.String[] easy_ReadXLSFile_SheetNames(System.String path)
                                               throws System.Exception

Reads the sheet names of the Microsoft Excel document (XLS file format)
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

Returns:

a string array that contains the sheet names

Throws:

System.Exception - an error might be thrown

easy_ReadXLSFile_SheetNames

public System.String[] easy_ReadXLSFile_SheetNames(System.IO.Stream f)
                                               throws System.Exception

Reads the sheet names of the Microsoft Excel document (XLS file format)
Available for: Professional, Reader

Parameters:

f - the stream that points to the Excel document.

Returns:

a string array that contains the sheet names

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXFile_SheetNames

public System.String[] easy_ReadXLSXFile_SheetNames(System.String path)
                                                throws System.Exception

Reads the sheet names of the Microsoft Excel document (XLSX file format)
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

Returns:

a string array that contains the sheet names

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXFile_SheetNames

public System.String[] easy_ReadXLSXFile_SheetNames(System.IO.Stream f)
                                                throws System.Exception

Reads the sheet names of the Microsoft Excel document (XLSX file format)
Available for: Professional, Reader

Parameters:

f - the stream that points to the Excel document.

Returns:

a string array that contains the sheet names

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet(System.String path,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                  throws System.Exception

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

Parameters:

path - 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                  throws System.Exception

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

Parameters:

f - 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet(System.String path,
 System.String sheetName,
 System.String rangeReference)
                                                  throws System.Exception

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

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                                                  throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet(System.String path,
 System.String sheetName)
                                                  throws System.Exception

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

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName)
                                                  throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet(System.String path)
                                                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet(System.String path,
 System.String rangeReference)
                                                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet(System.String path,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet(System.IO.Stream f)
                                                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet(System.IO.Stream f,
 System.String rangeReference)
                                                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet(System.IO.Stream f,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsList

public List easy_ReadXLSXSheet_AsList(System.String path,
 System.String sheetName)
                               throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsList

public List easy_ReadXLSXSheet_AsList(System.IO.Stream f,
 System.String sheetName)
                               throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsList

public List easy_ReadXLSXSheet_AsList(System.String path,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                               throws System.Exception

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

Parameters:

path - 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsList

public List easy_ReadXLSXSheet_AsList(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                               throws System.Exception

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

Parameters:

f - 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsList

public List easy_ReadXLSXSheet_AsList(System.String path,
 System.String sheetName,
 System.String rangeReference)
                               throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
This method is overridden as easy_ReadXLSXSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsList

public List easy_ReadXLSXSheet_AsList(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                               throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsList

public List easy_ReadXLSXActiveSheet_AsList(System.String path)
                                     throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsList

public List easy_ReadXLSXActiveSheet_AsList(System.String path,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                     throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

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:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsList

public List easy_ReadXLSXActiveSheet_AsList(System.String path,
 System.String rangeReference)
                                     throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsList

public List easy_ReadXLSXActiveSheet_AsList(System.IO.Stream f)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsList

public List easy_ReadXLSXActiveSheet_AsList(System.IO.Stream f,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

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:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsList

public List easy_ReadXLSXActiveSheet_AsList(System.IO.Stream f,
 System.String rangeReference)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXSheet_AsXML

public bool easy_ReadXLSXSheet_AsXML(System.String XMLFilePath,
 System.String XLSXFilePath,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                 throws System.Exception

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

Parameters:

XMLFilePath - the path to the XML document.

XLSXFilePath - 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 - an error might be thrown

easy_ReadXLSXSheet_AsXML

public bool easy_ReadXLSXSheet_AsXML(System.String XMLFilePath,
 System.String XLSXFilePath,
 System.String sheetName)
                                 throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXSheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSXFilePath - 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 - an error might be thrown

easy_ReadXLSXSheet_AsXML

public bool easy_ReadXLSXSheet_AsXML(System.String XMLFilePath,
 System.String XLSXFilePath,
 System.String sheetName,
 System.String rangeReference)
                                 throws System.Exception

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
This method is overridden as easy_ReadXLSXSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSXFilePath - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - 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 - an error might be thrown

easy_ReadXLSXSheet_AsXML

public bool easy_ReadXLSXSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSX,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                 throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSX - 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 - an error might be thrown

easy_ReadXLSXSheet_AsXML

public bool easy_ReadXLSXSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSX,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSX - 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 - an error might be thrown

easy_ReadXLSXSheet_AsXML

public bool easy_ReadXLSXSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSX,
 System.String sheetName,
 System.String rangeReference)
                                 throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSX - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - 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 - an error might be thrown

easy_ReadXLSXActiveSheet_AsXML

public bool easy_ReadXLSXActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSXFilePath,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                       throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXActiveSheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSXFilePath - the path to the Excel document.

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 - an error might be thrown

easy_ReadXLSXActiveSheet_AsXML

public bool easy_ReadXLSXActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSXFilePath)
                                       throws System.Exception

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

Parameters:

XMLFilePath - the path to the XML document.

XLSXFilePath - the path to the Excel document.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsXML

public bool easy_ReadXLSXActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSXFilePath,
 System.String rangeReference)
                                       throws System.Exception

Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSXActiveSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSXFilePath - the path to the Excel document.

rangeReference - 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 - an error might be thrown

easy_ReadXLSXActiveSheet_AsXML

public bool easy_ReadXLSXActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSX,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                       throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSX - the stream that points to the Excel document.

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 - an error might be thrown

easy_ReadXLSXActiveSheet_AsXML

public bool easy_ReadXLSXActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSX)
                                       throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSX - the stream that points to the Excel document.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSXActiveSheet_AsXML

public bool easy_ReadXLSXActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSX,
 System.String rangeReference)
                                       throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSX - the stream that points to the Excel document.

rangeReference - 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 - an error might be thrown

easy_ReadXLSBFile_SheetNames

public System.String[] easy_ReadXLSBFile_SheetNames(System.String path)
                                                throws System.Exception

Reads the sheet names of the Microsoft Excel document (XLSB file format)
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

Returns:

a string array that contains the sheet names

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBFile_SheetNames

public System.String[] easy_ReadXLSBFile_SheetNames(System.IO.Stream f)
                                                throws System.Exception

Reads the sheet names of the Microsoft Excel document (XLSB file format)
Available for: Professional, Reader

Parameters:

f - the stream that points to the Excel document.

Returns:

a string array that contains the sheet names

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet(System.String path,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                  throws System.Exception

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

Parameters:

path - 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                  throws System.Exception

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

Parameters:

f - 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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet(System.String path,
 System.String sheetName,
 System.String rangeReference)
                                                  throws System.Exception

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

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                                                  throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet(System.String path,
 System.String sheetName)
                                                  throws System.Exception

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

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet(System.IO.Stream f,
 System.String sheetName)
                                                  throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsList

public List easy_ReadXLSBSheet_AsList(System.String path,
 System.String sheetName)
                               throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsList

public List easy_ReadXLSBSheet_AsList(System.IO.Stream f,
 System.String sheetName)
                               throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsList

public List easy_ReadXLSBSheet_AsList(System.String path,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                               throws System.Exception

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

Parameters:

path - 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsList

public List easy_ReadXLSBSheet_AsList(System.IO.Stream f,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                               throws System.Exception

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

Parameters:

f - 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:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsList

public List easy_ReadXLSBSheet_AsList(System.String path,
 System.String sheetName,
 System.String rangeReference)
                               throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
This method is overridden as easy_ReadXLSBSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsList

public List easy_ReadXLSBSheet_AsList(System.IO.Stream f,
 System.String sheetName,
 System.String rangeReference)
                               throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - the range of cells from the sheetName Excel worksheet that will be read.

Returns:

a List that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet(System.String path)
                                                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet(System.String path,
 System.String rangeReference)
                                                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet(System.String path,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet(System.IO.Stream f)
                                                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet(System.IO.Stream f,
 System.String rangeReference)
                                                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsDataSet

public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet(System.IO.Stream f,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

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:

a DataSet that contains the cell values

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsList

public List easy_ReadXLSBActiveSheet_AsList(System.String path)
                                     throws System.Exception

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

Parameters:

path - the path to the Excel document.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsList

public List easy_ReadXLSBActiveSheet_AsList(System.String path,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                     throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

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:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsList

public List easy_ReadXLSBActiveSheet_AsList(System.String path,
 System.String rangeReference)
                                     throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsList

public List easy_ReadXLSBActiveSheet_AsList(System.IO.Stream f)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsList

public List easy_ReadXLSBActiveSheet_AsList(System.IO.Stream f,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

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:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsList

public List easy_ReadXLSBActiveSheet_AsList(System.IO.Stream f,
 System.String rangeReference)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document.

rangeReference - the range of cells from the current Excel worksheet that will be read.

Returns:

a List object with the content of the excel file. Every row is another List object element in the first one.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBSheet_AsXML

public bool easy_ReadXLSBSheet_AsXML(System.String XMLFilePath,
 System.String XLSBFilePath,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                 throws System.Exception

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

Parameters:

XMLFilePath - the path to the XML document.

XLSBFilePath - 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 - an error might be thrown

easy_ReadXLSBSheet_AsXML

public bool easy_ReadXLSBSheet_AsXML(System.String XMLFilePath,
 System.String XLSBFilePath,
 System.String sheetName)
                                 throws System.Exception

Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBSheet_AsXML_2 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSBFilePath - 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 - an error might be thrown

easy_ReadXLSBSheet_AsXML

public bool easy_ReadXLSBSheet_AsXML(System.String XMLFilePath,
 System.String XLSBFilePath,
 System.String sheetName,
 System.String rangeReference)
                                 throws System.Exception

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
This method is overridden as easy_ReadXLSBSheet_AsXML_3 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSBFilePath - the path to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - 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 - an error might be thrown

easy_ReadXLSBSheet_AsXML

public bool easy_ReadXLSBSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSB,
 System.String sheetName,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                 throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSB - 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 - an error might be thrown

easy_ReadXLSBSheet_AsXML

public bool easy_ReadXLSBSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSB,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSB - 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 - an error might be thrown

easy_ReadXLSBSheet_AsXML

public bool easy_ReadXLSBSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSB,
 System.String sheetName,
 System.String rangeReference)
                                 throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSB - the stream that points to the Excel document.

sheetName - the name of the worksheet that will be read.

rangeReference - 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 - an error might be thrown

easy_ReadXLSBActiveSheet_AsXML

public bool easy_ReadXLSBActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSBFilePath,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                       throws System.Exception

Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBActiveSheet_AsXML_5 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSBFilePath - the path to the Excel document.

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 - an error might be thrown

easy_ReadXLSBActiveSheet_AsXML

public bool easy_ReadXLSBActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSBFilePath)
                                       throws System.Exception

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

Parameters:

XMLFilePath - the path to the XML document.

XLSBFilePath - the path to the Excel document.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsXML

public bool easy_ReadXLSBActiveSheet_AsXML(System.String XMLFilePath,
 System.String XLSBFilePath,
 System.String rangeReference)
                                       throws System.Exception

Reads the cell values from the specified range of current worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
This method is overridden as easy_ReadXLSBActiveSheet_AsXML_3 in of EasyXLS.
Available for: Professional, Reader

Parameters:

XMLFilePath - the path to the XML document.

XLSBFilePath - the path to the Excel document.

rangeReference - 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 - an error might be thrown

easy_ReadXLSBActiveSheet_AsXML

public bool easy_ReadXLSBActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSB,
 int startRow,
 int startColumn,
 int endRow,
 int endColumn)
                                       throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSB - the stream that points to the Excel document.

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 - an error might be thrown

easy_ReadXLSBActiveSheet_AsXML

public bool easy_ReadXLSBActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSB)
                                       throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSB - the stream that points to the Excel document.

Returns:

true if the read operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_ReadXLSBActiveSheet_AsXML

public bool easy_ReadXLSBActiveSheet_AsXML(System.IO.Stream fXML,
 System.IO.Stream fXLSB,
 System.String rangeReference)
                                       throws System.Exception

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

Parameters:

fXML - the stream that points to the XML document.

fXLSB - the stream that points to the Excel document.

rangeReference - 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 - an error might be thrown

easy_LoadTXTFile

public bool easy_LoadTXTFile(System.String path,
 System.String rowDelimiter,
 System.String columnDelimiter)
                         throws System.Exception

Loads a specified document
Available for: Professional, Reader

Parameters:

path - the path to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadTXTFile

public bool easy_LoadTXTFile(System.IO.Stream f,
 System.String rowDelimiter,
 System.String columnDelimiter)
                         throws System.Exception

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

Parameters:

f - the stream that points to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadTXTFile

public bool easy_LoadTXTFile(System.IO.StreamReader f,
 System.String rowDelimiter,
 System.String columnDelimiter)
                         throws System.Exception

Generates the document at the specified stream and the character encoding can be set to the stream
Available for: Professional, Reader

Parameters:

f - the stream that points to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadTXTFile

public bool easy_LoadTXTFile(System.String path,
 System.String encoding,
 System.String rowDelimiter,
 System.String columnDelimiter)
                         throws System.Exception

Loads the TXT file with specified encoding; most common values are available in Encoding class
This method is overridden as easy_LoadTXTFile_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the TXT document.

encoding - the encoding for the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadCSVFile

public bool easy_LoadCSVFile(System.String path)
                         throws System.Exception

Loads a specified CSV document
Available for: Professional, Reader

Parameters:

path - the path to the CSV document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadCSVFile

public bool easy_LoadCSVFile(System.IO.Stream f)
                         throws System.Exception

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

Parameters:

f - the stream that points to the CSV document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadCSVFile

public bool easy_LoadCSVFile(System.IO.StreamReader f)
                         throws System.Exception

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

Parameters:

f - the stream that points to the CSV document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadCSVFile

public bool easy_LoadCSVFile(System.String path,
 System.String encoding)
                         throws System.Exception

Loads the CSV file with specified encoding; most common values are available in Encoding class
This method is overridden as easy_LoadCSVFile_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the CSV document.

encoding - the encoding for the CSV document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadHTMLFile

public bool easy_LoadHTMLFile(System.String path)
                          throws System.Exception

Loads the specified HTML file
This method is overridden as easy_LoadHTMLFile_2 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the HTML document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadHTMLFile

public bool easy_LoadHTMLFile(System.IO.Stream f)
                          throws System.Exception

Loads the specified HTML file
Available for: Professional, Reader

Parameters:

f - the stream that points to the HTML document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadHTMLFile

public bool easy_LoadHTMLFile(System.IO.StreamReader f)
                          throws System.Exception

Loads the specified HTML file and the character encoding can be set to the stream
Available for: Professional, Reader

Parameters:

f - the stream that points to the HTML document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadHTMLFile

public bool easy_LoadHTMLFile(System.String path,
 System.String encoding)
                          throws System.Exception

Loads the HTML file with specified encoding; most common values are available in Encoding class
This method is overridden as easy_LoadHTMLFile_4 in COM+ version of EasyXLS.
Available for: Professional, Reader

Parameters:

path - the path to the HTML document.

encoding - the encoding for the HTML document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXMLSpreadsheetFile

public bool easy_LoadXMLSpreadsheetFile(System.String path)
                                    throws System.Exception

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

Parameters:

path - the path to the Excel XML Spreadsheet document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_LoadXMLSpreadsheetFile

public bool easy_LoadXMLSpreadsheetFile(System.IO.Stream f)
                                    throws System.Exception

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

Parameters:

f - the stream that points to the Excel XML Spreadsheet document.

Returns:

true if the load operation is successful, false otherwise.

Throws:

System.Exception - an error might be thrown

easy_WriteCSVFile

public void easy_WriteCSVFile(System.String path,
 System.String sheetName)
                       throws System.Exception

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

Parameters:

path - the path to the CSV document.

sheetName - the name of the sheet whose content will be saved to the CSV document.

Throws:

System.Exception - an error might be thrown

easy_WriteCSVFile

public void easy_WriteCSVFile(System.IO.StreamWriter f,
 System.String sheetName)
                       throws System.Exception

Generates the CSV at the specified stream and the character encoding can be set to the stream
Available for: Professional, Writer

Parameters:

f - the stream that points to the CSV document that will be created.

sheetName - the name of the sheet whose content will be saved to the CSV document.

Throws:

System.Exception - an error might be thrown

easy_WriteCSVFile

public void easy_WriteCSVFile(System.IO.Stream f,
 System.String sheetName)
                       throws System.Exception

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

Parameters:

f - the stream that points to the CSV document that will be created.

sheetName - the name of the sheet whose content will be saved to the CSV document.

Throws:

System.Exception - an error might be thrown

easy_WriteCSVFile

public void easy_WriteCSVFile(System.String path,
 System.String encoding,
 System.String sheetName)
                       throws System.Exception

Generates the CSV file at the specified path with specified encoding; most common values are available in Encoding class
This method is overridden as easy_WriteCSVFile_4 in COM+ version of EasyXLS.
Available for: Professional, Writer

Parameters:

path - the path to the CSV file.

encoding - the encoding for the CSV file.

sheetName - the name of the sheet whose content will be saved to the CSV file.

Throws:

System.Exception - an error might be thrown

easy_WriteTXTFile

public void easy_WriteTXTFile(System.String path,
 System.String sheetName,
 System.String rowDelimiter,
 System.String columnDelimiter)
                       throws System.Exception

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

Parameters:

path - the path to the TXT document.

sheetName - the name of the sheet whose content will be saved to the TXT document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Throws:

System.Exception - an error might be thrown

easy_WriteHTMLFile

public void easy_WriteHTMLFile(System.String path,
 System.String sheetName)
                        throws System.Exception

Generates the HTML document at the specified path
This method is overridden as easy_WriteHTMLFile_3 in COM+ version of EasyXLS.
Available for: Professional, Writer

Parameters:

path - the path to the HTML document.

sheetName - the name of the sheet whose content will be saved to the HTML document.

Throws:

System.Exception - an error might be thrown

easy_WriteHTMLFile

public void easy_WriteHTMLFile(System.IO.Stream f,
 System.String sheetName)
                        throws System.Exception

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

Parameters:

f - the stream that points to the HTML document that will be created.

sheetName - the name of the sheet whose content will be saved to the HTML document.

Throws:

System.Exception - an error might be thrown

easy_WriteHTMLFile

public void easy_WriteHTMLFile(System.IO.StreamWriter f,
 System.String sheetName)
                        throws System.Exception

Generates the HTML at the specified stream and the character encoding can be set to the stream.
Available for: Professional, Writer

Parameters:

f - the stream that points to the HTML document that will be created.

sheetName - the name of the sheet whose content will be saved to the HTML document.

Throws:

System.Exception - an error might be thrown

easy_WriteHTMLFile

public void easy_WriteHTMLFile(System.String path,
 System.String encoding,
 System.String sheetName)
                        throws System.Exception

Generates the HTML file at the specified path with specified encoding; most common values are available in Encoding class
This method is overridden as easy_WriteHTMLFile_4 in COM+ version of EasyXLS.
Available for: Professional, Writer

Parameters:

path - the path to the HTML document.

encoding - the encoding for the HTML file.

sheetName - the name of the sheet whose content will be saved to the HTML document.

Throws:

System.Exception - an error might be thrown

easy_WriteTXTFile

public void easy_WriteTXTFile(System.IO.StreamWriter f,
 System.String sheetName,
 System.String rowDelimiter,
 System.String columnDelimiter)
                       throws System.Exception

Generates the document at the specified stream and the character encoding can be set to the stream
Available for: Professional, Writer

Parameters:

f - the stream that points to the document that will be created.

sheetName - the name of the sheet whose content will be saved to the document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Throws:

System.Exception - an error might be thrown

easy_WriteTXTFile

public void easy_WriteTXTFile(System.IO.Stream f,
 System.String sheetName,
 System.String rowDelimiter,
 System.String columnDelimiter)
                       throws System.Exception

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

Parameters:

f - the stream that points to the document that will be created.

sheetName - the name of the sheet whose content will be saved to the document.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Throws:

System.Exception - an error might be thrown

easy_WriteTXTFile

public void easy_WriteTXTFile(System.String path,
 System.String encoding,
 System.String sheetName,
 System.String rowDelimiter,
 System.String columnDelimiter)
                       throws System.Exception

Generates the TXT file at the specified path with specified encoding; most common values are available in Encoding class
This method is overridden as easy_WriteTXTFile_4 in COM+ version of EasyXLS.
Available for: Professional, Writer

Parameters:

path - the path to the TXT file.

sheetName - the name of the sheet whose content will be saved to the TXT file.

encoding - the encoding for the TXT file.

rowDelimiter - the row delimiter.

columnDelimiter - the column delimiter.

Throws:

System.Exception - an error might be thrown

easy_WriteXMLFile

public void easy_WriteXMLFile(System.String path)
                       throws System.Exception

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

Parameters:

path - the path to the XML document.

Throws:

System.Exception - an error might be thrown

easy_WriteXMLFile

public void easy_WriteXMLFile(System.IO.Stream f)
                       throws System.Exception

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

Parameters:

f - the stream that points to the XML document that will be created.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile

public void easy_WriteXLSFile(System.String path)
                       throws System.Exception

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

Parameters:

path - the path to the Excel document.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile

public void easy_WriteXLSFile(System.IO.Stream f)
                       throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromDataSet

public void easy_WriteXLSFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromDataSet

public void easy_WriteXLSFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromDataSet

public void easy_WriteXLSFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                     throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromDataSet

public void easy_WriteXLSFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                     throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromDataSet

public void easy_WriteXLSFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                     throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromDataSet

public void easy_WriteXLSFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                     throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromList

public void easy_WriteXLSFile_FromList(System.IO.Stream f,
 List list,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromList

public void easy_WriteXLSFile_FromList(System.IO.Stream f,
 List list,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromList

public void easy_WriteXLSFile_FromList(System.IO.Stream f,
 List list,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromList

public void easy_WriteXLSFile_FromList(System.String path,
 List list,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                throws System.Exception

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromList

public void easy_WriteXLSFile_FromList(System.String path,
 List list,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                throws System.Exception

Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSFile_FromList

public void easy_WriteXLSFile_FromList(System.String path,
 List list,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                throws System.Exception

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

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile

public void easy_WriteXLSXFile(System.String path)
                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile

public void easy_WriteXLSXFile(System.IO.Stream f)
                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromDataSet

public void easy_WriteXLSXFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromDataSet

public void easy_WriteXLSXFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromDataSet

public void easy_WriteXLSXFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromDataSet

public void easy_WriteXLSXFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromDataSet

public void easy_WriteXLSXFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromDataSet

public void easy_WriteXLSXFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromList

public void easy_WriteXLSXFile_FromList(System.IO.Stream f,
 List list,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromList

public void easy_WriteXLSXFile_FromList(System.IO.Stream f,
 List list,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromList

public void easy_WriteXLSXFile_FromList(System.IO.Stream f,
 List list,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromList

public void easy_WriteXLSXFile_FromList(System.String path,
 List list,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSXFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromList

public void easy_WriteXLSXFile_FromList(System.String path,
 List list,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSXFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startCellReference - the cell from where the DataSet values will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSXFile_FromList

public void easy_WriteXLSXFile_FromList(System.String path,
 List list,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile

public void easy_WriteXLSBFile(System.String path)
                        throws System.Exception

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

Parameters:

path - the path to the Excel document.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile

public void easy_WriteXLSBFile(System.IO.Stream f)
                        throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromDataSet

public void easy_WriteXLSBFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromDataSet

public void easy_WriteXLSBFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromDataSet

public void easy_WriteXLSBFile_FromDataSet(System.IO.Stream f,
 System.Data.DataSet ds,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromDataSet

public void easy_WriteXLSBFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromDataSet

public void easy_WriteXLSBFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromDataSet

public void easy_WriteXLSBFile_FromDataSet(System.String path,
 System.Data.DataSet ds,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                      throws System.Exception

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

Parameters:

path - the path to the Excel document

ds - the DataSet to be inserted; only the data from the first table of the DataSet will be inserted

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromList

public void easy_WriteXLSBFile_FromList(System.IO.Stream f,
 List list,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromList

public void easy_WriteXLSBFile_FromList(System.IO.Stream f,
 List list,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromList

public void easy_WriteXLSBFile_FromList(System.IO.Stream f,
 List list,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

f - the stream that points to the Excel document that will be created.

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromList

public void easy_WriteXLSBFile_FromList(System.String path,
 List list,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSBFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromList

public void easy_WriteXLSBFile_FromList(System.String path,
 List list,
 System.String startCellReference,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSBFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startCellReference - the cell where the DataSet values will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_WriteXLSBFile_FromList

public void easy_WriteXLSBFile_FromList(System.String path,
 List list,
 int startRow,
 int startCol,
 ExcelAutoFormat xlsAutoFormat,
 System.String sheetName)
                                 throws System.Exception

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

Parameters:

path - the path to the Excel document

list - a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.

startRow - the index of the row where the dataset data will be inserted from

startCol - the index of the column where the dataset data will be inserted from

xlsAutoFormat - the autoformat to be applied;

sheetName - the name of the sheet;

Throws:

System.Exception - an error might be thrown

easy_addWorksheet

public void easy_addWorksheet(ExcelWorksheet xlsWorksheet)

Adds a worksheet to the sheet list.

Parameters:

xlsWorksheet - the worksheet that will be added to the sheet list.

easy_addWorksheet

public void easy_addWorksheet(System.String sheetName)

Adds a worksheet having the specified worksheet name to the sheet list
This method is overridden as easy_addWorksheet_2 in COM+ version of EasyXLS.

Parameters:

sheetName - the worksheet name.

easy_addWorksheet

public void easy_addWorksheet(System.String sheetName,
 bool isSelected)

Adds a worksheet having the worksheet name and selected option specified
This method is overridden as easy_addWorksheet_3 in COM+ version of EasyXLS.

Parameters:

sheetName - the worksheet name.

isSelected - true if the worksheet is selected.

easy_insertWorksheet

public void easy_insertWorksheet(int index,
 ExcelWorksheet xlsWorksheet)

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

Parameters:

index - the index where the worksheet will be inserted to the sheet list.

xlsWorksheet - the worksheet that will be inserted to the sheet list.

easy_insertWorksheet

public void easy_insertWorksheet(int index,
 System.String sheetName)

Inserts a worksheet having the specified worksheet name to the sheet list on the specified position
This method is overridden as easy_insertWorksheet_2 in COM+ version of EasyXLS.

Parameters:

index - the index where the worksheet will be inserted to the sheet list.

sheetName - the worksheet name.

easy_insertWorksheet

public void easy_insertWorksheet(int index,
 System.String sheetName,
 bool isSelected)

Inserts a worksheet having the worksheet name and selected option specified
This method is overridden as easy_insertWorksheet_3 in COM+ version of EasyXLS.

Parameters:

index - the index where the worksheet will be inserted to the sheet list.

sheetName - the worksheet name.

isSelected - true if the worksheet is selected.

easy_removeSheet

public void easy_removeSheet(int index)

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

Parameters:

index - the index of the sheet that will be removed from the sheet list.

easy_removeSheet

public void easy_removeSheet(System.String sheetName)

Removes the sheet that has the specified name from the sheet list
This method is overridden as easy_removeSheet_2 in COM+ version of EasyXLS.

Parameters:

sheetName - the sheet name.

easy_getSheetAt

public ExcelSheet easy_getSheetAt(int index)

Returns the sheet on the specified position.

Parameters:

index - the index of the sheet in the sheet list.

Returns:

the sheet from the specified position

easy_getSheet

public ExcelSheet easy_getSheet(System.String sheetName)

Returns the sheet that has the specified name.

Parameters:

sheetName - the sheet name.

Returns:

the sheet that has the specified name

easy_getSheetPosition

public int easy_getSheetPosition(System.String sheetName)

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

Parameters:

sheetName - the sheet name.

Returns:

the position in the sheet list of the specified sheet

easy_addChart

public void easy_addChart(ExcelChartSheet xlsChartSheet)

Adds a chart to the sheet list.

Parameters:

xlsChartSheet - the chart that will be added to the sheet list.

easy_addChart

public void easy_addChart(System.String sheetName)

Adds a chart sheet having the specified sheet name to the sheet list
This method is overridden as easy_addChart_2 in COM+ version of EasyXLS.

Parameters:

sheetName - the chart sheet name.

easy_addChart

public void easy_addChart(System.String sheetName,
 System.String formulaDataRange,
 int seriesType)

Adds a chart sheet to the sheet list and the chart has the sheet name, the data range and the type of the series specified
This method is overridden as easy_addChart_5 in COM+ version of EasyXLS.

Parameters:

sheetName - the chart sheet name.

formulaDataRange - the range containing the data for the chart.

seriesType - the type of the chart series.

easy_addChart

public void easy_addChart(System.String sheetName,
 bool isSelected)

Adds a chart sheet having the sheet name and selected option specified
This method is overridden as easy_addChart_3 in COM+ version of EasyXLS.

Parameters:

sheetName - the chart sheet name.

isSelected - true if the chart sheet is selected.

easy_addChart

public void easy_addChart(System.String sheetName,
 bool isSelected,
 System.String formulaDataRange,
 int seriesType)

Adds a chart sheet to the sheet list and the chart has the sheet name, the selected option, the data range and the type of the series specified
This method is overridden as easy_addChart_4 in COM+ version of EasyXLS.

Parameters:

sheetName - the chart sheet name.

isSelected - true if the chart sheet is selected.

formulaDataRange - the range containing the data for the chart.

seriesType - the type of the chart series.

easy_insertChart

public void easy_insertChart(int index,
 ExcelChartSheet xlsChartSheet)

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

Parameters:

index - the index where the chart will be inserted in the sheet list.

xlsChartSheet - the chart sheet that will be inserted in the sheet list.

easy_insertChart

public void easy_insertChart(int index,
 System.String sheetName)

Inserts a chart sheet having the specified sheet name in the sheet list on the specified position
This method is overridden as easy_insertChart_2 in COM+ version of EasyXLS.

Parameters:

index - the index where the chart sheet will be inserted in the sheet list.

sheetName - the chart sheet name.

easy_insertChart

public void easy_insertChart(int index,
 System.String sheetName,
 System.String formulaDataRange,
 int seriesType)

Inserts a chart sheet in the sheet list on the specified position and the chart has the sheet name, the data range and the type of the series specified
This method is overridden as easy_insertChart_5 in COM+ version of EasyXLS.

Parameters:

index - the index where the chart sheet will be inserted in the sheet list.

sheetName - the chart sheet name.

formulaDataRange - the range containing the data for the chart.

seriesType - the type of the chart series.

easy_insertChart

public void easy_insertChart(int index,
 System.String sheetName,
 bool isSelected)

Inserts a chart sheet having the sheet name and selected option specified
This method is overridden as easy_insertChart_3 in COM+ version of EasyXLS.

Parameters:

index - the index where the chart sheet will be inserted in the sheet list.

sheetName - the chart sheet name.

isSelected - true if the chart sheet is selected.

easy_insertChart

public void easy_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
This method is overridden as easy_insertChart_4 in COM+ version of EasyXLS. The chart has the sheet name, the selected option, the data range and the type of the series specified.

Parameters:

index - the index where the chart sheet will be inserted in the sheet list.

sheetName - the chart sheet name.

isSelected - true if the chart sheet is selected.

formulaDataRange - the range containing the data for the chart.

seriesType - the type of the chart series.

easy_removeVBMacros

public void easy_removeVBMacros()

Removes the VB project and macros if any.

getFirstSelectedSheet

public int getFirstSelectedSheet()

Returns the first selected sheet.

Returns:

the first selected sheet.

getCurrentSheet

public int getCurrentSheet()

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

Returns:

the index of the current sheet.

setCurrentSheet

public void setCurrentSheet(int tabIndex)

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

Parameters:

tabIndex - the index of the sheet.

setWorkbookProtection

public void setWorkbookProtection(bool protectStructure,
 bool protectWindows,
 System.String password)

Sets the protection options of the document workbook. If a password is set the document will be encrypted.

Parameters:

protectStructure - true if the document structure is protected, false otherwise.

protectWindows - true if the document windows are protected, false otherwise.

password - the password required for removing the protection

See Also:

IsStructureProtected(), IsWindowsProtected()

setWorkbookPassword

public void setWorkbookPassword(System.String password)

Sets the password of the document workbook. If a password is set the document will be encrypted when writing. If the document is read, the password is required to be set before reading the document.

Parameters:

password - the password required for removing the protection

See Also:

IsStructureProtected(), IsWindowsProtected(), ExcelOptions.setEncryptionOptions(int, System.String)

IsStructureProtected

public bool IsStructureProtected()

Returns the protection option of the workbook structure.

Returns:

true if the document structure is protected, false otherwise

See Also:

setWorkbookProtection(bool, bool, System.String), IsWindowsProtected()

IsWindowsProtected

public bool IsWindowsProtected()

Returns the protection option of the workbook windows.

Returns:

true if the document windows are protected, false otherwise

See Also:

setWorkbookProtection(bool, bool, System.String), IsStructureProtected()

easy_getOptions

public ExcelOptions easy_getOptions()

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

Returns:

the options of an Excel document.

See Also:

easy_setOptions(EasyXLS.ExcelOptions)

easy_setOptions

public void easy_setOptions(ExcelOptions xlsOptions)

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

Parameters:

xlsOptions - the options of an Excel document.

See Also:

easy_getOptions()

getCircularReferences

public List getCircularReferences()

Returns a list of strings that contains information about the circular references inside the Excel document. The list is available only after the calculation of the formulas inside a worksheet.

Returns:

a list of strings that contains information about the circular references inside the Excel document.

See Also:

ExcelOptions.setCalculateFormulas(bool)

getSummaryInformation

public SummaryInformation getSummaryInformation()

Returns the summary information of an Excel document.

Returns:

the summary information of an Excel document.

See Also:

setSummaryInformation(EasyXLS.FileProperties.SummaryInformation)

setSummaryInformation

public void setSummaryInformation(SummaryInformation summaryInformation)

Sets the summary information of an Excel document.

Parameters:

summaryInformation - the summary information of an Excel document.

See Also:

getSummaryInformation()

getDocumentSummaryInformation

public DocumentSummaryInformation getDocumentSummaryInformation()

Returns the document summary information of an Excel document.

Returns:

the document summary information of an Excel document.

See Also:

setDocumentSummaryInformation(EasyXLS.FileProperties.DocumentSummaryInformation)

setDocumentSummaryInformation

public void setDocumentSummaryInformation(DocumentSummaryInformation documentSummaryInformation)

Sets the document summary information of an Excel document.

Parameters:

documentSummaryInformation - the document summary information of an Excel document.

See Also:

getSummaryInformation()

getExternalLinks

public ExternalLinks getExternalLinks()

Returns the list of the external links from the formulas inside the Excel document.

Returns:

the list of the external links for an Excel document

getTheme

public ExcelTheme getTheme()

Returns the theme of an Office 2007 or later Excel document.

Returns:

the theme of an Office 2007 or later Excel document.

See Also:

setTheme(String), setTheme(ExcelTheme)

setTheme

public void setTheme(ExcelTheme xlsTheme)

Sets the theme for an Office 2007 or later Excel document.

Parameters:

xlsTheme - the theme for an Office 2007 or later Excel document.

See Also:

getTheme(), setTheme(String)

setTheme

public void setTheme(System.String builtInTheme)

Sets a built-in theme for an Office 2007 or later Excel document.

Parameters:

builtInTheme - a built-in theme. Possible values are available in Theme class.

See Also:

getTheme(), setTheme(ExcelTheme)

Dispose

public void Dispose()

Disposes any resources that it has allocated.

Clone

public ExcelDocument Clone()

Creates and returns a copy of this object.

Returns:

a clone of this instance.