hyperformula

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

Documentation

• Explainer video
• Installation
• Basic usage
  • Demo with React
  • Demo with Angular
  • Demo with Vue.js
• API Reference
• Configuration options
• List of built-in functions
• Key concepts

Installation and usage

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);

Run this code in CodeSandbox

What can it be used for?

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

Contributing

Help us build the fastest and most flexible calculation engine for business web apps. Please read the Contributing Guide before making a pull request.

License

HyperFormula is available under the open source license (GPLv3).

To buy a commercial license, please write to us at [e-mail]

Copyrights

© 2022 Handsoncode

Changelog

[2.2.0] - 2022-11-17

Added

• Added an American English (enUS) language pack. It's a convenience alias: it contains the same translations as the existing British English (enGB) language pack. #1025

Fixed

• Fixed functions VLOOKUP and HLOOKUP to handle duplicates in the way specified by the OpenDocument standard. #1072
• Fixed the MATCH function to handle descending ranges in the way specified by the OpenDocument standard. #1063