Name: PHP quickly controls Excel PhpSpreadsheet
Uploaded: 2022-04-28T18:07:24+8:00
Duration: 132 min 28 s
Description: The old PHPExcel has stopped updating! The latest one currently is using the phpOffice plugin PhpSpreadsheet, a library written in pure PHP that provides a set of classes that allow you to read and write different spreadsheet file formats! PHP Chinese website teacher Ouyang Ke’s original course! Note: PHP running environment requires PHP7.1 or above

欧阳克

Gold lecturer

A total of 9 courses Student2762 Lecturer rating5.6

温故而知新，可以为师矣。博客：www.ouyangke.comMore>>

Course Introduction Course Outline Data Download Other Courses

You will learn：

PhpSpreadsheet manipulates spreadsheets

PHP quickly controls Excel PhpSpreadsheet

Chapter1 Introduction to PhpSpreadsheet
expand retract

Section1 What is PhpSpreadsheet
duration： 04 minutes 40 seconds

Section2 Install PhpSpreadsheet
duration： 05 minutes 50 seconds
Chapter2 Basic operations of PhpSpreadsheet
expand retract

Section1 Get workbook Get cells
duration： 07 minutes 33 seconds

Section2 Set cells
duration： 09 minutes 31 seconds
Chapter3 PhpSpreadsheet enhanced operations
expand retract

Section1 Set cell style
duration： 07 minutes 23 seconds

Section2 Set cell color and data type
duration： 10 minutes 31 seconds
Chapter4 PhpSpreadsheet batch operations
expand retract

Section1 table formula
duration： 08 minutes 07 seconds

Section2 Merge and split cells
duration： 11 minutes 17 seconds

Section3 Set cell height and width
duration： 08 minutes 46 seconds
Chapter5 PhpSpreadsheet workbook
expand retract

Section1 xlsx file download
duration： 06 minutes 47 seconds

Section2 xls file download, set title
duration： 07 minutes 00 seconds
Chapter6 PhpSpreadsheet in practice
expand retract

Section1 Actual combat 1
duration： 12 minutes 18 seconds

Section2 Actual combat 2
duration： 06 minutes 01 seconds

Section3 Actual combat 3
duration： 07 minutes 09 seconds

Section4 Actual combat 4
duration： 13 minutes 19 seconds

Section5 Actual combat 5
duration： 06 minutes 16 seconds