PHP ParserHandler示例

编程语言: PHP

类/类型: ParserHandler

hotexamples.com的示例: 2

PHP ParserHandler - 已找到2个示例。这些是从开源项目中提取的最受好评的ParserHandler现实PHP示例。您可以评价示例，以帮助我们提高示例质量。

常用方法

显示隐藏

initJson(1)

initSimpleJson(1)

initXml(1)

示例#1

显示文件

文件： calc.php 项目： Grprashanthkumar/ColfusionWeb

<?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));
    }
}

示例#2

显示文件

文件： test.php 项目： Grprashanthkumar/ColfusionWeb

<?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);