how to make multisheet?

[amin007]

i have try https://github.com/vernes/PHPReport/wiki/Examples-with-templates this ok, but how i can make multisheet in excel template?

how i can manage array with one in multisheet...

[vernes]

Currently you can't create multisheet documents. But that option is on todo list.

[yanhuixie]

Thanks for your excellent job, vernes! As my expediency, simply make little change in "render" method as following. Please pay attention, this is only for "_usingTemplate" situation.

//create or generate report if ($this->_usingTemplate) { $sheets = $this->objPHPExcel->getAllSheets(); if(count($sheets) > 1){ foreach ($sheets as $sheet){ $this->objWorksheet = $sheet; $this->generateReport(); } } else{ $this->generateReport(); } } else { $this->createReport(); }

To reducing the unnecessary loops, I also add a parameter named "forSheet" to determine the current sheet. public function generateReport() { $this->_lastColumn=$this->objWorksheet->getHighestColumn();//TODO: better detection $this->_lastRow=$this->objWorksheet->getHighestRow(); foreach($this->_data as $data) { $forSheet = isset($data['forSheet']) ? $data['forSheet'] : null; $title = $this->objWorksheet->getTitle(); if(!empty($forSheet) && $forSheet != $title){ continue; } ... } ... }