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 sPath)
      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 sPath)
      Loads a specified CSV document
      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
      Available for: Professional, Reader
      bool easy_LoadHTMLFile​(System.String sPath)
      Loads the specified HTML file
      Available for: Professional, Reader
      bool easy_LoadTXTFile​(System.IO.StreamReader f, System.String sRowDelimiter, System.String sColumnDelimiter)
      Generates the document at the specified stream.
      bool easy_LoadTXTFile​(System.IO.Stream f, System.String sRowDelimiter, System.String sColumnDelimiter)
      Generates the document at the specified stream
      Available for: Professional, Reader
      bool easy_LoadTXTFile​(System.String sPath, System.String sRowDelimiter, System.String sColumnDelimiter)
      Loads a specified document
      Available for: Professional, Reader
      bool easy_LoadXLSBFile​(System.IO.Stream f)
      Loads the specified Microsoft Excel document (Office 2007 file format)
      Available for: Professional, Reader
      bool easy_LoadXLSBFile​(System.String sPath)
      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 sPath)
      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 sPath)
      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 sPath)
      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 sPath)
      Reads the cell values from the specified CSV document
      Available for: Professional, Reader
      System.Data.DataSet easy_ReadCSVFile_AsDataSet​(System.IO.Stream f)
      Reads the cell values from the specified CSV document
      Available for: Professional, Reader
      System.Data.DataSet easy_ReadCSVFile_AsDataSet​(System.IO.StreamReader f)
      Reads the cell values from the specified CSV document
      Available for: Professional, Reader
      System.Data.DataSet easy_ReadCSVFile_AsDataSet​(System.String sPath)
      Reads the cell values from the specified CSV document
      Available for: Professional, Reader
      List easy_ReadExcelWorksheet_AsList​(ExcelWorksheet xlsWorksheet)
      Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRowDelimiter, System.String sColumnDelimiter)
      Reads the cell values from the specified TXT document
      Available for: Professional, Reader
      List easy_ReadTXTFile_AsList​(System.IO.Stream f, System.String sRowDelimiter, System.String sColumnDelimiter)
      Reads the cell values from the specified TXT document
      Available for: Professional, Reader
      List easy_ReadTXTFile_AsList​(System.String sPath, System.String sRowDelimiter, System.String sColumnDelimiter)
      Reads the cell values from the specified TXT document
      Available for: Professional, Reader
      System.Data.DataSet easy_ReadTXTFile_AsDataSet​(System.IO.StreamReader f, System.String sRowDelimiter, System.String sColumnDelimiter)
      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 sRowDelimiter, System.String sColumnDelimiter)
      Reads the cell values from the specified TXT document
      Available for: Professional, Reader
      System.Data.DataSet easy_ReadTXTFile_AsDataSet​(System.String sPath, System.String sRowDelimiter, System.String sColumnDelimiter)
      Reads the cell values from the specified TXT document
      Available for: Professional, Reader
      List 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 sPath)
      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 sRangeReference)
      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 sPath)
      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 sRangeReference)
      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 fXLSX)
      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 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 97-2003) and writes them into an XML document
      Available for: Professional, Reader
      bool easy_ReadXLSActiveSheet_AsXML​(System.IO.Stream fXML, System.IO.Stream fXLSX, System.String sRangeReference)
      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 XLSXFilePath)
      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 XLSXFilePath, 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 XLSXFilePath, System.String sRangeReference)
      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 sPath)
      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 sPath, 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 sPath, 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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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
      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 sRangeReference)
      Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
      Available for: Professional, Reader
      System.Data.DataSet 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 sRangeReference)
      Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
      Available for: Professional, Reader
      bool 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 sRangeReference)
      Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
      Available for: Professional, Reader
      bool 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 sRangeReference)
      Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
      Available for: Professional, Reader
      List 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 sRangeReference)
      Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
      Available for: Professional, Reader
      System.Data.DataSet 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 sRangeReference)
      Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
      Available for: Professional, Reader
      bool 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 sRangeReference)
      Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
      Available for: Professional, Reader
      bool 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 sRangeReference)
      Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
      Available for: Professional, Reader
      List 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 sPath)
      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 sPath, 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 sPath, 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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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 sRangeReference)
      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
      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 sRangeReference)
      Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
      Available for: Professional, Reader
      System.Data.DataSet 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 sRangeReference)
      Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
      Available for: Professional, Reader
      bool 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 sRangeReference)
      Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
      Available for: Professional, Reader
      bool 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 sRangeReference)
      Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
      Available for: Professional, Reader
      List 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 sPath, System.String sheetName)
      Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
      Available for: Professional, Reader
      System.Data.DataSet 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 sPath, System.String sheetName)
      Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
      Available for: Professional, Reader
      void 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 sSheetName)
      Generates the CSV at the specified stream
      Available for: Professional, Writer
      void easy_WriteCSVFile​(System.IO.StreamWriter f, System.String sSheetName)
      Generates the CSV at the specified stream.
      void easy_WriteCSVFile​(System.String sPath, System.String sSheetName)
      Generates the CSV document at the specified path
      Available for: Professional, Writer
      void easy_WriteHTMLFile​(System.IO.Stream f, System.String sSheetName)
      Generates the HTML at the specified stream
      Available for: Professional, Writer
      void easy_WriteHTMLFile​(System.IO.StreamWriter f, System.String sSheetName)
      Generates the HTML at the specified stream.
      void easy_WriteHTMLFile​(System.String sPath, System.String sSheetName)
      Generates the HTML document at the specified path
      Available for: Professional, Writer
      void easy_WriteTXTFile​(System.IO.Stream f, System.String sSheetName, System.String sRowDelimiter, System.String sColumnDelimiter)
      Generates the document at the specified stream
      Available for: Professional, Writer
      void easy_WriteTXTFile​(System.IO.StreamWriter f, System.String sSheetName, System.String sRowDelimiter, System.String sColumnDelimiter)
      Generates the document at the specified stream.
      void easy_WriteTXTFile​(System.String sPath, System.String sSheetName, System.String sRowDelimiter, System.String sColumnDelimiter)
      Generates the TXT document at the specified path
      Available for: Professional, Writer
      void 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 sPath)
      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 sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromList​(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromList​(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromList​(System.String sPath, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromList​(System.String sPath, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromList​(System.String sPath, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSBFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void 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 sPath)
      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 sSheetName)
      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 sSheetName)
      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 sSheetName)
      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 sPath, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromList​(System.String sPath, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromList​(System.String sPath, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void 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 sPath)
      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 sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromList​(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromList​(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromList​(System.String sPath, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromList​(System.String sPath, List list, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromList​(System.String sPath, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromDataSet​(System.IO.Stream f, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXLSXFile_FromDataSet​(System.String sPath, System.Data.DataSet ds, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
      Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
      Available for: Professional, Writer, Express Writer
      void easy_WriteXMLFile​(System.IO.Stream f)
      Generates the XML document at the specified stream
      Available for: Professional, Writer
      void easy_WriteXMLFile​(System.String sPath)
      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.
      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.
      • easy_IsExcel

        public bool easy_IsExcel​(System.String sPath)
                             
        Checks if the specified file is a Microsoft Excel document.
        Parameters:
        sPath - the path of the file.
        Returns:
        true if the file is an Excel document, false otherwise
        Throws:
        System.Exception
      • 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
      • easy_LoadXLSFile

        public bool easy_LoadXLSFile​(System.String sPath)
                                 
        Loads a specified Microsoft Excel document (Office 97-2003)
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the Excel document.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • easy_LoadXLSXFile

        public bool easy_LoadXLSXFile​(System.String sPath)
                                  
        Loads the specified Microsoft Excel document (Office 2007 file format)
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the Excel document.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • easy_LoadXLSBFile

        public bool easy_LoadXLSBFile​(System.String sPath)
                                  
        Loads the specified Microsoft Excel document (Office 2007 file format)
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the Excel document.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • easy_ReadTXTFile_AsList

        public List easy_ReadTXTFile_AsList​(System.String sPath,
                                            System.String sRowDelimiter,
                                            System.String sColumnDelimiter)
                                     
        Reads the cell values from the specified TXT document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        a List that contains the cell values
        Throws:
        System.Exception
      • easy_ReadTXTFile_AsList

        public List easy_ReadTXTFile_AsList​(System.IO.Stream f,
                                            System.String sRowDelimiter,
                                            System.String sColumnDelimiter)
                                     
        Reads the cell values from the specified TXT document
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        a List that contains the cell values
        Throws:
        System.Exception
      • easy_ReadTXTFile_AsList

        public List easy_ReadTXTFile_AsList​(System.IO.StreamReader f,
                                            System.String sRowDelimiter,
                                            System.String sColumnDelimiter)
                                     
        Reads the cell values from the specified TXT document
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        a List that contains the cell values
        Throws:
        System.Exception
      • easy_ReadCSVFile_AsList

        public List easy_ReadCSVFile_AsList​(System.String sPath)
                                     
        Reads the cell values from the specified CSV document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the CSV document.
        Returns:
        a List that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSSheet_AsXML

        public bool easy_ReadXLSSheet_AsXML​(System.String XMLFilePath,
                                               System.String XLSFilePath,
                                               System.String sheetName,
                                               System.String sRangeReference)
                                        
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
        Available for: Professional, Reader
        Parameters:
        XMLFilePath - the path to the XML document.
        XLSFilePath - the path to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSSheet_AsXML

        public bool easy_ReadXLSSheet_AsXML​(System.IO.Stream fXML,
                                               System.IO.Stream fXLS,
                                               System.String sheetName,
                                               System.String sRangeReference)
                                        
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 97-2003) and writes them into an XML document
        Available for: Professional, Reader
        Parameters:
        fXML - the stream that points to the XML document.
        fXLS - the stream that points to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_ReadXLSActiveSheet_AsXML

        public bool easy_ReadXLSActiveSheet_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 97-2003) 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
      • easy_ReadXLSActiveSheet_AsXML

        public bool easy_ReadXLSActiveSheet_AsXML​(System.String XMLFilePath,
                                                     System.String XLSXFilePath)
                                              
        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.
        XLSXFilePath - the path to the Excel document.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_ReadXLSActiveSheet_AsXML

        public bool easy_ReadXLSActiveSheet_AsXML​(System.String XMLFilePath,
                                                     System.String XLSXFilePath,
                                                     System.String sRangeReference)
                                              
        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.
        XLSXFilePath - the path to the Excel document.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_ReadXLSActiveSheet_AsXML

        public bool easy_ReadXLSActiveSheet_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 97-2003) 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
      • easy_ReadXLSActiveSheet_AsXML

        public bool easy_ReadXLSActiveSheet_AsXML​(System.IO.Stream fXML,
                                                     System.IO.Stream fXLSX)
                                              
        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.
        fXLSX - the stream that points to the Excel document.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_ReadXLSActiveSheet_AsXML

        public bool easy_ReadXLSActiveSheet_AsXML​(System.IO.Stream fXML,
                                                     System.IO.Stream fXLSX,
                                                     System.String sRangeReference)
                                              
        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.
        fXLSX - the stream that points to the Excel document.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • 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
      • easy_ReadExcelWorksheet_AsXML

        public bool easy_ReadExcelWorksheet_AsXML​(System.IO.Stream f,
                                                     System.String sheetName,
                                                     System.String sRangeReference)
                                              
        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.
        sRangeReference - 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
      • easy_ReadExcelWorksheet_AsXML

        public bool easy_ReadExcelWorksheet_AsXML​(System.String XMLFilePath,
                                                     System.String sheetName,
                                                     System.String sRangeReference)
                                              
        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.
        sRangeReference - 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadExcelWorksheet_AsXML

        public bool easy_ReadExcelWorksheet_AsXML​(System.IO.Stream f,
                                                     ExcelWorksheet xlsWorksheet,
                                                     System.String sRangeReference)
                                              
        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.
        sRangeReference - 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
      • easy_ReadExcelWorksheet_AsXML

        public bool easy_ReadExcelWorksheet_AsXML​(System.String XMLFilePath,
                                                     ExcelWorksheet xlsWorksheet,
                                                     System.String sRangeReference)
                                              
        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.
        sRangeReference - 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
      • easy_ReadTXTFile_AsDataSet

        public System.Data.DataSet easy_ReadTXTFile_AsDataSet​(System.String sPath,
                                                               System.String sRowDelimiter,
                                                               System.String sColumnDelimiter)
                                                        
        Reads the cell values from the specified TXT document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadTXTFile_AsDataSet

        public System.Data.DataSet easy_ReadTXTFile_AsDataSet​(System.IO.Stream f,
                                                               System.String sRowDelimiter,
                                                               System.String sColumnDelimiter)
                                                        
        Reads the cell values from the specified TXT document
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadTXTFile_AsDataSet

        public System.Data.DataSet easy_ReadTXTFile_AsDataSet​(System.IO.StreamReader f,
                                                               System.String sRowDelimiter,
                                                               System.String sColumnDelimiter)
                                                        
        Reads the cell values from the specified TXT document
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadCSVFile_AsDataSet

        public System.Data.DataSet easy_ReadCSVFile_AsDataSet​(System.String sPath)
                                                        
        Reads the cell values from the specified CSV document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the CSV document.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXMLSpreadsheet_AsDataSet

        public System.Data.DataSet easy_ReadXMLSpreadsheet_AsDataSet​(System.String sPath,
                                                                      System.String sheetName)
                                                               
        Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
        Available for: Professional, Reader
        Parameters:
        sPath - 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
      • 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
      • easy_ReadXMLSpreadsheet_AsList

        public List easy_ReadXMLSpreadsheet_AsList​(System.String sPath,
                                                   System.String sheetName)
                                            
        Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
        Available for: Professional, Reader
        Parameters:
        sPath - 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
      • 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
      • 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
      • 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
      • easy_ReadExcelWorksheet_AsDataSet

        public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet​(ExcelWorksheet xlsWorksheet,
                                                                      System.String sRangeReference)
                                                               
        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.
        sRangeReference - the range of cells (from the xlsWorksheet object) that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadExcelWorksheet_AsDataSet

        public System.Data.DataSet easy_ReadExcelWorksheet_AsDataSet​(System.String sheetName,
                                                                      System.String sRangeReference)
                                                               
        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.
        sRangeReference - the range of cells (from ExcelWorksheet named sheetName) that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadExcelWorksheet_AsList

        public List easy_ReadExcelWorksheet_AsList​(ExcelWorksheet xlsWorksheet,
                                                   System.String sRangeReference)
                                            
        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.
        sRangeReference - the range of cells (from the xlsWorksheet object) that will be read.
        Returns:
        a List that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadExcelWorksheet_AsList

        public List easy_ReadExcelWorksheet_AsList​(System.String sheetName,
                                                   System.String sRangeReference)
                                            
        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.
        sRangeReference - the range of cells (from ExcelWorksheet named sheetName) that will be read.
        Returns:
        a List that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSSheet_AsDataSet​(System.String path,
                                                                System.String sheetName,
                                                                System.String sRangeReference)
                                                         
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
        Available for: Professional, Reader
        Parameters:
        path - the path to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadXLSSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSSheet_AsDataSet​(System.IO.Stream f,
                                                                System.String sheetName,
                                                                System.String sRangeReference)
                                                         
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a DataSet object
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSActiveSheet_AsList

        public List easy_ReadXLSActiveSheet_AsList​(System.String sPath)
                                            
        Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
        Available for: Professional, Reader
        Parameters:
        sPath - 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet​(System.String path,
                                                                      System.String sRangeReference)
                                                               
        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.
        sRangeReference - 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
      • easy_ReadXLSActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet​(System.IO.Stream f,
                                                                      System.String sRangeReference)
                                                               
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadXLSActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSActiveSheet_AsDataSet​(System.String sPath)
                                                               
        Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the Excel document.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • easy_ReadXLSXSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet​(System.String path,
                                                                 System.String sheetName,
                                                                 System.String sRangeReference)
                                                          
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
        Available for: Professional, Reader
        Parameters:
        path - the path to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadXLSXSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSXSheet_AsDataSet​(System.IO.Stream f,
                                                                 System.String sheetName,
                                                                 System.String sRangeReference)
                                                          
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • easy_ReadXLSXActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet​(System.String path,
                                                                       System.String sRangeReference)
                                                                
        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.
        sRangeReference - the range of cells from the current Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSXActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSXActiveSheet_AsDataSet​(System.IO.Stream f,
                                                                       System.String sRangeReference)
                                                                
        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.
        sRangeReference - the range of cells from the current Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSXActiveSheet_AsList

        public List easy_ReadXLSXActiveSheet_AsList​(System.String sPath)
                                             
        Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
        Available for: Professional, Reader
        Parameters:
        sPath - 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
      • easy_ReadXLSXActiveSheet_AsList

        public List easy_ReadXLSXActiveSheet_AsList​(System.String sPath,
                                                    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:
        sPath - 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
      • easy_ReadXLSXActiveSheet_AsList

        public List easy_ReadXLSXActiveSheet_AsList​(System.String sPath,
                                                    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:
        sPath - 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSXSheet_AsXML

        public bool easy_ReadXLSXSheet_AsXML​(System.String XMLFilePath,
                                                System.String XLSXFilePath,
                                                System.String sheetName,
                                                System.String sRangeReference)
                                         
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
        Available for: Professional, Reader
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSXSheet_AsXML

        public bool easy_ReadXLSXSheet_AsXML​(System.IO.Stream fXML,
                                                System.IO.Stream fXLSX,
                                                System.String sheetName,
                                                System.String sRangeReference)
                                         
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
        Available for: Professional, Reader
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSXActiveSheet_AsXML

        public bool easy_ReadXLSXActiveSheet_AsXML​(System.String XMLFilePath,
                                                      System.String XLSXFilePath,
                                                      System.String sRangeReference)
                                               
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSXActiveSheet_AsXML

        public bool easy_ReadXLSXActiveSheet_AsXML​(System.IO.Stream fXML,
                                                      System.IO.Stream fXLSX,
                                                      System.String sRangeReference)
                                               
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSBSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet​(System.String path,
                                                                 System.String sheetName,
                                                                 System.String sRangeReference)
                                                          
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
        Available for: Professional, Reader
        Parameters:
        path - the path to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • easy_ReadXLSBSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSBSheet_AsDataSet​(System.IO.Stream f,
                                                                 System.String sheetName,
                                                                 System.String sRangeReference)
                                                          
        Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a DataSet object
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the Excel document.
        sheetName - the name of the worksheet that will be read.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSBActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet​(System.String path,
                                                                       System.String sRangeReference)
                                                                
        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.
        sRangeReference - the range of cells from the current Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSBActiveSheet_AsDataSet

        public System.Data.DataSet easy_ReadXLSBActiveSheet_AsDataSet​(System.IO.Stream f,
                                                                       System.String sRangeReference)
                                                                
        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.
        sRangeReference - the range of cells from the current Excel worksheet that will be read.
        Returns:
        a DataSet that contains the cell values
        Throws:
        System.Exception
      • 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
      • easy_ReadXLSBActiveSheet_AsList

        public List easy_ReadXLSBActiveSheet_AsList​(System.String sPath)
                                             
        Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
        Available for: Professional, Reader
        Parameters:
        sPath - 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
      • easy_ReadXLSBActiveSheet_AsList

        public List easy_ReadXLSBActiveSheet_AsList​(System.String sPath,
                                                    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:
        sPath - 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
      • easy_ReadXLSBActiveSheet_AsList

        public List easy_ReadXLSBActiveSheet_AsList​(System.String sPath,
                                                    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:
        sPath - 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • easy_ReadXLSBSheet_AsXML

        public bool easy_ReadXLSBSheet_AsXML​(System.String XMLFilePath,
                                                System.String XLSBFilePath,
                                                System.String sheetName,
                                                System.String sRangeReference)
                                         
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
        Available for: Professional, Reader
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSBSheet_AsXML

        public bool easy_ReadXLSBSheet_AsXML​(System.IO.Stream fXML,
                                                System.IO.Stream fXLSB,
                                                System.String sheetName,
                                                System.String sRangeReference)
                                         
        Reads the cell values from the specified range of specified worksheet of the Microsoft Excel document (Office 2007 file format) and writes them into an XML document
        Available for: Professional, Reader
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSBActiveSheet_AsXML

        public bool easy_ReadXLSBActiveSheet_AsXML​(System.String XMLFilePath,
                                                      System.String XLSBFilePath,
                                                      System.String sRangeReference)
                                               
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_ReadXLSBActiveSheet_AsXML

        public bool easy_ReadXLSBActiveSheet_AsXML​(System.IO.Stream fXML,
                                                      System.IO.Stream fXLSB,
                                                      System.String sRangeReference)
                                               
        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.
        sRangeReference - the range of cells from the sheetName Excel worksheet that will be read.
        Returns:
        true if the read operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_LoadTXTFile

        public bool easy_LoadTXTFile​(System.String sPath,
                                        System.String sRowDelimiter,
                                        System.String sColumnDelimiter)
                                 
        Loads a specified document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_LoadTXTFile

        public bool easy_LoadTXTFile​(System.IO.Stream f,
                                        System.String sRowDelimiter,
                                        System.String sColumnDelimiter)
                                 
        Generates the document at the specified stream
        Available for: Professional, Reader
        Parameters:
        f - the stream that points to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_LoadTXTFile

        public bool easy_LoadTXTFile​(System.IO.StreamReader f,
                                        System.String sRowDelimiter,
                                        System.String sColumnDelimiter)
                                 
        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.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • easy_LoadCSVFile

        public bool easy_LoadCSVFile​(System.String sPath)
                                 
        Loads a specified CSV document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the CSV document.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • 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
      • easy_LoadHTMLFile

        public bool easy_LoadHTMLFile​(System.String sPath)
                                  
        Loads the specified HTML file
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the HTML document.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • easy_LoadHTMLFile

        public bool easy_LoadHTMLFile​(System.IO.StreamReader 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
      • easy_LoadXMLSpreadsheetFile

        public bool easy_LoadXMLSpreadsheetFile​(System.String sPath)
                                            
        Loads a specified XML Spreadsheet document
        Available for: Professional, Reader
        Parameters:
        sPath - the path to the Excel XML Spreadsheet document.
        Returns:
        true if the load operation is successful, false otherwise.
        Throws:
        System.Exception
      • 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
      • easy_WriteCSVFile

        public void easy_WriteCSVFile​(System.String sPath,
                                      System.String sSheetName)
                               
        Generates the CSV document at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the CSV document.
        sSheetName - the name of the sheet whose content will be saved to the CSV document.
        Throws:
        System.Exception
      • easy_WriteCSVFile

        public void easy_WriteCSVFile​(System.IO.StreamWriter f,
                                      System.String sSheetName)
                               
        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.
        sSheetName - the name of the sheet whose content will be saved to the CSV document.
        Throws:
        System.Exception
      • easy_WriteCSVFile

        public void easy_WriteCSVFile​(System.IO.Stream f,
                                      System.String sSheetName)
                               
        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.
        sSheetName - the name of the sheet whose content will be saved to the CSV document.
        Throws:
        System.Exception
      • easy_WriteTXTFile

        public void easy_WriteTXTFile​(System.String sPath,
                                      System.String sSheetName,
                                      System.String sRowDelimiter,
                                      System.String sColumnDelimiter)
                               
        Generates the TXT document at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the TXT document.
        sSheetName - the name of the sheet whose content will be saved to the TXT document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Throws:
        System.Exception
      • easy_WriteHTMLFile

        public void easy_WriteHTMLFile​(System.String sPath,
                                       System.String sSheetName)
                                
        Generates the HTML document at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the HTML document.
        sSheetName - the name of the sheet whose content will be saved to the HTML document.
        Throws:
        System.Exception
      • easy_WriteHTMLFile

        public void easy_WriteHTMLFile​(System.IO.Stream f,
                                       System.String sSheetName)
                                
        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.
        sSheetName - the name of the sheet whose content will be saved to the HTML document.
        Throws:
        System.Exception
      • easy_WriteHTMLFile

        public void easy_WriteHTMLFile​(System.IO.StreamWriter f,
                                       System.String sSheetName)
                                
        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.
        sSheetName - the name of the sheet whose content will be saved to the HTML document.
        Throws:
        System.Exception
      • easy_WriteTXTFile

        public void easy_WriteTXTFile​(System.IO.StreamWriter f,
                                      System.String sSheetName,
                                      System.String sRowDelimiter,
                                      System.String sColumnDelimiter)
                               
        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.
        sSheetName - the name of the sheet whose content will be saved to the document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Throws:
        System.Exception
      • easy_WriteTXTFile

        public void easy_WriteTXTFile​(System.IO.Stream f,
                                      System.String sSheetName,
                                      System.String sRowDelimiter,
                                      System.String sColumnDelimiter)
                               
        Generates the document at the specified stream
        Available for: Professional, Writer
        Parameters:
        f - the stream that points to the document that will be created.
        sSheetName - the name of the sheet whose content will be saved to the document.
        sRowDelimiter - the row delimiter.
        sColumnDelimiter - the column delimiter.
        Throws:
        System.Exception
      • easy_WriteXMLFile

        public void easy_WriteXMLFile​(System.String sPath)
                               
        Generates the XML document at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the XML document.
        Throws:
        System.Exception
      • 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
      • easy_WriteXLSFile

        public void easy_WriteXLSFile​(System.String sPath)
                               
        Generates the Microsoft Excel document (Office 97-2003) at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the Excel document.
        Throws:
        System.Exception
      • 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
      • easy_WriteXLSFile_FromDataSet

        public void easy_WriteXLSFile_FromDataSet​(System.IO.Stream f,
                                                    System.Data.DataSet ds,
                                                    ExcelAutoFormat xlsAutoFormat,
                                                    System.String sSheetName)
                                             
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromDataSet

        public void easy_WriteXLSFile_FromDataSet​(System.IO.Stream f,
                                                    System.Data.DataSet ds,
                                                    System.String startCellReference,
                                                    ExcelAutoFormat xlsAutoFormat,
                                                    System.String sSheetName)
                                             
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromDataSet

        public void easy_WriteXLSFile_FromDataSet​(System.IO.Stream f,
                                                    System.Data.DataSet ds,
                                                    int startRow,
                                                    int startCol,
                                                    ExcelAutoFormat xlsAutoFormat,
                                                    System.String sSheetName)
                                             
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromDataSet

        public void easy_WriteXLSFile_FromDataSet​(System.String sPath,
                                                    System.Data.DataSet ds,
                                                    ExcelAutoFormat xlsAutoFormat,
                                                    System.String sSheetName)
                                             
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromDataSet

        public void easy_WriteXLSFile_FromDataSet​(System.String sPath,
                                                    System.Data.DataSet ds,
                                                    System.String startCellReference,
                                                    ExcelAutoFormat xlsAutoFormat,
                                                    System.String sSheetName)
                                             
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromDataSet

        public void easy_WriteXLSFile_FromDataSet​(System.String sPath,
                                                    System.Data.DataSet ds,
                                                    int startRow,
                                                    int startCol,
                                                    ExcelAutoFormat xlsAutoFormat,
                                                    System.String sSheetName)
                                             
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromList

        public void easy_WriteXLSFile_FromList​(System.IO.Stream f,
                                               List list,
                                               ExcelAutoFormat xlsAutoFormat,
                                               System.String sSheetName)
                                        
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromList

        public void easy_WriteXLSFile_FromList​(System.IO.Stream f,
                                               List list,
                                               System.String startCellReference,
                                               ExcelAutoFormat xlsAutoFormat,
                                               System.String sSheetName)
                                        
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromList

        public void easy_WriteXLSFile_FromList​(System.IO.Stream f,
                                               List list,
                                               int startRow,
                                               int startCol,
                                               ExcelAutoFormat xlsAutoFormat,
                                               System.String sSheetName)
                                        
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromList

        public void easy_WriteXLSFile_FromList​(System.String sPath,
                                               List list,
                                               ExcelAutoFormat xlsAutoFormat,
                                               System.String sSheetName)
                                        
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromList

        public void easy_WriteXLSFile_FromList​(System.String sPath,
                                               List list,
                                               System.String startCellReference,
                                               ExcelAutoFormat xlsAutoFormat,
                                               System.String sSheetName)
                                        
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSFile_FromList

        public void easy_WriteXLSFile_FromList​(System.String sPath,
                                               List list,
                                               int startRow,
                                               int startCol,
                                               ExcelAutoFormat xlsAutoFormat,
                                               System.String sSheetName)
                                        
        Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile

        public void easy_WriteXLSXFile​(System.String sPath)
                                
        Generates the Microsoft Excel Office2007 document at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the Excel document.
        Throws:
        System.Exception
      • 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
      • easy_WriteXLSXFile_FromDataSet

        public void easy_WriteXLSXFile_FromDataSet​(System.IO.Stream f,
                                                     System.Data.DataSet ds,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromDataSet

        public void easy_WriteXLSXFile_FromDataSet​(System.IO.Stream f,
                                                     System.Data.DataSet ds,
                                                     System.String startCellReference,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromDataSet

        public void easy_WriteXLSXFile_FromDataSet​(System.IO.Stream f,
                                                     System.Data.DataSet ds,
                                                     int startRow,
                                                     int startCol,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromDataSet

        public void easy_WriteXLSXFile_FromDataSet​(System.String sPath,
                                                     System.Data.DataSet ds,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromDataSet

        public void easy_WriteXLSXFile_FromDataSet​(System.String sPath,
                                                     System.Data.DataSet ds,
                                                     System.String startCellReference,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromDataSet

        public void easy_WriteXLSXFile_FromDataSet​(System.String sPath,
                                                     System.Data.DataSet ds,
                                                     int startRow,
                                                     int startCol,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromList

        public void easy_WriteXLSXFile_FromList​(System.IO.Stream f,
                                                List list,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromList

        public void easy_WriteXLSXFile_FromList​(System.IO.Stream f,
                                                List list,
                                                System.String startCellReference,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromList

        public void easy_WriteXLSXFile_FromList​(System.IO.Stream f,
                                                List list,
                                                int startRow,
                                                int startCol,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromList

        public void easy_WriteXLSXFile_FromList​(System.String sPath,
                                                List list,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromList

        public void easy_WriteXLSXFile_FromList​(System.String sPath,
                                                List list,
                                                System.String startCellReference,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSXFile_FromList

        public void easy_WriteXLSXFile_FromList​(System.String sPath,
                                                List list,
                                                int startRow,
                                                int startCol,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile

        public void easy_WriteXLSBFile​(System.String sPath)
                                
        Generates the Microsoft Excel Office2007 binary document at the specified path
        Available for: Professional, Writer
        Parameters:
        sPath - the path to the Excel document.
        Throws:
        System.Exception
      • 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
      • easy_WriteXLSBFile_FromDataSet

        public void easy_WriteXLSBFile_FromDataSet​(System.IO.Stream f,
                                                     System.Data.DataSet ds,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromDataSet

        public void easy_WriteXLSBFile_FromDataSet​(System.IO.Stream f,
                                                     System.Data.DataSet ds,
                                                     System.String startCellReference,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromDataSet

        public void easy_WriteXLSBFile_FromDataSet​(System.IO.Stream f,
                                                     System.Data.DataSet ds,
                                                     int startRow,
                                                     int startCol,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromDataSet

        public void easy_WriteXLSBFile_FromDataSet​(System.String sPath,
                                                     System.Data.DataSet ds,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromDataSet

        public void easy_WriteXLSBFile_FromDataSet​(System.String sPath,
                                                     System.Data.DataSet ds,
                                                     System.String startCellReference,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromDataSet

        public void easy_WriteXLSBFile_FromDataSet​(System.String sPath,
                                                     System.Data.DataSet ds,
                                                     int startRow,
                                                     int startCol,
                                                     ExcelAutoFormat xlsAutoFormat,
                                                     System.String sSheetName)
                                              
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the dataset data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromList

        public void easy_WriteXLSBFile_FromList​(System.IO.Stream f,
                                                List list,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromList

        public void easy_WriteXLSBFile_FromList​(System.IO.Stream f,
                                                List list,
                                                System.String startCellReference,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromList

        public void easy_WriteXLSBFile_FromList​(System.IO.Stream f,
                                                List list,
                                                int startRow,
                                                int startCol,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromList

        public void easy_WriteXLSBFile_FromList​(System.String sPath,
                                                List list,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromList

        public void easy_WriteXLSBFile_FromList​(System.String sPath,
                                                List list,
                                                System.String startCellReference,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • easy_WriteXLSBFile_FromList

        public void easy_WriteXLSBFile_FromList​(System.String sPath,
                                                List list,
                                                int startRow,
                                                int startCol,
                                                ExcelAutoFormat xlsAutoFormat,
                                                System.String sSheetName)
                                         
        Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
        Available for: Professional, Writer, Express Writer
        Parameters:
        sPath - 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;
        sSheetName - the name of the sheet;
        Throws:
        System.Exception
      • 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.