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

70469 person learning

16class hour

02 hours 12 minutes 28 secondsTotal course duration

2022-04-28update

欧阳克

Gold lecturer

A total of 9 courses Student2762 Lecturer rating5.1

温故而知新，可以为师矣。博客：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

Data Name operate
[must see]PhpSpreadsheet Exclusive for paid users

[must see]PhpSpreadsheet02 Exclusive for paid users

欧阳克 Lecturer Other Courses

ElementaryVuePress: Create a Vue static website in 30 minutes

15222
Collection
ElementaryVuePress: Vue's official static website generator speed guide

8112
Collection
IntermediateGetting started with Angular js

29690
Collection
ElementaryVariety of small programs

26620
Collection
ElementaryPHP job interview tips

6433
Collection
IntermediateOnline examination system practice

25876
Collection
IntermediateStore numbering system based on TP6

37452
Collection
IntermediateOnline registration system (mobile terminal) practice

78414
Collection
IntermediateGetting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]

95402
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！