php-export-data icon indicating copy to clipboard operation
php-export-data copied to clipboard

Multiple sheets and formula support added

Open walkstudio opened this issue 8 years ago • 0 comments

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

walkstudio avatar Jul 06 '17 12:07 walkstudio