 | Basic |
Class for handling of basic Excel formulas
Inheritance HierarchySystemObject
NanoXLSXBasicFormulas
NanoXLSXBasicFormulas
Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.2+7f12a949130e0be1e987e553d2d08c083176cdca
SyntaxC#
public static class BasicFormulas
The BasicFormulas type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | Average(Range) | Returns a cell with a average formula |
| Average(Worksheet, Range) | Returns a cell with a average formula |
| Ceil(Address, Int32) | Returns a cell with a ceil formula |
| Ceil(Worksheet, Address, Int32) | Returns a cell with a ceil formula |
| Floor(Address, Int32) | Returns a cell with a floor formula |
| Floor(Worksheet, Address, 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(Range) | Returns a cell with a max formula |
| Max(Worksheet, Range) | Returns a cell with a max formula |
| Median(Range) | Returns a cell with a median formula |
| Median(Worksheet, Range) | Returns a cell with a median formula |
| Min(Range) | Returns a cell with a min formula |
| Min(Worksheet, Range) | Returns a cell with a min formula |
| Round(Address, Int32) | Returns a cell with a round formula |
| Round(Worksheet, Address, Int32) | Returns a cell with a round formula |
| Sum(Range) | Returns a cell with a sum formula |
| Sum(Worksheet, Range) | Returns a cell with a sum formula |
| VLookup(Address, Range, Int32, Boolean) | Function to generate a Vlookup as Excel function |
| VLookup(Object, Range, Int32, Boolean) | Function to generate a Vlookup as Excel function |
| VLookup(Object, Worksheet, Range, Int32, Boolean) | Function to generate a Vlookup as Excel function |
| VLookup(Worksheet, Address, Worksheet, Range, Int32, Boolean) | Function to generate a Vlookup as Excel function |
See Also