DEPRECATION WARNING
This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
Sitemap¶
- Sitemap
- PHPExcel developer documentation
- 1. Ext: PHPExcel Library
- 2.Contents
- 3.Prerequisites
- 3.1.Software requirements
- 3.2.Installation instructions
- 3.3.Useful links and tools
- 3.3.1.OpenXML / SpreadsheetML
- 3.3.2.Frequently asked questions
- There seems to be a problem with character encoding...
- PHP complains about ZipArchive not being found
- Excel 2007 cannot open the file generated by PHPExcel_Writer_2007 on Windows
- Protection on my worksheet is not working?
- Feature X is not working with PHPExcel_Writer_Y
- Formulas don’t seem to be calculated in Excel2003 using compatibility pack?
- Setting column width is not 100% accurate
- 3.3.3.Tutorials
- 4.Architecture
- 5.Creating a spreadsheet
- 5.1.The PHPExcel class
- 5.2.Worksheets
- 5.3.Accessing cells
- 5.4.PHPExcel recipes
- 5.4.1.Setting a spreadsheet’s metadata
- 5.4.2.Setting a spreadsheet’s active sheet
- 5.4.3.Write a date into a cell
- 5.4.4.Write a formula into a cell
- 5.4.5.Explicitly set a cell’s datatype
- 5.4.6.Change a cell into a clickable URL
- 5.4.7.Setting a worksheet’s page orientation and size
- 5.4.8.Center a page horizontally/vertically
- 5.4.9.Setting the print header and footer of a worksheet
- 5.4.10.Setting printing breaks on a row or column
- 5.4.11.Show/hide gridlines when printing
- 5.4.12.Setting rows/columns to repeat at top/left
- 5.4.13.Specify printing area
- 5.4.14.Formatting cells
- 5.4.15.Number formats
- 5.4.16.Setting the default style of a workbook
- 5.4.17.Styling cell borders
- 5.4.18.Conditional formatting a cell
- 5.4.19.Add a comment to a cell
- 5.4.20.Apply autofilter to a range of cells
- 5.4.21.Setting security on a spreadsheet
- 5.4.22.Setting data validation on a cell
- 5.4.23.Setting a column’s width
- 5.4.24.Show/hide a column
- 5.4.25.Group/outline a column
- 5.4.26.Setting a row’s height
- 5.4.27.Show/hide a row
- 5.4.28.Group/outline a row
- 5.4.29.Merge/unmerge cells
- 5.4.30.Inserting rows/columns
- 5.4.31.Add a drawing to a worksheet
- 5.4.32.Add rich text to a cell
- 5.4.33.Define a named range
- 5.4.34.Redirect output to a client’s web browser
- 5.4.35.Setting the default column width
- 5.4.36.Setting the default row height
- 5.4.37.Add a GD drawing to a worksheet
- 5.4.38.Setting worksheet zoom level
- 6.Performing formula calculations
- 7.Reading and writing to file
- 8.Credits
- Valid array keys for style applyFromArray()
- Array key:
- fill
- Array key:
- typerotationstartcolorendcolorcolor
- Array key:
- namebolditalicunderlinestrikecolorsizesuperScriptsubScript
- Array key:
- allbordersleftrighttopbottomdiagonalverticalhorizontaldiagonaldirectio
- Array key:
- stylecolor
- Array key:
- horizontalverticalrotationwrapshrinkToFitindent
- Array key:
- code
- Array key:
- lockedhidden
- Author:
- Version:
- Date:
- Linktargets