Uses of Class
EasyXLS.ExcelWorksheet
Namespaces that use ExcelWorksheet
-
Uses of ExcelWorksheet in EasyXLS
Methods in EasyXLS with parameters of type ExcelWorksheetModifier and TypeMethodDescriptionEasyXLS.Formulas.Util.FunctionDataObjectExcelCell.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 formulaFormula.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.voidExcelDocument.easy_addWorksheet(ExcelWorksheet xlsWorksheet) Adds a worksheet to the sheet list.voidExcelDocument.easy_insertWorksheet(int index, ExcelWorksheet xlsWorksheet) Inserts a worksheet to the sheet list on the specified position.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, ReaderExcelDocument.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, ReaderExcelDocument.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, ReaderSystem.Data.DataSetExcelDocument.easy_ReadExcelWorksheet_AsDataSet(ExcelWorksheet xlsWorksheet) Reads the cell values from the specified ExcelWorksheet of the EasyXLS ExcelDocument into a DataSet object
Available for: Professional, ReaderSystem.Data.DataSetExcelDocument.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, ReaderSystem.Data.DataSetExcelDocument.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, ReaderboolExcelDocument.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, ReaderboolExcelDocument.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, ReaderboolExcelDocument.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, ReaderboolExcelDocument.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, ReaderboolExcelDocument.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, ReaderboolExcelDocument.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