Read any Excel File using PHPExcel in PHP

Download the source code here

[@Ariel_Fernandez]

Thanks friend, well explained, thanks for zooming in on the code, it's well readable, thanks.

[@mardocheegovesse9520]

For the fatal error concerning string.php change {} to []
Concerning the error of default .... Change the line 82 To this line } elseif (0 === strpos($pValue, '=') && strlen($pValue) > 1) {

[@lungten7673]

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

[@maha123grindi4]

i have the same error

[@okmaga]

downgrade your php version, i am using mamp which show me 2 version of php to select, in v8 getting same problem but switching to v7 works fine

[@SuperBlackboy2]

there's only a few of those errors. I just went through and changed every instance of a {} to []. That should fix it and not take too long.

[@carlos.rdveloz]

As ImperialN17 said, just go to string.php file and change all $str{$i} to $str[$i] in every lines where the error is shown

[@Guacatate]

excelent video, congratulations!

[@raashidvz5100]

Sir this is not working in latest version of php , can you please do a video how to do it in updated version🙏🙏🙏

[@JitendraRajput-yo1ds]

Sir date not read proper manner it was converted into strings so I want to date as same formate how can be possible

[@dharmahendra5424]

what if I want to add a file upload button to read excel files?
sorry if my english is bad

[@Производственнаягимнастика]

How to import if cells are merged in the file?

[@mamunamri2696]

How if there are any sheets in one file?

[@raashidvz5100]

Fatal error: Uncaught Error: Class "ZipArchive" not found in C:\xampp\htdocs\AMS\practice\Classes\PHPExcel\Reader\Excel2007.php:85 Stack trace: #0 C:\xampp\htdocs\AMS\practice\Classes\PHPExcel\IOFactory.php(269): PHPExcel_Reader_Excel2007->canRead('Book1.xlsx') #1 C:\xampp\htdocs\AMS\practice
eadExcel.php(19): PHPExcel_IOFactory::createReaderForFile('Book1.xlsx') #2 {main} thrown in C:\xampp\htdocs\AMS\practice\Classes\PHPExcel\Reader\Excel2007.php on line 85
Sir ,can you please help me to correct this error...........

[@flickerspot]

Thank you

[@levianlp]

thank you!

[@strangeguyoftheinternet151]

Does this work online on sites like 000Webhost?

[@damiano.447]

bro, how can I print a specific range of rows?

[@jakethe3z1kk59]

use loops

[@hellobraundesign]

1 000 000$ Man!

[@pozhiltimes9420]

Is this works for php 7 version? ?

[@jonathanbernal6980]

yess 7.3>= is deprecated

[@rv_channel8665]

Hlo sir, iam getting error in PHPExcel\shared\string.php

[@rv_channel8665]

Sir plzz give solution for this it is soo importent😞😞

[@rv_channel8665]

Sir plzzzzzz sir

[@jaysoncainglet8456]

@@rv_channel8665 go to that file and then change the {} to []

[@rv_channel8665]

@@jaysoncainglet8456 tq sir for ur ripley, but iam changed and I got output alredy but it was soo good sir tq fir sharing a such of information

[@marthajsayers8146]

Thank you! EXCELLENT video and you explained it very well! Prayers for you!!

[@l._.mr.vedant._.l]

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

[@ebusiness7230]

thank you man , you saved my project, i will pray for you

[@gauripawar4808]

Sir I am getting the error $excelReader is undefined variable. Sir please help me what to do

[@frenchimp]

Hi, gerat video. However phpexcel is 'dead' and phpspreadsheet requires using composer. I don't have composer. Can I install phpsspreadsheet by hand?

[@somorontv8114]

Please make us video
How to see mysql username or password or datebase on siteground please thanks for your all vidoes

[@wisdomguy9837]

What if an excel file with formulas? Can use an excel with formulas does the formulas work with the browser?

[@AkshayPawar-uu8kf]

very informative, but if we change the value of excel will this automatically get updated to php and website ??

[@ifrakouser6316]

I cudn't read a single field 😣 ....plz help me out

[@saimani9860]

is possible excel to dat file conversion using php

[@dirtymcfly6354]

unfortunately the "PHPExcel.php" does not work anymore with all the new Versions because of following Error: :D

[@dirtymcfly6354]

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

[@skayteurted8727]

merci mais il y a un souci pour lire les dates ca provoque des erreurs

[@sivakumar-uf3pv]

Super & thanks

[@itandlife572]

Thanks friend

[@cloudrebue4446]

Sir I am looking for a way I can send a message from excel by looping through the entire excel and replace a string with the actual value like
Dear {{NAME}}, please pay your balance of {{AMOUNT}}
Where NAME and AMOUNT is the 1st row. I want the message to contain the actual value of the cell eg
Dear JOHN, please pay your balance of $1000

[@jinujawad]

Programmatically u can do that, what type of message u need to send. U mean sms?
And from where does u fetch name and amount?

[@cloudrebue4446]

@@jinujawad I am fetching everything from excel, I have a form textarea where someone writes a message with the merge tags i.e the tcolumn headings, my work is to loop through the entire excel and replace my column headings inside the textarea with exact column values then insert them in a db

[@emmanuelepiscope4853]

Thank you

[@akashrajendran3862]

Does it read images too?

[@مسلمرفاعي-ه6ك]

Excellent

[@omarelrafhi9595]

very good video, thanks !

[@ВикаБаринова-п2ы]

0:36

[@kimiyosakura7873]

Thank you for your excellent video! just follow step by step and its working perfectly. Keep up the good work