Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm trying to print out mysql table data into excel.  I found code on
web but it outputs everything into one cell instead of spacing out on
spreadsheet.  I have no clue how to fix.

$result = mysql_query("SELECT * FROM $db_table3");
$count = mysql_num_fields($result);

for ($i = 0; $i < $count; $i++){
$header .= mysql_field_name($result, $i)."\t";

while($row = mysql_fetch_row($result)){
$line = '';
foreach($row as $value){
if(!isset($value) || $value == ""){
$value = "\t";
# important to escape any quotes to preserve them in the data.
# needed to encapsulate data in quotes because some data might be
multi line.
# the good news is that numbers remain numbers in Excel even though
$value = $value . "\t";
$line .= $value;
$data .= trim($line)."\n";
# this line is needed because returns embedded in the data have "\r"
# and this looks like a "box character" in Excel
$data = str_replace("\r", "", $data);
# Nice to let someone know that the search came up empty.
# Otherwise only the column name headers will be output to Excel.
if ($data == "") {
$data = "\nno matching records found\n";
# This line will stream the file to the user rather than spray it
across the screen
header("Content-type: application/octet-stream");
# replace excelfile.xls with whatever you want the filename to default
header("Content-Disposition: attachment; filename=excelfile.xls");
header("Pragma: no-cache");
header("Expires: 0");
echo $header."\n".$data;

Re: spreadsheet

On Wed, 04 Jul 2007 01:21:05 -0000, up2trouble

Quoted text here. Click to load it

Output it into an HTML table as if you were displaying it on a
You can even do pretty colours!

helped me...
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html

Re: spreadsheet

On 4 jul, 03:06, David Quinton
Quoted text here. Click to load it

You could try saving your file as txt file and then import it from
Excel, in that way you'll make sure that the content that you are
generating is ok and you should focus in find the correct headers for
the file.

Site Timeline