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!
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
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
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
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');
It has been 5 years, but the video still helping people out. Thanks for making this content
Que grande eres. Muchas Gracias
very clear and easy to understand. Thanks alot
tnx, its the best PHPSpreadsheet tutorial
Thanks GemaCode. This was helpful to me today
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!
Thank you very much, it helped me a lot.
Muchas gracias por el video bro aprendi dos cosas aqui ufff gracias
Very helpful, thank you!
Thank you very much!!! you have helped me a lot!
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
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
Buen video. Muchas gracias!! ♥
Всё очень понятно и наглядно. Спасибо❤️
very useful. thanks bro!
Thanks for the video bro, very much needed for me
Merci c'est cool
is it possible to apply filter only for columns B, G F ?
thanks bro, but how, if i want to add description under table like signature or text
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?
Is there an opportunity to set filters (pivot table) with PHPSpreadsheet directly?
Thank you!!
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
Você quer saber como que pinta uma célula com uma cor específica é isso?
Já conseguiu?
@@ShurekHam já consegui resolver.... se precisar posso detalhar o que fiz.
ME HA SERVIDO DE MUCHO
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');
Hola, la sacaste de la codmentacion official o de gitgub?