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

Подписаться 19 тыс.

Просмотров 6 тыс.

50% 1

#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

Опубликовано:

18 авг 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@limoh 2 года назад

Thank You, Amitav

@amitavroydev 2 года назад

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

@francisjipson6749 2 года назад

👍👍

@amitavroydev 2 года назад

Thanks

@melodicTune9464 2 года назад

Thank you very much..

@amitavroydev 2 года назад

You are welcome

@eliaschampi 2 года назад

Great! Laravel exCel

@amitavroydev 2 года назад

Yup

@user-xo2nq9bx3b 7 месяцев назад

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 7 месяцев назад

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

@ErvisHysiDev 2 года назад

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

@amitavroydev 2 года назад

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

@ibrahimsherif6648 2 года назад

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 2 года назад

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.

@Ehsankhan0577 2 года назад

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

@amitavroydev 2 года назад

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);

@SalomDunyoIT 2 года назад

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

@amitavroydev 2 года назад

Don't know.. sorry about that.

@rhnnf3502 2 года назад

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

@amitavroydev 2 года назад

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

@yakiiz5924 2 года назад

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

@amitavroydev 2 года назад

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 :)

@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

@lastninja2022 2 года назад

do you have CRUD and search filter with this printing?

@amitavroydev 2 года назад

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

@naumtinga 2 года назад

Can i put style the tables? IT LOOKS TO SIMPLE

@amitavroydev Год назад

Yes you can

@akshaythorat3904 2 года назад

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

@amitavroydev 2 года назад

Intelliphense

@khizrshaikh9902 3 года назад

*_first comment I want heart_*

@amitavroydev 3 года назад

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

@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.