Generating Excel in php

I am accustomed to generating Excel spreadsheets in php programs using

header("Content-type: application/");
$fn = "excel" . date('Y-m-d_h_i') . ".xls";
header("Content-Disposition: attachment; filename=" . $fn);

I now have a customer that wants excel formulas in cells, etc.

I'm guessing that when I understand the details of the formulas, I can just print those formulas in the appropriates cells; like sum(G4:G67), etc.

There is apparently a Ruby on Rails Gem that does all this.

Is there anything comparable in php?
Richard KortsAsked:
Who is Participating?
GaryConnect With a Mentor Commented:
PHPExcel has all the classes for you including adding formulae to cells

Would be a lot easier than writing up all your own code.
Richard KortsAuthor Commented:

Look for my next question about YAML.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.