A headless spreadsheet • A parser and evaluator of Excel formulas
HyperFormula is a headless spreadsheet built on top of TypeScript. It is a parser and evaluator of Excel formulas for web applications. You can use it in a browser or as a service, with Node.js as your back-end technology.
- High-speed Excel formula parsing and evaluating
- A library of nearly 400 built-in functions
- Support for internationalization with 17 built-in languages
- Support for custom functions
- Function syntax compatible with Microsoft Excel and Google Sheets
- Support for Node.js
- Support for undo/redo
- Support for CRUD operations
- Support for clipboard
- Support for named expressions
- Support for data sorting
- Support for React, Angular, and Vue.js
- Open-source license
- Actively maintained by the team that stands behind Handsontable - JavaScript Data Grid
- Explainer video
- Installation
- Basic usage
- API Reference
- Configuration options
- List of built-in functions
- Key concepts
Install the library from npm:
npm install hyperformula
Once installed, you can use it like this:
import { HyperFormula } from 'hyperformula';
// define the options
const options = {
licenseKey: 'gpl-v3',
};
// define the data
const data = [['10', '20', '30', '=SUM(A1:C1)']];
// build an instance with defined options and data
const hfInstance = HyperFormula.buildFromArray(data, options);
// call getCellValue to get the calculation results
const mySum = hfInstance.getCellValue({ col: 3, row: 0, sheet: 0 });
// print the result in the browser's console
console.log(mySum);
HyperFormula doesn't assume any existing user interface, making it a great general-purpose library that can be used in various business applications. Here are some examples:
- Spreadsheets
- Business logic builders
- Forms and form builders
- Computation notebooks
- Smart documents
- Educational apps
- Online calculators
Help us build the fastest and most flexible calculation engine for business web apps. Please read the Contributing Guide before making a pull request.
HyperFormula is available under the open source license (GPLv3).
To buy a commercial license, please write to us at [email protected]
© 2022 Handsoncode