Uses of Class
EasyXLS.Util.List
Namespaces that use List
-
Uses of List in EasyXLS
Modifier and TypeMethodDescriptionExcelDocument.easy_ReadCSVFile_AsList(System.IO.Stream f)
Reads the cell values from the specified CSV document
Available for: Professional, Reader
ExcelDocument.easy_ReadCSVFile_AsList(System.IO.StreamReader f)
Reads the cell values from the specified CSV document
Available for: Professional, Reader
ExcelDocument.easy_ReadCSVFile_AsList(System.String path)
Reads the cell values from the specified CSV document
Available for: Professional, Reader
ExcelDocument.easy_ReadCSVFile_AsList(System.String path, System.String encoding)
Reads the cell values from the specified CSV file with specified encoding; most common values are available inEncoding
class
This method is overridden as easy_ReadCSVFile_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet)
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.easy_ReadExcelWorksheet_AsList(ExcelWorksheet xlsWorksheet, System.String rangeReference)
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadExcelWorksheet_AsList(System.String sheetName)
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadExcelWorksheet_AsList(System.String sheetName, int startRow, int startColumn, int endRow, int endColumn)
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadExcelWorksheet_AsList(System.String sheetName, System.String rangeReference)
Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a List object
This method is overridden as easy_ReadExcelWorksheet_AsList_6 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadTXTFile_AsList(System.IO.StreamReader f, System.String rowDelimiter, System.String columnDelimiter)
Reads the cell values from the specified TXT document
Available for: Professional, Reader
ExcelDocument.easy_ReadTXTFile_AsList(System.IO.Stream f, System.String rowDelimiter, System.String columnDelimiter)
Reads the cell values from the specified TXT document
Available for: Professional, Reader
ExcelDocument.easy_ReadTXTFile_AsList(System.String path, System.String rowDelimiter, System.String columnDelimiter)
Reads the cell values from the specified TXT document
Available for: Professional, Reader
ExcelDocument.easy_ReadTXTFile_AsList(System.String path, System.String encoding, System.String rowDelimiter, System.String columnDelimiter)
Reads the cell values from the TXT file with specified encoding; most common values are available inEncoding
class
This method is overridden as easy_ReadTXTFile_AsList_4 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.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
ExcelDocument.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
ExcelDocument.easy_ReadXLSActiveSheet_AsList(System.String path)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003)
Available for: Professional, Reader
ExcelDocument.easy_ReadXLSActiveSheet_AsList(System.String path, int startRow, int startColumn, int endRow, int endColumn)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadXLSActiveSheet_AsList(System.String path, System.String rangeReference)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.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
ExcelDocument.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
ExcelDocument.easy_ReadXLSBActiveSheet_AsList(System.String path)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
ExcelDocument.easy_ReadXLSBActiveSheet_AsList(System.String path, int startRow, int startColumn, int endRow, int endColumn)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadXLSBActiveSheet_AsList(System.String path, System.String rangeReference)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.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
ExcelDocument.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
ExcelDocument.easy_ReadXLSBSheet_AsList(System.String path, System.String sheetName)
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSBSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.easy_ReadXLSBSheet_AsList(System.String path, System.String sheetName, System.String rangeReference)
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
This method is overridden as easy_ReadXLSBSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.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
ExcelDocument.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
ExcelDocument.easy_ReadXLSSheet_AsList(System.String path, System.String sheetName)
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003)
This method is overridden as easy_ReadXLSSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.easy_ReadXLSSheet_AsList(System.String path, System.String sheetName, System.String rangeReference)
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 97-2003) into a List object
This method is overridden as easy_ReadXLSSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.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
ExcelDocument.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
ExcelDocument.easy_ReadXLSXActiveSheet_AsList(System.String path)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
Available for: Professional, Reader
ExcelDocument.easy_ReadXLSXActiveSheet_AsList(System.String path, int startRow, int startColumn, int endRow, int endColumn)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXActiveSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.easy_ReadXLSXActiveSheet_AsList(System.String path, System.String rangeReference)
Reads the cell values from the current worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXActiveSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.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
ExcelDocument.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
ExcelDocument.easy_ReadXLSXSheet_AsList(System.String path, System.String sheetName)
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format)
This method is overridden as easy_ReadXLSXSheet_AsList_3 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.easy_ReadXLSXSheet_AsList(System.String path, System.String sheetName, System.String rangeReference)
Reads the cell values from the specified worksheet of the Microsoft Excel document (Office 2007 file format) into a List object
This method is overridden as easy_ReadXLSXSheet_AsList_5 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelDocument.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
ExcelDocument.easy_ReadXMLSpreadsheet_AsList(System.String path, System.String sheetName)
Reads the cell values from the specified worksheet of the Microsoft Excel XML Spreadsheet into a DataSet object
This method is overridden as easy_ReadXMLSpreadsheet_AsList_2 in COM+ version of EasyXLS.
Available for: Professional, Reader
ExcelTable.findAll(System.String value, int lookIn, bool matchCase, bool matchEntireCellContents)
Searches all the occurrences of the cell that matches the criteria.ExcelDocument.getCircularReferences()
Returns a list of strings that contains information about the circular references inside the Excel document.ExcelTable.getHorizontalPageBreaks()
Returns a list with all horizontal page breaksExcelTable.getVerticalPageBreaks()
Returns a list with all vertical page breaksModifier and TypeMethodDescriptionvoid
ExcelWorksheet.easy_addConditionalFormatting(int firstRow, int firstColumn, int lastRow, int lastColumn, List lstConditions)
Adds a conditional formatting at the specified range to worksheet.
This method is overridden as easy_addConditionalFormatting_2 in COM+ version of EasyXLS.
void
ExcelWorksheet.easy_addConditionalFormatting(System.String range, List lstConditions)
Adds a conditional formatting at the specified range to worksheet.
This method is overridden as easy_addConditionalFormatting_3 in COM+ version of EasyXLS.
void
ExcelWorksheet.easy_insertList(List list)
Inserts the data from the specified List object into this ExcelWorksheet starting from the first row and first column of the worksheet data table.void
ExcelWorksheet.easy_insertList(List list, int startRow, int startCol)
Inserts the data from the specified List object into this ExcelWorksheet starting from thestartRow
row index andstartCol
column index.
Thelist
must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.
This method is overridden as easy_insertList_3 in COM+ version of EasyXLS.
void
ExcelWorksheet.easy_insertList(List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat)
Inserts the data from the specified List object into this ExcelWorksheet starting from thestartRow
row index andstartCol
column index.
Thelist
must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.
This method is overridden as easy_insertList_4 in COM+ version of EasyXLS.
void
ExcelWorksheet.easy_insertList(List list, ExcelAutoFormat xlsAutoFormat)
Inserts the data from the specified List object into this ExcelWorksheet starting from the first row and first column of the worksheet data table.
This method is overridden as easy_insertList_2 in COM+ version of EasyXLS.
Thelist
must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.void
ExcelWorksheet.easy_insertList(List list, System.String startCellReference)
Inserts the data from the specified List object into this ExcelWorksheet starting with the specified cell.
Thelist
must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.
This method is overridden as easy_insertList_5 in COM+ version of EasyXLS.
void
ExcelWorksheet.easy_insertList(List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat)
Inserts the data from the specified List object into this ExcelWorksheet starting with the specified cell.
Thelist
must be a list of rows, each row is an EasyXLS.Util.List object and each row must contain the values.
This method is overridden as easy_insertList_6 in COM+ version of EasyXLS.
void
ExcelDocument.easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSBFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSBFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSBFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSBFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSBFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSBFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 97-2003) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSXFile_FromList(System.IO.Stream f, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSXFile_FromList(System.String path, List list, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSXFile_FromList(System.String path, List list, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSXFile_FromList_2 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer
void
ExcelDocument.easy_WriteXLSXFile_FromList(System.String path, List list, System.String startCellReference, ExcelAutoFormat xlsAutoFormat, System.String sheetName)
Generates a Microsoft Excel document (Office 2007 file format) having one worksheet filled with the list data
This method is overridden as easy_WriteXLSXFile_FromList_3 in COM+ version of EasyXLS.
Available for: Professional, Writer, Express Writer
ModifierConstructorDescriptionExcelConditionalFormatting(int firstRow, int firstColumn, int lastRow, int lastColumn, List lstConditions)
Defines an instance of the conditional formatting having the specified range.ExcelConditionalFormatting(System.String range, List lstConditions)
Defines an instance of the conditional formatting on the specified range.Formula(ExcelDocument excel, EasyXLS.OpenXML.Workbook workbook, List lstForCalculatedFields)
Defines a new instance of the object that parses formulas. -
Uses of List in EasyXLS.Util
Methods in EasyXLS.Util that return List