# Basic usage
TIP
The instance can be created with three static methods:
buildFromArray
,
buildFromSheets
or buildEmpty
. You can check all of their
descriptions in our API reference.
If you've already installed the library, it's time to start writing the first simple application.
First, if you used NPM or Yarn to install the package, make sure you have properly imported HyperFormula as shown below:
import { HyperFormula } from 'hyperformula';
If you embed HyperFormula in the <script>
tag using CDN, then it will
be accessible as global variable HyperFormula
and ready to use.
Now you can use the available options to configure the instance of HyperFormula according to your needs, like this:
const options = {
licenseKey: 'gpl-v3'
};
Then, prepare some data to be used by your app. In this case, the data
set will contain numbers and just one formula =SUM(A1,B1)
. Use the
buildFromArray
method to create the instance:
// define the data
const data = [['10', '20', '3.14159265359', '=SUM(A1:C1)']];
// build an instance with defined options and data
const hfInstance = HyperFormula.buildFromArray(data, options);
Alright, now it's time to do some calculations. Let's use the
getCellValue
method to retrieve the results of a formula included
in the data
.
// call getCellValue to get the calculation results
const mySum = hfInstance.getCellValue({ col: 3, row: 0, sheet: 0 });
You can check the output in the console:
// this outputs the result in the browser's console
console.log(mySum);
That's it! You've grasped a basic idea of how the HyperFormula engine works. It's time to move on to a more advanced example.