new DepParser(configopt)
- Source:
Parameters:
| Name | Type | Attributes | Description |
|---|---|---|---|
config |
Object |
<optional> |
Methods
callFunction(name, args) → {*}
- Source:
Call an excel function.
Parameters:
| Name | Type | Description |
|---|---|---|
name |
Function name. |
|
args |
Arguments that pass to the function. |
Returns:
- Type
- *
checkFormulaResult(result) → {*}
- Source:
Check and return the appropriate formula result.
Parameters:
| Name | Type | Description |
|---|---|---|
result |
Returns:
- Type
- *
getCell(ref) → {*}
- Source:
Get value from the cell reference
Parameters:
| Name | Type | Description |
|---|---|---|
ref |
Returns:
- Type
- *
getRange(ref) → {*}
- Source:
Get values from the range reference.
Parameters:
| Name | Type | Description |
|---|---|---|
ref |
Returns:
- Type
- *
getVariable(name) → {*}
- Source:
TODO: Get references or values from a user defined variable.
Parameters:
| Name | Type | Description |
|---|---|---|
name |
Returns:
- Type
- *
parse(inputText, position, ignoreErroropt) → {Array.<{}>}
- Source:
Parse an excel formula and return the dependencies
Parameters:
| Name | Type | Attributes | Default | Description |
|---|---|---|---|---|
inputText |
string | |||
position |
Object | |||
ignoreError |
boolean |
<optional> |
false
|
if true, throw FormulaError when error occurred. if false, the parser will return partial dependencies. |
Returns:
- Type
- Array.<{}>
retrieveRef(valueOrRef) → {*}
- Source:
Retrieve values from the given reference.
Parameters:
| Name | Type | Description |
|---|---|---|
valueOrRef |
Returns:
- Type
- *