13 users Sign-in to change your status

sfExcelReaderPlugin provides classes to interpret and output Microsoft Excel data files (.xls) using PHP Excel Reader. Template Applications Media Backend

• Homepage
• Repository
• Report a bug
• Download package
• Browse source

Provides classes to interpret and output Microsoft Excel data files (.xls) using PHP Excel Reader.

Developers

Name	Status	Email
Tomasz Ducin	lead	moc.liamg <<ta>> nicud.zsamot

License

--------------------------------------------------------------------
The PHP License, version 3.0
Copyright (c) 1999 - 2006 The PHP Group. All rights reserved.
--------------------------------------------------------------------

Redistribution and use in source and binary forms, with or without
modification, is permitted provided that the following conditions
are met:

1. Redistributions of source code must retain the above copyright
notice, this list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright
notice, this list of conditions and the following disclaimer in
the documentation and/or other materials provided with the
distribution.

3. The name "PHP" must not be used to endorse or promote products
derived from this software without prior written permission. For
written permission, please contact group@php.net.

4. Products derived from this software may not be called "PHP", nor
may "PHP" appear in their name, without prior written permission
from group@php.net. You may indicate that your software works in
conjunction with PHP by saying "Foo for PHP" instead of calling
it "PHP Foo" or "phpfoo"

5. The PHP Group may publish revised and/or new versions of the
license from time to time. Each version will be given a
distinguishing version number.
Once covered code has been published under a particular version
of the license, you may always continue to use it under the terms
of that version. You may also choose to use such covered code
under the terms of any subsequent version of the license
published by the PHP Group. No one other than the PHP Group has
the right to modify the terms applicable to covered code created
under this License.

6. Redistributions of any form whatsoever must retain the following
acknowledgment:
"This product includes PHP, freely available from
<http://www.php.net/>".

THIS SOFTWARE IS PROVIDED BY THE PHP DEVELOPMENT TEAM ``AS IS'' AND
ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE PHP
DEVELOPMENT TEAM OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
OF THE POSSIBILITY OF SUCH DAMAGE.

--------------------------------------------------------------------

This software consists of voluntary contributions made by many
individuals on behalf of the PHP Group.

The PHP Group can be contacted via Email at group@php.net.

For more information on the PHP Group and the PHP project,
please see <http://www.php.net>.

This product includes the Zend Engine, freely available at
<http://www.zend.com>.

Releases for sf 1.4

Releases for sf 1.3

Releases for sf 1.2

Join this plugin team

Other releases

Release 1.1.2 - 22/12/2009

Release 1.0.3 - 22/12/2009

sfExcelReaderPlugin

Provides you with a class to interpret and output excel data files (.xls) using PHP Excel Reader. Current version of the plugin uses PHP Excel Reader v.2.21.

Installation

Install the plugin via the subversion repository by executing the following command from the project root directory:

$ svn co http://svn.symfony-project.com/plugins/sfExcelReaderPlugin/branches/1.4 plugins/sfExcelReaderPlugin

or by using the default symfony plugin install command:

$ ./symfony plugin:install sfExcelReaderPlugin

Right after the installation of the plugin, you should update plugin assets:

$ ./symfony plugin:publish-assets

so that the CSS of Excel Reader is accessible.

Usage

Here is an easy example of using PHP Excel Reader:

$data = new sfExcelReader('example.xls');
echo $data->dump(true, true);

To find out more features, please lok at the documentation of PHP Excel Reader.

sfExcelReaderExample

The plugin is provided with an example module to test if everything works fine. Right after installation, go to your application config directory and add sfExcelReaderExample module to enabled modules section in settings.yml file. Next step is to edit config/routing.yml file of the plugin - you shall uncomment all lines. Then clear the cache:

$ ./symfony cc

and everything is ready to run:

http://local.site/excel

in your browser. You shall see a demonstration of both interpreting and correct displaying of xls file.

Documentation

Documentation of PHP Excel Reader is available here.