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

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

　　

http://www.bkjia.com/PHPjc/735881.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/735881.htmlTechArticlePHPExcel - Excel的PHP处理引擎 PHPExcel 提供了一系列的 PHP语言 类，让你可以轻松地读写操作以下格式的文件：.xls/.xlsx/.csv/.ods/Gnumeric/PDF/HTML... 主...