PHP excel import data into database

thanks for the code sir .. i have one doubt am facing a error ["Trying to access array offset on value of type int in PHPExcel/PHPExcel/Cell/DefaultValueBinder.php on line 90"] ... am using integer number in excel thats why am getting this error could you please help me in this

iss library me brackets ka error aa rha hai...
Now {} for array in php is depricated...
solution is use [ ]

I'm very must impress with your lecture, can you please make video to retrieve import Google sheets data to MySQL once we submit through form automatically

Array and string offset access syntax with curly braces is no longer supported in PHPExcel\Shared\String.php

sir i need help, in java for
data import into database by java servlet or jsp/jsf.

Sir, I am trying to use this but I am getting this error
Warning: Trying to access array offset on value of type int in C:\xampp\htdocs\uploads\PHPExcel\PHPExcel\Cell\DefaultValueBinder.php on line 89
PLs help me sir

Your video always become best and best . 👍

Multiple sheets ho to ?

Hello,
I want my excel column names to be remained in my excel file. Suppose I want Name attribute of my excel not to be removed. How can I do it? Is there any change in "getCellByColumnAndRow" ?

for($i=2;$i<=$getHighestRow;$i++) use this loop for skip excel heading

how to update from csv file sir ?

Hello sir! I have php8.1.2 version . I am installing PHPExcel1.8.1 for importing Excel file into databases but this library shows many error , I have resolved many error but there are more error also left. Sir please give me some suggestions how can I overcome this problem

I have no idea what you are saying. This does not sound like English

How can we do this with laravel ... Anyone please answer

sir image ko kaise import karege

Sir mere Excel me 2 excel sheet hai aur mujhe one by one krke dono hi import krni hai every sheet me 80000 rows hai to kaise kren

Thanks...it helped me a lot.

Hello sir , i think it will upload duplicate data too.

input as date in the same excel what should we do ?

Dear vishal, 

I am from Bangladesh and i am a big fan of your php programming.

I have a request to you if you have enough time please make a video onthis topic. 


Topic: Recently i am learning web development.  I downloaded some open source softwares source code for practice.  But when i want to edit html directory,  it shows access denied for this directory.  My point is how i can hide my codea also like this so that i can stay safe if i make something important? 



I know you are busy,  bug if you give me just a clue on how to start learning on this issue i will be greatly appreciated to you. 


Thank you

If duplicate email also exist on excel sheet then ignore this record to insert into my table. Please help?

Sir i am getting 500 error using your code

Hat's off sir thank you for this video

Hi sir,
Is possible in php .xlsx to .dat file conversation

Sir ,
Warning: require(PHPExcel/PHPExcel.php) [function.require]: failed to open stream: No such file or directory in C:\xampp\htdocs\Excel\Import\index.php on line 8

Fatal error: require() [function.require]: Failed opening required 'PHPExcel/PHPExcel.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\Excel\Import\index.php on line 8 how can I solve dis? PLZ HELP.

import me 500 se jyada row import nahi ho raha sir. help.. anyone??

thank you sir

Bhai. Excel sheet par, agar, muje, hindi fonts, like utf8 add karnna he, jo upload karneke bad, muje database pe ???? ???? Question mark atha he, is to upload karne ke time, utf8 pe convert karne keliye kya code ligna ?

vishal sir is our dictionary

main do se jada column import krta hu to ye error milta hai
Fatal error: Array and string offset access syntax with curly braces is no longer supported in C:\xampp\htdocs\login\PHPExcel\PHPExcel\Shared\String.php on line 529

Laravel me kaise kare unicode language ke saath

Thanks ♥

Sir PHPExcel\Shared\String.php me line no. 529 per error hai kase solve karenge please help.
Maine aap wale ko as it is run kiya hai aur phpexcel ko download kiya hai usme bhi same error hai

Fatal error: Array and string offset access syntax with curly braces is no longer supported in C:\xampp\htdocs\php\excel\import\PHPExcel\PHPExcel\Shared\String.php on line 529
so help me

Fatal error: Array and string offset access syntax with curly braces is no longer supported in D:\xampp\htdocs\import\PHPExcel\PHPExcel\Shared\String.php on line 529

there's a error.. pls help me sir

Good job bro, but I have a bug when I'm trying to read integer data, I have received this message : Trying to access array offset on value of type int in C:\xampp\htdocs\pnc2 - Copie\admin\PHPExcel\PHPExcel\Cell\DefaultValueBinder.php on line 86

Anyone can help me
thnkx a lot

Fatal error: Array and string offset access syntax with curly braces is no longer supported in C:\xampp\htdocs\account\import1\PHPExcel\PHPExcel\Shared\String.php on line 529

sir upload karne pe yeh error a rahi hai

Wow Sir, You are amazing your teaching style is the best that it made this code very easier to understand, thanks a lot for sharing knowledge, May God always bless you :)

How to upload hindi language/multi language data in excel.

thanks man

Ye bahut usefule tha.leking agar mujhe row ko validate krna ho to kaise krenge

How to do this task in laravel

Sir please provide me solutions localhost par chal raha h server par upload kar raha hua to nhi chal raha h data insert nahi ho raha h database mein

Wonderful video

PhpExcel is dead.Outdated knowledge se kisi ka fayda nhi hota.Sirf views ke liya Hume pagal bana rahe ho.Waise agar pta na ho to bta du an PhpSpreadsheet use hoti h

sir really thnks
all code is working

Sir I'm not unable to import data from Excel when I'm including library it is showing page is not working

Sir, is it possible to upload photos this way from excel file.