Very nice. But i got few questions. Lets say i want to rearrange the file columns or if i want add ruppee symbol before price for certain columns; how we do do that? Would be really greatful.
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
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 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
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) {
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
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...........
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
thank you man , you saved my project, i will pray for you
Thank you! EXCELLENT video and you explained it very well! Prayers for you!!
Thanks friend, well explained, thanks for zooming in on the code, it's well readable, thanks.
Very nice. But i got few questions. Lets say i want to rearrange the file columns or if i want add ruppee symbol before price for certain columns; how we do do that? Would be really greatful.
excelent video, congratulations!
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
i have the same error
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
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.
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
Thank you for your excellent video! just follow step by step and its working perfectly. Keep up the good work
what if I want to add a file upload button to read excel files?
sorry if my english is bad
Excellent
Sir date not read proper manner it was converted into strings so I want to date as same formate how can be possible
Super & thanks
very informative, but if we change the value of excel will this automatically get updated to php and website ??
How to import if cells are merged in the file?
very good video, thanks !
How if there are any sheets in one file?
is possible excel to dat file conversion using php
Thanks friend
What if an excel file with formulas? Can use an excel with formulas does the formulas work with the browser?
Does it read images too?
merci mais il y a un souci pour lire les dates ca provoque des erreurs
Does this work online on sites like 000Webhost?
Sir this is not working in latest version of php , can you please do a video how to do it in updated version🙏🙏🙏
bro, how can I print a specific range of rows?
use loops
Thank you
Hi, gerat video. However phpexcel is 'dead' and phpspreadsheet requires using composer. I don't have composer. Can I install phpsspreadsheet by hand?
thank you!
Is this works for php 7 version? ?
yess 7.3>= is deprecated
Hlo sir, iam getting error in PHPExcel\shared\string.php
Sir plzz give solution for this it is soo importent😞😞
Sir plzzzzzz sir
@@rv_channel8665 go to that file and then change the {} to []
@@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
I cudn't read a single field 😣 ....plz help me out
Please make us video
How to see mysql username or password or datebase on siteground please thanks for your all vidoes
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
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?
@@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
0:36
1 000 000$ Man!
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) {
unfortunately the "PHPExcel.php" does not work anymore with all the new Versions because of following Error: :D
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
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...........
Sir I am getting the error $excelReader is undefined variable. Sir please help me what to do
Thank you
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