Logo

Maarten Balliauw {blog}

ASP.NET, ASP.NET MVC, Windows Azure, PHP, ...

About the author

Maarten Balliauw is currently employed as a Technical Evangelist at JetBrains. His interests are mainly web applications developed in ASP.NET (C#) or PHP and the Windows Azure cloud platform.
More about me More about me
Send mail E-mail me


ASP.NET MVC Quickly Pro NuGet Subscribe to my RSS feed Follow me on Twitter! View Maarten Balliauw's profile on LinkedIn
Maarten Balliauw - MVP - Most Valuable Professional
Maarten Balliauw - ASPInsider

Search

Pages

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 2013


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: General | OpenXML | Personal | PHP | Publications
E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (8) | Post RSSRSS comment feed

Comments (8) -

renganathan India |

Thursday, December 11, 2008 11:35 AM

renganathan

How to Create Excel Sortlist in php coding  

maartenba Belgium |

Thursday, December 11, 2008 11:43 AM

maartenba

Check the PHPExcel manual on that (autofilter)

alains France |

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 |

Wednesday, September 30, 2009 7:57 AM

maartenba

Are you using PHP 5.2+? Latest PHPExcel version?

alains France |

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 |

Wednesday, September 30, 2009 9:23 AM

maartenba

That should work with PHP > 5.2.x

alains France |

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 |

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 ?

Pingbacks and trackbacks (1)+

Comments are closed