2007 August 20, 2007
Create Excel files with PHP
Published by micka39 in Tricks, Bons plans, Free, Internet, Microsoft Office, PHP 
Previously we created the csv file to replace xls which owns Microsoft.
This time you can create real xls file with graphical form through the framework PHP excel available on codeplex.
Here is the list of functions (in English):
Create an in-memory representation spreadsheet Set spreadsheet meta data (author, title, description, ...) Add worksheets to spreadsheet Add data and formulas to individual cells Merge Cells Protect ranges of cells with a password Supports setting cell width and height Supports different fonts and font styles Supports formatting, styles, cell borders, fills, gradients, ... 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" panes cell Supports workbook-level security Supports worksheet-level protection Cell data validation Insert / remove rows / columns Calculate formula values 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
Output your spreadsheet object to different file formats
- Excel 2007 (SpreadsheetML)
- BIFF5 (Excel 97 and higher)
- PHPExcel Serialized Spreadsheet
- CSV (Comma Separated Values)
- HTML
Read different file formats into your spreadsheet object
- Excel 2007 (SpreadsheetML)
- PHPExcel Serialized Spreadsheet
- CSV (Comma Separated Values)
It'll just try it!
Framework available for PHP version 5.2 and must have the extensionphp_zip activate.
Update: You have the option to save to xls, xlsx, csv.
To create your own file xls via your web application, follow this link ...
Technorati Tags: excel, php, framework
[...] Find everything on CodePlex, the platform Open Source Microsoft? The proof Micka found a PHP framework enabling it to generate. Xls! Ideal for your applications. Php wanting generate catalogs compatible Office [...]