php and excel

[asherinho]

hi! can anyone help,I want the excel sheet to open in maximized mode instead of restore mode.I have a php page which query the database and writes the results to the excel sheet but on opening the excel sheet,it opens in restore mode.Below are codes for the page which does the query and writing to excel,but it refers some classes.Any idea?

 

<?php
require("connection.php");
$db=mysql_connect("$host","$user","$password");
  mysql_select_db("$dbname",$db);
	$result=mysql_query("SELECT * FROM file_info WHERE actn_officer != 'registerer' ORDER BY file_no");
	$num_rows=mysql_num_rows($result);
       
set_time_limit(10);

require_once "class.writeexcel_workbook.inc.php";
require_once "class.writeexcel_worksheet.inc.php";

$fname = tempnam("/tmp", "result.xls");
$workbook = &new writeexcel_workbook($fname);
$worksheet = &$workbook->addworksheet();



$border2 =& $workbook->addformat();

$worksheet->set_column(0, 0, 34);
$worksheet->set_column(1, 1, 34);
$worksheet->set_column(2, 2, 34);
$worksheet->set_column(3, 3, 34);
$worksheet->set_column(4, 4, 34);
$worksheet->set_column(5, 5, 34);
$worksheet->set_column(6, 6, 34);
$worksheet->set_column(7, 7, 12);
$worksheet->set_column(8, 8, 28);
$worksheet->set_column(9, 9, 26);
$worksheet->set_column(10, 10, 36);
$worksheet->set_column(11, 11, 36);

$border2->set_bold();
$border2->set_align('center');
$border2->set_size(10);
$today=getdate(time());
$worksheet->write(0, 0, $today["year"]/$today["mon"]/$today["mday"]);
$worksheet->write(1, 0, "FILE NUMBER",$border2);
$worksheet->write(1, 1, "FILE NAME",$border2);
$worksheet->write(1, 2, "ACTION",$border2);
$worksheet->write(1, 3, "POSTAL ADDRESS",$border2);
$worksheet->write(1, 4, "PHONE NUMBER",$border2);
$worksheet->write(1, 5, "FAX NUMBER",$border2);
$worksheet->write(1, 6, "EMAIL",$border2);
$worksheet->write(1, 7, "DATE",$border2);
$worksheet->write(1, 8, "TIME",$border2);
$worksheet->write(1, 9, "OFFICER",$border2);
$worksheet->write(1, 10, "PREV OFFICER",$border2);
$worksheet->write(1, 11, "DEPARTMENT",$border2);
$i=2;
while( $record=mysql_fetch_assoc($result)){
$worksheet->set_column($i, $i, 13);
  $worksheet->write($i, 0, $record["file_no"]);
  $worksheet->write($i, 1, $record["file_name"]);
  $worksheet->write($i, 2, $record["action"]);
  $worksheet->write($i, 3, $record["postal_adres"]);
  $worksheet->write($i, 4, $record["phone"]);
  $worksheet->write($i, 5, $record["fax"]);
  $worksheet->write($i, 6, $record["email"]);	 
  $worksheet->write($i, 7, $record["date_taken"]);
  $worksheet->write($i, 8, $record["time"]);
  $worksheet->write($i, 9, $record["actn_officer"]);
  $worksheet->write($i, 10, $record["prev_officer"]);
  $worksheet->write($i, 11, $record["department"]);
  $i++;

  }

$workbook->close();

header("Content-Type: application/x-msexcel; name=\"example-repeat.xls\"");
header("Content-Disposition: inline; filename=\"example-repeat.xls\"");
$fh=fopen($fname, "rb");
fpassthru($fh);
unlink($fname);

?>