PHPOffice

From LIMSWiki
Revision as of 00:27, 30 January 2013 by Shawndouglas (talk | contribs) (→‎Product history: Grammar)
Jump to navigationJump to search
PHPOffice
Original author(s) Maarten Balliauw
Developer(s) PHPOffice developers
Initial release February 23, 2007 (2007-02-23) (1.0.0)[1]
Stable release

Spreadsheet: 2.1.0; Presentation: 1.0.0; Word: 1.2.0
  (Spreadsheet: May 10, 2024; 6 months ago (2024-05-10); Presentation: November 25, 2017; 6 years ago (2017-11-25); Word: December 28, 2023; 10 months ago (2023-12-28))

[±]
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 a 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:

Entities using PHPOffice

Further reading

External links

References

  1. ↑ 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. 
  2. ↑ "PHPOffice - Members". GitHub. https://github.com/PHPOffice?tab=members. Retrieved 29 January 2013. 
  3. ↑ 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. 
  4. ↑ Balliauw, Maarten (25 April 2009). "PHPPowerPoint 0.1.0 (CTP 1)". Microsoft CodePlex. http://phppowerpoint.codeplex.com/releases/view/26621. Retrieved 29 January 2013. 
  5. ↑ "PHPWord 0.6.2-1 Beta". Microsoft CodePlex. 8 July 2011. http://phpword.codeplex.com/releases/view/49543. Retrieved 29 January 2013. 
  6. ↑ "PHPExcel - Features". Microsoft CodePlex. http://phpexcel.codeplex.com/wikipage?title=Features&referringTitle=Home. Retrieved 13 January 2013. 
  7. ↑ "PHPWord - Home". Microsoft CodePlex. http://phpword.codeplex.com/. Retrieved 13 January 2013. 
  8. ↑ "PHPPowerPoint - Features". Microsoft CodePlex. http://phppowerpoint.codeplex.com/wikipage?title=Features&referringTitle=Home. Retrieved 13 January 2013. 
Retrieved from "https://www.limswiki.org/index.php?title=PHPOffice&oldid=9692"