Phpexcel Graphic Chart (i) Getting Started

Source: Internet
Author: User
Tags format php language memory usage version git clone
Phpexcel-excel's PHP processing engine   Phpexcel provides a series of PHP language classes that allow you to easily read and write files in the following format:. xls/.xlsx/.csv/.ods/gnumeric/pdf/html ... Main features include: Set up file meta information, multiple worksheets, custom fonts and styles, borders and fills, pictures, calculation formulas, converting file types, etc.   I just used the export data to the tabular Excel file, this time I need to achieve the goal is:json-> Phpexcel->excel+chart (line/pie/etc ...)   This series of "Phpexcel Graphics and graphs" is summarized as follows:   Phpexcel graphic Chart (i)- Getting Started----------------Introduction to the basic steps of Phpexcel class libraries and Drawing Phpexcel graphic Chart (b)-graphic----------------The most commonly used Line/pie/bar/radar graphics as an example, and compare and analyze 4 kinds of API Phpexcel graphic Chart (c)-Advanced----------------Let the graphic landscaping, complete some high-level effect Phpexcel graphic Chart (iii)- Advanced----------------Phpexcel can complete the graphics related to the advanced features   original articles, reproduced please specify the Source: Http://www.cnblogs.com/phpgcs   This article synopsis: 1. Download and study Phpexcel Warehouse 2. The difference between Phpexcel drawing and general data processing 3. Note Summary     First, it is best to download the Phpexcel project to the local to study   1 git clone git@github.com:phpoffice/phpexcel.git Please read the README.MD documentation carefully, because it contains important version information, especially the version range information for reading and writing Excel documents   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 + 20 21 ### Reading  * BIFF 5-8 (. xls) Excel 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 and above  * Office Open XML (. xlsx) Excel 2007 and above &NB sp;* 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_gd 2 enabled (optional, but required for exact column width autocalculation)   into examples folder, Ohmygod, can complete so many functions Yes &nbs P 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 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 5 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 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 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   Well, this time the mission is chart, first from Li NE chart to start with, related files only a ***line.php   we first run directly:   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

Related Article

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.