PHPExcel Library

Copyright © by Sebastian Winterhalder <sw@no spam pleaseinternetgalerie.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
  • 3.1. Software requirements
  • 3.2. Installation instructions
  • 3.3. Useful links and tools
    • OpenXML / SpreadsheetML
    • Frequently asked questions
    • Tutorials
• 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
    • Setting a cell value by coordinate
    • Retrieving a cell by coordinate
    • Setting a cell value by column and row
    • Retrieving a cell by column and row
    • Looping cells
    • Using value binders to facilitate data entry
  • 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
  • 6.1. Using the PHPExcel calculation engine
  • 6.2. Known limitations
    • Operator precedence
    • X ^ N (Power)
    • Formulas involving numbers and text
• 7. Reading and writing to file
  • 7.1. PHPExcel_IOFactory
    • Creating PHPExcel_Reader_IReader using PHPExcel_IOFactory
    • Creating PHPExcel_Writer_IWriter using PHPExcel_IOFactory
  • 7.2. Excel 2007 (SpreadsheetML) file format
    • PHPExcel_Reader_Excel2007
    • PHPExcel_Writer_Excel2007
  • 7.3. Serialized file format
    • PHPExcel_Reader_Serialized
    • PHPExcel_Writer_Serialized
  • 7.4. Excel 5 (BIFF) file format
    • PHPExcel_Reader_Excel5
    • PHPExcel_Writer_Excel5
  • 7.5. CSV (Comma Separated Values)
    • PHPExcel_Reader_CSV
    • PHPExcel_Writer_CSV
  • 7.6. HTML
    • PHPExcel_Writer_HTML
  • 7.7. PDF
    • PHPExcel_Writer_PDF
• 8. Credits

This document is related to version 1.7.4 of the extension phpexcel_library.