About zkyg/spreadsheet-formula-laravel

zkyg/spreadsheet-formula-laravel is a Laravel package for parsing and calculate simple ms excel formula using php(through phpspreadsheet) for laravel. It currently has 1 GitHub stars and 14 downloads on Packagist (latest version v1.0.3). Install it with composer require zkyg/spreadsheet-formula-laravel. Discover more Laravel packages by zkyg or browse all Laravel packages to compare alternatives.

Last updated August 15, 2026

spreadsheet-formula-excel

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

Comments