Make a Table, Styling, and Autofilter in PHPSpreadsheet | PHPSpreadsheet Tutorial #3
HTML-код
- Опубликовано: 28 сен 2024
- Hi everyone. Welcome to my php tutorial video.
in this video i'm about to explain how to deal with data types in PHPSpreadsheet.
which are string, numbers, boolean, date, rich text, and hyperlink.
in this video you will also learn how to set default fonts, set column width to auto size, how to read the documentation, how to use PHPSpreadsheet classes, and change worksheet name.
this video is a part of a tutorial series, so make sure to watch the previous version if you haven't already done so.
Watch all PHP Excel series here : goo.gl/j37ds6
Watch all PHP Office series here : goo.gl/VrLYkd
PHPSpreadsheet : github.com/PHP...
Source Code : bit.ly/3hYdT0F
Music :
+ Golden By. Vibe Tracks
+ Faith By. Vibe Tracks
+ TFB9 By. Vibe Tracks
+ How it Began By. Silent Partner
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.
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
Thanks GemaCode. This was helpful to me today
Muchas gracias por el video bro aprendi dos cosas aqui ufff 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?
Buen video. Muchas gracias!! ♥
tnx, its the best PHPSpreadsheet tutorial
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 very much!!! you have helped me a lot!
Merci c'est cool
Is there an opportunity to set filters (pivot table) with PHPSpreadsheet directly?
very clear and easy to understand. Thanks alot
Thanks for the video bro, very much needed for me
Que grande eres. Muchas Gracias
Very helpful, thank you!
very useful. thanks bro!
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?
Всё очень понятно и наглядно. Спасибо❤️
ME HA SERVIDO DE MUCHO
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.