Update of my status. My system is now working fully. Thank you very much for this tutorial. My previous problem was due to i was using a excel templates which had vba scripts on it which i did not created. But after i creating a fresh excel templates the codes starts working 100% in first chance. Again thank you.
@gabrielmh20134 жыл бұрын
Hola, gracias por tus vídeos, me ayudaron mucho, yo estaba usando phpexcel y tuve que mudarme a phpspredsheet por falta de herramientas. Un favor, podrías mostrar un ejemplo donde pueda clonar celdas, agregar saltos de pagina, y leer el nombre de las hojas dentro de una plantilla.
@ChefOtang3 жыл бұрын
this is what Im looking for, thank you
@barbarazavaleta52645 жыл бұрын
Nice tutorial so helpful i wish you culd make a how to insert xlsx data into database video, thanks in advance!
@romantrahtenberg51195 жыл бұрын
Hello from Russia!))) when you make a video in which you tell how to get data from a file excel and processing it in php, next load it into the database?
@rhaystrike4 жыл бұрын
hello, thank you very much for the explanation, could you upload the file from chapter 4 to google drive?
@ranadeepjash11505 жыл бұрын
hi my case excel is downloading but in corrupted format. and in notepad++ the downloaded excel showing following problem " Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\sdrf\excel\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Cell\Cell.php on line 329 " kindly help me.i have not found any maximum execution parameter in cell.php. also change php.ini file max_execution_time to 3000 second. But not worked.
@RamyaP-k8t16 күн бұрын
Hi I added like same. but in my file once i opened and after clicking the cell only , conditional formatting of yellow color text changed. actually i want to email the excel with conditional formatting. can you pls help me
@osvaldobanze18455 жыл бұрын
Muito obrigado ajudou-me muito.
@dgatica2 жыл бұрын
cuando intento cargar el templateme arroja este error, puedes ayudarme ? Fatal error: Constructor PhpOffice\PhpSpreadsheet\Reader\Xlsx\Styles::__construct() cannot declare a return type in D:\xampp\htdocs\dlogger\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx\Styles.php on line 18
@walderb.andriola62355 жыл бұрын
Hi, Great job! How to insert image into cell? Thanks.
@jahfartv3 жыл бұрын
very good video, same library suitable for server (online)? local server ok but online error coming....
@AlejoElGunner4 жыл бұрын
You rock! thanks :D
@diagknowstech4 жыл бұрын
hi sir .... this vid is so helpful... i just want to ask if there is a way to also insert image from the template....
@hygisonbrandao92513 жыл бұрын
can you teach how to hide columns as well please?
@clashwiththepa2504 жыл бұрын
why shapes missing php excel? my template have a shapes but after downloading shapes are not visible.
@flutterrun6703 жыл бұрын
hello i want to ask if who had an idea on how to put a red color in the cell column if no given data in the database
@rushabhchhantbar90295 жыл бұрын
Data base data fatch and horizontal total print after conversation to excel and excel in print horizontal total
@jhesuslegarda40265 жыл бұрын
I have an issue: PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\phpdemos\excel3.php on line 15 Can you giveme an idea of what us happening? because I'm following all the tutorial steps.
@SalientAnimal5 жыл бұрын
I keep getting an error when trying to open the file :Excel cannot open the file 'template.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the file format of the file. Any help here? I was able to successfully work through the first 3 Tutorials without any issues, it's only now that I am trying to use the template created.
@SalientAnimal5 жыл бұрын
@@GemaCode Thank you I managed to get it to work. I looks like it failed because the template I had setup had multiple worksheets. When I removed the additional worksheet it worked. Is there a way to use a template with multiple worksheets and then to populate your data onto specific sheets only? Also, can one then include the script into a PHPMAiler Script where the result is then automatically e-mailed to a recipient?
@gkdada674 жыл бұрын
Sir I need a date format to Excel to MySQL need help sir
@yeimerpinedo84024 жыл бұрын
How do I close the Excel document after going through it?
@diagknowstech4 жыл бұрын
sir how about reading spreadsheet to database
@hairieamin46514 жыл бұрын
why did my downloaded excel file is in invalid format? i did everything right, i think
@diagknowstech4 жыл бұрын
i had that issue... i ried using csv and then i saw the error.. turns out it was just a typographical error.
@dijiflex5 жыл бұрын
I have problem. Everything is working on the local server but when i upload it to the live server i get a syntax error on one of the phpspreadsheet files. i have confirmed that i am using php version 7.0 on my cpanel Parse error: syntax error, unexpected '=' in /home/kyucuco1/*************/user/includes/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line 2460
@dijiflex5 жыл бұрын
i got the problem it was mine, i realized that for data coming from the database i had use while loop the way you did. Othewise thanks
@dijiflex5 жыл бұрын
@@GemaCode And please can you make a video on how to use phpspreadsheets for pdf generation