<?php
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
include_once '../parser/formula/formula.php';
include_once 'handler.php';
include_once 'formulas.php';
if (empty($_REQUEST['ss'])) {
echo "Spreadsheet needed";
exit;
}
$spreadsheets = json_decode($_REQUEST['ss']);
$formulas = new formulas();
$handler = ParserHandler::initSimpleJson($spreadsheets, $formulas);
$handler->calc();
if (isset($_REQUEST['c'])) {
$cell = $_REQUEST['c'];
$sheet = isset($_REQUEST['s']) ? $_REQUEST['s'] : 0;
$handler->setSheet($sheet);
echo json_encode($handler->cellValue($cell));
} else {
if (isset($_REQUEST['cr'])) {
$cells = explode(':', $_REQUEST['cr']);
$sheet = isset($_REQUEST['s']) ? $_REQUEST['s'] : 0;
$handler->setSheet($sheet);
echo json_encode($handler->cellRangeValue($cells[0], $cells[1]));
} else {
echo json_encode($handler->toArray(isset($_REQUEST['s']) ? $_REQUEST['s'] : null));
}
}
<?php
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
include_once 'handler.php';
include_once 'formulas.php';
$spreadsheets = array(array(array("=AVG(B1 * 100 / 100)", 2), array("=(2^8 * A1) / B1 * B2", "=A1"), array("=B3", "This is B3"), array("=INPUT('tax')", "=OUTPUT('taxes', INPUT('tax'))"), array("=A1", "=A2", "=A3"), array("=AVG(1,2,3,4,5,6,7)", "")), array(array("=SHEET1!A1")));
$formulas = new formulas();
$handler = ParserHandler::initSimpleJson($spreadsheets, $formulas);
$formulas->inputs['tax'] = 'Injected value';
$handler->calc();
print_r(json_encode($spreadsheets) . "\n");
print_r(json_encode($handler->toArray()) . "\n");
print_r($spreadsheets[0]);
print_r($handler->toArray());
print_r($formulas->outputs);
$handlerJson = ParserHandler::initJson(json_decode('[{"title":"simple table 1","rows":[{"height":"18px","columns":[{"formula":"100","value":100,"class":"styleBold styleCenter"},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]}],"metadata":{"widths":["120px","120px","120px","120px","120px","120px"]}},{"title":"simple table 2","rows":[{"height":"18px","columns":[{"formula":"SHEET1!A1 + 100","value":200,"class":"styleBold styleCenter"},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]},{"height":"18px","columns":[{},{},{},{},{},{}]}],"metadata":{"widths":["120px","120px","120px","120px","120px","120px"]}}]'), $formulas);
$handlerJson->calc();
print_r($handlerJson->spreadsheets);
$xml = simplexml_load_string('<spreadsheets><spreadsheet title="simple table 1"><rows><row height="18px"><columns><column><formula>100</formula><value>100</value><class>styleBold styleCenter</class></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row></rows><metadata><widths><width>120px</width><width>120px</width><width>120px</width><width>120px</width><width>120px</width><width>120px</width></widths></metadata></spreadsheet><spreadsheet title="simple table 2"><rows><row height="18px"><columns><column><formula>SHEET1!A1 + 100</formula><value>200</value><class>styleBold styleCenter</class></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row><row height="18px"><columns><column></column><column></column><column></column><column></column><column></column><column></column></columns></row></rows><metadata><widths><width>120px</width><width>120px</width><width>120px</width><width>120px</width><width>120px</width><width>120px</width></widths></metadata></spreadsheet></spreadsheets>');
$handlerXml = ParserHandler::initXml($xml, $formulas);
$handlerXml->calc();
print_r($handlerXml->spreadsheets);
