Видео

How about loading your own excel template and append your data?

Thank you very much, it helped me a lot.

--with-all-dependencies saved my time thanks buddy

i need to use a worksheet like thing in my software Is the laravel excel work it?

how to create drop down list or select in column, can you help me

Thank you very much, it helped me a lot.

i am found a troubel .. please help me ... Call to undefined method App\Exports\MasterData\ExporNominnatif::queue()

hello.am following your video.however am having a bit of a change.with the query and title methods.they are returning blank.my excel file thats being downloaded it dosent have employees names on the sheets as well as the each employee's information.what could be the problem? the two models am using are Employee and Adavance.Employee being the main model while the adavance as the child with the information of each employee. below is my code " <?php namespace App\Exports; use App\Models\Employee; use App\Models\Adavance; use Illuminate\Contracts\Support\Responsable; use Illuminate\Contracts\View\View; use Maatwebsite\Excel\Concerns\FromArray; use Maatwebsite\Excel\Concerns\FromCollection; use Maatwebsite\Excel\Concerns\FromQuery; use Maatwebsite\Excel\Concerns\FromView; use Maatwebsite\Excel\Concerns\WithHeadings; use Maatwebsite\Excel\Concerns\Exportable; use Maatwebsite\Excel\Concerns\WithMapping; use Maatwebsite\Excel\Concerns\WithMultipleSheets; use Maatwebsite\Excel\Concerns\WithTitle; // use Maatwebsite\Excel\Excel; libxml_use_internal_errors(true); class EmployeesExport implements WithMultipleSheets { use Exportable; protected $data; // private $fileName='employees.csv'; // private $writerType= Excel::XLSX; // private $headers=[ // 'Content-Type'=>'Text/csv' // ]; public function __construct($data) { $this->data = $data; } // // /** // * @return \Illuminate\Support\Collection // */ // public function collection() // { // // return $this->data; // } /** * @return array */ public function sheets(): array { $sheets = []; foreach ($this->data as $employee) { $sheets[] = new SheetExport($employee); } return $sheets; } } ==================================== <?php namespace App\Exports; use App\Models\Adavance; use App\Models\Employee; use Maatwebsite\Excel\Concerns\FromCollection; use Maatwebsite\Excel\Concerns\FromQuery; use Maatwebsite\Excel\Concerns\WithHeadings; use Maatwebsite\Excel\Concerns\WithMapping; use Maatwebsite\Excel\Concerns\WithTitle; class SheetExport implements FromQuery, WithTitle,WithHeadings,WithMapping { public $employee; public function __construct($employee) { $this->employee=$employee; } /** * @return string */ public function title(): string { return $this->employee->name; } /** * @return array */ public function headings(): array { return[ 'ID', 'REASON', 'AMOUNT', ]; } /** * */ public function query() { return Adavance::where('employee_id',$this->employee->id); } /** * @param RowType $row * @return array */ public function map($row): array { return [ $row['id'], $row['reason'], $row['amount'], ]; } } ==================================================== <?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Exports\EmployeesExport; use Maatwebsite\Excel\Facades\Excel; use App\Models\Employee; use App\Models\Adavance; class ExportsController extends Controller { public function export() { $employees=Employee::all(); // return Excel::download(new EmployeesExport($employees), 'Employees.csv'); return (new EmployeesExport($employees))->download('employees.csv'); // return (new EmployeesExport($employees)); } } "

thanks for the explication is very clear and specific

Thank you, but with php 8.2 and laravel 10, the command install the version 1.1

Thanks. By the way, where do you sketch the ER diagram?

