Read any Excel File using PHPExcel in PHP

Download the source code here

[@ebusiness7230]

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

[@marthajsayers8146]

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

[@kimiyosakura7873]

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

[@Ariel_Fernandez]

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

[@Guacatate]

excelent video, congratulations!

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

[@raashidvz5100]

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

[@AkshayPawar-uu8kf]

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

[@omarelrafhi9595]

very good video, thanks !

[@sivakumar-uf3pv]

Super & thanks

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

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

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

Excellent

[@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?

[@wisdomguy9837]

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

[@gauripawar4808]

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

[@skayteurted8727]

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

[@itandlife572]

Thanks friend

[@saimani9860]

is possible excel to dat file conversion using php

[@mamunamri2696]

How if there are any sheets in one file?

[@levianlp]

thank you!

[@flickerspot]

Thank you

[@frenchimp]

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

[@akashrajendran3862]

Does it read images too?

[@strangeguyoftheinternet151]

Does this work online on sites like 000Webhost?

[@ifrakouser6316]

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

[@somorontv8114]

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

[@damiano.447]

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

[@jakethe3z1kk59]

use loops

[@pozhiltimes9420]

Is this works for php 7 version? ?

[@jonathanbernal6980]

yess 7.3>= is deprecated

[@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) {

[@hellobraundesign]

1 000 000$ Man!

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

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

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

0:36

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

[@emmanuelepiscope4853]

Thank you

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