Local Environment: PHP: v8.0.2 Framework: Laravel v8.* mPDF Version: v8.0.10 Deploying With: Laravel Deployer / PHP deployer (deployer) Operating System and Version: macOs Cataline 10.15.5 & Laravel Valet Production Environment: PHP: v8.0.2 Framework: Laravel v8.* mPDF Version: v8.0.10 Product version: Plesk Obsidian 18.0.32. OS version: CentOS 7.9.2009 x86_64 Description It works very well in the ..
I am using Maatwebsite Laravel-excel version 3.1. And I want to set the default styling of the sheet. I have read the documentation about including a macro in your laravel app by setting: Sheet::macro(‘getDefaultStyle’,function(Sheet $sheet){ $sheet->getDefaultStyle(); }); This in my AppServiceProvider boot() method. But when everytime i reload the page it crashes the page and ..
I have an API created for export records in xlsx. It is working fine when I call the API directly but if I am using Guzzle/Http to call the API and this was tested using Postman, I get the following error: "message": "Malformed UTF-8 characters, possibly incorrectly encoded", "exception": "InvalidArgumentException", "file": "C:xampphtdocsborneoshop-admin-laravelvendorlaravelframeworksrcIlluminateHttpJsonResponse.php", "line": 75, …… ..
I’m using rap2hpoutre/fast-excel library for exporting the information I need. Currently, with basic settings, I receive my data in the excel document in the following format: Questions First Question Second Question Third Question What I want to get is: Questions First Question Second Question Third Question Is there any way to do this? Thanks in ..
enter image description here In the code how can I give a new line down. I want to have days on a row and have to load every day. Sourc..
Good afternoon everyone, I need to make an insert in 2 tables: "serialziacions" and "det_serializacions" for what in my controller I have a function that through a transaction will make the insert, but in the table "det_serializacions" data must be inserted from an excel file that is loaded from a form in a modal window ..
In my Laravel backend project, I’m trying to customize the excel data while exporting it. I’m adding to add row colors in that excel. Excel Sheet before customization public function add_color_to_sheet($sheet) { $sheet->cells(‘A1:E1’, function ($cells) { $cells->setBackground(‘#3490ED’); }); $sheet->cells(‘A2:E2’, function ($cells) { $cells->setBackground(‘#6D8947’); }); $sheet->cells(‘A3:E3’, function ($cells) { $cells->setBackground(‘#0DF3FE’); }); $sheet->cells(‘A8:E8’, function ($cells) { $cells->setBackground(‘#0DF3FE’); ..
controller CustomersImport enter image description here enter image description here CustomerController public function importDownload(Request $request) { $request->validate([ ‘file’ => [‘required’, new ExcelRule($request->file(‘file’))], ]); $import = new CustomersImport(); $data = Excel::import($import, request()->file(‘file’),); return back()->with(‘success’, ‘Customers Data Imported successfully.’); } CustomerImport class CustomersImport implements ToCollection, WithValidation { /** * @param array $row * * @return IlluminateDatabaseEloquentModel|null */ ..
I am working on multiple sheets on laravel excel. And, I am exporting data on two sheets using two export. But, half of the data to pushed on 2nd sheets will be generated in 1st export. So I am having difficulties in passing this data from 1st expor to second sheets. This could be further ..
I know a similar question has been asked but the reasons for those error does not imply in my case because I am not fetching results anywhere in code. I am getting this error No query results for model [AppUser] NULL 387 /laravel/framework/src/Illuminate/Database/Eloquent/Builder.php My Excel import code: <?php namespace AppImports; use Auth; use AppUser; use ..
I am trying to export view using laravel Excel 3.1. While the export is working, I am not being able to style it. My laravel Export looks as: <?php namespace AppExports; use IlluminateContractsViewView; use MaatwebsiteExcelConcernsFromView; use MaatwebsiteExcelConcernsWithEvents; use MaatwebsiteExcelConcernsRegistersEventListeners; use MaatwebsiteExcelEventsAfterSheet; class MatrixExcelExport implements FromView, WithEvents { use RegistersEventListeners; protected $data, $selected_data, $am_lists_only, $categories_list, $amenities_list, ..
I have an excel file that has a query to get the neighborhoods, and the total record for each neighborhood. But how can I put at the end, when all the data of the query is placed in the excel a custom column that is the sum or the total of the neighborhoods. This is ..
I’m using laravel excel for create a excel, but I need to create sheets with chars, anyone can suggest me some package of Laravel or a tutorial where I can find this. I am searching in the docs of laravel excel but I don’t see anything at all over there. Thanks in advance. Sourc..
I am using Laravel Excel to generated pdf invoice. Below code is from controller to download the pdf. I have created a Export file InvoicesExport.it is downloading but styles are not applied.Can you help me to the show the invoice with styles. public function pdfInvoice($id) { $booking = Booking::findOrFail($id); return Excel::download(new InvoicesExport($booking), ‘invoice’.time().’.pdf’); } InvoicesExport ..
I am using Laravel Excel to generated pdf invoice. Below code is from controller to download the pdf. I have created a Export file InvoicesExport.it is downloading but styles are not applied.I have checked weather it is loaded. Can you help me to the show the invoice with styles. public function pdfInvoice($id) { $booking = ..
I have an excel file that contains 5 rows and 2 rows will do insert work and 3 will do update work and we can’t separate it. So I do update manually in if condition after converting data in array-like $file = $request->file(‘excel’); $array = Excel::toArray(new UtilityTaskImport, $file); after update work, I have the remaining ..
I have problem with laravel-excel 3.1 after i have been upgrade laravel version and php version i got some requirement from laravel to upgrade laravel-excel too. after that i got problem with excel-export not support new version(3.1) before i use 2.1. anyone can help to update my currently code above? pls! and Thanks Guys! private ..
I am having an issue with import excel file into database. I want to upload column name into the database. Everything is working fine, but the values inserted is "r" rather than being the values in the cell. I don’t know what I am missing below is my code: controller: public function import(Request $request) { ..
I trying to export a Excel file, from a collection using laravel. The code bellow, returns me this. I need to add a 2 new rows above the start of columsn, is that possible? What Should I do? <?php namespace AppTraits; namespace AppExports; // use IlluminateSupportCollection; use IlluminateDatabaseEloquentCollection; use MaatwebsiteExcelConcernsFromCollection; use MaatwebsiteExcelConcernsWithHeadings; use MaatwebsiteExcelConcernsWithMapping; use ..
When I try to export datas as excel file on the specific request I got below error PhpOfficePhpSpreadsheetReaderException Failed to load path_to_projectstorageframeworklaravel-excellaravel-excel-pz23rYwVENIOZUw7vnvhKaNjUkkNLNT8.html as a DOM Document I search alot but couldnot find any answer, the problem comes only when semester = First Sem but when semester is second, third etc this error doesn’t come and ..
I need to import price lists in different formats: xls, csv, and text files where cells separated with semicolon, one space, several spaces, fixed width. These files i can open with microsoft office professional 2016. Can i do this with laravel-excel because i did not find information in official documentation ? Sourc..
[validating another 989 rows][1] [1]: https://i.stack.imgur.com/4ErrL.png i created import function with laravel-excel and i make a column as required. The file contains 10 rows, but after doing check in the failures it always return another 989 rows below the datas & heading.. any suggestion ? my controller public function import(Request $request) { $import = new ..
In excel, I have columns named Country, Country Name, Currency, End Rates and Average Rates. End Rates and Average Rates are Calculate Formula Columns. When I try to import data from excel sheet I’m facing some problem. When I get End Rates and Average Rate value, values are converted to integer. I try to use ..
I have 2 endpoints: This one for filter data /api/v1/admin/sale-product?status=success&category=something So, after I filtered it I want to export those data as csv file by below endpoint: /api/v1/admin/sale-detail/export If my data isn’t filtered It will export all data. How can I do it? I’m using Laravel Excel Any suggestion? Please help me!!! My Controller: <?php ..
I am trying to export a csv file using laravel excel. The excel export are working fine at other end but on console commands it returns error Array and string offset access syntax with curly braces is deprecated Request all to please guide me with same. Command Code: <?php namespace AppConsoleCommands; use AppHttpControllersController; use Excel; ..
