PHP quickly controls Excel PhpSpreadsheet-Free online video tutorial-php.cn

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

PHP quickly controls Excel PhpSpreadsheet

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

Intermediate

71659 person learning

16 class hour

02 hours 12 minutes 28 seconds Total course duration

2022-04-28update

欧阳克

Gold lecturer

A total of 9 coursesStudent2762 Lecturer rating5.7

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

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

Data Nameoperate
[must see]PhpSpreadsheetExclusive for paid users

[must see]PhpSpreadsheet02Exclusive for paid users

欧阳克 Lecturer Other Courses

Elementary VuePress: Create a Vue static website in 30 minutes

15810
Collection
Elementary VuePress: Vue's official static website generator speed guide

8438
Collection
Intermediate Getting started with Angular js

30629
Collection
Elementary Variety of small programs

27037
Collection
Elementary PHP job interview tips

6711
Collection
Intermediate Online examination system practice

26555
Collection
Intermediate Store numbering system based on TP6

38072
Collection
Intermediate Online registration system (mobile terminal) practice

79586
Collection
Intermediate Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]

96057
Collection

Delivery price：￥9

favor

Opening a VIP only requires￥ 7 Save ￥ 2

discount

VIP member exclusive VIP 60+ courses are free to watch

Coupon

Participate in the full reduction promotion The specific usage regulations are based on coupons

Buy Now

This course includes：

02 hours 12 minutes 28 seconds Watch videos anytime

2 Download Resources

Popular courses Latest courses

More>

About us Disclaimer Sitemap: php.cn：Public welfare online PHP training，Help PHP learners grow quickly！