BadMethodCallException I have a problem with installing this library BadMethodCallException Method Illuminate\Foundation\Application::share does not exist. at vendor\laravel\framework\src\Illuminate\Macroable\Traits\Macroable.php:112 108▕ */ 109▕ public function __call($method, $parameters) 110▕ { 111▕ if (! static::hasMacro($method)) { ➜ 112▕ throw new BadMethodCallException(sprintf( 113▕ 'Method %s::%s does not exist.', static::class, $method 114▕ )); 115▕ } 116▕ i Bad Method Call: Did you mean Illuminate\Foundation\Application::isShared() ? 1 vendor\maatwebsite\excel\src\Maatwebsite\Excel\ExcelServiceProvider.php:154 Illuminate\Foundation\Application::__call("share") 2 vendor\maatwebsite\excel\src\Maatwebsite\Excel\ExcelServiceProvider.php:58 Maatwebsite\Excel\ExcelServiceProvider::bindClasses()

i get this error after publishing the config BadMethodCallException Method Illuminate\Foundation\Application::share does not exist. at vendor\laravel\framework\src\Illuminate\Macroable\Traits\Macroable.php:112 108▕ */ 109▕ public function __call($method, $parameters) 110▕ { 111▕ if (! static::hasMacro($method)) { ➜ 112▕ throw new BadMethodCallException(sprintf( 113▕ 'Method %s::%s does not exist.', static::class, $method 114▕ )); 115▕ } 116▕

i get this error at 4:38 ==> 'Could not find zip member zip://C:\xampp\htdocs\test\storage\framework\cache\laravel-excel\laravel-excel-P9aTOJFWmjjjJjG3R6tKO6NI5W1zkpDE.xlsx#_rels\.rels'

You talk too fast, lack any detail and copy and paste bullshit. WTF is wrong with all of you low level devs in India? Do you actually know anything about what you are doing or do you just ram through the documentation with no clue of how to use this shit in the real world? Massive waste of time here. Goddamn I hate Laravel and PHP. Sloppy halfwit nonsense.

Sir, What is the name of the browser extension for checking these queries?

Thank you for this amazing content keep going, excellent job.

Thank you very much, sir!

Great tutorial, thanks. BTW, you forgot to send a message in your login method so your message is the status code: return response()->success($response, 201); instead of return response()->success($response, 'User Logged in', 201);

i get a lot of errors

very nice, sir

Excellent series on Laravel Excel. Thank you very much, good job! I hope you keep uploading content.

thanks, good examples !!

Hi there. I've a many to many relationship and I want to create for each one a row with all related record. How can I do that?

how to implement this signature url in button instead of copying.

hi Naveed, i looking for merge heading cells, so i need a heading to become one cells

Thank you

Good and you can make it better if you use some standard font for your IDE. For personal use, you are free to use any font of your choice but if you want to target mass, should standardize these things. Good luck.

Thank you very much Hesan, this is an excellent series with unique lessons, I am really really loving this series. Super useful & informative. ❤❤❤

When I click on the selected Google account, it displays "Not Found The requested URL was not found on this server". How do I fix it?

Hi Naveed, I found a missing gem for my laravel learning. This series is excellent work you have done for us. thank you so much. 🥰

excellent job ❤❤❤

great and short tutorial

thanks very helpful github plz?

can you tell me complete seo process in laravel?how to it and its exact process?

hi bro, could you make tutorial laravel socialite with passport?

Is lazy eager loading memory efficient?

bro why you using this font for your IDE lol, good tutorial <3

I have been trying to overcome this error for several days and without success. Laravel\ Socialite\ Two \ InvalidStateException (laravel 10.10.1) i do everything like you do, also watched a lot of other videos and info and gpt chat haha, also i created a new clean laravel project and i try to do it here but without success. I do not understand why. i am using docker. I tried github and twitter authorization, the problem is the same. some people say that it may be in the sessions, but as I see you didn’t even change this functionality, and the usual authorization works correctly for me. I look forward to your reply, thanks!

can i make it using sanctum package ?

What is so hard with providing the source code for this, like even a gist file.

Thanks Great tutorial. All other tutorials miss this step of credentials.

Very nice video

Great job , upload more video

Your interface font is really frustrating for the viewer 🙂

It's hard to see the fonts. It would be better if you increase the font size in IDE. Btw thanks for the tutorial bro.

Well, I'd love to see how to validate DATEFORMAT, could you please show an example ? (yyyy-mm-dd)

So view composer is that easy? you a time saver bro

What's the name of the font your using

Nobody talks about how to use the token to validate route request