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

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!

Merci c'est cool

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');

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

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

very clear and easy to understand. Thanks alot

Que grande eres. Muchas Gracias

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

Thanks GemaCode. This was helpful to me today

Very helpful, thank you!

Buen video. Muchas gracias!! ♥

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?

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

very useful. thanks bro!

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

Thank you!!

ME HA SERVIDO DE MUCHO

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

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

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

tnx, its the best PHPSpreadsheet tutorial

Thanks for the video bro, very much needed for me