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