Home > Backend Development > PHP Tutorial > Getting Started with phpexcel Graphics and Charts (1)_PHP Tutorial

Getting Started with phpexcel Graphics and Charts (1)_PHP Tutorial

WBOY
Release: 2016-07-13 10:37:26
Original
1155 people have browsed it

PHPExcel - PHP processing engine for Excel

PHPExcel provides a series of PHP language classes, allowing you to easily read and write files in the following formats: .xls/.xlsx/.csv/.ods/Gnumeric/PDF/HTML...
Main functions include: setting file meta information, multiple worksheets, customized fonts and styles, borders and fills, pictures, calculation formulas, converting file types, etc.
Before, I only used to export data to Excel files in list format. The goal I need to achieve this time is: JSON->phpexcel->excel+chart(line/pie/etc...)
The outline of this series of articles "phpexcel graphs and charts" is as follows:
phpexcel graphs and charts (1) - Getting started----------------Introducing the PHPExcel class library and the basic steps for drawing
phpexcel graphics chart (2) - Graphics---------------- Take the most commonly used line/pie/bar/radar graphics as an example, and compare and analyze 4 types API
phpexcel graphics chart (3)-Advanced----------------Let the graphics beautify and complete some advanced effects
phpexcel graphics chart (3)-Advanced------------- Advanced functions related to charts that PHPExcel can complete
Original article, please indicate the source when reprinting: http://www.cnblogs.com/phpgcs
Summary of this article:
1. Download and study the PHPExcel repository
2. The difference between PHPExcel drawing and ordinary data processing
3. Summary of precautions
First of all, it is best to download the PHPExcel project locally to study
1
git clone git@github.com:PHPOffice/PHPExcel.git
Please read the README.md documentation carefully first, because it contains very important version information, especially the version range information for reading and writing Excel documents
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
### Reading
* BIFF 5-8 (.xls) Excel 95 and above
* Office Open XML (.xlsx) Excel 2007 and above
* SpreadsheetML (.xml) Excel 2003
* Open Document Format/OASIS (.ods)
* Gnumeric
* HTML
* SYLK
* CSV
### Writing
* BIFF 8 (.xls) Excel 95 and above
* Office Open XML (.xlsx) Excel 2007 and above
* HTML
* CSV
* PDF (using either the tcPDF, DomPDF or mPDF libraries, which need to be installed separately)
## Requirements
* PHP version 5.2.0 or higher
* PHP extension php_zip enabled (required if you need PHPExcel to handle .xlsx .ods or .gnumeric files)
* PHP extension php_xml enabled
* PHP extension php_gd2 enabled (optional, but required for exact column width autocalculation)
 
Enter the Examples folder, OhMygod, can complete so many functions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
01pharSimple.php
01simple-download-pdf.php
01simple-download-xls.php
01simple-download-xlsx.php
01simplePCLZip.php
01simple.php
02types.php
02types-xls.php
03formulas.php
04printing.php
05featuredemo.inc.php
05featuredemo.php
06largescale.php
06largescale-with-cellcaching.php
06largescale-with-cellcaching-sqlite3.php
06largescale-with-cellcaching-sqlite.php
06largescale-xls.php
07readerPCLZip.php
07reader.php
08conditionalformatting2.php
08conditionalformatting.php
09pagebreaks.php
10autofilter.php
10autofilter-selection-1.php
10autofilter-selection-2.php
10autofilter-selection-display.php
11documentsecurity.php
11documentsecurity-xls.php
12cellProtection.php
13calculation.php
14excel5.php
15datavalidation.php
15datavalidation-xls.php
16csv.php
17html.php
18extendedcalculation.php
19namedrange.php
20readexcel5.php
21pdf.php
22heavilyformatted.php
23sharedstyles.php
24readfilter.php
25inmemoryimage.php
26utf8.php
27imagesexcel5.php
28iterator.php
29advancedvaluebinder.php
30template.php
31docproperties_write.php
31docproperties_write-xls.php
32chartreadwrite.php
33chartcreate-area.php
33chartcreate-bar.php
33chartcreate-bar-stacked.php
33chartcreate-column-2.php
33chartcreate-column.php
33chartcreate-composite.php
33chartcreate-line.php
33chartcreate-multiple-charts.php
33chartcreate-pie.php
33chartcreate-radar.php
33chartcreate-scatter.php
33chartcreate-stock.php
34chartupdate.php
35chartrender.php
36chartreadwriteHTML.php
36chartreadwritePDF.php
37page_layout_view.php
38cloneWorksheet.php
40duplicateStyle.php
Excel2003XMLReader.php
Excel2003XMLTest.xml
.gitignore
GnumericReader.php
GnumericTest.gnumeric
images/
list
.~lock.33chartcreate-line.xlsx#
OOCalcReaderPCLZip.php
OOCalcReader.php
OOCalcTest.ods
Quadratic2.php
Quadratic.php
Quadratic.xlsx
runall.php
SylkReader.php
SylkTest.slk
templates/
XMLReader.php
XMLTest.xml
 
 
好吧,这次的任务是chart,就先从 line chart 入手,相关的文件只有一个 ***line.php
 
我们先直接运行一把:
 
1
2
3
4
5
6
liuyuan@ebuinfo:/var/www/projects/PHPExcel/Examples$ php 33chartcreate-line.php 
07:13:22 Write to Excel2007 format
07:13:23 File written to 33chartcreate-line.xlsx
07:13:23 Peak memory usage: 8.75 MB
07:13:23 Done writing file
File has been created in /var/www/projects/PHPExcel/Examples
  

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/735881.htmlTechArticlePHPExcel - Excel的PHP处理引擎 PHPExcel 提供了一系列的 PHP语言 类,让你可以轻松地读写操作以下格式的文件:.xls/.xlsx/.csv/.ods/Gnumeric/PDF/HTML... 主...
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template