Ejemplos de Svrnm\ExcelDataTables\ExcelDataTable en PHP

Ejemplo n.º 1

Archivo: example.php Proyecto: svrnm/exceldatatables

<?php

require_once '../../vendor/autoload.php';
$dataTable = new Svrnm\ExcelDataTables\ExcelDataTable();
$in = 'spec.xlsx';
$out = 'test.xlsx';
$data = array(array("Date" => new \DateTime('2014-01-01 13:00:00'), "Value 1" => 0, "Value 2" => 1), array("Date" => new \DateTime('2014-01-02 14:00:00'), "Value 1" => 1, "Value 2" => 0), array("Date" => new \DateTime('2014-01-03 15:00:00'), "Value 1" => 2, "Value 2" => -1), array("Date" => new \DateTime('2014-01-04 16:00:00'), "Value 1" => 3, "Value 2" => -2), array("Date" => new \DateTime('2014-01-05 17:00:00'), "Value 1" => 4, "Value 2" => -3), array("Date" => new \DateTime('2014-01-03 15:00:00'), "Value 1" => 30, "Value 2" => -1), array("Date" => new \DateTime('2014-01-04 16:00:00'), "Value 1" => 3, "Value 2" => -2), array("Date" => new \DateTime('2014-01-05 17:00:00'), "Value 1" => 4, "Value 2" => -3));
$dataTable->showHeaders()->preserveFormulas('Data')->addRows($data)->refreshTableRange('Data')->attachToFile($in, $out, false);

Ejemplo n.º 2

Archivo: performance.php Proyecto: svrnm/exceldatatables

        for ($j = 0; $j < $cols; $j++) {
            switch ($j % 3) {
                case 0:
                    $row[] = $i;
                    break;
                case 1:
                    $row[] = '(' . $i . ',' . $j . ')';
                    break;
                case 2:
                    $row[] = new DateTime('2014-01-01');
                    break;
            }
        }
        $data[] = $row;
    }
    $start = microtime(true);
    $dataTable = new Svrnm\ExcelDataTables\ExcelDataTable();
    $dataTable->showHeaders();
    $dataTable->addRows($data);
    $time0 = microtime(true) - $start;
    $dataTable->attachToFile($in, $out);
    $time1 = microtime(true) - $start;
    $lastPeak = memory_get_peak_usage();
    echo $rows . ' x ' . $cols . ":\t";
    echo $time0 . " s\t";
    echo $time1 . " s\t";
    echo floor($rows / $time1) . " rows/s\t";
    echo floor($rows * $cols / $time1) . " entries/s\t";
    echo $lastPeak / (1024 * 1024) . ' MB' . PHP_EOL;
    $rows *= 2;
}

Ejemplo n.º 3

Archivo: example.php Proyecto: svrnm/exceldatatables

<?php

require_once '../vendor/autoload.php';
$dataTable = new Svrnm\ExcelDataTables\ExcelDataTable();
$in = 'spec.xlsx';
$out = 'test.xlsx';
$data = array(array("Date" => new \DateTime('2014-01-01 13:00:00'), "Value 1" => 0, "Value 2" => 1), array("Date" => new \DateTime('2014-01-02 14:00:00'), "Value 1" => 1, "Value 2" => 0), array("Date" => new \DateTime('2014-01-03 15:00:00'), "Value 1" => 2, "Value 2" => -1), array("Date" => new \DateTime('2014-01-04 16:00:00'), "Value 1" => 3, "Value 2" => -2), array("Date" => new \DateTime('2014-01-05 17:00:00'), "Value 1" => 4, "Value 2" => -3));
$dataTable->showHeaders()->addRows($data)->attachToFile($in, $out, false);

Ejemplo n.º 4

Archivo: performance.php Proyecto: svrnm/exceldatatables

            switch ($j % 3) {
                case 0:
                    $row[] = $i;
                    break;
                case 1:
                    $row[] = '(' . $i . ',' . $j . ')';
                    break;
                case 2:
                    $row[] = new DateTime('2014-01-01');
                    break;
            }
        }
        $data[] = $row;
    }
    $start = microtime(true);
    $dataTable = new Svrnm\ExcelDataTables\ExcelDataTable();
    $dataTable->showHeaders();
    $dataTable->preserveFormulas('Data');
    $dataTable->addRows($data);
    $time0 = microtime(true) - $start;
    $dataTable->attachToFile($in, $out);
    $time1 = microtime(true) - $start;
    $lastPeak = memory_get_peak_usage();
    echo $rows . ' x ' . $cols . ":\t";
    echo $time0 . " s\t";
    echo $time1 . " s\t";
    echo floor($rows / $time1) . " rows/s\t";
    echo floor($rows * $cols / $time1) . " entries/s\t";
    echo $lastPeak / (1024 * 1024) . ' MB' . PHP_EOL;
    $rows *= 2;
}