A few people have recently asked me about outputting data to Excel. This is a very simple thing to do from PHP with two lines of code.
[cc lang=”PHP”]header(“Content-type: application/vnd.ms-excel”);
header(“Content-Disposition: attachment; filename=webbased.xls”);[/cc]
After this just output your data to a table which you can style using in-line CSS.
PS you can also use formulas.