excel-formula-utilities
Advanced tools
Comparing version 1.0.1 to 1.0.2
@@ -31,4 +31,5 @@ { | ||
"scripts": { | ||
"dev": "vite --host", | ||
"build": "vite build --mode modern && vite build --mode legacy", | ||
"dev": "vite --host --mode playground", | ||
"build:playground": "vite build --mode playground", | ||
"build": "vite build --mode modern && vite build --mode legacy && pnpm run build:playground", | ||
"test:unit": "vitest", | ||
@@ -45,3 +46,5 @@ "test:coverage": "vitest --coverage", | ||
"@kouts/eslint-config": "^1.1.0", | ||
"@vitejs/plugin-vue": "^5.1.2", | ||
"@vitest/coverage-v8": "^2.0.5", | ||
"autoprefixer": "^10.4.20", | ||
"eslint": "^9.9.0", | ||
@@ -51,5 +54,8 @@ "glob": "^11.0.0", | ||
"lint-staged": "^15.2.8", | ||
"postcss": "^8.4.41", | ||
"prettier": "^3.3.3", | ||
"tailwindcss": "^3.4.9", | ||
"vite": "^5.4.0", | ||
"vitest": "^2.0.5" | ||
"vitest": "^2.0.5", | ||
"vue": "^3.4.37" | ||
}, | ||
@@ -56,0 +62,0 @@ "resolutions": { |
@@ -14,3 +14,3 @@ { | ||
], | ||
"version": "1.0.1", | ||
"version": "1.0.2", | ||
"type": "module", | ||
@@ -32,4 +32,5 @@ "main": "./dist/cjs/index.js", | ||
"scripts": { | ||
"dev": "vite --host", | ||
"build": "vite build --mode modern && vite build --mode legacy", | ||
"dev": "vite --host --mode playground", | ||
"build:playground": "vite build --mode playground", | ||
"build": "vite build --mode modern && vite build --mode legacy && pnpm run build:playground", | ||
"test:unit": "vitest", | ||
@@ -48,3 +49,5 @@ "test:coverage": "vitest --coverage", | ||
"@semantic-release/git": "^10.0.1", | ||
"@vitejs/plugin-vue": "^5.1.2", | ||
"@vitest/coverage-v8": "^2.0.5", | ||
"autoprefixer": "^10.4.20", | ||
"eslint": "^9.9.0", | ||
@@ -54,6 +57,9 @@ "glob": "^11.0.0", | ||
"lint-staged": "^15.2.8", | ||
"postcss": "^8.4.41", | ||
"prettier": "^3.3.3", | ||
"semantic-release": "^24.0.0", | ||
"tailwindcss": "^3.4.9", | ||
"vite": "^5.4.0", | ||
"vitest": "^2.0.5" | ||
"vitest": "^2.0.5", | ||
"vue": "^3.4.37" | ||
}, | ||
@@ -60,0 +66,0 @@ "resolutions": { |
# excel-formula-utilities | ||
This project is a port of the [excel-formula](https://github.com/joshbtn/excelFormulaUtilitiesJS) library to ES6 without any dependencies. | ||
It's a library that can be used to pretty print excel formulas or convert excel formulas into JavaScript, C# or Python code. | ||
This project is a port of the [excel-formula](https://github.com/joshbtn/excelFormulaUtilitiesJS) library to ES6. | ||
It contains a set of functions that can be used to pretty print Excel formulas and convert them into JavaScript, C# or Python code. | ||
**Key Differences from [excel-formula](https://github.com/joshbtn/excelFormulaUtilitiesJS):** | ||
- Removed external dependencies (Bootstrap, jQuery) | ||
- Removed jQuery methods and replaced them with ES6 equivalents | ||
- Modularized the library with support for tree-shaking | ||
- Does not expose a global (window) variable | ||
- Added `isEu` as an option to the `getTokens`, `formatFormula` and `formatFormulaHTML` methods | ||
- Provides ES, CJS, and UMD module formats | ||
## Install | ||
@@ -14,2 +23,4 @@ | ||
### Module bundler | ||
```javascript | ||
@@ -21,2 +32,11 @@ import { formatFormula } from 'excel-formula-utilities' | ||
### Browser | ||
```html | ||
<script src="https://unpkg.com/excel-formula-utilities"></script> | ||
<script> | ||
const formattedFormula = ExcelFormulaUtilities.formatFormula('SUM(A1:A2)') | ||
</script> | ||
``` | ||
## Available methods | ||
@@ -23,0 +43,0 @@ |
143450
239
19