Difference between revisions of "PHPOffice"
Shawndouglas (talk | contribs) (Corrected a few items.) |
Shawndouglas (talk | contribs) (Added history and feats.) |
||
| Line 25: | Line 25: | ||
==Product history== | ==Product history== | ||
The PHPOffice "collection" didn't really come together until GitHub project was started on June 10, 2012, incorporating the PHPExcel, PowerPoint, and Word projects. Members of that GitHub project include Maarten Balliauw, original creater of PHPExcel, and Mark Baker, a key developer/coordinator for all three projects.<ref name="OffGHMembs">{{cite web |url=https://github.com/PHPOffice?tab=members |title=PHPOffice - Members |publisher=GitHub |accessdate=29 January 2013}}</ref> | |||
===PHPExcel=== | ===PHPExcel=== | ||
In December 2006, developer Maarten Balliauw began working on PHP-based Excel 2007 classes "to check how hard it could be to create Excel 2007 files using PHP5."<ref name="ExcDec06">{{cite web |url=http://blog.maartenballiauw.be/post/2007/01/18/excel2007-in-php-project-status.aspx |title=Excel2007 in PHP - Project status |author=Balliauw, Maarten |publisher=Maarten Balliauw |date=18 January 2007 |accessdate=29 January 2013}}</ref> Encouraged by his progress, Balliauw continued with the open-source project, hosted on Microsoft CodePlex. This eventually led to a version 1.0.0 release of those classes as PHPExcel on February 23, 2007.<ref name="PHPEx100" /> Of the tree PHPOffice projects, PHPExcel remains the most active one as of January 2013, with a stable release of 1.7.8 arriving in October 2012. | |||
===PHPPowerPoint=== | ===PHPPowerPoint=== | ||
An alpha version (0.1.0) of PHPPowerPoint was introduced to Microsoft CodePlex by PHPExcel developer Maarten Balliauw on April 25, 2009<ref name="PPFirst">{{cite web |url=http://phppowerpoint.codeplex.com/releases/view/26621 |title=PHPPowerPoint 0.1.0 (CTP 1) |author=Balliauw, Maarten |publisher=Microsoft CodePlex |date=25 April 2009 |accessdate=29 January 2013}}</ref>, but no further releases have been made. It's unclear if there are any plans to continue the project. | |||
===PHPWord=== | ===PHPWord=== | ||
A beta version (0.6.0) of PHPWord was introduced to Microsoft CodePlex on March 20, 2010, followed by an updated 0.6.2 in July 2011<ref name="WordFirst">{{cite web |url=http://phpword.codeplex.com/releases/view/49543 |title=PHPWord 0.6.2-1 Beta |publisher=Microsoft CodePlex |date=08 July 2011 |accessdate=29 January 2013}}</ref>, but no further releases have been made. It's unclear if there are any plans to continue the project. | |||
==Features== | ==Features== | ||
| Line 43: | Line 45: | ||
'''PHPExcel''' | '''PHPExcel''' | ||
* | |||
* create an in-memory spreadsheet representation | |||
* manage spreadsheet meta-data | |||
* add worksheets | |||
* add data and formulas to cells | |||
* merge and protect cells | |||
* support for numerous functions like hyperlinks and resizing | |||
* data validation | |||
* worksheet references | |||
* calculations | |||
* image management | |||
* print options | |||
* output as and read various formats | |||
'''PHPPowerPoint''' | '''PHPPowerPoint''' | ||
* | |||
* create an in-memory presentation representation | |||
* manage presentation meta-data | |||
* add slides | |||
* support for fonts, styles, formatting, fills | |||
* hyperlinks | |||
* rich-text | |||
* image management | |||
* print options | |||
* various output formats | |||
'''PHPWord''' | '''PHPWord''' | ||
* | Insert and format... | ||
* document sections | |||
* text elements | |||
* text breaks | |||
* page breaks | |||
* images and binary OLE-Objects | |||
* watermarks | |||
* header and footer | |||
* tables | |||
* native titles and table-of-contents | |||
* list elements | |||
* hyperlinks | |||
* basic templates | |||
==Hardware/software requirements== | ==Hardware/software requirements== | ||
Revision as of 00:26, 30 January 2013
| Original author(s) | Maarten Balliauw |
|---|---|
| Developer(s) | PHPOffice developers |
| Initial release | February 23, 2007 (1.0.0)[1] |
| Stable release |
Spreadsheet: 2.1.0; Presentation: 1.0.0; Word: 1.2.0 |
| Preview release | None [±] |
| Written in | PHP |
| Operating system | Cross-platform |
| Type | Document management software |
| License(s) | GNU General Public License v2.0 |
| Website | github.com/PHPOffice |
PHPOffice is a collection of free open-source PHP libraries for reading and writing files from a wide variety of document formats. Currently there are three projects associated with PHPOffice: PHPExcel, PHPWord, and PHPPowerPoint. However, only the PHPExcel project seems to have any momentum behind it as of January 2013. The libraries for all projects are built on Microsoft's OpenXML standard and PHP.
Product history
The PHPOffice "collection" didn't really come together until GitHub project was started on June 10, 2012, incorporating the PHPExcel, PowerPoint, and Word projects. Members of that GitHub project include Maarten Balliauw, original creater of PHPExcel, and Mark Baker, a key developer/coordinator for all three projects.[2]
PHPExcel
In December 2006, developer Maarten Balliauw began working on PHP-based Excel 2007 classes "to check how hard it could be to create Excel 2007 files using PHP5."[3] Encouraged by his progress, Balliauw continued with the open-source project, hosted on Microsoft CodePlex. This eventually led to a version 1.0.0 release of those classes as PHPExcel on February 23, 2007.[1] Of the tree PHPOffice projects, PHPExcel remains the most active one as of January 2013, with a stable release of 1.7.8 arriving in October 2012.
PHPPowerPoint
An alpha version (0.1.0) of PHPPowerPoint was introduced to Microsoft CodePlex by PHPExcel developer Maarten Balliauw on April 25, 2009[4], but no further releases have been made. It's unclear if there are any plans to continue the project.
PHPWord
A beta version (0.6.0) of PHPWord was introduced to Microsoft CodePlex on March 20, 2010, followed by an updated 0.6.2 in July 2011[5], but no further releases have been made. It's unclear if there are any plans to continue the project.
Features
The main features of the PHPOffice projects include[6][7][8]:
PHPExcel
- create an in-memory spreadsheet representation
- manage spreadsheet meta-data
- add worksheets
- add data and formulas to cells
- merge and protect cells
- support for numerous functions like hyperlinks and resizing
- data validation
- worksheet references
- calculations
- image management
- print options
- output as and read various formats
PHPPowerPoint
- create an in-memory presentation representation
- manage presentation meta-data
- add slides
- support for fonts, styles, formatting, fills
- hyperlinks
- rich-text
- image management
- print options
- various output formats
PHPWord Insert and format...
- document sections
- text elements
- text breaks
- page breaks
- images and binary OLE-Objects
- watermarks
- header and footer
- tables
- native titles and table-of-contents
- list elements
- hyperlinks
- basic templates
Hardware/software requirements
Installation requirements for PHPOffice include:
- PHP 5.2.x or greater
- php_zip, php_xml, and php_gd2 enabled
- The PHP extensions ZipArchive and xmllib installed
Consult the documentation on the Microsoft CodePlex pages linked here.
Videos, screenshots, and other media
Documentation for the PHPOffice projects can be found in the following places:
- PHPExcel: phpexcel.codeplex.com
- PHPPowerPoint: phpword.codeplex.com
- PHPWord: phppowerpoint.codeplex.com
Entities using PHPOffice
Further reading
External links
- PHPOffice on GitHub
- PHPExcel on Microsoft CodePlex
- PHPWord on Microsoft CodePlex
- PHPPowerPoint on Microsoft CodePlex
References
- ↑ 1.0 1.1 Balliauw, Maarten (23 February 2007). "PHPExcel 1.0.0 final". Maarten Balliauw. http://blog.maartenballiauw.be/post/2007/02/23/phpexcel-1-0-0-final.aspx. Retrieved 13 January 2013.
- ↑ "PHPOffice - Members". GitHub. https://github.com/PHPOffice?tab=members. Retrieved 29 January 2013.
- ↑ Balliauw, Maarten (18 January 2007). "Excel2007 in PHP - Project status". Maarten Balliauw. http://blog.maartenballiauw.be/post/2007/01/18/excel2007-in-php-project-status.aspx. Retrieved 29 January 2013.
- ↑ Balliauw, Maarten (25 April 2009). "PHPPowerPoint 0.1.0 (CTP 1)". Microsoft CodePlex. http://phppowerpoint.codeplex.com/releases/view/26621. Retrieved 29 January 2013.
- ↑ "PHPWord 0.6.2-1 Beta". Microsoft CodePlex. 8 July 2011. http://phpword.codeplex.com/releases/view/49543. Retrieved 29 January 2013.
- ↑ "PHPExcel - Features". Microsoft CodePlex. http://phpexcel.codeplex.com/wikipage?title=Features&referringTitle=Home. Retrieved 13 January 2013.
- ↑ "PHPWord - Home". Microsoft CodePlex. http://phpword.codeplex.com/. Retrieved 13 January 2013.
- ↑ "PHPPowerPoint - Features". Microsoft CodePlex. http://phppowerpoint.codeplex.com/wikipage?title=Features&referringTitle=Home. Retrieved 13 January 2013.
