Difference between revisions of "PHPOffice"

From LIMSWiki
Jump to navigationJump to search
(Created article. Will add more later.)
 
(Updated due to recent changes.)
 
(3 intermediate revisions by the same user not shown)
Line 6: Line 6:
| caption                =  
| caption                =  
| collapsible            =  
| collapsible            =  
| author                =  
| author                = Maarten Balliauw
| developer              =  
| developer              = PHPOffice developers
| released              = {{Start date|2003|03|21}} (1.0.0)<ref name="GO100">{{cite web |url=http://superb-dca3.dl.sourceforge.net/project/group-office/CHANGELOG.TXT |title=Group-Office CHANGELOG |publisher=SourceForge |accessdate=13 January 2013}}</ref>
| released              = {{Start date|2007|02|23}} (1.0.0)<ref name="PHPEx100">{{cite web |url=http://blog.maartenballiauw.be/post/2007/02/23/phpexcel-1-0-0-final.aspx |title=PHPExcel 1.0.0 final |author=Balliauw, Maarten |publisher=Maarten Balliauw |date=23 February 2007 |accessdate=13 January 2013}}</ref>
| discontinued          =  
| discontinued          =  
| frequently updated    = yes<!-- Release version update? Don't edit this page, just click on the version number! -->
| frequently updated    = yes<!-- Release version update? Don't edit this page, just click on the version number! -->
| programming language  = PHP, JavaScript
| programming language  = PHP
| operating system      = Cross-platform
| operating system      = Cross-platform
| platform              =  
| platform              =  
| size                  =  
| size                  =  
| language              = Multi-lingual
| language              =  
| status                =  
| status                =  
| genre                  = Enterprise management software
| genre                  = Document management software
| license                = GNU Affero General Public License
| license                = GNU General Public License v2.0
| website                = [http://www.group-office.com/ Group-Office.com]
| website                = [https://github.com/PHPOffice github.com/PHPOffice]
}}
}}


'''PHPOffice''' is a collection of free 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.
'''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: PHPSpreadsheet, PHPPresentation, and PHPWord. (Previous names for the first two were PHPExcel and PHPPowerPoint.) The libraries for all projects are built on Microsoft's OpenXML standard and PHP.


==Product history==
==Product history==


===PHPExcel===
The PHPOffice "collection" didn't really come together until a GitHub project was started on June 10, 2012, incorporating the PHPExcel, PHPPowerPoint, and PHPWord projects. Members of that GitHub project included 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>


===PHPSpreadsheet (formerly 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===
===PHPPresentation (formerly 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>


===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>


==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==


Installation requirements for PHPOffice include:
Installation requirements for PHPOffice vary based upon the project. Consult each project page for more details.
 
* 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 [http://limswiki.org/index.php?title=PHPOffice#External_links here].


==Videos, screenshots, and other media==
==Videos, screenshots, and other media==
Line 65: Line 95:
Documentation for the PHPOffice projects can be found in the following places:
Documentation for the PHPOffice projects can be found in the following places:


* '''PHPExcel''': [http://phpexcel.codeplex.com/wikipage?title=Documents phpexcel.codeplex.com]
* '''PHPSpreadsheet''': [https://github.com/PHPOffice/PhpSpreadsheet/blob/develop/README.md]
* '''PHPPowerPoint''': [http://phpword.codeplex.com/documentation phpword.codeplex.com]
* '''PHPPresentation''': [https://github.com/PHPOffice/PHPPresentation/blob/develop/README.md]
* '''PHPWord''': [http://phppowerpoint.codeplex.com/wikipage?title=Documents phppowerpoint.codeplex.com]
* '''PHPWord''': [https://github.com/PHPOffice/PHPWord/blob/develop/README.md]


==Entities using PHPOffice==
==Entities using PHPOffice==
Line 80: Line 110:


* [https://github.com/PHPOffice PHPOffice on GitHub]
* [https://github.com/PHPOffice PHPOffice on GitHub]
* [http://phpexcel.codeplex.com/ PHPExcel on Microsoft CodePlex]
* [http://phpexcel.codeplex.com/ PHPExcel on Microsoft CodePlex] (Old and deprecated)
* [http://phpword.codeplex.com/ PHPWord on Microsoft CodePlex]
* [http://phpword.codeplex.com/ PHPWord on Microsoft CodePlex] (Old and deprecated)
* [http://phppowerpoint.codeplex.com/ PHPPowerPoint on Microsoft CodePlex]
* [http://phppowerpoint.codeplex.com/ PHPPowerPoint on Microsoft CodePlex] (Old and deprecated)


==References==
==References==
Line 88: Line 118:


<!---Place all category tags here-->
<!---Place all category tags here-->
[[Category:Enterprise management software (open source)]]
[[Category:Document management software (open source)]]
[[Category:Productivity software (open source)]]
[[Category:Productivity software (open source)]]

Latest revision as of 20:16, 4 May 2018

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: PHPSpreadsheet, PHPPresentation, and PHPWord. (Previous names for the first two were PHPExcel and PHPPowerPoint.) 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, PHPPowerPoint, and PHPWord projects. Members of that GitHub project included Maarten Balliauw, original creater of PHPExcel, and Mark Baker, a key developer/coordinator for all three projects.[2]

PHPSpreadsheet (formerly 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.

PHPPresentation (formerly PHPPowerPoint)

An alpha version (0.1.0) of PHPPowerPoint was introduced to Microsoft CodePlex by PHPExcel developer Maarten Balliauw on April 25, 2009.[4]

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]

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 vary based upon the project. Consult each project page for more details.

Videos, screenshots, and other media

Documentation for the PHPOffice projects can be found in the following places:

  • PHPSpreadsheet: [1]
  • PHPPresentation: [2]
  • PHPWord: [3]

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=33165"