Category : phpexcel

Problem Statement: We are storing files on an S3 bucket and want to load them via ->load(). Could not open storage/app/path/file.xlsx for reading! File does not exist. Files and Configuration: use IlluminateSupportFacadesStorage; use PHPExcel_Reader_Excel2007; $path = Storage::disk(‘s3-storage’)->path(‘app/path/’ , $filename); $objReader = new PHPExcel_Reader_Excel2007(); $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load($path); config/filesystems.php ‘s3-storage’ => [ ‘driver’ => ‘s3’, ‘key’ ..

Read more

Laravel Version: 5.5 PHP Version $ php –version: PHP PHP 7.1.3 (cli) Database Driver & Version $ mysql –version: mysql Ver 8.0.23-0ubuntu0.20.04.1 Problem Statement: We are storing files on an S3 bucket and want to load them via load method. Could not open storage/app/path/file.xlsx for reading! File does not exist. Files and Configuration: use IlluminateSupportFacadesStorage; ..

Read more

I am using SimpleXLSXGen in Laravel8. But I want to write column name in excel. How can i do that ? public function savexls(Request $request) { $id = $request->id; $mercs = DB::table(‘be_medical_insurance_for_foreigners’)-> select(‘be_medical_insurance_for_foreigners.id’,’be_medical_insurance_for_foreigners.create_date’,’be_medical_insurance_for_foreigners.version’, ‘be_product.name as productname’, ‘be_medical_insurance_for_foreigners.email’, ‘be_medical_insurance_for_foreigners.merchant_code’, ‘be_medical_insurance_for_foreigners.name’, ‘be_medical_insurance_for_foreigners.order_document_link’)->get(); $data= json_decode($mercs,true); SimpleXLSXGen::fromArray( $data )->saveAs(‘datatypes.xlsx’); return redirect(‘/datatypes.xlsx’); } Sourc..

Read more

We’are using Maatwebsite version 3.1.0 with Laravel version 6.x. Excel files that are exported by this composer package are too slow to edit by Excel program than same files generated by copy/paste all datasets from exported excel. The size of output file exported by Maatwebsite is rather smaller than the file generated by copy/paste but ..

Read more

I am using Laravel 5.2 and maatwebsite/excel 2.1, the issue is border line is not showing after setting background color, I have used the below code. $excel->getActiveSheet()->setBorder(‘A1:’ . $excel->getActiveSheet()->getHighestColumn() . $excel->getActiveSheet()->getHighestRow(), ‘thin’); Excel screenshot Sourc..

Read more