Logo

Maarten Balliauw {blog}

ASP.NET, ASP.NET MVC, Azure, PHP, OpenXML, VSTS, ...

About the author

Maarten Balliauw is an MVP ASP.NET and is currently employed as .NET Software Engineer at RealDolmen. His interests are mainly web applications developed in ASP.NET (C#) or PHP.
More about me More about me
Send mail E-mail me


Microsoft Most Valuable Professional - MVP - ASP.NET

Subscribe to my RSS feed Follow me on Twitter! View Maarten Balliauw's profile on LinkedIn RealDolmen - Rock-solid passion for ICT
I'm a speaker at TechDays Belgium and TechDays Finland

Search

Pages

Latest Twitter

    Follow me on Twitter...

    My projects

    Recent posts

    Categories


    Archive

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

    © Copyright Maarten Balliauw 2010

    PHPExcel featured in php|architect / November 2008

    Posted by maartenba on Monday, December 01, 2008 7:32 AM

    Cover of php|architect / November 2008 Nice to see that there's a lot of activity going on related to PHPExcel! This weekend, I receievd my electronic copy of php|architect / November 2008 featuring an article on generating PDF and Excel files using PHP. Guess which library is being used in the second part of the article...

    While reading the article, I noticed a very cool thing: the author, Aaron Wormus, is using a convenient way to generate charts in PHPExcel using Google Charts API. Since PHPExcel currently does not support creating graphs, this is really a good method to use charts in PHPExcel generated Excel files. Here's a screenshot of the generated file in the magazine:

    image 

    Sweet!


    Categories: CodePlex | General | ICT | Internet | OpenXML | Personal | PHP | Publications | XML
    E-mail | Kick it! | DZone it! | del.icio.us
    Permalink | Comments (9) | Post RSSRSS comment feed

    Comments

    renganathan India | Reply

    Thursday, December 11, 2008 11:35 AM

    renganathan

    How to Create Excel Sortlist in php coding  

    maartenba Belgium | Reply

    Thursday, December 11, 2008 11:43 AM

    maartenba

    Check the PHPExcel manual on that (autofilter)

    alains France | Reply

    Tuesday, September 29, 2009 10:06 PM

    alains

    bonjour,

    je n'arrive pas à utiliser PHPExcel
    j'obtiens  :

    Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /homez.194/plaidoye/www/PHPExcel.php on line 70

    je dois oublier quelque-chose d'évident pour vous

    voici le début du  source de mon php :

    /** PHPExcel */
    require_once 'PHPExcel.php';

    /** PHPExcel_Cell_AdvancedValueBinder */
    require_once 'PHPExcel/Cell/AdvancedValueBinder.php';

    /** PHPExcel_IOFactory */
    require_once 'PHPExcel/IOFactory.php';



    $objReader = PHPExcel_IOFactory::createReader('Excel2007');
    $objReader->setReadDataOnly(true);

    $objPHPExcel = $objReader->load("FichiersDesEcoles/Liste_ecoles.xls");
    $objWorksheet = $objPHPExcel->getActiveSheet();


    merci d'avance pour votre compréhension

    maartenba Belgium | Reply

    Wednesday, September 30, 2009 7:57 AM

    maartenba

    Are you using PHP 5.2+? Latest PHPExcel version?

    alains France | Reply

    Wednesday, September 30, 2009 8:20 AM

    alains

    thank you very uuch for your answer
    i  am using the release I found on your site  so called : PHPExcel 1.7.0 Production
    is it correct ?

    AS

    maartenba Belgium | Reply

    Wednesday, September 30, 2009 9:23 AM

    maartenba

    That should work with PHP > 5.2.x

    alains France | Reply

    Wednesday, September 30, 2009 2:50 PM

    alains

    After having changed some parameter in order to use PHP 5  this problem disappeared.

    it happened only some minutes before now

    but now comes a new problem

    my Excel file size is 5 MO

    the load function aborts because of lack of memory

    I understand that the whole file is put into RAM

    It works if the file size is < 150 KO

    Is it possible not to load the whole file into memory ?

    alains France | Reply

    Wednesday, September 30, 2009 4:32 PM

    alains


    I changed some parameter to use PHP 5  and now it works !
    but now appears a new problem : the memory size (mutualized server) is not enough
    (32 MO)
    the file's size is 5 MO
    It seems that when in RAM, it needs more than 32 MO

    so if I load only one sheet I have the following problem :

    this sheet contains formulas refering to other sheets which are not loaded

    -> the cells containing formulas have no more values

    is it possible to do better ?

    oshuamoreno.com | Reply

    Friday, October 23, 2009 2:32 AM

    pingback

    Pingback from oshuamoreno.com

    PHPExcel: read Excel from LAMP | Oshua Moreno

    Add comment




      Country flag

    biuquote
    • Comment
    • Preview
    Loading