php-export-data
php-export-data copied to clipboard
Multiple sheets and formula support added
Example of use:
$excel = new ExportDataExcel('browser'); $excel->filename = "test.xls";
$excel->title = "Foglio 1";
$data = array( array(1,2,3,"=SUM(R[0]C[-3]:R[0]C[-1])"), array("asdf","jkl","semi"), array("1273623874628374634876","=asdf","10-10"), array("2010-01-02 10:00AM","1/1/11","10-10"), array("1234","12.34","-123."), array("-12345678901234567890","0.0000000000123456789","-"), );
$excel->initialize(); foreach($data as $row) { $excel->addRow($row); }
$excel->addSheet("Foglio 2"); foreach($data as $row) { $excel->addRow($row); }
$excel->finalize();