文档介绍:PHPExcel Developer Documentation
Contents
PHPExcel Developer Documentation 1
1. Contents 2
2. Prerequisites 4
. Software requirements 4
. Installation instructions 4
. Getting started 4
. Useful links and tools 4
. OpenXML / SpreadsheetML 4
. Frequently asked questions 5
. Tutorials 5
3. Architecture 6
. Schematical 6
. Lazy Loader 6
. Spreadsheet in memory 6
. Readers and writers 6
. Fluent interfaces 7
4. Creating a spreadsheet 9
. The PHPExcel class 9
. Configuration Settings 9
. Cell Caching 9
. Language/Locale 11
. Clearing a Workbook from memory 11
. Worksheets 11
. Accessing cells 11
. Setting a cell value by coordinate 11
. Retrieving a cell by coordinate 11
. Setting a cell value by column and row 11
. Retrieving a cell by column and row 12
. Looping cells 12
. Using value binders 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 Settings for Formulae 15
. Write a newline character "\n" in a cell (ALT+"Enter") 16
. Explicitly set a cell’s datatype 17
. Change a cell into a clickable URL 17
. Setting a worksheet’s page orientation and size 17
. Page Setup: Scaling options 17
. Page margins 18
. Center a page horizontally/vertically 19
. 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
. Setting rows/columns to repeat at top/left 21
. Specify printing area 21
. Formatting cells 21
. Number formats 22
. Alignment and wrap text 23
. Setting the default style of a workbook 23
. Styling cell borders 23
. Conditional formatting a cell 24
.