two requests for a helpful person

[sfullman]

Hi, I should know this but here I am asking for help:

1. I need to start working with Excel Spreadsheets, i.e. creating them. I can create a "mickey mouse" spreadsheet already by writing an HTML table with data with fwrite(), calling it something.xls, and giving a link to it. Most browsers open this as an excel spreadsheet of sorts, and Excel seems to recognize this as well.

But, I need to create a REAL spreadsheet with at least some basic formulas such as "[this field] = A1 + B1*1.08", and also creating a named range.

2. How to do output a header("Content-typ: application/x-msexcel"); directive or something so that the browser thinks my php file is actually an excel spreadsheet? The above x-msexc.. doesn't work, it still comes out as text/html.

Profuse quantities of reference links would be greatly appreciated!!!

Sam Fullman
Compass POint Media

[hand]

A simple sample

<?php
$DATABASE = "test";
$TABLE_NAME = "sample";

Header("Content-Type: application/vnd.ms-excel");

mysql_connect("localhost", "", "")
       or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

mysql_select_db($DATABASE)
       or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

$result = mysql_query("SHOW FIELDS FROM $DATABASE.$TABLE_NAME");

while ($row = mysql_fetch_array($result)) {
    print "$row[Field] $row[Type]\t";
    $fields[] = $row[Field];
}
print "\n"; 

$query_text = "SELECT * FROM $TABLE_NAME";

$result = mysql_query($query_text);

while ($row = mysql_fetch_array($result)) {
   for ($i=0; $i<count($fields); $i++) {
        print $row[$fields[$i]]."\t"; 
   }
   print "\n";
}
?>

Some classes you can find here
http://byting.mirrors.phpclasses.org/search.html?words=excel&go_search=1