Uses of Class
EasyXLS.ExcelDocument
-
Uses of ExcelDocument in EasyXLS
Modifier and TypeMethodDescriptionExcelDocument.Clone()
Creates and returns a copy of this object.ExternalLinks.getExcelDocument(System.String link)
Returns the Excel document specified by the link.Modifier 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 ExcelWorksheetModifierConstructorDescriptionFormula(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
Modifier 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.