help with exporting to excel

[knowram]

I followed the really cool how to at http://www.phpfreaks.com/tutorials/114/0.php but I had to change some things to get it to stop giving me errors. After I did that It seemed to work great but it put everything into one cell in the excel document.

 

Any ideas?

 

Here is what I had to change.

 

for ($i = 0; $i < $fields; $i++) {
$header .= mssql_field_name($export, $i) . "\t";
}

TO

for ($i = 0; $i < $fields; $i++) {
	if (empty($header)){
		$header = mssql_field_name($export, $i) . "\t";
	}else{
		$header .= mssql_field_name($export, $i) . "\t";
	}
}

And

while($row = mssql_fetch_row($export)) {
	    $line = '';
	    foreach($row as $value) {
	        if ((!isset($value)) OR ($value == "")) {
	            $value = "\t";
	        } else {
	            $value = str_replace('"', '""', $value);
	            $value = '"' . $value . '"' . "\t";
	        }
	        $line .= $value;
	    }
	    $data .= trim($line)."\n";
	}
	$data = str_replace("\r","",$data);

 

TO

while($row = mssql_fetch_row($export)) {
	    $line = '';
	    foreach($row as $value) {
	        if ((!isset($value)) OR ($value == "")) {
	            $value = "\t";
	        } else {
	            $value = str_replace('"', '""', $value);
	            $value = '"' . $value . '"' . "\t";
	        }
	        $line .= $value;
	    }
	    if (empty($data)){
	    	$data = trim($line)."\n";
	    }else{
	    	$data .= trim($line)."\n";
	    }
	}
	$data = str_replace("\r","",$data);

 

Thanks for the help