phpexcel图形图表(一)入门

PHPExcel - Excel的PHP处理引擎

PHPExcel 提供了一系列的 PHP语言 类，让你可以轻松地读写操作以下格式的文件：.xls/.xlsx/.csv/.ods/Gnumeric/PDF/HTML...

主要功能包括：设置文件的meta信息，多工作表，定制字体和样式，边框和填充，图片，计算公式，转换文件类型等等

之前我只是用到了导出数据到列表格式的Excel文件，这次需要实现的目标是：JSON->phpexcel->excel+chart(line/pie/etc...)

立即学习“PHP免费学习笔记（深入）”；

本系列《phpexcel图形图表》文章梗概如下：

phpexcel图形图表(一)-入门----------------介绍PHPExcel类库和画图的基本步骤

phpexcel图形图表(二)-图形----------------以最常用的line/pie/bar/radar图形为例作图，并对比和分析4种API

phpexcel图形图表(三)-进阶----------------让图形美化，完成一些高级的效果

phpexcel图形图表(三)-高级----------------PHPExcel能完成的图表相关的高级功能

原创文章，转载请注明出处：http://www.cnblogs.com/phpgcs

本篇文章梗概：

1. 下载并研究PHPExcel仓库

2. PHPExcel画图和普通数据处理的区别

3. 注意事项总结

首先最好是把PHPExcel的项目下载到本地来研究

1

git clone git@github.com:PHPOffice/PHPExcel.git

请先仔细阅读README.md说明文档，因为里面包含了很重要的版本信息，尤其是读写Excel文档的版本范围信息

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)

进入Examples文件夹，OhMygod,可以完成这么多的功能呀

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

爱图表

AI驱动的智能化图表创作平台

99

查看详情

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