function admin_import() { App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php')); $excelHandler = new PHPExcel_Handler("reader", "excel5"); $excelReader = $excelHandler->getProcesser(); $outputFileName = "d:/output.xls"; $excelObj = $excelReader->load($outputFileName); debug($excelObj->getActiveSheet()->toArray()); $this->render("admin_export"); }
function admin_import_data() { $this->layout = 'ajax'; if (!empty($this->data)) { // do validate $this->MailServer->set($this->data); if ($this->MailServer->validates()) { if (isset($this->data['MailServer']['file']['size']) && $this->data['MailServer']['file']['size'] > 0) { $importFileName = $this->Upload->upload('file', 'MailServer'); App::import("Vendor", "PHPExcel_Handler", array('file' => 'PHPExcel' . DS . 'Handler.php')); $excelHandler = new PHPExcel_Handler("reader", "excel5"); $excelReader = $excelHandler->getProcesser(); $excelObj = $excelReader->load($importFileName); $data = $excelObj->getActiveSheet()->toArray(); if (is_array($data) && count($data) > 1) { array_shift($data); foreach ($data as $key => $item) { $tmp = array('MailServer' => array('host' => $item[0], 'ssl' => $item[1], 'port' => $item[2], 'account' => $item[3], 'passwd' => $item[4])); unset($data[$key]); $data[$key] = $tmp; } $this->MailServer->saveAll($data); } unlink($importFileName); echo "done"; exit; } else { echo "done"; exit; } } } }