hyperformula
Advanced tools
HyperFormula is a JavaScript engine for efficient processing of spreadsheet-like data and formulas
HyperFormula allows you to perform spreadsheet-like calculations in your web applications. It is written in TypeScript and supports all major JavaScript frameworks. You can use it in a browser or as a service with Node.js as your back-end technology.
The engine comes with a built-in, localized library of functions grouped into different categories, and covers most user-triggered actions such as CRUD operations, undo/redo, and clipboard operations. It also supports the use of cross-sheet references, named expressions, different data types, and custom functions.
Install the library from npm:
npm install hyperformula
Once properly 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, which makes it a great general-purpose library that can be used in various business applications. Here are some examples:
Help us build the fastest and most flexible calculation engine for business web apps. Please read the Contributing Guide before making a pull request.
Your help is much appreciated in any of the following topics:
HyperFormula is a double-licensed software. In all your non-commercial projects, you can use it under the open source GPLv3 license. Additionally, there is also a commercial license, and support services available.
You should know that this project wouldn’t exist without co-financing from European Union funds under the European Regional Development Funds as a part of the Smart Growth Operational Programme. Project implemented as a part of the Polish National Centre for Research and Development: “Fast Track”.
Created by Handsontable, NavAlgo, and Contributors.
© 2021 Handsoncode
[1.0.0] - 2021-07-15
Date() objects on the
input. #648getAllNamedExpressionsSerialized method. #680simpleCellRangeFromString and simpleCellRangeToString
helpers. #720CellError to exports. #736AlwaysDense, AlwaysSparse,
DenseSparseChooseBasedOnThreshold. #747#SPILL! error type. #708getFillRangeData to support different types of
offsetting. #767{=FORMULA})
notation. Engine now supports formulas returning array of values (instead of only scalars).
#652SimpleCellRange type argument: copy, cut, getCellDependents,
getCellPrecedents, getFillRangeData, getRangeFormulas,
getRangeSerialized, getRangeValues, isItPossibleToMoveCells,
isItPossibleToSetCellContents, moveCells. #687setCellContents so that it is possible to override space occupied by
spilled array. #708addRows/removeRows so that it is possible to add/remove rows across
spilled array without changing array size. #708addColumns/removeColumns so that it is possible to add/remove columns
across spilled array without changing array size. #732| before | after | |-----------------------|----------------------| | matrixColumnSeparator | arrayColumnSeparator | | matrixRowSeparator | arrayRowSeparator |
| before | after | |--------------------|-------------------| | matrixMapping | arrrayMapping | | isCellPartOfMatrix | isCellPartOfArray |
| before | after | |------------------------------|-----------------------------| | SourceLocationHasMatrixError | SourceLocationHasArrayError | | TargetLocationHasMatrixError | TargetLocationHasArrayError |
gpu.js making it even more
optional #753FAQs
HyperFormula is a JavaScript engine for efficient processing of spreadsheet-like data and formulas
The npm package hyperformula receives a total of 67,022 weekly downloads. As such, hyperformula popularity was classified as popular.
We found that hyperformula demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 6 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Socket’s threat research team has detected six malicious npm packages typosquatting popular libraries to insert SSH backdoors.
Security News
MITRE's 2024 CWE Top 25 highlights critical software vulnerabilities like XSS, SQL Injection, and CSRF, reflecting shifts due to a refined ranking methodology.
Security News
In this segment of the Risky Business podcast, Feross Aboukhadijeh and Patrick Gray discuss the challenges of tracking malware discovered in open source softare.