function admin_export() { $this->MailCustomer->recursive = 0; $raw_data = $this->paginate(); App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php')); $excelHandler = new PHPExcel_Handler("writer", "excel5"); $objActSheet = $excelHandler->getExcel()->getActiveSheet(); //-- set current sheet name -- $objActSheet->setTitle(date("Y-m-d")); //-- set contents $data = array(); $title_data = array(__("Nickname", true), __("Categories", true), __("Gender", true), __("Email", true), __("Tel", true)); array_push($data, $title_data); foreach ($raw_data as $row) { $item = array($row['MailCustomer']['nickname'], $row['MailCustomer']['mail_customer_category_id'], $row['MailCustomer']['gender'], $row['MailCustomer']['email'], $row['MailCustomer']['tel']); array_push($data, $item); } $objActSheet->fromArray($data); $outputFileName = "mail_customers_list.xls"; $excelHandler->saveOutput($outputFileName); }
function admin_export() { $this->MailServer->recursive = 0; $raw_data = $this->paginate(); App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php')); $excelHandler = new PHPExcel_Handler("writer", "excel5"); $objActSheet = $excelHandler->getExcel()->getActiveSheet(); //-- set current sheet name -- $objActSheet->setTitle(date("Y-m-d")); //-- set contents $data = array(); $title_data = array(__("Host", true), __("Ssl", true), __("Port", true), __("Account", true), __("Passwd", true)); array_push($data, $title_data); foreach ($raw_data as $row) { $item = array($row['MailServer']['host'], $row['MailServer']['ssl'], $row['MailServer']['port'], $row['MailServer']['account'], $row['MailServer']['passwd']); array_push($data, $item); } $objActSheet->fromArray($data); $outputFileName = "mail_servers_list.xls"; $excelHandler->saveOutput($outputFileName); }
function admin_export() { $this->Financy->recursive = 0; $raw_data = $this->paginate(); App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php')); $excelHandler = new PHPExcel_Handler("writer", "excel5"); $objActSheet = $excelHandler->getExcel()->getActiveSheet(); //设置当前活动sheet的名称 $objActSheet->setTitle(date("Y-m-d")); //-- set contents $data = array(); $title_data = array(__("Categories", true), __("Create Date", true), __("Debit", true), __("Money", true), __("Memo", true)); array_push($data, $title_data); Configure::load("common"); $debit_options = Configure::read('debit_options'); foreach ($raw_data as $row) { $item = array($row['FinanceCategory']['category_name'], $row['Financy']['create_date'], $debit_options[$row['Financy']['debit']], $row['Financy']['money'], $row['Financy']['memo']); array_push($data, $item); } $objActSheet->fromArray($data); $outputFileName = "output.xls"; $excelHandler->saveOutput($outputFileName); }