Make a Table, Styling, and Autofilter in PHPSpreadsheet | PHPSpreadsheet Tutorial #3

[@Lullabyt]

Great, thanks so much for the content. Because of you I was able to build a very powerful report extractor to my costumers exporting data in .xlsx and also .pdf using Dompdf that works along with PHPSpreadSheets. It would be much more difficult if it wasn't for this video. You rock!

[@soyoyeolamide9980]

Thanks GemaCode. This was helpful to me today

[@kaungko7393]

very clear and easy to understand. Thanks alot

[@LuisGonzalez-zl8pm]

Que grande eres. Muchas Gracias

[@douglasfernando3845]

Thank you very much, it helped me a lot.

[@Ohda3su]

For striped rows it's better to use conditional formating as this allow the user to use sorting and filters without breaking the row color order. You helped me to make my xls better ! ty

[@gabrielfreitas4270]

Complementing this comment, use these formulae. Change "A" and "1" so the reference match the first cell in the row where data begin. There is two conditions, one for each stripe color: =MOD(SUBTOTAL(3, $A$1:$A1), 2) = 0 =MOD(SUBTOTAL(3, $A$1:$A1), 2) = 1

[@romansmal7476]

tnx, its the best PHPSpreadsheet tutorial

[@nicolasvallejos4969]

Very helpful, thank you!

[@ithielragnaros]

Muchas gracias por el video bro aprendi dos cosas aqui ufff gracias

[@aledc777]

Thank you very much!!! you have helped me a lot!

[@fenozotahinarakotosoa4140]

Merci c'est cool

[@DeZZZle]

Всё очень понятно и наглядно. Спасибо❤️

[@saepuloh475]

very useful. thanks bro!

[@saihemanthjakkula2461]

Thanks for the video bro, very much needed for me

[@maxrivera3275]

Buen video. Muchas gracias!! ♥

[@howtohavesubscribers]

Thank you so much. But in case am working with a file that already contains merged cells, how do i detect if cells are merged or not?

[@jesusedwarmelendezdiaz5815]

is it possible to apply filter only for columns B, G F ?

[@carlosband5143]

Thank you... it was not what i need, but gave me some idea. I just need to create an EXCEL spreadsheet and formated a Cell with the color given by a seting color in my table DB named "color-show". Sorry for my poor english. I am brazilian and dont speak it well

[@ShurekHam]

Você quer saber como que pinta uma célula com uma cor específica é isso? Já conseguiu?

[@carlosband5143]

@@ShurekHam já consegui resolver.... se precisar posso detalhar o que fiz.

[@brayenes]

thanks bro, but how, if i want to add description under table like signature or text

[@carlosdelgado16931]

Thank you!!

[@olegbakum4872]

Is there an opportunity to set filters (pivot table) with PHPSpreadsheet directly?

[@ithielragnaros]

para el color y el color de fondo me sirvio mucho para el auto filtro lo saque de la documentacion $spreadsheet->getActiveSheet()->setAutoFilter('A1:E20');

[@hermain-vm]

Hola, la sacaste de la codmentacion official o de gitgub?

[@jorgeherrera6895]

ME HA SERVIDO DE MUCHO