Hey Andre, i have an id & column checkbox in my views. how i can pass the parameter from controller to export model? i tried $request method and it says ($request) must be compatible with Maatwebsite\Excel\Concerns\FromCollection::collection()
did u know how to return multiples models in public function collection? i want to combined these 2 models together but either one is not appear when i exported
saved life.. Thanks a alot ... please make a video how to generate pdf from dynamic content with PAGE NUMBER in laravel.. PAGE NUMBER IS MUST .. from 2 weeks i'm stucked on that
How do I use decimal values here? When I open the file it says that is currupted and when is its opened the decimal transforms from 444.99 to 444.99.00
can you help me to get the 'starting column and the highest column' likewise the highest row in the particular excel , AfterSheet in the event listed 'cachedHighestColumn' but couldn't obtain it programatically... Thanks...
I don't know if exists a better option, but this works for me, on the AfterSheet: $row = $event->sheet->insertNewRowBefore(2, 11); Reference: phpoffice.github.io/PhpSpreadsheet/master/PhpOffice/PhpSpreadsheet/Worksheet/Worksheet.html#method_insertNewRowBefore
Thanks Andre This may help you gays to get the sum of particular column dynamically public function registerEvents(): array { return [ AfterSheet::class => function(AfterSheet $event) { $event->sheet->setCellValue('E'. ($event->sheet->getHighestRow()+1), '=SUM(E2:E'.$event->sheet->getHighestRow().')'); } ]; } Note: in my case the data I want to get the SUM is in "E" Column you can change it as you want
Sorry to be so offtopic but does anyone know of a trick to get back into an Instagram account? I was stupid forgot the login password. I love any tricks you can offer me!
@Axton Cody i really appreciate your reply. I got to the site on google and Im in the hacking process now. I see it takes a while so I will get back to you later when my account password hopefully is recovered.
2 weeks trying to solve the styling of the Excel sheet thx for this, i appreciate it
man, you always save my life, thank you!
thanks a lot u save my time
Things I like in this video
1. Your voice
2. Your theme (My guess is Ayu Mirage)
3. Your tutorial which is informative.
dude, i appreciate your work, thanks a lot!!
nice explain..
Hey Andre, i have an id & column checkbox in my views. how i can pass the parameter from controller to export model?
i tried $request method and it says
($request) must be compatible with Maatwebsite\Excel\Concerns\FromCollection::collection()
did u know how to return multiples models in public function collection? i want to combined these 2 models together but either one is not appear when i exported
saved life.. Thanks a alot ... please make a video how to generate pdf from dynamic content with PAGE NUMBER in laravel.. PAGE NUMBER IS MUST .. from 2 weeks i'm stucked on that
4:40 selecting columns to show
11:08 Adding headings to columns
شكراً لك , شرحك جيد جداً , وخصوصاً بعد أن تعبت من كثرة البحث على المحتوى الغير المفيد
Thanks Man for the video ...
Is the premium course available ??
Nice and useful tutorial!
Thanks man! you are a life saver!
Great Great playlist, thanks you so much!!!!
How do I use decimal values here? When I open the file it says that is currupted and when is its opened the decimal transforms from 444.99 to 444.99.00
alright, i'm trying to do a dynamic excel from a stored procedure, to format the cell style, do you have any suggestions. regards
congratulations mate
Do you have any example importing XLSX files ?
I appreciate this!
Thank you so much for the video.
You helped me a lot.
I like it when Dr Strange narrate the video
Haha, thanks for watching! Strange is my favourite!
How can we pass parameters to collection method of UserExport.php?
hey Andre,
how to pass id so we can export certain user's detail?
Do you have anyone for powerpoint?
can you help me to get the 'starting column and the highest column' likewise the highest row in the particular excel ,
AfterSheet in the event listed 'cachedHighestColumn' but couldn't obtain it programatically...
Thanks...
awesome video! thanks Andre. can you make a video on import too?
hey Andre can you do for the import too?
I'll look into the new importing feature
Andre Madarang thank yo verymuch , I really love the way how you explained things in details.
Nice tutorial.. thanks
Thanks for watching!
how to append dynamic count like 1,2,3 and so on let's say # column?
Hello thanks for your video it was very useful. I have a question, is there anyway to export (Barcode) or (Image)?
Thanks for watching! I'm not sure what you mean.
For example I have users table and each user has a profile image when I export users table how can I export their profile image to excel?
what are u doing on 13.06 .. you suddenly import NumberFormat ??
I have the same question
thank you for this packages
when i need import specific sheet whats about this class FirstSheetImport
Im getting confuse how to export image to excel with blade (formview)
hey man i want export my file excel to table html after that i want save in database can you help please
Hi how can i add multiple custom rows on the top before the collection? The headers() function only accepts a one dimenisional array...
I don't know if exists a better option, but this works for me, on the AfterSheet:
$row = $event->sheet->insertNewRowBefore(2, 11);
Reference: phpoffice.github.io/PhpSpreadsheet/master/PhpOffice/PhpSpreadsheet/Worksheet/Worksheet.html#method_insertNewRowBefore
How i do set background color at a row?
How to convert Excel and PDF using vuejs and laravel .. explain me out in brief
Idk why every client wants to see data in Excel no matter how beautifully you made the Admin panel for them
can you show me how to do that with FromArray?
how to implements this to API?
Thanks Andre
This may help you gays to get the sum of particular column dynamically
public function registerEvents(): array
{
return [
AfterSheet::class => function(AfterSheet $event) {
$event->sheet->setCellValue('E'. ($event->sheet->getHighestRow()+1), '=SUM(E2:E'.$event->sheet->getHighestRow().')');
}
];
}
Note: in my case the data I want to get the SUM is in "E" Column you can change it as you want
WOW... i was struggling with this. Thank you
make a video about imports too.
Thanks. how can i do it using ajax.. .....Anyone Try it using ajax ???
the version 3 do not allow import csv to the database, please use the version 2
You're right. The docs say that they will re-add this functionality in version 3.1.
yes. for import, you have to use phpoffice/phpspreadsheet package
great vid as always! thanks a lot Andre. Keep it up sharing your guidance :)
Thanks for watching!
Sorry to be so offtopic but does anyone know of a trick to get back into an Instagram account?
I was stupid forgot the login password. I love any tricks you can offer me!
@Ameer Finnegan instablaster :)
@Axton Cody i really appreciate your reply. I got to the site on google and Im in the hacking process now.
I see it takes a while so I will get back to you later when my account password hopefully is recovered.
@Axton Cody It did the trick and I now got access to my account again. I am so happy!
Thank you so much you saved my ass !
how import from excel into database ??
The latest version 3.1 of this package supports imports: laravel-excel.maatwebsite.nl/3.1/imports/
colod you make a video about import file
Will consider
Please update this tut!!!!!!!!
You can also watch this video if you want latest package information :
th-cam.com/video/EnR1xF69_AA/w-d-xo.html
great
Thanks for watching!
please use queue for export 500000 records
how to use as i get error-> Allowed memory size of 134217728 bytes exhausted
💙
💜
its like im listening to robot
Call to undefined method Maatwebsite\Excel\Excel::load()