yes!
read this part of the code:
$export = mysql_query("SELECT * FROM your_table");
$count = mysql_num_fields($export);
for ($i = 0; $i < $count; $i++) {
$header .= strtoupper(mysql_field_name($export, $i))."\t";
}
while($row = mysql_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);
if ($data == "") {
$data = "\n(0) Records Found!\n";
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=yourfile.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";
----- Original Message -----
From: egacatorce
To: [email protected]
Sent: Friday, September 08, 2006 1:40 PM
Subject: [php_mysql] Writing Data To Excel File
Guys,
I haven't done this yet. How can I write data from MySQL database to
MS Excel file using PHP? Thanks!
[Non-text portions of this message have been removed]
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php_mysql/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
