Phpexcel graph (1) Getting started

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 functions include: Setting the meta information of a file, multi-worksheet, customization... "/> <scripttype =" te PHPExcel-the PHP processing engine PHPExcel of Excel 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 commonly used line/pie/bar/radar graphics as an example to plot and compare and analyze four APIphpexcel graphics charts (3)-Advanced ---------------- beautify the graphics, complete some advanced results phpexcel graphic charts (3)-Advanced ---------------- original articles on advanced functions of PHPExcel charts that can be completed. For more information, see the source: http://www.cnblogs.com/phpgcs Summary of this article: 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 (.xls) 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 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 en Abled * PHP extension php_gd2 enabled (optional, but required for exact column width autocalculation) enter the Examples folder, OhMygod, can complete so many features Ah. php01simple-download-pdf.php01simple-download-xls.php01simple-download-xlsx.php0 1simplePCLZip. php01simple. php02types. php02types-xls.php03formulas.php04printing.php05featuredemo.inc.php05featuredemo.php06largescale.php06largescale-with-cellcaching.php06largescale-with-cellcaching-sqlite3.php06largescale-with-cellcaching-sqlite.php06largescale-xls.php07readerPCLZip.php07reader.php08conditionalformatting2.php08conditionalformatting.php09pagebreaks.php10autofilter.php10autofilter Selection-1.php10autofilter-selection-2.php10autofilter-selection-display.php11documentsecurity.php11documentsecurity-xls.php12cellProtection.php13calculation.php14excel5.php15datavalidation.php15datavalidation-xls.php16csv.php17html.php18extendedcalculation.php19namedrange.php20readexcel5.php21pdf.php22heavilyformatted.php23sharedstyles.php24readfilter.php25inmemoryimage.php26utf8.php27imagesexc El5.php28iterator. php29advancedvaluebinder. php30template. php31docproperties_write.php31docproperties_write-xls.php32chartreadwrite.php33chartcreate-area.php33chartcreate-bar.php33chartcreate-bar-stacked.php33chartcreate-column-2.php33chartcreate-column.php33chartcreate-composite.php33chartcreate-line.php33chartcreate-multiple-charts.php33chartcreate-pie.php33chartcreate-radar.php33chartcreate-scat Ter. the php33chartcreate-stock.php34chartupdate.php35chartrender.php36chartreadwriteHTML.php36chartreadwritePDF.php37page_layout_view.php38cloneWorksheet.php40duplicateStyle.phpExcel2003XMLReader.phpExcel2003XMLTest.xml.gitignoreGnumericReader.phpGnumericTest.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