public function exportCMS() { $list = array_merge(Configure::read('MultiLanguage.fallback'), Configure::read('MultiLanguage.list')); App::uses('ExcelLib', 'Lib'); $excel = new ExcelLib(); $excel->init(); $data = array(); //save $mapping = array(); foreach (Configure::read('MultiLanguage.app_mapping_list') as $key => $val) { $mapping[$val] = strtoupper($key); } $header[] = 'Key'; foreach (array_keys($list) as $lang) { $header[] = $mapping[$lang]; } $data[] = $header; $languages = $this->getCMSLanguages(); foreach ($languages as $key => $language) { $row = array(); $row[] = $key; foreach ($language as $val) { $row[] = $val; } $data[] = $row; } $excel->writeFromArray($data); $excel->send2Browser(array('filename' => sprintf("cms-translation-%s.xls", date("Ymd", time())))); }
function export($id = 0) { $costingDb = $this->Costing->findById($id); $this->checkCanDo($costingDb); App::uses('ExcelLib', 'Lib'); $costingRecord = $this->Costing->getCostingRecord($costingDb); $data = $costingRecord['excelData']; $excel = new ExcelLib(); $excel->init(); $excel->writeFromArray($data); $excel->PHPExcel->getActiveSheet()->setTitle('Costing'); $excel->PHPExcel->setActiveSheetIndex(0); $excel->send2Browser(); die; }