问如何在YI1.16中将excel数据导入mySQL

EN

public function actionYourActionName(){
   if (isset($_FILES['csv_file']) && !empty($_FILES['csv_file'])) {
    $csv = array();
    $file = fopen($_FILES['csv_file']['tmp_name'], 'r');
    while (($line = fgetcsv($file)) !== FALSE) {
       //$line is an array of the csv elements
        $csv[] = $line;
    }
    fclose($file);
    for ($i = 1; $i < count($csv); $i++) {
       $model = new YourmodelName();
      foreach ($csv[0] as $key => $value) {
         $model->$value = $csv[$i][$key];
     }
        if($model->save()){
          //do here what you want to do after saving model
       }else{return $model->getErrors();}
    }
}
}else{
    $this->render('your view name');
}

echo CHtml::form('', 'post', array('id' => "verticalForm", 'class' => 'well form-vertical', 'enctype' => 'multipart/form-data'));
echo CHtml::fileField('csv_file[]', '', array('id' => 'csv_file', 'multiple' => 'multiple'));
echo '<p class="help-block">Please upload .csv files only.</p>';
echo CHtml::submitButton('Submit', array('class' => 'btn btn-primary'));
echo CHtml::endForm();