blog community

Welcome to blog community Sign in | Join | Help
in Search

Wouter van Vugt

This blog is no longer maintained and has moved

Spreadsheet formulas and PHP

One of the things that I tell in my Open XML workshops is that when you insert a new row in a spreadsheet, before rows that have formulas in them, you probably have to manually update those formulas since they now reference rows that have moved because of the insertion. To support this better you need a framework that implements a formula parser, but which also updates the formulas for you, not an easy task!

After reading Maarten's blog, I noticed that his PHP library already does this! See his 1.3.0 release.

Almost enough to make me start programming PHP Maarten!

 

Published Thursday, August 02, 2007 3:07 PM by wouterv
Filed under: ,

Comments

 

Maarten said:

It really is cool, I was impressed with it myself :-) Actually, I ported a JavaScript formula parser to PHP, and added a "compiler" (to PHP code). This is quite handy, as you can insert/delete columns and rows. I'm playing with the idea of a port of PHPExcel to C#, but that would cost me too much time (which I'd rather spend on implementing graph support into PHPExcel). About learning PHP: maybe you and Doug can team up, he's quite busy doing some study on that...
August 2, 2007 8:29 PM
 

Doug Mahugh said:

Shh, Maarten, I was hoping to actually learn something before Wouter. Wouter, please carry on with your .NET ways and leave the real-man PHP programming to me and Maarten. :-)
August 7, 2007 12:48 AM
Anonymous comments are disabled

This Blog

Syndication

News


Add to Technorati Favorites
Powered by Community Server, by Telligent Systems