zkyg/spreadsheet-formula-laravel

Parsing and calculate simple Ms Excel formula using PHP(through PHPSpreadsheet) for Laravel

Maintainers

Details

github.com/zkyg/spreadsheet-formula-excel

Source

Issues

Installs: 10

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 1

Forks: 1

Open Issues: 0

v1.0.3 2021-08-06 05:51 UTC

Requires

MIT e5f612c96ae4ec8300d58bcf7fad1ec3d4559923

This package is auto-updated.

Last update: 2024-05-06 14:16:50 UTC

README

Library to parse and execute simple spreadsheet formula inside Laravel project. Basically it's using PhpSpreadsheet to simulate and get the formula result.

  • Install
composer require zkyg/spreadsheet-formula-laravel
  • How to use
$formula = "=IF( [[value1]] < 5, \"ok\", [[value1]] + [[value2]] )";
$values = [
    'value1' => 7,
    'value2' => 3
];
$res = \zkyg\SpreadsheetFormulaLaravel\SpreadsheetFormulaParser::getInstance()->calculate(
    $formula,
    $values
);
// $res = 10
  • Rules:
- Parameter count have to be equals in both formula & value list.
- Value index name is alphanumeric and cannot begin with number.
- Function segment separated with "," not ";"