PHPExcel开发手册.doc

PHPExcel开发手册.docPHPEkceia
PHPExcel Developer Documentation
Author: Version: Date:
Maarte n Balliauw

26 August 2010
4
3
PHPEkceia
Contents
PHPExcel Developer Docume ntatio n 1
Contents 2
Prerequisites 4
Software requirements 4
In stallati on in struct ions 4
Gett ing started 4
Useful li nks and tools 4
Open XML / SpreadsheetML 4
Freque ntly asked questions 5
Tutorials 5
Architecture 6
Schematical 6
Lazy Loader 6
Spreadsheet i n memory 6
Readers and writers 6
Flue nt in terfaces 7
Creati ng a spreadsheet 9
The PHPExcel class 9
Configuration Settings
Cell Caching
Language/Locale 11
Cleari ng a Workbook from memory 11
Worksheets 11
Access ing cells 11
Sett ing a cell value by coordinate 11
Retrievi ng a cell by coord in ate 11
Sett ing a cell value by colu mn and row 11
Retrievi ng a cell by colu mn and row 12
Looping cells 12
Using value bin ders to facilitate data entry 13
PHPExcel recipes 14
Setting a spreadsheet ' s metadata 14
Setting a spreadsheet ' s active sheet 14
Write a date into a cell 14
Write a formula into a cell 15
Locale Sett ings for Formulae 15
Write a n ewli ne character "\n" in a cell (ALT+"E nter") 16
Explicitly set a cell ' s datatype 16
Change a cell into a clickable URL 17
Setting a worksheet ' s page orientation and size 17
Page Setup: Scali ng opti ons 17
Page margins 18
Cen ter a page horizontally/vertically 18
Setting the print header and footer of a worksheet 19
Setting printing breaks on a row or column 20
Show/hide gridlines when printing 20
Sett ing rows/colu mns to repeat at top/left 20
Specify printing area 20
Formatt ing cells 21
Number formats 22
Alig nment and wrap text 23
Sett ing the default style of a workbook 23
Styli ng cell borders 23
Con diti onal formatti ng