Can the parser be use as a stand alone?

[codersbet]

I would like to know if I can use the parser without a data table. i.e. say if I have a data=[{name: 'test', salary:1500}, {name: 'test', salary:2000} ] can do something like SUM(salary)

[sequba]

Hi @codersbet, thanks for reaching out to us!

Method 1

If you don't want to put your data into an array you can call calculateFormula() to use HyperFormula as an advanced calculator:

    const hf = HyperFormula.buildFromArray([]);

    const data = [
      { name: 'test1', salary: 1500 },
      { name: 'test2', salary: 2000 },
    ];
    const salaries = data.map(item => item.salary).join(',');
    const totalSalary = hf.calculateFormula(`=SUM(${salaries})`, 0);

Method 2

You can put your data into an array and define a named expression Salary that points to the right data column.

    const data = [
      { name: 'test1', salary: 1500 },
      { name: 'test2', salary: 2000 },
    ];
    const dataArray = data.map(item => [ item.name, item.salary ]);
    const hf = HyperFormula.buildFromSheets(
      { Data: dataArray },
      {},
      [{ name: 'Salary', expression: '=Data!$B:$B' }]
    );
    const totalSalary = hf.calculateFormula('=SUM(Salary)', 0);

I hope one of these methods solves your problem ;)