php7.1.3开发手册下载,PHPExcel开发手册.pdf

PHPExcel Developer Documentation

Author: Maarten Balliauw

Version: 1.7.4

Date: 26 August 2010

1. Contents

PHPExcel Developer Documentation 1

1.  Contents 2

2.  Prerequisites 4

2.1.  Software requirements 4

2.2.  Installation instructions 4

2.3.  Getting started 4

2.4.  Useful links and tools 4

2.4.1.  OpenXML / SpreadsheetML 4

2.4.2.  Frequently asked questions 5

2.4.3.  Tutorials 5

3.  Architecture 6

3.1.  Schematical 6

3.2.  Lazy Loader 6

3.3.  Spreadsheet in memory 6

3.4.  Readers and writers 6

3.5.  Fluent interfaces 7

4.  Creating a spreadsheet 9

4.1.  The PHPExcel class 9

4.2.  Configuration Settings 9

4.2.1.  Cell Caching 9

4.2.2.  Language/Locale 11

4.3.  Clearing a Workbook from memory11

4.4.  Worksheets 11

4.5.  Accessing cells 11

4.5.1.  Setting a cell value by coordinate 11

4.5.2.  Retrieving a cell by coordinate 11

4.5.3.  Setting a cell value by column and row11

4.5.4.  Retrieving a cell by column and row 12

4.5.5.  Looping cells 12

4.5.6.  Using value binders to facilitate data entry 13

4.6.  PHPExcel recipes 14

4.6.1.  Setting a spreadsheet’s metadata 14

4.6.2.  Setting a spreadsheet’s active sheet 14

4.6.3.  Write a date into a cell 14

4.6.4.  Write a formula into a cell 15

4.6.5.  Locale Settings for Formulae 15

4.6.6.  Write a newline character "\n" in a cell (ALT+"Enter") 16

4.6.7.  Explicitly set a cell’s datatype 16

4.6.8.  Change a cell into a clickable URL 17

4.6.9.  Setting a worksheet’s page orientation and size 17

4.6.10.  Page Setup: Scaling options 17

4.6.11.  Page margins 18

4.6.12.  Center a page horizontally/vertically 18

4.6.13.  Setting the print header and footer of a worksheet 19