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

Подписаться 5 тыс.

Просмотров 20 тыс.

50% 1

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/PHPOffice/PhpSprea...
Source Code : bit.ly/3hYdT0F
Music :
+ Golden By. Vibe Tracks
+ Faith By. Vibe Tracks
+ TFB9 By. Vibe Tracks
+ How it Began By. Silent Partner

Наука

Опубликовано:

11 апр 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 27

@douglasfernando3845 Месяц назад

Thank you very much, it helped me a lot.

@romansmal7476 4 года назад

tnx, its the best PHPSpreadsheet tutorial

@kaungko7393 Год назад

very clear and easy to understand. Thanks alot

@aledc777 4 года назад

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

@fenozotahinarakotosoa4140 Год назад

Merci c'est cool

@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 2 года назад

Thanks GemaCode. This was helpful to me today

@nicolasvallejos4969 2 года назад

Very helpful, thank you!

@saihemanthjakkula2461 5 лет назад

Thanks for the video bro, very much needed for me

@DeZZZle 3 года назад

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

@maxrivera3275 2 года назад

Buen video. Muchas gracias!! ♥

@LuisGonzalez-zl8pm Год назад

Que grande eres. Muchas Gracias

@saepuloh475 3 года назад

very useful. thanks bro!

@ithielragnaros Год назад

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

@carlosdelgado16931 4 года назад

Thank you!!

@Ohda3su 3 года назад

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

@jorgeherrera6895 4 года назад

ME HA SERVIDO DE MUCHO

@howtohavesubscribers 2 года назад

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?

@olegbakum4872 4 года назад

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

@jesusedwarmelendezdiaz5815 Год назад

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

@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 7 месяцев назад

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

@carlosband5143 4 года назад

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