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 /. ods/Gnumeric/PDF/HTML... main features include: Setting meta information of a file, multiple worksheets, custom fonts and styles, borders and fills, pictures, calculation formulas, before converting the file type, I only used the 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 graph articles outlines the following: phpexcel graph (1)-Getting Started ---------------- introduce the basic steps of PHPExcel class library and drawing phpexcel graph (2) -graphics -------------- use the most common line/pie/bar/radar graphics as an example to plot and compare and analyze the four APIs Phpexcel graphic charts (III)-advanced ---------------- beautify the graph and complete some advanced results phpexcel graphic charts (III)-advanced ---------------- original articles on advanced functions related to charts that PHPExcel can complete, reprint please indicate the source: http://www.cnblogs.com/phpgcs this article Synopsis: 1. download and study the PHPExcel repository 2. difference between PHPExcel drawing and common data processing 3. note: First of all, it is best to download the PHPExcel project to a local study 1git clone git@github.com: PHPOffice/PHPExcel. read README carefully for git. md documentation, because it contains very important version information, especially the version range information for Reading and writing Excel documents 1234567891011121314151617181920212223 ### Reading * BIFF 5-8 (. xl S) Excel 95 and abve * Office Open XML (.xlsx) Excel 2007 and abve * 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 versi On 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 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 6364656667686970717273747576777879808182838485868788899001pharSimple. php01simple-download-pdf.php01simple-download-xls.php01simple-download-xlsx.php01simplePCLZip.php01simple.php02types.php02types-xls.php03formulas.php04printing.php05featuredemo.inc.php05featuredemo.php06largescale.php06largescale-with-cellcaching.php06largescale-with-cellcaching-sqlite3.php06largescale-with-cellcaching-sqlite.php Bytes Culation. php19namedrange. php20readexcel5. php21pdf. Examples. php23sharedstyles. php24readfilter. php25inmemoryimage. php26utf8. php27imagesexcel5. php28iterator. Examples. php30template. php31docproperties_write.php31docproperties_write-xls.php32chartreadwrite.php33chartcreate-area.php33chartcreate-bar.php33chartcreate-bar-stacked.php33chartcreate-column-2.php33chartcreate-colum N. php33chartcreate-composite.php33chartcreate-line.php33chartcreate-multiple-charts.php33chartcreate-pie.php33chartcreate-radar.php33chartcreate-scatter.php33chartcreate-stock.php34chartupdate.php35chartrender.php36chartreadwriteHTML.php36chartreadwritePDF.php37page_layout_view.php38cloneWorksheet.php40duplicateStyle.phpExcel2003XMLReader.phpExcel2003XMLTest.xml.gitignoreGnumericReader.phpGnumeric Test. gnumericimages/list .~ Invalid runall. phpSylkReader. phpSylkTest. slktemplates/XMLReader. phpXMLTest. xml: Well, this task is the chart. We should start with the line chart. The related file only has one *** line. php: 123456liuyuan @ ebuinfo:/var/www/projects/PHPExcel/Examples $ php 33chartcreate-line.php 07:13:22 Write to Excel2007 format07: 13: 23 File written to answer: 13: 23 Peak memory usage: 8.75 MB07: 13: 23 Done writing fileFile has been created in/var/www/projects/PHPExcel/Examples