PHPExcel 1.7.6

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : LGPL - GNU Lesser General Public License
CreatedCreated : Jul 26, 2011
Size downloadDownloads : 15
Program licensing
Thank you for voting...

This project is built around Microsoft's OpenXML ...

This project is built around Microsoft's OpenXML standard and PHP.
Developers can write to and read from different file formats, like excel 2007, PDF, HTML.
A PEAR package is also available.
Most important functions of PHPExcel by RealDolmen:

• Create an in-memory spreadsheet representation

• Set spreadsheet meta data (author, title, description, . . . )

• Add worksheets to spreadsheet

• Add data and formulas to individual cell

• Merge cells

• Protect ranges of cells with a password

supports setting cell width and height

• Supports different fonts and font styles

• Supports format, styles, cell borders, fills, gradients, . . .

• Supports hyperlinks

• Supports different data types for individual cells

• Supports cell text wrapping

• Supports conditional formatting

• Supports column auto-sizing

• Supports rich-text strings

• Supports autofilter

• Supports "freezing" cell panes

• Supports cell-level security

• Supports workbook-level security

• Supports worksheet-level protection

• Group rows/columns

• Cell data validation

• Insert/remove rows/columns

• Named ranges

• Worksheet references

• Calculate formula values

• Add comments to a cell

• Add images to your spreadsheet

• Set image styles (Positioning, Rotation, Shadow)

• Set printing options (Header, Footer, Page margins, Paper size, Orientation, Row and column breaks, Repeat rows at header / columns at left, Print area)

Output file formats:

• Excel 2007 (spreadsheetML)

• BIFF8 (Excel 97 and higher)

phpexcel 1.7.6 Serialized Spreadsheet

• CSV (Comma Separated Values)



Input (Read) file formats:

• Excel 2007 (spreadsheetML)

• BIFF5 (Excel 5. 0 / Excel 95), BIFF8 (Excel 97 and higher)

• PHPExcel [phpexcel1.7.6.exe] Serialized Spreadsheet

• Excel 2003 XML format

• Open Office Calc (. ods)

• Gnumeric

• Symbolic Link (SYLK)

• CSV (Comma Separated Values)
News in the current PHPExcel - 0MB version:


• Improved performance (speed), for building the Shared Strings table in the Excel2007 Writer.

• Improved performance (speed), for PHP to Excel date conversions

• Enhanced SheetViews element structures in the Excel2007 Writer for frozen panes.

• Removed Serialized reader/Writer as these no longer work.


• Provide option to use PCLZip as an alternative to ZipArchive. This allows the writing of Excel2007 files, even without ZipArchive enabled (it does require zlib), or when php_zip is one of the buggy PHP 5. 2. 6 or 5. 2. 8 versions. It can be enabled using PHPExcel 1.7.6_Settings::setZipClass(PHPExcel 1.7.6_Settings::PCLZIP);

• Added listWorksheetNames() method to Readers that support multiple worksheets in a workbook, allowing a user to extract a list of all the worksheet names from a file without parsing/loading the whole file.

• Speed boost and memory reduction in the Worksheet toArray() method.

• Added new rangeToArray() and namedRangeToArray() methods to the PHPExcel_Worksheet object.

• Added support for cell comments in the OOCalc, Gnumeric and Excel2003XML Readers, and in the Excel5 Reader

• Improved toFormattedString() handling for Currency and Accounting formats to render currency symbols

• Implement more Excel calculation functions. Implemented the DAVERAGE(), DCOUNT(), DCOUNTA(), DGET(), DMAX(), DMIN(), DPRODUCT(), DSTDEV(), DSTDEVP(), DSUM(), DVAR() and DVARP() Database functions

Bug fixes:

• Simple =IF() formula disappears

• PHP Warning: preg_match(): Compilation failed: PCRE does not support \ \ L, \ \ l, \ \ N, \ \ P, \ \ p, \ \ U, \ \ u, or \ \ X

• VLOOKUP choking on parameters in PHPExcel. 1. 7. 5/PHPExcel_Writer_Excel2007

• PHPExcel_Cell::isInRange() incorrect results - offset by one column

• Treat CodePage of 0 as CP1251 (for . xls files written by applications that don't set the CodePage correctly, such as Apple Numbers)

• Need method for removing autoFilter

• coordinateFromString throws exception for rows greater than 99, 999

• PHPExcel Excel2007 Reader colour problems with solidfill

• Formatting get lost and edit a template XLSX file

• Excel 2007 Reader /writer lost fontcolor

• File that makes cells go black

• Minor patchfix for Excel2003XML Reader when XML is defined with a charset attribute

• PHPExcel_Worksheet-> toArray() index problem

• Worksheet fromArray() only working with 2-D arrays

• Reduced false positives from isDateTimeFormatCode() method by suppressing testing within quoted strings

PHPExcel 1.7.6 scripting tags: excel, file, cell, cells, format, reader, supports, phpexcel, data grid, excel file, spreadsheet manipulation. What is new in PHPExcel 1.7.6 software script? - Unable to find PHPExcel 1.7.6 news. What is improvements are expecting? Newly-made PHPExcel 1.8 will be downloaded from here. You may download directly. Please write the reviews of the PHPExcel. License limitations are unspecified.