<?php
// Example of exporting a large amount of data to a file. On my
// computer it takes 43 seconds to write out 83MB of data, but
// only uses 750kb of memory.
require "../php-export-data.class.php";
function genRandomString($length = 100) {
$characters = "0123456789abcdefghijklmnopqrstuvwxyz _";
$string = "";
for ($p = 0; $p < $length; $p++) {
$string .= $characters[mt_rand(0, strlen($characters)-1)];
}
return $string;
}
$excel = new ExportDataExcel('file');
$excel->filename = "test_big_excel.xls";
$excel->initialize();
for($i = 1; $i<100000; $i++) {
$row = array($i, genRandomString(), genRandomString(), genRandomString(), genRandomString(), genRandomString());
$excel->addRow($row);
}
$excel->finalize();
print "memory used: " . number_format(memory_get_peak_usage());
|
Download
