Uses of Class
EasyXLS.ExcelWorksheet

Namespaces that use ExcelWorksheet
Namespace
Description
EasyXLS
 

  • Uses of ExcelWorksheet in EasyXLS

    Methods in EasyXLS with parameters of type ExcelWorksheet
    Modifier and Type
    Method
    Description
    EasyXLS.Formulas.Util.FunctionDataObject
    ExcelCell.calculateFormula​(ExcelDocument excel, ExcelWorksheet cellWorksheet, ExcelWorksheet formulaWorksheet, int nCellRow, int nCellColumn, int nFormulaRow, int nFormulaColumn, bool bRecalculate)
    Calculates the cell formula if the cell value is a formula
    FormulaResult
    Formula.computeFormula​(System.String sFormula, ExcelWorksheet currentWorksheet_arg, ExcelWorksheet formulaWorksheet_arg, int formulaRow, int formulaColumn)
    Returns the result of an Excel formula; the formula should not start with the = (equal) sign like in Excel.
    void
    ExcelDocument.easy_addWorksheet​(ExcelWorksheet xlsWorksheet)
    Adds a worksheet to the sheet list.
    void
    ExcelDocument.easy_insertWorksheet​(int index, ExcelWorksheet xlsWorksheet)
    Inserts a worksheet to the sheet list on the specified position.
    List
    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
    List
    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
    List
    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
    System.Data.DataSet
    ExcelDocument.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
    ExcelDocument.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
    ExcelDocument.easy_ReadExcelWorksheet_AsDataSet​(ExcelWorksheet xlsWorksheet, System.String rangeReference)
    Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
    Available for: Professional, Reader
    bool
    ExcelDocument.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
    ExcelDocument.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
    ExcelDocument.easy_ReadExcelWorksheet_AsXML​(System.IO.Stream f, ExcelWorksheet xlsWorksheet, System.String rangeReference)
    Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
    Available for: Professional, Reader
    bool
    ExcelDocument.easy_ReadExcelWorksheet_AsXML​(System.String XMLFilePath, ExcelWorksheet xlsWorksheet)
    Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
    This method is overridden as easy_ReadExcelWorksheet_AsXML_2 in COM+ version of EasyXLS.
    Available for: Professional, Reader
    bool
    ExcelDocument.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
    ExcelDocument.easy_ReadExcelWorksheet_AsXML​(System.String XMLFilePath, ExcelWorksheet xlsWorksheet, System.String rangeReference)
    Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument and writes them into an XML document
    This method is overridden as easy_ReadExcelWorksheet_AsXML_3 in COM+ version of EasyXLS.
    Available for: Professional, Reader