# excelFormulaUtilitiesJS

**Repository Path**: neequ_admin/excelFormulaUtilitiesJS

## Basic Information

- **Project Name**: excelFormulaUtilitiesJS
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-07-13
- **Last Updated**: 2021-07-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Excel Formula Utilities for JavaScript

[![Build Status](https://travis-ci.org/joshbtn/excelFormulaUtilitiesJS.svg?branch=master)](https://travis-ci.org/joshbtn/excelFormulaUtilitiesJS) [![CDNJS version](https://img.shields.io/cdnjs/v/excel-formula.svg)](https://cdnjs.com/libraries/excel-formula)

Excel Formula Utilities for JavaScript is a library that can be used to
pretty print excel formulas or convert excel formulas into JavaScript.
The JavaScript generated by this library will not execute on it's own.
You'll need to include something like
[formula.js](https://github.com/sutoiku/formula.js/) to cover all the functions
from Excel.

##Install using npm
npm install excel-formula

## Installation for web
Grab the latest js files in the dist folder.

## Basic usage for web
```html
    <script src="excel-formula.js" />
    <script>
        var formattedFormula = excelFormulaUtilities.formatFormulaHTML('IF(1+1=2,"true","false")');
        alert(formattedFormula)
    </script>
```
## Basic Usage for Node
```javascript
    var formula = require('excel-formula');
    var formattedFormula = formula.formatFormula('IF(1+1=2,"true","false")');
    console.log(formatFormula);
```
## Node methods
See basic usage above.
```javascript
    formula.getTokens (formula);
    formula.formatFormula (formula, [opts])
    formula.toJavaScript(formula)
    formula.toCSharp(formula)
```
## Web methods
excelFormulaUtilities is a global variable.
```javascript
    excelFormulaUtilities.getTokens (formula);
    excelFormulaUtilities.formatFormula (formula, [opts]) // This will work fine in a pre tag
    excelFormulaUtilities.formatFormulaHTML(formula) // Use this if you want the output as html.
    excelFormulaUtilities.formula2JavaScript(formula)
    excelFormulaUtilities.formula2CSharp(formula)
```