Problem 1 - Installation request for phpoffice/phpspreadsheet ^1.13 -> satisfiable by phpoffice/phpspreadsheet[1.13.0]. - phpoffice/phpspreadsheet 1.13.0 requires ext-zip * -> the requested PHP extension zip is missing from your system. :(
Hallo GemaCode, I've this error: Parse error: syntax error, unexpected '$spreadsheet' (T_VARIABLE) in C:\xampp\htdocs\phpspreadsheet\table2.php on line 10. Line10: $spreadsheet = new Spreadsheet();
you help me a lot, thank you for your tutorial. In my case is the error "phpoffice/phpspreadsheet 1.21.0 requires ext-gd * but it is not present." and I open extension "gd" in my php.ini (extension=gd). And solve for me
Hello, I have an excel file that comes with 45 columns, of which I need to delete 37 (not consecutive), how can I do it so that after deleting those columns I save it in mysql. Thank you.
How to 1.protect worksheets and restrict user actions like row and column insertion, deletion, and resizing using php spreadsheet 2.Protect cells using a lock cell feature to restrict user editing action in selected cells using php spreadsheet 3.hide protected formula using php spreadsheet
What if you have already passed other headers that are non xl and you need to pass both? Is it possible to pass the excel headers using Ajax asynchronously?
if u got " Package phpoffice/phpspreadsheet has requirements incompatible with your PHP version, PHP extensions and Composer v ersion: - phpoffice/phpspreadsheet 1.23.0 requires ext-gd * but it is not present." go to C:\xampp\php\php.ini search and uncomment following extension=gd so you should have something like (;extension=gd) to (extension=gd)
Here's the link. Idk why the link is always broken in the video. drive.google.com/drive/folders/0Bz0LtVYVXKGqQWZKWlZqVC05a0k?resourcekey=0-viz4Z7908c9FGWWsgYXSNw
Just here to say.... awesome work. Been trying this for a while, tried multiple different ways and finally decided to give php spreadsheets a try. A godsend.
In the minute 10:56 I have a problem, when i am going to write that code, it doesn't work for me. I've your same code but the headers doesn't work. Any help?
Hi, agree to do a tutorial with phpSpreadSheet explaining the automatic creation of a pivot table in a second sheet from the library of this tutorial? please thank you
Look at this stack over flow post. Explains everything about what you want to do. stackoverflow.com/questions/48767355/how-to-use-phpspreadsheet-without-installation-like-phpexcel
Your video was great, well explained, rich!
Not compatible with office 365 when using IOFactory.
Thanks for the video Gemul!
Thank you very much I confirm that I was able to install it
hey mysql server in xampp wil no longer start after i installed phpspreadsheet and uncommented extension zip and gd .What could be the issue???
Could you please say how can we do this in Drupal?
why is the first export method not recomended ?
how to make text underline?
Problem 1
- Installation request for phpoffice/phpspreadsheet ^1.13 -> satisfiable by phpoffice/phpspreadsheet[1.13.0].
- phpoffice/phpspreadsheet 1.13.0 requires ext-zip * -> the requested PHP extension zip is missing from your system.
:(
coulnt install on my mac but could install it on my pc! :)
Many thanks bro
Gracias fue muy Util...
THX
super:)
Awesome video dude. Everything was explained well. It helped me a lot on my project. Thanks and keep doing this kind of videos. More power!
poor quality of the video thus the client he/she can't see any demonstration
Thank you very much Gemul!, It was very helpful.
Great tutorial! Thank you Gemul!
Hallo GemaCode,
I've this error:
Parse error: syntax error, unexpected '$spreadsheet' (T_VARIABLE) in
C:\xampp\htdocs\phpspreadsheet\table2.php on line 10.
Line10: $spreadsheet = new Spreadsheet();
you help me a lot, thank you for your tutorial.
In my case is the error "phpoffice/phpspreadsheet 1.21.0 requires ext-gd * but it is not present." and I open extension "gd" in my php.ini (extension=gd). And solve for me
Hello, I have an excel file that comes with 45 columns, of which I need to delete 37 (not consecutive), how can I do it so that after deleting those columns I save it in mysql. Thank you.
Thanks for the video now I have the solution to correctly download the document, thanks from Mexico
How to
1.protect worksheets and restrict user actions like row and column insertion, deletion, and resizing using php spreadsheet
2.Protect cells using a lock cell feature to restrict user editing action in selected cells using php spreadsheet
3.hide protected formula using php spreadsheet
What if you have already passed other headers that are non xl and you need to pass both? Is it possible to pass the excel headers using Ajax asynchronously?
if u got " Package phpoffice/phpspreadsheet has requirements incompatible with your PHP version, PHP extensions and Composer v
ersion:
- phpoffice/phpspreadsheet 1.23.0 requires ext-gd * but it is not present."
go to C:\xampp\php\php.ini
search and uncomment following
extension=gd
so you should have something like
(;extension=gd) to (extension=gd)
Thank's a lot!
Amazing Series, Thank you. The source code link is broken, can anyone please upload the source code and share a link here??
Here's the link. Idk why the link is always broken in the video. drive.google.com/drive/folders/0Bz0LtVYVXKGqQWZKWlZqVC05a0k?resourcekey=0-viz4Z7908c9FGWWsgYXSNw
Thanks a million @@GemaCode
Can you please add chapter 4 of this series to the source code? since it only has chapters 1, 2, and 3@@GemaCode
You helped me a lot,Thank you for that.
Is possible to install this library without composer?
Thanks a lot for this excellent tutorial, it real help.
Hi I can't access php spreadsheet can u help? can i get ur email? please thank you
This what I am looking for
Thnx Man!!
thank you
Gemul Channel
it made my day thanks a lot
nice.. really helpful thamks
waa so many things i have to master in one video.. maturnuwun dek
Super helpful! Thank you!
how can read only from first sheet?
Thanks, good explanation
Just here to say.... awesome work. Been trying this for a while, tried multiple different ways and finally decided to give php spreadsheets a try. A godsend.
In the minute 10:56 I have a problem, when i am going to write that code, it doesn't work for me. I've your same code but the headers doesn't work. Any help?
Don't worry, I already fixed it
thanks you so much
que editor de videos usas?
Great tutorial! It was very helpfull. Thank you very much!!
nice video 👏🏼
i love u so much
Thank you!
Thank you!!
Great video tutorial, how can i make same but in CSV file? Thank you!!
fputcsv builtin php function
GREAT WORK SIR. Keep making more of these
Thank you Great video
thank you very very much.
thank you so much man, you have been very helpful to me
Great video tutorial.
Hi, agree to do a tutorial with phpSpreadSheet explaining the automatic creation of a pivot table in a second sheet from the library of this tutorial?
please
thank you
OK no worries
thank you so much
@@GemaCode make it soon please we are waiting
thanks, have a great day
You're welcome. Thanks for the feedback.:)
Well, good day to you too!
Hello, you have any idea how to install PhpspreadSheet on a live server with no SSH access to install Composer?
Look at this stack over flow post. Explains everything about what you want to do.
stackoverflow.com/questions/48767355/how-to-use-phpspreadsheet-without-installation-like-phpexcel