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 [email protected]: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
