Getting Started with phpexcel Graphics and Charts (1)

Home

Backend Development

PHP Tutorial

Getting Started with phpexcel Graphics and Charts (1)_PHP Tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 am 10:37 AM

phpexcelgraphicschart

PHPExcel - PHP processing engine for Excel

PHPExcel provides a series of PHP language classes, allowing you to easily read and write files in the following formats: .xls/.xlsx/.csv/.ods/Gnumeric/PDF/HTML...

Main functions include: setting file meta information, multiple worksheets, customized fonts and styles, borders and fills, pictures, calculation formulas, converting file types, etc.

Before, I only used to export data to Excel files in list format. The goal I need to achieve this time is: JSON->phpexcel->excel+chart(line/pie/etc...)

The outline of this series of articles "phpexcel graphs and charts" is as follows:

phpexcel graphs and charts (1) - Getting started----------------Introducing the PHPExcel class library and the basic steps for drawing

phpexcel graphics chart (2) - Graphics---------------- Take the most commonly used line/pie/bar/radar graphics as an example, and compare and analyze 4 types API

phpexcel graphics chart (3)-Advanced----------------Let the graphics beautify and complete some advanced effects

phpexcel graphics chart (3)-Advanced------------- Advanced functions related to charts that PHPExcel can complete

Original article, please indicate the source when reprinting: http://www.cnblogs.com/phpgcs

Summary of this article:

1. Download and study the PHPExcel repository

2. The difference between PHPExcel drawing and ordinary data processing

3. Summary of precautions

First of all, it is best to download the PHPExcel project locally to study

git clone git@github.com:PHPOffice/PHPExcel.git

Please read the README.md documentation carefully first, because it contains very important version information, especially the version range information for reading and writing Excel documents

### 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)

Enter the Examples folder, OhMygod, can complete so many functions

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

我们先直接运行一把：

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

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

The Continued Use of PHP: Reasons for Its EnduranceApr 19, 2025 am 12:23 AM

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

PHP and Python: Exploring Their Similarities and DifferencesApr 19, 2025 am 12:21 AM

PHP and Python are both high-level programming languages that are widely used in web development, data processing and automation tasks. 1.PHP is often used to build dynamic websites and content management systems, while Python is often used to build web frameworks and data science. 2.PHP uses echo to output content, Python uses print. 3. Both support object-oriented programming, but the syntax and keywords are different. 4. PHP supports weak type conversion, while Python is more stringent. 5. PHP performance optimization includes using OPcache and asynchronous programming, while Python uses cProfile and asynchronous programming.

PHP and Python: Different Paradigms ExplainedApr 18, 2025 am 12:26 AM

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

PHP and Python: A Deep Dive into Their HistoryApr 18, 2025 am 12:25 AM

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

Choosing Between PHP and Python: A GuideApr 18, 2025 am 12:24 AM

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP and Frameworks: Modernizing the LanguageApr 18, 2025 am 12:14 AM

PHP remains important in the modernization process because it supports a large number of websites and applications and adapts to development needs through frameworks. 1.PHP7 improves performance and introduces new features. 2. Modern frameworks such as Laravel, Symfony and CodeIgniter simplify development and improve code quality. 3. Performance optimization and best practices further improve application efficiency.

PHP's Impact: Web Development and BeyondApr 18, 2025 am 12:10 AM

PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip

How does PHP type hinting work, including scalar types, return types, union types, and nullable types?Apr 17, 2025 am 12:25 AM

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values and handle functions that may return null values.

See all articles