/** * Show the form for creating a new resource. * * @return Response */ public function importDosen() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/dosen')->with('msge', 'Input tidak boleh kosong!'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); #validation data $rules = array('nik' => 'required', 'nama_dosen' => 'required', 'field_studi' => 'required', 'alumni' => 'required', 'status_dosen' => 'required', 'alamat_email' => 'required'); $counter = 0; foreach ($excels as $key => $excel) { $validator = Validator::make($excel->toArray(), $rules); $cekada = Dosen::find($excel->nik); if ($cekada) { continue; } if ($validator->fails()) { continue; } $dosens = array('nik' => $excel->nik, 'nama_dosen' => $excel->nama_dosen, 'field_studi' => $excel->field_studi, 'alumni' => $excel->alumni, 'status_dosen' => $excel->status_dosen, 'alamat_email' => $excel->alamat_email); $tambah = Dosen::create($dosens); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/dosen')->with('msgs', ' <b>' . $counter . '</b> Data dosen berhasil di import!'); } else { return Redirect::to('administrator/dosen')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku!'); } } }
/** * Read and extract records from file * * @param $file * @return array */ protected function extractRecords($file) { return $this->excel->load($file)->all()->toArray(); }
/** * Bind Excel class * @return void */ protected function bindExcel() { // Bind the Excel class and inject its dependencies $this->app['excel'] = $this->app->share(function ($app) { $excel = new Excel($app['phpexcel'], $app['excel.reader'], $app['excel.writer'], $app['excel.parsers.view']); $excel->registerFilters($app['config']->get('excel.filters', array())); return $excel; }); }
/** * Generate CSV with headers form an array * @param $filename * @param array $data * @param array $headers */ public function generateWithHeaders($filename, array $data, array $headers) { return $this->generator->create($filename, function ($excel) use($data, $headers) { $excel->sheet('aidStream', function ($sheet) use($data, $headers) { $sheet->fromArray($data, '', '', '', $headers); }); })->export($this->defaultOutputFormat); }
/** * Execute the job. * @param Excel $excel */ public function handle(Excel $excel) { $excel->create($this->product->code, function ($excel) { $excel->sheet($this->product->code, function ($sheet) { $codes = $this->codes or $this->product->codes()->get(['code']); $sheet->fromArray($codes); }); })->download('xlsx'); }
/** * Show the form for creating a new resource. * * @return Response */ public function importMahasiswa() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/mahasiswa')->with('msge', 'Input tidak boleh kosong.'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); #validation data $rules = array('nim' => 'required', 'nama_mahasiswa' => 'required', 'tempat_lahir' => 'required', 'tanggal_lahir' => 'required', 'alamat' => 'required', 'telepon' => 'required', 'jenis_kelamin' => 'required', 'agama' => 'required', 'angkatan' => 'required', 'kode_prodi' => ' required'); $counter = 0; foreach ($excels as $key => $excel) { $validation = Validator::make($excel->toArray(), $rules); $cekada = Mahasiswa::find($excel->nim); if ($cekada) { continue; } if ($validation->fails()) { continue; } $mahasiswa = array('nim' => $excel->nim, 'nama_mahasiswa' => $excel->nama_mahasiswa, 'tempat_lahir' => $excel->tempat_lahir, 'tanggal_lahir' => $excel->tanggal_lahir, 'alamat' => $excel->alamat, 'telepon' => $excel->telepon, 'jenis_kelamin' => $excel->jenis_kelamin, 'agama' => $excel->agama, 'angkatan' => $excel->angkatan, 'kode_prodi' => $excel->kode_prodi); $tambah = Mahasiswa::create($mahasiswa); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/mahasiswa')->with('msgs', '<b>' . $counter . '</b> Data mahasiswa berhasil diimport.'); } else { return Redirect::to('administrator/mahasiswa')->with('msge', 'Tidak ada data yang di import.'); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function importMatakuliah() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/matakuliah')->with('msge', 'Input tidak boleh kosong!'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); $rules = array('kode_matakuliah' => 'required', 'kode_prodi' => 'required', 'nama_matakuliah' => 'required', 'sks_teori' => 'required', 'sks_praktek' => 'required', 'sks_praktikum' => 'required'); $counter = 0; foreach ($excels as $key => $excel) { $validator = Validator::make($excel->toArray(), $rules); $cekada = Matakuliah::find($excel->kode_matakuliah); if ($cekada) { continue; } if ($validator->fails()) { continue; } $matakuliah = array('kode_matakuliah' => $excel->kode_matakuliah, 'kode_prodi' => $excel->kode_prodi, 'nama_matakuliah' => $excel->nama_matakuliah, 'sks_teori' => $excel->sks_teori, 'sks_praktek' => $excel->sks_praktek, 'sks_praktikum' => $excel->sks_praktikum); $tambah = Matakuliah::create($matakuliah); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/matakuliah')->with('msgs', '<b>' . $counter . '</b> Data matakuliah berhasil diimport !'); } else { return Redirect::to('administrator/matakuliah')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku'); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function importKrs() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/krs')->with('msge', 'Inputan tidak boleh kosong.'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); #validasi data $rules = array('nim' => 'required', 'semester' => 'required', 'kode_matakuliah' => 'required', 'status_krs' => 'required'); $counter = 0; foreach ($excels as $key => $excel) { $Validator = Validator::make($excel->toArray(), $rules); $cekada = Krs::find($excel->id_krs); if ($cekada) { continue; } if ($Validator->fails()) { continue; } $krs = array('nim' => $excel->nim, 'semester' => $excel->semester, 'kode_matakuliah' => $excel->kode_matakuliah, 'status_krs' => $excel->status_krs); $tambah = Krs::create($krs); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/krs')->with('msgs', 'Berhasil import <b>' . $counter . '</b> data krs'); } else { return Redirect::to('administrator/krs')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku'); } } }
/** * Export to Excel data sheet * * @return \Maatwebsite\Excel\Excel * */ public function excel(Excel $xls) { $carbon = Carbon::now(); // $doc = $excel->create('Bookings-Excel-Sheet'.$carbon , function($excel){ // $excel->sheet('Bookings-excel-sheet' , function($sheet){ // // $bookings = BookingsModel::all(); // $sheet->loadView('admin/bookings/partials/bookings-part',['bookings' => $bookings ]); // }); // }); $doc = $xls->create('Bookings-Excel' . $carbon, function ($excel) { $excel->sheet('booking', function ($sheet) { $bookings = BookingsModel::all(); $sheet->loadView('admin.bookings.partials.bookings-part', ['bookings' => $bookings]); }); })->download(); return $doc; }
/** * Start the Batach * @param Excel $excel * @param array $files * @param Closure $callback * @return Excel */ public function start(Excel $excel, $files, Closure $callback) { // Set excel object $this->excel = $excel; // Set files $this->_setFiles($files); // Do the callback if ($callback instanceof Closure) { foreach ($this->getFiles() as $file) { // Load the file $excel = $this->excel->load($file); // Do a callback with the loaded file call_user_func($callback, $excel, $file); } } // Return our excel object return $this->excel; }
public function import(Excel $excel, ImportRequest $request) { $file = $request->file('excel'); //Input::file('excel'); //dd($file); if (!$file) { Flash('Seleccione un archivo!!'); return Redirect()->route('clients'); } $excel->load($file, function ($reader) { foreach ($reader->get() as $client) { // para evitar en los campos que no se permiten null poner en blanco $data = array_map(function ($v) { return is_null($v) ? "" : $v; }, $client->toArray()); /* $data = [ 'name' => $client->title, 'author' =>$client->author, 'year' =>$client->publication_year ];*/ $this->clientRepo->store($data); } }); //return Book::all(); Flash('Imported !!'); return Redirect()->route('clients'); }
public function parse(Request $request) { $file = $request->file('file'); return $this->excel->load($file)->get(); }
/** * Echo in a jqGrid compatible format the data requested by a grid. * * @param RepositoryInterface $dataRepository * An implementation of the RepositoryInterface * @param array $postedData * All jqGrid posted data * @return string * String of a jqGrid compatible data format: xml, json, jsonp, array, xmlstring, jsonstring. */ public function encodeRequestedData(RepositoryInterface $Repository, $postedData) { // $page = $postedData['page']; // get the requested page // $limit = $postedData['rows']; // get how many rows we want to have into the grid // $sidx = $postedData['sidx']; // get index row - i.e. user click to sort // $sord = $postedData['sord']; // get the direction if (isset($postedData['page'])) { $page = $postedData['page']; // get the requested page } else { $page = 1; } if (isset($postedData['rows'])) { $limit = $postedData['rows']; // get how many rows we want to have into the grid } else { $limit = null; } if (isset($postedData['sidx'])) { $sidx = $postedData['sidx']; // get index row - i.e. user click to sort } else { $sidx = null; } if (isset($postedData['sord'])) { $sord = $postedData['sord']; // get the direction } if (isset($postedData['filters']) && !empty($postedData['filters'])) { $filters = json_decode(str_replace('\'', '"', $postedData['filters']), true); } if (!$sidx || empty($sidx)) { $sidx = null; $sord = null; } if (isset($filters['rules']) && is_array($filters['rules'])) { foreach ($filters['rules'] as &$filter) { switch ($filter['op']) { case 'eq': //equal $filter['op'] = '='; break; case 'ne': //not equal $filter['op'] = '!='; break; case 'lt': //less $filter['op'] = '<'; break; case 'le': //less or equal $filter['op'] = '<='; break; case 'gt': //greater $filter['op'] = '>'; break; case 'ge': //greater or equal $filter['op'] = '>='; break; case 'bw': //begins with $filter['op'] = 'like'; $filter['data'] = $filter['data'] . '%'; break; case 'bn': //does not begin with $filter['op'] = 'not like'; $filter['data'] = $filter['data'] . '%'; break; case 'in': //is in $filter['op'] = 'is in'; break; case 'ni': //is not in $filter['op'] = 'is not in'; break; case 'ew': //ends with $filter['op'] = 'like'; $filter['data'] = '%' . $filter['data']; break; case 'en': //does not end with $filter['op'] = 'not like'; $filter['data'] = '%' . $filter['data']; break; case 'cn': //contains $filter['op'] = 'like'; $filter['data'] = '%' . $filter['data'] . '%'; break; case 'nc': //does not contains $filter['op'] = 'not like'; $filter['data'] = '%' . $filter['data'] . '%'; break; } } } else { $filters['rules'] = array(); } $count = $Repository->getTotalNumberOfRows($filters['rules']); if (empty($limit)) { $limit = $count; } if (!is_int($count)) { throw new Exception('The method getTotalNumberOfRows must return an integer'); } if ($count > 0) { $totalPages = ceil($count / $limit); } else { $totalPages = 0; } if ($page > $totalPages) { $page = $totalPages; } if ($limit < 0) { $limit = 0; } $start = $limit * $page - $limit; if ($start < 0) { $start = 0; } $limit = $limit * $page; if (empty($postedData['pivotRows'])) { $rows = $Repository->getRows($limit, $start, $sidx, $sord, $filters['rules']); } else { $rows = json_decode($postedData['pivotRows'], true); } if (!is_array($rows) || isset($rows[0]) && !is_array($rows[0])) { throw new Exception('The method getRows must return an array of arrays, example: array(array("column1" => "1-1", "column2" => "1-2"), array("column1" => "2-1", "column2" => "2-2"))'); } if (isset($postedData['exportFormat'])) { $this->Excel->create($postedData['name'], function ($Excel) use($rows, $postedData) { foreach (json_decode($postedData['fileProperties'], true) as $key => $value) { $method = 'set' . ucfirst($key); $Excel->{$method}($value); } $Excel->sheet($postedData['name'], function ($Sheet) use($rows, $postedData) { $columnCounter = 0; foreach (json_decode($postedData['model'], true) as $a => $model) { if (isset($model['hidden']) && $model['hidden'] !== true) { $columnCounter++; } if (isset($model['hidedlg']) && $model['hidedlg'] === true) { continue; } if (empty($postedData['pivot'])) { foreach ($rows as $b => &$row) { if (isset($model['hidden']) && $model['hidden'] === true) { unset($row[$model['name']]); } else { if (isset($model['label'])) { $row = array_add($row, $model['label'], $row[$model['name']]); unset($row[$model['name']]); } else { $temp = $row[$model['name']]; unset($row[$model['name']]); $row = array_add($row, $model['name'], $temp); } } } } if (isset($model['align']) && isset($model['hidden']) && $model['hidden'] !== true) { $Sheet->getStyle($this->num_to_letter($columnCounter, true))->getAlignment()->applyFromArray(array('horizontal' => $model['align'])); } } foreach (json_decode($postedData['sheetProperties'], true) as $key => $value) { $method = 'set' . ucfirst($key); $Sheet->{$method}($value); } $Sheet->fromArray($rows); $Sheet->row(1, function ($Row) { $Row->setFontWeight('bold'); }); }); })->export($postedData['exportFormat']); } else { echo json_encode(array('page' => $page, 'total' => $totalPages, 'records' => $count, 'rows' => $rows)); } }
/** * Echo in a jqGrid compatible format the data requested by a grid. * * @param RepositoryInterface $dataRepository * An implementation of the RepositoryInterface * @param array $postedData * All jqGrid posted data * @return string * String of a jqGrid compatible data format: xml, json, jsonp, array, xmlstring, jsonstring. */ public function encodeRequestedData(RepositoryInterface $Repository, $postedData) { // $page = $postedData['page']; // get the requested page // $limit = $postedData['rows']; // get how many rows we want to have into the grid // $sidx = $postedData['sidx']; // get index row - i.e. user click to sort // $sord = $postedData['sord']; // get the direction if (isset($postedData['page'])) { $page = $postedData['page']; // get the requested page } else { $page = 1; } if (isset($postedData['rows'])) { $limit = $postedData['rows']; // get how many rows we want to have into the grid } else { $limit = null; } if (isset($postedData['sidx'])) { $sidx = $postedData['sidx']; // get index row - i.e. user click to sort } else { $sidx = null; } if (isset($postedData['sord'])) { $sord = $postedData['sord']; // get the direction } if (isset($postedData['filters']) && !empty($postedData['filters'])) { $filters = json_decode(str_replace('\'', '"', $postedData['filters']), true); } if (isset($postedData['nodeid'])) { $nodeId = $postedData['nodeid']; } else { $nodeId = null; } if (isset($postedData['n_level'])) { $nodeLevel = $postedData['n_level']; } else { $nodeLevel = null; } if (isset($postedData['exportFormat'])) { $exporting = true; } else { $exporting = false; } if (!$sidx || empty($sidx)) { $sidx = null; $sord = null; } if (isset($filters['rules']) && is_array($filters['rules'])) { foreach ($filters['rules'] as &$filter) { switch ($filter['op']) { case 'eq': //equal $filter['op'] = '='; break; case 'ne': //not equal $filter['op'] = '!='; break; case 'lt': //less $filter['op'] = '<'; break; case 'le': //less or equal $filter['op'] = '<='; break; case 'gt': //greater $filter['op'] = '>'; break; case 'ge': //greater or equal $filter['op'] = '>='; break; case 'bw': //begins with $filter['op'] = 'like'; $filter['data'] = $filter['data'] . '%'; break; case 'bn': //does not begin with $filter['op'] = 'not like'; $filter['data'] = $filter['data'] . '%'; break; case 'in': //is in $filter['op'] = 'is in'; break; case 'ni': //is not in $filter['op'] = 'is not in'; break; case 'ew': //ends with $filter['op'] = 'like'; $filter['data'] = '%' . $filter['data']; break; case 'en': //does not end with $filter['op'] = 'not like'; $filter['data'] = '%' . $filter['data']; break; case 'cn': //contains $filter['op'] = 'like'; $filter['data'] = '%' . $filter['data'] . '%'; break; case 'nc': //does not contains $filter['op'] = 'not like'; $filter['data'] = '%' . $filter['data'] . '%'; break; case 'nu': //is null $filter['op'] = 'is null'; $filter['data'] = ''; break; case 'nn': //is not null $filter['op'] = 'is not null'; $filter['data'] = ''; break; } } } else { $filters['rules'] = array(); } $count = $Repository->getTotalNumberOfRows($filters['rules']); if (empty($limit)) { $limit = $count; } if (!is_int($count)) { throw new Exception('The method getTotalNumberOfRows must return an integer'); } if ($count > 0) { $totalPages = ceil($count / $limit); } else { $totalPages = 0; } if ($page > $totalPages) { $page = $totalPages; } if ($limit < 0) { $limit = 0; } $start = $limit * $page - $limit; if ($start < 0) { $start = 0; } $limit = $limit * $page; if (empty($postedData['pivotRows'])) { $rows = $Repository->getRows($limit, $start, $sidx, $sord, $filters['rules'], $nodeId, $nodeLevel, $exporting); } else { $rows = json_decode($postedData['pivotRows'], true); } if (!is_array($rows) || isset($rows[0]) && !is_array($rows[0])) { throw new Exception('The method getRows must return an array of arrays, example: array(array("column1" => "1-1", "column2" => "1-2"), array("column1" => "2-1", "column2" => "2-2"))'); } if ($exporting) { $this->Excel->create($postedData['name'], function ($Excel) use($rows, $postedData) { foreach (json_decode($postedData['fileProperties'], true) as $key => $value) { $method = 'set' . ucfirst($key); $Excel->{$method}($value); } $Excel->sheet($postedData['name'], function ($Sheet) use($rows, $postedData) { $groupingView = json_decode($postedData['groupingView'], true); $groupHeaders = json_decode($postedData['groupHeaders'], true); $columnsPositions = array(); $groupFieldName = ''; $columnCounter = 0; foreach (json_decode($postedData['model'], true) as $a => $model) { if (!empty($groupingView) && $groupingView['groupField'][0] == $model['name']) { if (isset($model['hidden']) && $model['hidden'] === true) { $groupFieldHidden = true; } else { $groupFieldHidden = false; } $groupFieldName = $model['name']; if (isset($model['label'])) { $groupFieldLabel = $model['label']; } else { $groupFieldLabel = $model['name']; } } if (isset($model['hidden']) && $model['hidden'] !== true) { $columnCounter++; $columnsPositions[$model['name']] = $columnCounter; } if (isset($model['hidedlg']) && $model['hidedlg'] === true) { continue; } if (empty($postedData['pivot'])) { foreach ($rows as $index => &$row) { if (isset($model['hidden']) && $model['hidden'] === true && $model['name'] != $groupFieldName) { unset($row[$model['name']]); } else { if (isset($model['label'])) { $row[$model['label']] = $row[$model['name']]; unset($row[$model['name']]); } else { $temp = $row[$model['name']]; unset($row[$model['name']]); $row[$model['name']] = $temp; } } } } if (isset($model['align']) && isset($model['hidden']) && $model['hidden'] !== true) { $Sheet->getStyle($this->num_to_letter($columnCounter, true))->getAlignment()->applyFromArray(array('horizontal' => $model['align'])); } } foreach (json_decode($postedData['sheetProperties'], true) as $key => $value) { $method = 'set' . ucfirst($key); $Sheet->{$method}($value); } if (!empty($groupingView)) { $groupedRows = $groupedRowsNumbers = array(); $rowCounter = 0; foreach ($rows as $index => &$row) { if ($rowCounter == 0) { $currentgroupFieldValue = $row[$groupFieldLabel]; if ($groupFieldHidden) { unset($row[$groupFieldLabel]); } $firstColumnName = key($row); $groupedRow = $row; foreach ($groupedRow as $label => &$cell) { if ($firstColumnName == $label) { $cell = $currentgroupFieldValue; } else { $cell = ''; } } $rowCounter = 2; if (!empty($groupHeaders)) { $rowCounter++; } array_push($groupedRows, $groupedRow); array_push($groupedRowsNumbers, $rowCounter); } else { if ($row[$groupFieldLabel] != $currentgroupFieldValue) { $currentgroupFieldValue = $groupedRow[$firstColumnName] = $row[$groupFieldLabel]; $rowCounter++; array_push($groupedRows, $groupedRow); array_push($groupedRowsNumbers, $rowCounter); } if ($groupFieldHidden) { unset($row[$groupFieldLabel]); } } array_push($groupedRows, $row); $rowCounter++; } $lastCellLetter = $this->num_to_letter($columnCounter, true); foreach ($groupedRowsNumbers as $index => $groupedRowsNumber) { $Sheet->mergeCells("A{$groupedRowsNumber}:{$lastCellLetter}{$groupedRowsNumber}"); } $rows = $groupedRows; } if (empty($groupHeaders)) { $Sheet->fromArray($rows); } else { $headers = $firstHeader = array(); for ($i = 0; $i < count($columnsPositions); $i++) { $firstHeader[$i] = ''; } foreach ($groupHeaders as $index => $groupHeader) { $firstHeader[$columnsPositions[$groupHeader['startColumnName']] - 1] = $groupHeader['titleText']; $Sheet->mergeCells($this->num_to_letter($columnsPositions[$groupHeader['startColumnName']], true) . '1:' . $this->num_to_letter($columnsPositions[$groupHeader['startColumnName']] + $groupHeader['numberOfColumns'] - 1, true) . '1'); } array_push($headers, $firstHeader); array_push($headers, array_keys($rows[0])); $Sheet->fromArray(array_merge($headers, $rows), null, 'A1', false, false); $Sheet->row(2, function ($Row) { $Row->setFontWeight('bold'); }); } $Sheet->row(1, function ($Row) { $Row->setFontWeight('bold'); }); }); })->export($postedData['exportFormat']); } else { echo json_encode(array('page' => $page, 'total' => $totalPages, 'records' => $count, 'rows' => $rows)); } }
public function exportExcel() { $prodi = Input::get('kode_prodi'); $gangep = Input::get('gangep'); $tahun = Input::get('tahun_ajaran'); if (empty($prodi) || empty($gangep) || empty($tahun)) { return Redirect::to('administrator/rekapitulasi/cetakLaporan')->with('msge', 'Maaf.....<br>Inputan tidak boleh ada yang kosong!'); } else { $rekap1 = DB::table('v_interprestasi')->where('kode_prodi', '=', $prodi)->where('gangep', '=', $gangep)->where('tahun_ajaran', '=', $tahun)->get(); Excel::create('Laporan Evaluasi Proses Belajar Mengajar', function ($excel) use($rekap1) { // Set the properties $excel->setTitle('Evaluasi Proses Belajar Mengajar')->setCreator('STMIK Bumigora Mataram'); $excel->sheet('Data PBM', function ($sheet) use($rekap1) { $row = 1; $sheet->row($row, array('No', 'Kode Prodi', 'Nama Matakuliah', 'Nama Dosen', 'Semester', 'Kelas', 'Total Mahasiswa', 'Total Mahasiswa Isi', 'Total Mahasiswa Tidak Isi', 'Presentase Index', 'Keterangan', 'Tahun Ajaran')); $no = 1; foreach ($rekap1 as $val) { $sheet->row(++$row, array($no++, $val->kode_prodi, $val->nama_matakuliah, $val->nama_dosen, $val->semester, $val->kelas, $val->tot_mahasiswa, $val->tot_mhs_isi, $val->tot_mhs_tdk_isi, $val->PresentaseIndex, $val->keterangan, $val->tahun_ajaran)); } }); })->export('xls'); } }
/** * Get register, enabled (or both) filters * * @param string|boolean $key [description] * @return array * @static */ public static function getFilters($key = false) { return \Maatwebsite\Excel\Excel::getFilters($key); }
/** * Create a new file and load a view * * @param string $view * @param array $data * @param array $mergeData * @return \Maatwebsite\Excel\LaravelExcelWriter * @static */ public static function loadView($view, $data = array(), $mergeData = array()) { return \Maatwebsite\Excel\Excel::loadView($view, $data, $mergeData); }
/** * Create the json response. * * @return mixed */ public function export() { $this->filename = 'export-' . date('Y-m-d'); $result = []; /** @var IndexResult $item */ foreach ($this->getIndexBuilder()->getResult() as $item) { foreach ($item->getFields() as $field) { $value = $field->getValue(); if (!is_string($value)) { $value = $value->toArray(); } $result[$item->getIdentifier()][$field->getName()] = $value; } } Excel::create($this->getFilename(), function ($excel) use($result) { $excel->setTitle('Export'); $excel->setCreator('Bauhaus')->setCompany('KraftHaus'); $excel->sheet('Excel sheet', function ($sheet) use($result) { $sheet->setOrientation('landscape'); $sheet->fromArray($result); }); })->download('xls'); }