Uses of Class
EasyXLS.ExcelDocument
Namespaces that use ExcelDocument
-
Uses of ExcelDocument in EasyXLS
Methods in EasyXLS that return ExcelDocumentModifier and TypeMethodDescriptionExcelDocument.Clone()Creates and returns a copy of this object.ExternalLinks.getExcelDocument(System.String link) Returns the Excel document specified by the link.Methods in EasyXLS with parameters of type ExcelDocumentModifier 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 formulavoidExcelWorksheet.easy_addPivotTable(System.String name, System.String location, System.String sourceFormulaRange, ExcelDocument xls) Adds a pivot table having the specified name, location and data source to the worksheet.
This method is overridden as easy_addPivotTable_2 in COM+ version of EasyXLS.System.StringExcelWorksheet.easy_computeFormulas(ExcelDocument excel, bool recalculateFormula) Calculates all formulas existing in the cells of this ExcelWorksheetConstructors in EasyXLS with parameters of type ExcelDocumentModifierConstructorDescriptionFormula(ExcelDocument excel) Defines a new instance of the object that parses formulas.Formula(ExcelDocument excel, bool bR1C1ReferenceStyle) Defines a new instance of the object that parses formulas.Formula(ExcelDocument excel, EasyXLS.OpenXML.Workbook workbook) Defines a new instance of the object that parses formulas.Formula(ExcelDocument excel, EasyXLS.OpenXML.Workbook workbook, List lstForCalculatedFields) Defines a new instance of the object that parses formulas. -
Uses of ExcelDocument in EasyXLS.PivotTables
Methods in EasyXLS.PivotTables with parameters of type ExcelDocumentModifier and TypeMethodDescriptionvoidExcelPivotTable.Refresh(ExcelDocument xls) Refreshes the field names accordingly to the data on the source range.voidExcelPivotTable.setSourceRange(System.String formulaRange, ExcelDocument xls) Sets the data source for the pivot table.