public function actionUploadGovernrate() { $model = new XlsxFile(); $filecsv = ''; if ($model->load(Yii::$app->request->post())) { $file = UploadedFile::getInstance($model, 'file'); $filename = 'Data.' . $file->extension; $upload = $file->saveAs('uploads/csv/' . $filename); define('CSV_PATH', 'uploads/csv/'); $inputFileName = CSV_PATH . $filename; try { $inputFileType = \PHPExcel_IOFactory::identify($inputFileName); $objReader = \PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($inputFileName); } catch (Exception $e) { die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage()); } // Get worksheet dimensions $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); //Delet old governrates $goverObj = new Govenment(); $goverObj->deleteAll(); // Loop through each row of the worksheet in turn for ($row = 1; $row <= $highestRow; $row++) { // Read a row of data into an array $fillData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE); if ($fillData[0][0] != "gov_code" and $fillData[0][0] != '') { // echo $fillData[0][0].'----'.$fillData[0][1]."<br/>"; $goverObj = new Govenment(); $goverObj->title = $goverObj->title_ar = $fillData[0][1]; $goverObj->country_code = isset($fillData[0][3]) ? $fillData[0][3] : 'EGY'; $goverObj->government_code = $fillData[0][0]; if (!$goverObj->save()) { //var_dump($goverObj->getErrors()); } } // foreach($fillData[0] as $k=>$v) // echo "Row: ".$row."- Col: ".($k+1)." = ".$v."<br />"; // echo $v."<br/>"; // $oCustomer= new Item(); // $oCustomer->title=$fillData[0][1]; // $oCustomer->save(); } unlink('uploads/csv/' . $filename); $this->flash('success', Yii::t('easyii/customers', 'Data Imported successfully')); return $this->redirect(['/admin/customers/items/1']); } else { return $this->render('uploadcsv', ['model' => $model, 'filecsv' => $filecsv]); } }