NanoXLSX Library Documentation
 | CellBasicFormulas Class |
Class for handling of basic Excel formulas
Inheritance HierarchyNamespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
SyntaxC#
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