phpexcel图形图表(一)入门

PHPExcel - Excel的PHP处理引擎

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

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

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

本系列《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

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

  



郑重声明:本文版权包含图片归原作者所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们(delete@yzlfxy.com)修改或删除,多谢。

郑重声明:本文版权归原作者所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们修改或删除,多谢。

留言与评论(共有 0 条评论)
昵称:
匿名发表
   
验证码: