Phpexcel graph (1) getting started. PHPExcel-the PHP processing engine PHPExcel provides a series of PHP language classes, allowing you to easily read and write files in the following format: .xls.xlsx.csv. odsGnumericPDFHTML... PHP processing engine for main PHPExcel-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 meta information of a file, multiple worksheets, custom fonts and styles, borders and fills, pictures, calculation formulas, and conversion file types.
Previously, I only used an Excel file to export data to the list format. The goal of this operation is: JSON-> phpexcel-> excel + chart (line/pie/etc ...)
This series of phpexcel graphic charts provides the following synopsis:
Phpexcel graph (1)-Getting Started ---------------- describes the basic steps of PHPExcel class library and drawing
Phpexcel graph (2)-graph ---------------- use the most commonly used line/pie/bar/radar graph as an example to plot and compare and analyze four APIs
Phpexcel graph (3)-Advanced ---------------- beautify the graph and complete some advanced effects
Phpexcel graphic charts (III)-Advanced functions related to charts supported by PHPExcel
Original article, reproduced please indicate the source: http://www.cnblogs.com/phpgcs
Summary of this article:
1. download and study the PHPExcel repository
2. differences between PHPExcel and common data processing
3. Summary
First, it is best to download the PHPExcel project to the local for research.
1
Git clone git@github.com: PHPOffice/PHPExcel. git
Read README. md carefully because it contains 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 and OhMygod. you 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-demo.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
Well, this job is a chart. we should start with line chart, and there is only one *** line. php file.
Run the following command:
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
Http://www.bkjia.com/PHPjc/735881.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/735881.htmlTechArticlePHPExcel-Excel's PHP processing engine PHPExcel offers a series of PHP language classes that allow you to easily read and write files in the following formats :. xls /. xlsx /. csv /. ods/Gnumeric/PDF/HTML... main...