当前位置: 首页>>代码示例>>PHP>>正文


PHP Excel::selectSheetsByIndex方法代码示例

本文整理汇总了PHP中Maatwebsite\Excel\Facades\Excel::selectSheetsByIndex方法的典型用法代码示例。如果您正苦于以下问题:PHP Excel::selectSheetsByIndex方法的具体用法?PHP Excel::selectSheetsByIndex怎么用?PHP Excel::selectSheetsByIndex使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Maatwebsite\Excel\Facades\Excel的用法示例。


在下文中一共展示了Excel::selectSheetsByIndex方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: import

 public function import()
 {
     $path = 'C:/Filename.xls';
     Excel::selectSheetsByIndex(0)->load($path, function ($reader) {
         DB::table('members')->insert($reader->toArray());
     });
 }
开发者ID:beyondlex,项目名称:search,代码行数:7,代码来源:MemberController.php

示例2: proses_import

 public function proses_import(Request $request)
 {
     ini_set('max_execution_time', 300);
     $rules = ['excel' => 'required'];
     $pesan = ['excel.required' => 'File excel harus diisi'];
     $validasi = Validator::make($request->all(), $rules, $pesan);
     if ($validasi->fails()) {
         return Redirect::back()->withErrors($validasi)->withInput();
     }
     $excel = $request->file('excel');
     //ambil sheet pertama
     $excels = Excel::selectSheetsByIndex(0)->load($excel, function ($reader) {
         //options jika ada
     })->get();
     //digunakan untuk menghitung total siswa yang masuk
     $counter = 0;
     $rowRules = ['no_peserta' => 'required', 'nisn' => 'required', 'nama' => 'required', 'jk' => 'required', 'rombel' => 'required'];
     foreach ($excels as $row) {
         //membuat validasi untuk row di excel
         //jangan lupa mengubah $row menjadi array
         $validasi = Validator::make($row->toArray(), $rowRules);
         //skip baris ini jika tidak valid, langsung ke baris berikutnya
         if ($validasi->fails()) {
             continue;
         }
         $cek = Siswa::where('nis', $row['nisn'])->count();
         if ($cek > 0) {
             continue;
         }
         $pass = mt_rand() . '@';
         $data = array('nis' => $row['nisn'], 'nama' => $row['nama'], 'kd_kelas' => $row['rombel'], 'jk' => $row['jk'], 'tmp_lahir' => $row['tempat'], 'tgl_lahir' => $row['tanggal'], 'nik' => $row['nik'], 'agama' => $row['agama'], 'alamat' => $row['alamat'], 'rt' => $row['rt'], 'rw' => $row['rw'], 'dusun' => $row['dusun'], 'kelurahan' => $row['kelurahan'], 'kecamatan' => $row['kecamatan'], 'kode_pos' => $row['kode_pos'], 'no_skhun' => $row['skhun'], 'nm_ayah' => $row['ayah'], 'nm_ibu' => $row['ibu'], 'no_peserta' => $row['no_peserta'], 'password' => Hash::make($pass), 'password_asli' => $pass, 'status' => 0);
         DB::table('siswa')->insert($data);
         $counter++;
     }
     Session::flash('pesan', "Berhasil mengimport " . $counter . " siswa");
     return Redirect::to('admin/siswa');
 }
开发者ID:jamalapriadi,项目名称:uas-smagawi,代码行数:37,代码来源:SiswaController.php

