text format problem after transfer to excell

[chyan]

i have create a report with php and i'm planned to transfer it to ms excel
so user can edit that report

so i'm using this function in my PHP

header('Content-Type: application/msexcel');
header('Content-Disposition: inline; filename=data.xls');

the result is almost perfect except only one problem

the problem is in column with id number, where the id number started with zero
like 02011, 02222 etc, Ms excell remove the zero number and display only 2011,2222
but if the id number isnt started with zero, there is no problem

first, i guess it happen because i'm using data tipe 'int' in mysql database so
i'm trying to change it to 'varchar' but the problem still persist

second , i'm try to display the report just in html page with php
and im got a perfect result except no chance to edit the report
so the problem might be in excell because excell don't treat the id number as a string

but meanwhile, im still prefer to transfer it to excel, and let the user to used the excell function
and format the column to text then add the missing zero

i just want to know if there is a chance to solve my problem,so my user can get the
instant result

HELP ME

[weekender]

try enclosing the id data in "quotes"

[chyan]

l'd do that but nothing happen
excell still dont display the first zero number

[tekky]

Originally posted by chyan
l'd do that but nothing happen
excell still dont display the first zero number

for General cell formats leading 0's are dropped, to preserve leading 0's you need to set your cell format to Text (possibly another format that would work but I've always used Text for leading 0's)

[edit -- note to the not so obvious people out there -- cell formats I am referring to are Excel options not HTML --]

[chyan]

here is my updated code ;

in beginning section :

header('Content-Type: application/msexcell');
header('Content-Disposition: inline; filename=data.xls');

in body section :

if($ss=='state' && $ss==''){

$view1="select id, name,address,phone,state from user_data
where state='$st'";

if(!$result1=mysql_query($view1,$dbh))
{
echo mysql_error();
exit;
}

while ($row1=mysql_fetch_array($result1)){
echo "<hr width=95% align=left>";
echo "<table border=1 cellpadding=0 cellspacing=0 width=95% bgcolor=cecece>";
echo "<tr><td><b>User Data<b></td></tr>";
echo "</table><br>";
echo "<table border=0 cellpadding=0 cellspacing=0 width=95% >";
echo "<tr>";
echo "<td width=20%><font face=arial,helvetica,sans-serif size=-2><b>id Number</b></td>";
echo "<td width=80%><font face=arial,helvetica,sans-serif size=-2>: \"".$row1[id]."\"</td>"; // i had quoted the id number 
echo "<tr>";
echo "<td width=20%><font face=arial,helvetica,sans-serif size=-2><b>Name</b></td>";
echo "<td width=80%><font face=arial,helvetica,sans-serif size=-2>: $row1[name]</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=20%><font face=arial,helvetica,sans-serif size=-2><b>Address</b></td>";
echo "<td width=80%><font face=arial,helvetica,sans-serif size=-2>: $row1[address]</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=20%><font face=arial,helvetica,sans-serif size=-2><b>Phone</b></td>";
echo "<td width=80%><font face=arial,helvetica,sans-serif size=-2>: $row1[phone]</td>";
echo "<tr>";
echo "<td width=20%><font face=arial,helvetica,sans-serif size=-2><b>state</b></td>";
echo "<td width=80%><font face=arial,helvetica,sans-serif size=-2>: $row1[state]</td>";
echo "</tr>";
echo "<tr>";
echo "</table><br>";
}

anything wrong with my coding?

how can i use php to automatically format the cell to text before the data being transferred to excell ?

[tekky]

ok question

does your SQL table contain leading 0's? if not then you would just need to fix that... beyond that, I have never used PHP to display data inline via Excel so I couldnt help you there

[chyan]

there is no problem in my sql data filed
the problem was occur when i transfered data to excell

anyway thank you