Namespace EasyXLS

Class 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.
      void easy_addChart​(System.String sheetName, bool isSelected)
      Adds a chart sheet having the sheet name and selected option specified.
      void easy_addChart​(System.String sheetName, bool isSelected, System.String formulaDataRange, int seriesType)
      Adds a chart sheet to the sheet list.
      void easy_addChart​(System.String sheetName, System.String formulaDataRange, int seriesType)
      Adds a chart sheet to the sheet list.
      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.
      void easy_addWorksheet​(System.String sheetName, bool isSelected)
      Adds a worksheet having the worksheet name and selected option specified.
      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.
      void easy_insertChart​(int index, System.String sheetName, bool isSelected)
      Inserts a chart sheet having the sheet name and selected option specified.
      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.
      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.
      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.
      void easy_insertWorksheet​(int index, System.String sheetName, bool isSelected)
      Inserts a worksheet having the worksheet name and selected option specified.
      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.
      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.
      bool easy_LoadHTMLFile​(System.String path)
      Loads the specified HTML file
      Available for: Professional, Reader
      bool easy_LoadHTMLFile​(System.String path, System.String encoding)
      Loads the HTML file with specified encoding.
      bool easy_LoadTXTFile​(System.IO.StreamReader f, System.String rowDelimiter, System.String columnDelimiter)
      Generates the document at the specified stream.
      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.
      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.
      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.
      List easy_ReadExcelWorksheet_AsList​(ExcelWorksheet xlsWorksheet)
      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, 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
      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
      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
      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
      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
      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
      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
      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
      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
      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.
      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.
      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
      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
      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
      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
      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)
      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)
      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
      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
      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)
      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
      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
      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
      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)
      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
      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
      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
      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)
      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)
      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
      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
      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)
      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
      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
      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
      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
      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.
      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.
      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.
      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.
      void easy_WriteHTMLFile​(System.String path, System.String sheetName)
      Generates the HTML document at the specified path
      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.
      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.
      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.
      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
      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
      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
      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
      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
      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
      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.
    • Constructor Detail

      • ExcelDocument

        public ExcelDocument()
        Defines an instance of the object that reads/writes Excel files.
      • ExcelDocument

        public ExcelDocument​(int worksheetCount)
        Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets.
        Parameters:
        worksheetCount - the number of worksheets.
      • ExcelDocument

        public ExcelDocument​(int worksheetCount,
                             int chartsheetCount)
        Defines an instance of the object that reads/writes Excel files having a predefined number of worksheets and chart sheets.
        Parameters:
        worksheetCount - the number of worksheets.
        chartsheetCount - the number of chart sheets.
    • Method Detail

      • 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
      • easy_IsExcel

        public bool easy_IsExcel​(System.String path)
                             
        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)
                             
        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)
                                 
        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)
                                 
        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)
                                  
        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)
                                  
        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)
                                  
        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)
                                  
        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)
                                     
        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)
                                     
        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)
                                     
        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)
                                     
        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 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)
                                     
        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)
                                     
        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)
                                     
        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)
                                     
        Reads the cell values from the specified CSV file with specified encoding. Most common values are available in Encoding class.
        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)
                                        
        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)
                                        
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
        Available for: Professional, Reader
        Parameters:
        XMLFilePath - the path to the XML document.
        XLSFilePath - the path to the Excel document.
        sheetName - the name of the worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception - 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)
                                        
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
        Available for: Professional, Reader
        Parameters:
        XMLFilePath - the path to the XML document.
        XLSFilePath - the path to the Excel document.
        sheetName - the name of the worksheet that will be read.
        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)
                                        
        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)
                                        
        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)
                                        
        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)
                                              
        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.
        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)
                                              
        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)
                                              
        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:
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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.
        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)
                                              
        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)
                                              
        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.
        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)
                                              
        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)
                                              
        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.
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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.
        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)
                                              
        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)
                                              
        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.
        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)
                                                        
        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)
                                                        
        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)
                                                        
        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)
                                                        
        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)
                                                        
        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)
                                                        
        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)
                                                        
        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)
                                                        
        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)
                                                               
        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)
                                                               
        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)
                                            
        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 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)
                                            
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                            
        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)
                                            
        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.
        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)
                                            
        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.
        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)
                                            
        Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List 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 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)
                                            
        Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
        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)
                                            
        Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List 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 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)
                                      
        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 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)
                                      
        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)
                                      
        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)
                                      
        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)
                                      
        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.
        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)
                                      
        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)
                                                         
        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)
                                                         
        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)
                                                         
        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)
                                                         
        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)
                                                         
        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)
                                                         
        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)
                                            
        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)
                                            
        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)
                                            
        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:
        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)
                                            
        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)
                                            
        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:
        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)
                                            
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                               
        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)
                                                       
        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)
                                                       
        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)
                                                        
        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)
                                                        
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                       
        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 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)
                                       
        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)
                                       
        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)
                                       
        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)
                                       
        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.
        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)
                                       
        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)
                                             
        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)
                                             
        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 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)
                                             
        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 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)
                                             
        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)
                                             
        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)
                                             
        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)
                                         
        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)
                                         
        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.
        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)
                                         
        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:
        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)
                                         
        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)
                                         
        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)
                                         
        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)
                                               
        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.
        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)
                                               
        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)
                                               
        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:
        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)
                                               
        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)
                                               
        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)
                                               
        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)
                                                        
        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)
                                                        
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                                          
        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)
                                       
        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 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)
                                       
        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)
                                       
        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)
                                       
        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)
                                       
        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.
        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)
                                       
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                                                
        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)
                                             
        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)
                                             
        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 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)
                                             
        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 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)
                                             
        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)
                                             
        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)
                                             
        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)
                                         
        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)
                                         
        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.
        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)
                                         
        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:
        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)
                                         
        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)
                                         
        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)
                                         
        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)
                                               
        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.
        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)
                                               
        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)
                                               
        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:
        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)
                                               
        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)
                                               
        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)
                                               
        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)
                                 
        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)
                                 
        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)
                                 
        Generates the document at the specified stream. 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)
                                 
        Loads 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 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)
                                 
        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)
                                 
        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)
                                 
        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)
                                 
        Loads 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 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)
                                  
        Loads the specified HTML file
        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)
                                  
        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)
                                  
        Loads the specified HTML file. 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)
                                  
        Loads the HTML file with specified encoding. Most common values are available in Encoding class.
        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)
                                            
        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)
                                            
        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)
                               
        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)
                               
        Generates the CSV at the specified stream. 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)
                               
        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)
                               
        Generates the CSV file at the specified path with specified encoding. Most common values are available in Encoding class.
        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)
                               
        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)
                                
        Generates the HTML document at the specified path
        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)
                                
        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)
                                
        Generates the HTML at the specified stream. 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)
                                
        Generates the HTML file at the specified path with specified encoding. Most common values are available in Encoding class.
        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)
                               
        Generates the document at the specified stream. 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)
                               
        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)
                               
        Generates the TXT file at the specified path with specified encoding. Most common values are available in Encoding class.
        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)
                               
        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)
                               
        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)
                               
        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)
                               
        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)
                                             
        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)
                                             
        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)
                                             
        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)
                                             
        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)
                                             
        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)
                                             
        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)
                                        
        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)
                                        
        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)
                                        
        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)
                                        
        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.
        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)
                                        
        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.
        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)
                                        
        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)
                                
        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)
                                
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                         
        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)
                                         
        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)
                                         
        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)
                                         
        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.
        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)
                                         
        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.
        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)
                                         
        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)
                                
        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)
                                
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                              
        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)
                                         
        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)
                                         
        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)
                                         
        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)
                                         
        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.
        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)
                                         
        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.
        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)
                                         
        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.
        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.
        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.
        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.
        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.
        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.
        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. The chart has the sheet name, the data range and the type of the series specified.
        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.
        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. The chart has the sheet name, the selected option, the data range and the type of the series specified.
        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.
        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. The chart has the sheet name, 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.
        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.
        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. 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()
      • 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)
      • 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()
      • 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
      • 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.