PHP操控Excel视频教程

• Chapter1 Course introduction
• 1-1 Introduction to PHPExcel
• Chapter2 Preliminary preparation
• 2-1 Download the PHPExcel plugin
• 2-2 Configure virtual domain name
• 2-3 How to handle WAMP environment startup failure
• Chapter3 Quick Start Example
• 3-1 Export file step analysis using PHPExcel
• 3-2 Implementation using PHPExcel export file code
• Chapter4 PHPExcel exports MySQL database data
• 4-1 MySQL configuration file writing
• 4-2 Read data and output to local file for saving
• 4-3 Output to browser
• Chapter5 Excel style control (1)
• 5-1 demand analysis
• 5-2 PHPExcel query student information
• 5-3 PHPExcel populates student information
• 5-4 PHPExcel fills class grade information
• 5-5 PHPExcel merge cells
• 5-6 PHPExcel text center
• Chapter6 Excel style control (2)
• 6-1 PHPExcel set font
• 6-2 PHPExcel set cell background color
• 6-3 PHPExcel adds borders to cells
• 6-4 Line break in PHPExcel cell
• 6-5 PHPExcel cell format control (extra long number display
• Chapter7 PHP operates Excel to generate graphical reports
• 7-1 Prepare data
• 7-2 Populate data into table
• 7-3 Generate axis scales for linear tables
• 7-4 Draw linear table frame
• 7-5 Add linear table to table and generate Excel file
• 7-6 Display coordinate data on a linear table
• 7-7 Summarize
• Chapter8 PHP import Excel
• 8-1 Read excel file
• 8-2 Partial loading technology implementation
• Chapter9 Course review and notes
• 9-1 Course summary