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.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 formulavoid
ExcelWorksheet.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.String
ExcelWorksheet.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 TypeMethodDescriptionvoid
ExcelPivotTable.Refresh(ExcelDocument xls)
Refreshes the field names accordingly to the data on the source range.void
ExcelPivotTable.setSourceRange(System.String formulaRange, ExcelDocument xls)
Sets the data source for the pivot table.