PHPExcel Library
Copyright © by Sebastian Winterhalder <sw@internetgalerie.ch>Published under the Open Content License available from http://www.opencontent.org/opl.shtml
Table Of Contents
- 1. Ext: PHPExcel Library
- 2. Contents
- 3. Prerequisites
- 4. Architecture
- 4.1. Schematical
- 4.2. Spreadsheet in memory
- 4.3. Readers and writers
- 4.4. Fluent interfaces
- 5. Creating a spreadsheet
- 5.1. The PHPExcel class
- 5.2. Worksheets
- 5.3. Accessing cells
- 5.4. PHPExcel recipes
- Setting a spreadsheet’s metadata
- Setting a spreadsheet’s active sheet
- Write a date into a cell
- Write a formula into a cell
- Explicitly set a cell’s datatype
- Change a cell into a clickable URL
- Setting a worksheet’s page orientation and size
- Center a page horizontally/vertically
- Setting the print header and footer of a worksheet
- Setting printing breaks on a row or column
- Show/hide gridlines when printing
- Setting rows/columns to repeat at top/left
- Specify printing area
- Formatting cells
- Number formats
- Setting the default style of a workbook
- Styling cell borders
- Conditional formatting a cell
- Add a comment to a cell
- Apply autofilter to a range of cells
- Setting security on a spreadsheet
- Setting data validation on a cell
- Setting a column’s width
- Show/hide a column
- Group/outline a column
- Setting a row’s height
- Show/hide a row
- Group/outline a row
- Merge/unmerge cells
- Inserting rows/columns
- Add a drawing to a worksheet
- Add rich text to a cell
- Define a named range
- Redirect output to a client’s web browser
- Setting the default column width
- Setting the default row height
- Add a GD drawing to a worksheet
- Setting worksheet zoom level
- 6. Performing formula calculations
- 7. Reading and writing to file
- 7.1. PHPExcel_IOFactory
- 7.2. Excel 2007 (SpreadsheetML) file format
- 7.3. Serialized file format
- 7.4. Excel 5 (BIFF) file format
- 7.5. CSV (Comma Separated Values)
- 7.6. HTML
- 7.7. PDF
- 8. Credits
This document is related to version 1.7.4 of the extension phpexcel_library.