How to Import Data from Excel/CSV File into MySql DB in PHP using PhpSpreadsheet | Insert & Update

[@ngongo934]

i am from VietNam and i thank you so much

[@mdjabedbhuiyan]

I complete your all play list tutorial of funda of web it english.

[@mdjabedbhuiyan]

Your tutorial is so easy to understand. Thanks

[@webeloperuz1669]

i don't know indian language this is video very hard for me

[@FundaofWebITHindi]

You can try with english language:
ua-cam.com/video/LX5KiK7pBmE/v-deo.html

[@mdjabedbhuiyan]

Thanks for create my required tutorial.

[@oumasstabdallah3424]

Thank you brother. you did will actually

[@margaretkanganga4882]

☺
Hi, very good tutorial

[@smarter_by_bit9346]

aap to mano bhagvaan kaa rup hi ho.......shukriyaa bhai

[@mdjabedbhuiyan]

You are real hero. Thanks

[@FundaofWebITHindi]

Thank you. Keep supporting.

[@johnroninocarpio6239]

is the data will not showing up in the main homepage of the website?

[@StatusWorld-pz8ld]

Sir after installing pho spreadsheet its redirecting to index.php if i remove spreadsheet files its works properly, can i know how to fix it

[@VishwasKale51]

xls file format not getting upload, it displaying special char in DB

[@vishnu-h5q]

Hello sir I have a question when you write any name in hindi language it will look like this ???? ?? What is the solution of this

[@trinhthanhhiep9195]

What version of xampp are you using?

[@wplearners8480]

that's very nice but how can we handle date cell in php?

[@neeraj0511]

hello sir
composer install krne ke bad v link se vendor folder create nhi ho rha h
sir, kia krna hoga plz help
sir plz share mail Id for ask Question.

[@bibhanshuyadav]

I am getting some error like this:
Undefined type of phpspreadsheet\IOFactory....
Need help

[@the_power_ride]

Isme index.php file ka. Code kahan se le. Skte hn.... Please reply?

[@akila9168]

I have product excel data along with images. How to import images from an excel file?

[@1149binu]

Sir,If the excel have 2000rows will it work?

[@Shopnomoi]

Hi, very good tutorial
I would like to insert multiple tables from the csv fie
Like some data insert table one, other data insert table 2
how to do that, Could help me?

[@swapnilpatil4994]

How give mobile validation in import

[@mdjabedbhuiyan]

I want to import some student data from csv file but some row column field select form select option. If see an video tutorial. Thanks

[@FundaofWebITHindi]

If you have any suggestion, please do let me know.

[@mdjabedbhuiyan]

Branch option, shift option, version option, session option, group option, class oprion, section option, student type option, those option value take from html form and other some info take csv file. How can i import multiple row in mysqli database. Thanks

[@FundaofWebITHindi]

Can you be little more clear. What is required with small explanation as example.

[@surajopagrahari877]

How to increase limit data import. actually we have face a problem it's only 2000 data import but we want more thousands data import how could possible this ?

[@ashishnath9121]

How to create table instead of insert or update here?

[@ammar-techprofessionalserv4423]

Please I need the source code for study

[@ashinsiby2814]

How to install composer??

[@rajeshtewari6059]

How to import date from excel

[@msa_1439]

hello Bro I am From #Somaliland, English Version of This Lecture is Very Important Please Could you do it for us, please???

[@pratikbhuva4346]

Thanks. very easy to understand. how to start reading from second row? as excel files may have headers

[@kushgada2133]

Did you get to know how to do that ? If yes please guide me

[@trinhthanhhiep9195]

Your requirements could not be resolved to an installable set of packages.
Problem 1
- Root composer.json requires phpoffice/phpspreadsheet ^1.18 -> satisfiable by phpoffice/phpspreadsheet[1.18.0].
- phpoffice/phpspreadsheet 1.18.0 requires ext-gd * -> it is missing from your system. Install or enable PHP's gd extension.
To enable extensions, verify that they are enabled in your .ini files:
- C:\xampp\php\php.ini
You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.
Installation failed, deleting ./composer.json.
can you help me? please!

[@snehadutta2664]

how to download composer

[@bejoapp]

Can you share the source remover?

[@debashishbasu1505]

how to remove excel header??

[@franklingonzalezsierra217]

Hola, no me funciona. Me puede compartir el código?

[@enotechworld112]

Fatal error: Uncaught Error: Class "PhpOffice\PhpSpreadsheet\IOFactory" not found in D:\xampp\htdocs\excel_project\upload_sheet.php:19 Stack trace: #0 {main} thrown in D:\xampp\htdocs\excel_project\upload_sheet.php on line 19
how to fix this error?

[@bibhanshuyadav]

Did you solved this?? I need some help

[@denchaisingmahan]

How to Import Data from PDF and Word

[@msa_1439]

How to Skip Header from Excel Spreadsheet While Uploading to MySQL

[@santoshkp9254]

You can just use a variable i to iterate over all the rows and then use a condition if i==0 then continue; this will skip your header row hopefully.

[@debashishbasu1505]

@@santoshkp9254 please share code

[@santoshkp9254]

@@debashishbasu1505 I would have provided you the code but it very simple you just have to use if($i==0) { continue; } this would surely do the work.

[@debashishbasu1505]

@@santoshkp9254 where it's put this code
After foreach??

[@santoshkp9254]

@@debashishbasu1505 just after your loop. Like
foreach(your expression){
if($i==0){ continue; }
// then wrtite all your logic
}

[@Telugufacts228]

if you that code with you please share it guys

[@markevantorremocha2664]

file of the code pleaseee i really want this

[@nishantnagdeve5431]

i want to ignore first row of excel sheet..

[@shreeharshpandey1055]

Sir, when I am clicking on submit button it's redirecting to code.php page but over there no data is visible and data is not being imported too in the database.(No error is showing on the page of code.php)

[@almosawi32]

Fatal error: Uncaught Error: Class 'PhpOffice\PhpSpreadsheet\IOFactory ... return nothing because not correct composer, php zip extension installed in your server

[@debashishbasu1505]

Undefined index: file

[@debashishbasu1505]

i want to ignore first row of excel sheet..