I can't see a way to pass formulas to excel. Without this, it is of very limited use.

Jepp, this is true. I am already working on allowing at least the most simple mathematic operations. Stay tuned for an update beginning of next week. Currently it's really just a data dump into an xml file.

I just took a look into the formula thing and I am quite impressed how excel deals with this. However, I am not sure how to implement such a feature. Adding formular usage to the class will definitely make it lose it's "lightweight".

Hello!

For a personal project I made this little modification to AddRow method to put a simple formula at worksheet

if (preg_match('/^=/', $v)) { $type = 'Number'; // $cells .= "\n"; }

OBS: RC it's cells offset from current position I know this resolv my own issue and it's far from being a global solution , but may could help.

Bye!

I've checked various possibilities to insert formulas into the excel/XML document. Quite easy, when parsing the equal sign "=" at the beginning of the string. However, I decided, not to support formulas in version 1 releases of the library.

Introducing formulas insertion needs more than the creation of an array for dumping into excel. So a preparation wrapper would be the best way to enter single cells, add up to rows and finally to columns. This exceeds the idea of a simple dump library.