NanoXLSX Library Documentation
CellBasicFormulas Class |
Class for handling of basic Excel formulas
Inheritance Hierarchy
Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
Syntax
C#
public static class BasicFormulas
Methods
Name | Description | |
---|---|---|
Average(CellRange) |
Returns a cell with a average formula
| |
Average(Worksheet, CellRange) |
Returns a cell with a average formula
| |
Ceil(CellAddress, Int32) |
Returns a cell with a ceil formula
| |
Ceil(Worksheet, CellAddress, Int32) |
Returns a cell with a ceil formula
| |
Floor(CellAddress, Int32) |
Returns a cell with a floor formula
| |
Floor(Worksheet, CellAddress, Int32) |
Returns a cell with a floor formula
| |
GetBasicFormula |
Function to generate a basic Excel function with one cell range as parameter and an optional post argument
| |
GetVLookup |
Function to generate a Vlookup as Excel function
| |
Max(CellRange) |
Returns a cell with a max formula
| |
Max(Worksheet, CellRange) |
Returns a cell with a max formula
| |
Median(CellRange) |
Returns a cell with a median formula
| |
Median(Worksheet, CellRange) |
Returns a cell with a median formula
| |
Min(CellRange) |
Returns a cell with a min formula
| |
Min(Worksheet, CellRange) |
Returns a cell with a min formula
| |
Round(CellAddress, Int32) |
Returns a cell with a round formula
| |
Round(Worksheet, CellAddress, Int32) |
Returns a cell with a round formula
| |
Sum(CellRange) |
Returns a cell with a sum formula
| |
Sum(Worksheet, CellRange) |
Returns a cell with a sum formula
| |
VLookup(Object, CellRange, Int32, Boolean) |
Function to generate a Vlookup as Excel function
| |
VLookup(CellAddress, CellRange, Int32, Boolean) |
Function to generate a Vlookup as Excel function
| |
VLookup(Object, Worksheet, CellRange, Int32, Boolean) |
Function to generate a Vlookup as Excel function
| |
VLookup(Worksheet, CellAddress, Worksheet, CellRange, Int32, Boolean) |
Function to generate a Vlookup as Excel function
|
See Also