Тёмный

Laravel Excel Live-Coding: Export - Edit - Import Back 

Laravel Daily
Подписаться 145 тыс.
Просмотров 21 тыс.
50% 1

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

 

21 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 37   
@rodrigomendonca3474
@rodrigomendonca3474 5 лет назад
That is it. I need update dsts from my database. I receive a .xls file from client with the new position of consumers. With your lesson i can update my database. THANK YOU VERY MUCH, and congratulation for this job.
@Paltibenlaish
@Paltibenlaish 4 года назад
doing foreach column and updating or inserting results many queries when working with thousands of records, :( is there a cleaner and optimized version for this?
@oscarpedrozascaglione7555
@oscarpedrozascaglione7555 5 лет назад
Great video, thank you so much... If i would want to add and edit some rows at the same time.. is it possible? for example could I export the file, add a new row and import back? I'm waiting for your answer.. thanks!!!
@PovilasKorop
@PovilasKorop 5 лет назад
Your question was "is it possible"? Yes, possible. But sorry, I won't this write code for you, it would be a big separate tutorial.
@fareligormolimboufankem6460
@fareligormolimboufankem6460 2 года назад
Hello and thank you very much for this tutorial but I have a concern most of the time we import and export with the HeadingRow I would like to know how to do the same with the Update of the EXCEL file
@bobpps
@bobpps 5 лет назад
Большое спасибо! У Вас чудесные уроки!
@BonesTormAxeso
@BonesTormAxeso 3 года назад
Its posible to get the columns from the excel and add them to a model as a column too dinamcally? They're about 200+ columns
@bumblebity2902
@bumblebity2902 3 года назад
How pass foreign key id, if I want for example import certain company's projects? Or export certain company projects.
@swapnilkurhade8943
@swapnilkurhade8943 3 года назад
can we upload images from excel file to laravel local storage?
@fuadbakhsh3953
@fuadbakhsh3953 4 года назад
Sir how to import 2 column merged heading in excel.
@Ousainoujaiteh
@Ousainoujaiteh 5 лет назад
Hi sir I followed your video but i always get this error when I want to import "File could not be read".Thank you
@rishavkumar8611
@rishavkumar8611 5 лет назад
Thanks so much for the video...but if i want to import more rows in database it's not importing can u guide me for that
@kenjohnsiosan9707
@kenjohnsiosan9707 5 лет назад
thank u for this videos sir...question though how to export with search query params. hope you noticed my comment 🙂
@shadowartificalin
@shadowartificalin 3 года назад
thanks , i love Master
@antonyjasper4133
@antonyjasper4133 5 лет назад
Thank you so much, I have done this in my project and it works fine.
@vidhyaprakash85
@vidhyaprakash85 5 лет назад
I want example for importing excel data to update the foreign key value in table while importing
@AmeerHamza-cy6km
@AmeerHamza-cy6km 3 года назад
I have to write to existing xlsx file
@toipham3227
@toipham3227 5 лет назад
great video! thank you a lot!
@gmfer9604
@gmfer9604 3 года назад
The video is very clear, thank you. When I try this using SQL Server I get this error: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type nvarchar to bigint. (SQL: select top 1 * from [schedules] where [schedules].[id] = import) No matter what I do, cannot pass it. It is an issue with the Database? Thanks for the help.
@gmfer9604
@gmfer9604 3 года назад
Already figured it out. Was a routing issue.
@andryayiik4895
@andryayiik4895 5 лет назад
what text editor didyou use on this video?
@LaravelDaily
@LaravelDaily 5 лет назад
PhpStorm
@marceloferreira6497
@marceloferreira6497 5 лет назад
Hello, I can not do this! Can you help me? I realize that this is your job, and time is money, I would pay for work, I'm waiting for an answer.
@toipham3227
@toipham3227 5 лет назад
what is the bugs. send here and i'll fix it for you (free)
@SamiMansour
@SamiMansour 5 лет назад
Amazing, Is there coupon code available?
@LaravelDaily
@LaravelDaily 5 лет назад
Just generated a friendly 10% code for you: SAMI10 (or someone can use it if they see it first) :)
@SamiMansour
@SamiMansour 5 лет назад
@@LaravelDaily Thank you :) i win it :)
@samhk2222
@samhk2222 5 лет назад
You could use the method updateOrCreate from laravel.com/docs/5.7/eloquent#updates right?
@LaravelDaily
@LaravelDaily 5 лет назад
Yes, if you want to create new entries in your Excel and import them back, then this method would be very useful.
@Поставщик-ф5ю
@Поставщик-ф5ю 5 лет назад
But how to export in csv
@SinghatehAlagie
@SinghatehAlagie 4 года назад
just change the extension
@lolo5787
@lolo5787 5 лет назад
very nice
@alejandrolandaverde9112
@alejandrolandaverde9112 4 года назад
Somebody here work this with mondb?
Далее
How to import & export excel with laravel 9
11:33
Просмотров 9 тыс.
[Live-Coding] Laravel Multi-Tenancy with Single Trait
16:01
Laravel Excel Export Import | Laravel tutorial
25:57
Просмотров 10 тыс.
Handling Exceptions in Laravel Excel Import
7:37
Просмотров 19 тыс.
How to Bulk Insert Data With Laravel
23:42
Просмотров 10 тыс.
So I've tried 3 popular Laravel CMSs...
17:53
Просмотров 3,3 тыс.