PHP Excel::load方法代码示例

 static function csvToRespondents($file, $project_id)
 {
     $respondents = Excel::load($file, function ($reader) {
         $reader->toArray();
     });
     $respondents = $respondents->parsed;
     $count = null;
     foreach ($respondents as $respondent) {
         $count++;
         $new = Respondent::create(['first_name' => $respondent->first_name, 'last_name' => $respondent->last_name, 'gender' => $respondent->gender, 'dob' => $respondent->dob, 'project_id' => $project_id]);
         if (isset($respondent->email) && $respondent->email != null) {
             $email = RespondentEmail::firstOrCreate(['project_id' => $project_id, 'address' => $respondent->email]);
             $email->type = $respondent->type;
             $email->save();
             $new->emails()->save($email);
         }
         if (isset($respondent->phone) && $respondent->phone != null) {
             $ph_num = Uploader::cleanPhoneNumber($respondent->phone);
             $phone = RespondentPhone::firstOrCreate(['project_id' => $project_id, 'number' => $ph_num]);
             $phone->type = $respondent->phone_type;
             $phone->save();
             $new->phones()->save($phone);
         }
         if (isset($respondent->email) && $respondent->email != null) {
             $address = RespondentAddress::firstOrCreate(['project_id' => $project_id, 'street_number' => $respondent->street_number, 'street_name' => $respondent->street_name, 'apt' => $respondent->apt, 'city' => $respondent->city, 'state' => $respondent->state, 'zip' => $respondent->zip, 'type' => $respondent->address_type]);
             $new->addresses()->save($address);
         }
     }
     return $count;
 }

 private function insertArticles($filename)
 {
     $i = 0;
     $filename = 'storage/app/' . $filename;
     Excel::load($filename, function ($reader) use($i) {
         $results = $reader->get();
         foreach ($results as $article) {
             $NoEstaEnLaBD = is_null(Article::where('product_code', $article['codigo'])->first());
             if ($NoEstaEnLaBD) {
                 // si el articulo _NO_ se encuentra en la base de datos
                 if (is_null($article['serializable'])) {
                     $serializable = 0;
                 } else {
                     $serializable = $article['serializable'];
                 }
                 $a = Article::create(['product_code' => $article['codigo'], 'unit' => $article['ub'], 'name' => $article['descripcion'], 'barcode' => $article['barcode'], 'fav' => $article['fav'], 'serializable' => $serializable, 'active' => $article['activo']]);
                 $i++;
             } else {
                 // si el codigo se encuentra en la base de datos
             }
         }
     });
     // Fin del Excel::load
     return $i;
 }

 /**
  * @param Request $request
  * @return View
  */
 public function postImportContacts(Request $request)
 {
     $start = microtime(true);
     $authenticated_user = $request->user();
     $creation_data = new CRUDResultData();
     $file = Input::file('imported_contacts');
     if (is_null($file)) {
         $extension = 'ERROR';
         $creation_data->extra_info .= 'No file uploaded. ';
     } else {
         $extension = $file->getClientOriginalExtension();
     }
     if ($extension == 'xls' or $extension == 'xlsx') {
         $php_excel = Excel::load($file->getPathname());
         $worksheet = $php_excel->setActiveSheetIndex(0)->toArray();
         $validation_data = $this->validateExcel($worksheet);
         if ($validation_data->success == false) {
             $creation_data = $validation_data;
         } else {
             $creation_data->success = true;
             $creation_data->extra_info = $validation_data->extra_info;
             $this->insertFromExcel($worksheet, $authenticated_user);
         }
     } elseif ($extension == 'csv' or $extension == 'tsv') {
     }
     $creation_data->extra_info .= 'Time to finish: ' . round((microtime(true) - $start) * 1000, 3) . ' ms. ';
     $creation_data->extra_info .= 'Uploaded by: ' . $authenticated_user->name . ' - ' . $authenticated_user->email . '. ';
     $this->logImportResult($creation_data, $authenticated_user);
     return View('contacts/import_contact')->with('creation_data', $creation_data);
 }

 public function excel(Request $request)
 {
     try {
         Log::info(Input::file('input_excel'));
         Excel::load($request->file('input_excel'), function ($reader) {
             $array = $reader->toArray();
             Log::info($array);
             $banqueId = $this->gestSession->addBanqueByExcel($array[0]);
             Log::info("IdBanque1 " . $banqueId);
             $i = 1;
             while ($i < sizeof($array)) {
                 Log::info($array);
                 $titreIdGItem = $this->gestSession->addTitreGItemByExcel($array[$i]);
                 Log::info("IdTitreGItem " . $titreIdGItem);
                 $i++;
                 while ($i < sizeof($array) && $array[$i]["label_item"] != null) {
                     $this->gestSession->addItemByExcel($array[$i], $banqueId, $titreIdGItem);
                     $i++;
                 }
             }
         });
         return Redirect::back();
     } catch (\Exception $e) {
         echo "Format Incorrect";
     }
 }

 public function importdata(Request $request)
 {
     $results = null;
     $type = $request->input('type');
     $retdate = Excel::load($request->file('exelimport'), function ($reader) use($type) {
         $results = $reader->get();
         $ret = $results->toArray();
         //            var_dump($ret);
         foreach ($ret as $index => $value) {
             $EMP_ID = $value["emp_id"];
             $PLAN_ID = $value["plan_id"];
             $EQUITY_RATE = $value["equity_rate"];
             $DEBT_RATE = $value["debt_rate"];
             $MODIFY_DATE = $value["modify_date"];
             $EFFECTIVE_DATE = $value["effective_date"];
             $MODIFY_COUNT = $value["modify_count"];
             $MODIFY_COUNT_TIMESTAMP = $value["modify_count_timestamp"];
             $MODIFY_BY = $value["modify_by"];
             $insert = "INSERT INTO TBL_USER_FUND_CHOOSE (PLAN_ID,EMP_ID,EQUITY_RATE,DEBT_RATE,MODIFY_DATE,EFFECTIVE_DATE,MODIFY_COUNT,MODIFY_COUNT_TIMESTAMP,MODIFY_BY) VALUES(" . $PLAN_ID . ",'" . $EMP_ID . "'," . $EQUITY_RATE . "," . $DEBT_RATE . ",'" . $MODIFY_DATE . "','" . $EFFECTIVE_DATE . "'," . $MODIFY_COUNT . ",'" . $MODIFY_COUNT_TIMESTAMP . "','" . $MODIFY_BY . "')";
             DB::insert(DB::raw($insert));
         }
         $staturet = true;
         $data = "ok";
     });
     return response()->json(array('success' => true, 'html' => $retdate));
 }

 public static function _loadXls($url)
 {
     $data = Excel::load($url, function ($reader) {
         return $reader->all();
     });
     return $data;
 }

 public function import()
 {
     Excel::load('public/books.csv', function ($reader) {
         foreach ($reader->get() as $book) {
             Renglon::create(['descrip_renglon' => $book->id_tipo_, 'id_marca' => $book->unidad_medida, 'id_modelo' => $book->cantidad, 'unidad_medida' => $book->unidad_medida, 'cantidad' => $book->cantidad, 'existencia_minima' => $book->existencia_minima, 'foto_producto' => $book->foto_producto, 'cod_usua' => $book->cod_usua]);
         }
     });
     return Renglon::all();
 }

 protected function loadFragments(string $path) : Collection
 {
     return Excel::load($path)->all()->flatMap(function (RowCollection $sheet) {
         return $sheet->reject(function (CellCollection $row) {
             return empty(trim($row->group));
         })->map(function (CellCollection $row) use($sheet) {
             return $row->put('hidden', $sheet->getTitle() === 'hidden')->toArray();
         });
     });
 }

 public function postCargarUsuarios(CargarUsuariosRequest $request)
 {
     $imagen = $request->file('imagen');
     $ruta = '/img/';
     $nombre = 'usuarios' . '.' . $imagen->guessExtension();
     $imagen->move(getcwd() . $ruta, $nombre);
     $result = Excel::load('public/img/usuarios.xlsx')->get();
     foreach ($result as $informe) {
         Usuario::create(['id' => $informe->id, 'nombre' => $informe->nombre, 'email' => $informe->email, 'password' => bcrypt($informe->password), 'tipo' => $informe->tipo]);
     }
     return redirect("/")->with('creada', 'Archivo subido');
 }

 public function importData(Request $request)
 {
     $file = $request->file('file');
     $name = time() . $file->getClientOriginalName();
     #$file->getClientOriginalName();
     $file->move('csv', $name);
     Excel::load('public/csv/' . $name, function ($reader) {
         $reader->each(function ($row) {
             Product::create($row->all());
         });
     });
     //message Done'
     #return redirect()->route('product.index');
 }

 public function importar()
 {
     Excel::load('Clientes.xlsx', function ($reader) {
         foreach ($reader->get() as $cliente) {
             \JLcourier\Entities\Cliente::create(['id' => $cliente->id, 'nombre' => $cliente->nombre, 'ruc' => $cliente->ruc, 'banco' => $cliente->banco]);
         }
     });
     Excel::load('Ordenes.xlsx', function ($reader) {
         foreach ($reader->get() as $orden) {
             \JLcourier\Entities\OrdenServicio::create(['id' => $orden->id, 'cliente_id' => $orden->cliente_id, 'fecha_inicio' => $orden->fecha_inicio, 'nro_orden' => $orden->nro_orden, 'tipo' => $orden->tipo, 'tiempo' => $orden->tiempo, 'estado' => $orden->estado]);
         }
     });
     return \JLcourier\Entities\Cliente::all();
 }

 public function import()
 {
     try {
         $file = Input::file('file');
         //$path = Input::file('pricelist')->getRealPath();
         $temp = null;
         Excel::load($file, function ($reader) use($temp) {
             //$reader->dump();
             // Loop through all rows
             $reader->each(function ($row) {
             });
         });
     } catch (Exception $e) {
         return 'Message: ' . $e->getMessage();
     }
     return redirect()->action('HomeController@index');
 }

 public function Checkdate(Request $request)
 {
     $results = null;
     $result = Excel::load($request->file('exelimport'))->get();
     $count = $result->count();
     //
     //      Excel::load($request->file('exelimport'), function ($reader) use($count) {
     //
     //            $results = $reader->get();
     //
     //            $ret = $results->toArray();
     //
     //
     //            $count = count($ret);
     //
     //
     //        });
     return response()->json(array('success' => true, 'html' => $count));
 }

 public static function parseFileImport(\Illuminate\Http\Request $r)
 {
     $result = array('items' => '', 'file' => '');
     $config = \Config::get('user_import');
     $generateName = uniqid() . '.' . $r->file('file')->getClientOriginalExtension();
     $result['file'] = pathinfo($generateName)['basename'];
     $r->file('file')->move($config['path_price'], $result['file']);
     //$delimiter
     $excel = Excel::load($config['path_price'] . $result['file'], function ($reader) {
         $reader->noHeading();
     });
     if ($excel->getTotalRowsOfFile() > 10) {
         $excel = $excel->take(3)->get()->toArray();
     } else {
         $excel = $excel->get()->toArray();
     }
     $result['items'] = UserImport::formaterDataFile($excel, $generateName);
     return $result;
 }

 public function import()
 {
     /************* Base ***********/
     Excel::load('data/base_stcs.csv', function ($reader) {
         foreach ($reader->get() as $employee) {
             Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 1]);
         }
     });
     Excel::load('data/base_sthcs.csv', function ($reader) {
         foreach ($reader->get() as $employee) {
             Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 2]);
         }
     });
     Excel::load('data/base_sitcs.csv', function ($reader) {
         foreach ($reader->get() as $employee) {
             Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 3]);
         }
     });
     return Employee::all();
 }