<?php
ini_set(
  'include_path',
  ini_get( 'include_path' ) . PATH_SEPARATOR . "pear/php"
);
$database = "";
$database_host = "";
$database_username = "";
$database_password = "";
require_once "Spreadsheet/Excel/Writer.php";

// Create an instance
 $xls =& new Spreadsheet_Excel_Writer();

// Send HTTP headers to tell the browser what's coming
$xls->send("filename.xls");

// Add a worksheet to the file, returning an object to add data to
$sheet =& $xls->addWorksheet('Worksheet Name');

$tabledata = get_table_data("table");
$i=0;
foreach($tabledata as $table) {
        $sheet->write(0, $i, $table['name']);
        $i++;
}

$result = sqlquery("SELECT * from table");
$data = get_result($result);
$i=1;
foreach($data as $d) {
        $j=0;
        foreach($tabledata as $table) {
                $sheet->write($i, $j, $d[$table['name']]);
                $j++;
        }
        $i++;
}


// Finish the spreadsheet, dumping it to the browser
$xls->close();

?>