#### Category : export

good morning, i want to ask. for using a function like this why doesn’t it work? when tried on localhost php native DR. ACHMAD,. S.PD can change to Dr. ACHMAD,. S.Pd but when I export excel, why is the name still all capital letters, right? Thank you. public function nama_gelar($str){$string = ucwords(strtolower($str));$tanda = ..

How to get heading from different table on export? class Kriteria_Export implements FromCollection, WithMapping, WithHeadings { public function collection() { return Alternatif::all(); } public function map($alternatif) :array { return [$alternatif->nama_alt, ]; } public function headings(): array { return [ ‘Nama Alternatif’, ]; } } Tabel Alternatif Tabel Kriteria When Export I want like this ..

I’m using BarryvdhDomPDF export data from laravel webpage into pdf. But I’m getting ‘Maximum execution time of 60 seconds exceeded’ picture of error in app.php I already set Barryvdh class and aliases as PDF in web.php Route::get(‘/Student/Materi/singleMateri/exportPdf/{id}’, ‘[email protected]’)->middleware(‘role:Student’); in StudentController.php public function exportPdf($id) {$singleMateri = Materi::findOrFail($id);$pdf = PDF::loadview(‘pages.student.materi.exportPdf’, compact(‘singleMateri’) ); return $pdf->download(‘materi.pdf’); } .. Read more How to pass parameter into export file? Sourc.. Read more I am having an issue while exporting the large user data into an excel sheet. It causes a timeout error and the whole data is not exporting. How can I fix this issue? Please help. The total number of records in the data is greater than 40000 records. Sourc.. Read more I have two simple files: app.js section.blade.php I’m trying to export one function to the other. app.js file: export function test(testfile) { return ‘test’; } section.blade.php <script type="module"> import { test } from ‘/js/app.js’; console.log(test); </script> When I do this, I get: Uncaught SyntaxError: The requested module ‘/js/app.js’ does not provide an export named ‘test’ .. Read more I am trying to export a sheet with multiple worbooks and to generate each workbook from a view. i have created 5 different .blade files containing html tables and want to generate eache work book from each .blade file. I am trying to export a sheet with multiple worbooks and to generate each workbook from .. Read more I’ve already installed and used with success maatwebsite/excel in Laravel 8, with collections and "static" queries. Now I have a situation where an admin user can create his own queries and store them on database (table name: exports), with some placeholders, example: select id, name as full_name, is_active as active from users where my_field > .. Read more Class ‘ZipArchive’ not found {"exception":"[object] (SymfonyComponentDebugExceptionFatalThrowableError(code: 0) Sourc.. Read more I’m having a trouble on how can I implement export file in vue.js using datatable in laravel. I know it is common to ask this problem, but I couldn’t find a way yet. When I click button it should automatically download the datatable data in excel. Is there any quickest way to export using datatable?. .. Read more I need to freeze header of excel. Only first row but it isn’t working. I have refered answer in question : Is there a way to freeze the first row of the excel with Laravel Excel 3.1? still freeze panes are not working.. Is there mistake with code. class ReportExport implements WithMultipleSheets { use Exportable,RegistersEventListeners; .. Read more public function cal1(request$request){ $request->validate([ ‘month’ => ‘required’ ]);$month1 = $request->get(‘month’); // dd($month1); $date = DB::table(‘users’)->where(‘date’, ‘==’,$month1); return Excel::download(new UsersExport($date), ‘users.xlsx’); } here is my controller, it exports the excel sheet with all the data in DB table. I want to export excel sheet having data month wise. thanks in advance. Sourc.. Read more I have a problem with exporting kml and gpx files using laravel controller: for json export I use function public function mapExportJSON(Request$request) { $client = new Client();$http = $client->post( ‘https://myurl’ , [ ‘body’ => json_encode(array(‘points’ =>$request->points)), ‘headers’ => [ ‘Cache-Control’ => ‘no-cache’, ‘Content-type’ => ‘application/json’, ] ] ); $result =$http->getBody()->getContents(); return ..

I got error when trying to export excel from my localhost This my code : $data[‘main’] =$this->getDailyIncome($input);$data[‘data’] = $data;$data[‘payments’] = $this->payments;$dateNew = str_replace("/","-",$input->daily);$data[‘date’] = Carbon::parse($dateNew)->format(‘d-m-Y’); return Excel::create(‘Daily Report’ .$data[‘site_now’]->name, function ($excel) use ($data, $input) {$excel->sheet(‘Daily Report’, function ($sheet) use ($data, $input) {$sheet->loadView($this->viewFolder . ".excel.daily_income",$data); $sheet->setFontFamily(‘Comic Sans .. Read more I got error when trying to export excel from my localhost This my code : $data[‘main’] = $this->getDailyIncome($input); $data[‘data’] =$data; $data[‘payments’] =$this->payments; $dateNew = str_replace("/","-",$input->daily); $data[‘date’] = Carbon::parse($dateNew)->format(‘d-m-Y’); return Excel::create(‘Daily Report’ . $data[‘site_now’]->name, function ($excel) use ($data,$input) { $excel->sheet(‘Daily Report’, function ($sheet) use ($data,$input) { $sheet->loadView($this->viewFolder . ".excel.daily_income", $data);$sheet->setFontFamily(‘Comic Sans ..

I’m not able to modify a file. I want to import the excel file, modify it and then download it. Is there no way achieve this in version 3.1 ? Sourc..

Please, does anyone have a tip that can process data over 500,000 rows in LAravel. Actually, I have to generate a CSV, it puts a memory limit error. Thanks for your help. Sourc..

I just want to display an excel file of the line linked to the id of my patient. But it create an excel file with all my patients & not just one. I dont understand why, because when i make dd($patient) i only see the patient with the Id that im looking for. Sorry for .. Read more I’m using the Maatwebsite/Laravel-Excel 3.1 version library in Laravel to download an xlsx file. its working fine in localhost but not working in live server. UsersExport namespace AppExports; use AppExportsUsersExport; use MaatwebsiteExcelConcernsFromCollection; use DB; class UsersExport implements FromCollection { public function collection() { return DB::table(’employees’)->get(); } } Controller namespace AppHttpControllers; use IlluminateHttpRequest; use DB; use .. Read more I am trying to export database sql file and also save the file in database, This code working for export database file but i want to save it also in public directory //ENTER THE RELEVANT INFO BELOW$mysqlHostName = env(‘DB_HOST’); $mysqlUserName = env(‘DB_USERNAME’);$mysqlPassword = env(‘DB_PASSWORD’); $DbName = env(‘DB_DATABASE’);$backup_name = "mybackup.sql"; \$tables = array("users","password_resets","divisions"); ..

I have a Laravel project. in resource/js/app.js I have a Vue instance and when I want to read or write vm in my blade, I just can’t! I think this is because of my webpack.mix.js but I can’t figure out what is the exact cause. resources/js/app.js: let vm = new Vue({ data() { return { ..

i was using php 7.2 and laravel 6 and developing a export module somewhere where i need to export mysql data into xls. when i was exporting to csv is working fine and column exported on each column according to order. but in case of xls all record exported in single column. i know that ..

How to use the 2 library at the same laravel app. I want to use the DOMPDF for 1 page pdf and the TCPDF for multiple pages(1000 pages). but the problem is that the TCPDF is overwriting all the functions of the dompdf. What is the best way to use these 2 vendors in same ..

I’m using the Laravel framework and I’m trying to customize a project. I’ve created the tables, databases and associated PHP files, but I’m not sure how to export selected rows and when I’m exporting, it has all the rows of the table? Source: Laravel Sta..

how to download or stream large file of pdf using php or laravel. I am using dompdf to generate pdf but my query is large. If i limit the query into 100 it loads 12 rows only. but if i remove the limit 100, it cant download or stream. Source: Laravel Sta..