Laravel Exel pacakge tutorial export data to XLS, CSV and PDF

#laravel
While working on some reporting requirements in a project, I discovered this nice package which can help us a lot in generating reports in different formats like Excel, CSV and even PDF.
This is the first video where I go on exploring the package.
You can find me on:
Twitter: / amitavroy7​
Discord: / discord

[@limoh]

Thank You, Amitav

[@amitavroydev]

Welcome... request you to share the content and subscribe if you have not done it already

[@ErvisHysiDev]

What if I want do make a query with condition where('invoice.id', $id), can you please share any example for that?

[@amitavroydev]

It will just be a query with the condition. For example, User::select(['fields'])->where('user', $id)->get();

[@ibrahimsherif6648]

Good evening, nice video, but i've an issue, what is in i want the pdf in landscape format ?? How would i specify it please ?? Thanks in advance...

[@amitavroydev]

This package allows you to use DOM PDF to generate PDF. And, in DOM PDF you can use the set_paper method to define landscape. Check the stackoverflow link: stackoverflow.com/a/36018887/1367259 This should help you.

[@carlosmaralit-o3l]

hello there, can you do a video about modifying the looks of the pdf using that library as well? and also maybe like when you click something, the pdf will open up on new tab? thank youuuuu, this is very helpful vid, I learn a lot

[@amitavroydev]

It's possible. However, not something I am planning to do recently

[@SalomDunyoIT]

How about Cyrillic chars from DB(utf8mb4 set) to pdf using fromView?

[@amitavroydev]

Don't know.. sorry about that.

[@bl4nknvrlose604]

Is it possible to assign or specify the excel file when exporting? I have a format to follow but I can't figure out.

[@amitavroydev]

I don't think I completely understand your requirement. Can you elaborate? possible to assign or specify the excel file - you mean a file where you want to append data?

[@bl4nknvrlose604]

@@amitavroydev yeah but i do think it's not possible so I think I gonna design in the blade view.

[@amitavroydev]

That's what even I felt. Might be possible but can be quite complicated

[@francisjipson6749]

👍👍

[@amitavroydev]

Thanks

[@yakiiz5924]

Hello, do you have any video about your windows or vscode configuration?

[@amitavroydev]

For windows, no. I never thought people would be interested. However, my entire vscode setting is here: gist.github.com/amitavroy/c4c83057e3bf82b18eaaf410efa2e940 Do note, some plugins are just sitting there :)

[@naumtinga]

Can i put style the tables? IT LOOKS TO SIMPLE

[@amitavroydev]

Yes you can

[@mr_d_hub]

Thank you very much..

[@amitavroydev]

You are welcome

[@akshaythorat3904]

Sir can you please share vs code extensions list used for laravel..😊

[@amitavroydev]

Intelliphense

[@khizrshaikh9902]

*_first comment I want heart_*

[@amitavroydev]

Thanks for the comment and support. Do subscribe if you have not done already and do like the video.

[@eliaschampi]

Great! Laravel exCel

[@amitavroydev]

Yup

[@Ehsankhan0577]

nice video......sir how to insert data from the file into table.......means reverse of it

[@amitavroydev]

When you insert the file, you get the file object. You need to then use that file object to save the relationship. For example, if a user has a profile pic which is of type file. Then, save the file const file = await fileService.save(data); const user = ..., profilePic = file await userService.save(user);

[@lastninja2022]

do you have CRUD and search filter with this printing?

[@amitavroydev]

This video is a straight up one on how to use the package. If you apply filter and get the query, you will get the result and you can then send it to the package do get an Excel

[@rhnnf3502]

Hello, is there any way to change to pdf size or fit in a large table ? Thanks !

[@amitavroydev]

PDF are generally page size. But the package does allow you to set a custom page size

[@darn2926]

I know its long but somebody help me, what do i do if i want such that not to export the file, meaning having a pop up where the user chooses a download location, what i want is generate a report and have it sent as an attachment on an email, so i was asking how can i attain that, where the controller will make the xls or pdf and have it sent on an email. please @amitavroydev and thank you

[@amitavroydev]

In this case, raise an event and then handle it through the event listener.