示例3: import

 public function import(Request $request)
 {
     exit;
     $path = $request->input('path');
     set_time_limit(600);
     //        Excel::filter('chunk')->selectSheetsByIndex(0)->load($path)->noHeading()->chunk(1000, function($result){
     //            $data = $result->toArray();
     //            unset($data[0]);
     //            if ($data) {
     //                foreach ($data as $k=>$v) {
     //                    $in[] = array(
     //                        'user_name'=>$v[0],
     //                        'sno'=>$v[1],
     //                        'gender'=>$v[2],
     //                        'id_card'=>$v[3],
     //                        'birthday'=>$v[4],
     //                        'nation'=>$v[5],
     //                        'grade'=>$v[6],
     //                        'degree'=>$v[7],
     //                        'major'=>$v[8],
     //                        'phone'=>$v[9],
     //                        'learn_center'=>$v[10],
     //                        'roll_status'=>$v[11],
     //                        'account_status'=>$v[12],
     //                        'roll_filled'=>$v[13],
     //                        'graduation_filled'=>$v[14],
     //                        'degree_filled'=>$v[15],
     //                        'fee'=>$v[16],
     //                        'fee_ed'=>$v[17],
     //                        'fee_status'=>$v[18],
     //                        'teaching_way'=>$v[19],
     //                        'ordered'=>$v[20],
     //                    );
     ////                    $in[] = array(
     ////                        'user_name'=>$v[0],
     ////                        'sno'=>$v[1],
     ////                        'gender'=>$v[2],
     ////                        'id_card'=>$v[3],
     ////                        'class_name'=>$v[4],
     ////                        'grade'=>$v[5],
     ////                        'major'=>$v[6],
     ////                        'school'=>$v[7],
     ////                        'site'=>$v[8],
     ////                        'degree'=>$v[9],
     ////                        'course_name'=>$v[10],
     ////                        'note'=>$v[11],
     ////                        'ordered'=>$v[12],
     ////                    );
     //                }
     //                DB::table('t1')->insert($in);
     //            }
     //        });
     //        exit;
     Excel::selectSheetsByIndex(0)->load($path, function ($reader) {
         $data = $reader->noHeading()->toArray();
         unset($data[0]);
         if ($data) {
             foreach ($data as $k => $v) {
                 $in[] = array('user_name' => $v[0], 'sno' => $v[1], 'gender' => $v[2], 'id_card' => $v[3], 'birthday' => $v[4], 'nation' => $v[5], 'grade' => $v[6], 'degree' => $v[7], 'major' => $v[8], 'phone' => $v[9], 'learn_center' => $v[10], 'roll_status' => $v[11], 'account_status' => $v[12], 'roll_filled' => $v[13], 'graduation_filled' => $v[14], 'degree_filled' => $v[15], 'fee' => $v[16], 'fee_ed' => $v[17], 'fee_status' => $v[18], 'teaching_way' => $v[19], 'ordered' => $v[20]);
                 //                    $in[] = array(
                 //                        'user_name'=>$v[0],
                 //                        'sno'=>$v[1],
                 //                        'gender'=>$v[2],
                 //                        'id_card'=>$v[3],
                 //                        'class_name'=>$v[4],
                 //                        'grade'=>$v[5],
                 //                        'major'=>$v[6],
                 //                        'school'=>$v[7],
                 //                        'site'=>$v[8],
                 //                        'degree'=>$v[9],
                 //                        'course_name'=>$v[10],
                 //                        'note'=>$v[11],
                 //                        'ordered'=>$v[12],
                 //                    );
             }
             DB::table('t1')->insert($in);
         }
         //            DB::table('t2')->insert($reader->toArray());
     });
     exit;
     Excel::filter('chunk')->selectSheetsByIndex(0)->load($path)->chunk(500, function ($results) {
         //            DB::enableQueryLog();
         //            $results = $results->slice(1);
         foreach ($results->toArray() as $v) {
             print_r($v);
         }
         //            DB::table('t2')->insert($results->toArray());
         //            exit;
         //            foreach ($results as $k=>$v) {
         ////                $data = $v->toArray();//->values()
         //
         //                $in[] = array(
         //                    'user_name'=>$v[0],
         //                    'sno'=>$v[1],
         //                    'gender'=>$v[2],
         //                    'id_card'=>$v[3],
         //                    'class_name'=>$v[4],
         //                    'grade'=>$v[5],
         //                    'major'=>$v[6],
         //                    'school'=>$v[7],
//.........这里部分代码省略.........
开发者ID:beyondlex,项目名称:search,代码行数:101,代码来源:FileUploadController.php

示例4: injectInsertAndUpdateData

 protected function injectInsertAndUpdateData()
 {
     return Excel::selectSheetsByIndex(0)->filter('chunk')->load($this->callback->getData()['realpath'])->skip(HoneyBaby::SKIP_LARAVEL_EXCEL_CHUNK_BUG_INDEX)->chunk(HoneyBaby::CHUNK_SIZE, $this->getChunkProcess());
 }
开发者ID:jocoonopa,项目名称:lubri,代码行数:4,代码来源:HoneyBabyController.php

示例5: postUpload

 public function postUpload(Request $request)
 {
     //return dd($request->all());
     if (!$request->hasFile('file') || !$request->file('file')->isValid()) {
         return redirect('/remittance/philhealth')->withErrors('File is corrupted! Try again.');
     }
     if (strtolower($request->file->getClientOriginalExtension()) !== 'xls') {
         return redirect('/remittance/philhealth')->withErrors('Invalid file extension! Use .xls file extension.');
     }
     $filename = $request->file->getClientOriginalName();
     $destinationPath = public_path('uploads' . DS . 'remittance');
     $request->file->move($destinationPath, $filename);
     $file = $destinationPath . DS . $filename;
     try {
         $e = Excel::selectSheetsByIndex(0)->load($file);
     } catch (\Exception $e) {
         return redirect('/remittance/philhealth')->withErrors('Something went wrong! ' . $e->getMessage());
     }
     try {
         $company = $this->company->find($request->input('company_id'));
     } catch (\Exception $e) {
         return redirect('/remittance/philhealth')->withErrors('Invalid company!');
     }
     if (is_null($company)) {
         return redirect('/remittance/philhealth')->withErrors('Company not found!');
     }
     $fields = ['phealth_no', 'bracket', 'e_status', 'date_hired', 'birthday'];
     $rs = $e->select($fields)->get();
     $data = [];
     $data[0] = ['MEM_PHIC_NO', 'MO_SAL', 'EE_STAT', 'EFF_DATE', 'DATE_OF_BIRTH'];
     foreach ($rs as $key => $row) {
         $idx = $key + 1;
         foreach ($fields as $key => $value) {
             switch ($value) {
                 case 'e_status':
                     if ($row->{$value} == 'NH') {
                         $data[$idx][$key] = 'NH';
                         $data[$idx][$key + 1] = $row->date_hired->format('Y-m-d');
                     } else {
                         $data[$idx][$key] = 'A';
                         $data[$idx][$key + 1] = null;
                     }
                     break;
                 case 'date_hired':
                     break;
                 default:
                     $data[$idx][$key] = $row->{$value};
                     break;
             }
         }
     }
     $month = Carbon::parse($request->input('date'))->endOfMonth();
     $fname = 'PLH-' . strtoupper($company->code) . '-' . $month->format('Ym');
     try {
         Excel::create($fname, function ($excel) use($fname, $data) {
             $excel->sheet($fname, function ($sheet) use($data) {
                 $sheet->fromArray($data);
             });
         })->store('csv', public_path('downloads' . DS . 'remittance'));
     } catch (\Exception $e) {
         return redirect('/remittance/philhealth')->withErrors('Something went wrong! ' . $e->getMessage());
     }
     $companies = $this->company->all(['code', 'descriptor', 'id']);
     $dl = public_path('downloads' . DS . 'remittance') . DS . $fname . '.csv';
     if (File::exists($dl)) {
         return redirect('remittance/philhealth')->with('companies', $companies)->with('dl', $fname . '.csv');
     } else {
         return redirect('remittance/philhealth')->with('companies', $companies)->withErrors('Something went wrong!');
     }
 }
开发者ID:jrsalunga,项目名称:gi-cashier,代码行数:70,代码来源:RemittanceController.php


注:本文中的Maatwebsite\Excel\Facades\Excel::selectSheetsByIndex方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。