public function actionCreate()
{

        $database = 'karyawan'; //nama database
        $user = 'user'; //nama user db
        $pass = 'passwordnya'; //pass db
        $host = 'localhost'; 

        $conn = mysqli_connect($host,$user,$pass,$database); 


        if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
        exit();
        }

        include"PHPExcel.php";

        $random = "file_upload_".date('Y-m-d-H-i-s').rand(11111,99999);
        $target_file = Yii::app()->basePath.'/../upload/'.$random.basename($_FILES["file_excel"]["name"]);
        $uploadOk = 1;

        if (move_uploaded_file($_FILES["file_excel"]["tmp_name"], $target_file)) {

            ini_set('memory_limit', '-1');
            $objReader = PHPExcel_IOFactory::createReader('Excel2007');

            $inputFileType = 'Excel2007';
            $sheetIndex = 0;
            $inputFileName = $target_file;

            $objReader = PHPExcel_IOFactory::createReader($inputFileType);
            $sheetnames = $objReader->listWorksheetNames($inputFileName);
            $objReader->setLoadSheetsOnly($sheetnames[$sheetIndex]);

                    try {
                        $objPHPExcel = $objReader->load($inputFileName);
                        } catch(Exception $e) {
                        die('Error loading file :' . $e->getMessage());
                        }

            $worksheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
            $numRows = count($worksheet);

            //baca untuk setiap baris excel
            $no = 1 ;
                for ($i=2; $i <= $numRows ; $i++) {


                    $worksheet[$i]['E'] = str_replace("'"," ",$worksheet[$i]['E']);
                    $worksheet[$i]['A'] = str_replace("'"," ",$worksheet[$i]['A']);
                    $worksheet[$i]['F'] = str_replace("'"," ",$worksheet[$i]['F']);
                    $worksheet[$i]['B'] = str_replace("'"," ",$worksheet[$i]['B']);
                    $worksheet[$i]['Y'] = str_replace("'"," ",$worksheet[$i]['Y']);
                    $worksheet[$i]['T'] = str_replace("'"," ",$worksheet[$i]['T']);
                    $worksheet[$i]['V'] = str_replace("'"," ",$worksheet[$i]['V']);
                    $worksheet[$i]['H'] = str_replace("'"," ",$worksheet[$i]['H']);

                    $worksheet[$i]['E'] = strtoupper($worksheet[$i]['E']);
                    $worksheet[$i]['A'] = strtoupper($worksheet[$i]['A']);

                        if ($worksheet[$i]['E'] != '') {
     
                            $sql = "INSERT INTO tabel (kolom1,kolom2,kolom3,kolom4,kolom5,kolom6,kolom7,kolom8,kolom9)
                            VALUES ('".$worksheet[$i]['E']."','".$worksheet[$i]['A']."','".$worksheet[$i]['F']."','".$worksheet[$i]['B']."','".$worksheet[$i]['Y']."','".$worksheet[$i]['T']."','".$worksheet[$i]['T']."','".$worksheet[$i]['V']."','".$worksheet[$i]['H']."')";

                            if (mysqli_query($conn, $sql)) {
                                $pesan= "Sukses Simpan Data!";
                                } else {
                                Yii::app()->user->setFlash('sukses', 'File Gagal Diupload ');
                                $this->redirect(array('master/index'));
                                }

                        }

                    $no++;

                }

            Yii::app()->user->setFlash('sukses', 'Input Data Siswa Berhasil ');
            $this->redirect(array('master/index'));
            } else {
            Yii::app()->user->setFlash('sukses', 'File Gagal Diupload ');
            $this->redirect(array('master/upload'));
        }
}