export data to excel file (works on IE/Firefox but not google chrome)

[new_php85]

Hi Guys....

 

I need to export data into excel file. So far its works on IE and Firefox. But if i using Google Chrome it download only php file. Eg(suppose file test.xls but it goes to test.php). 

 

Why it happen??

[trq]

Why it happen??

 

How should we know?

[new_php85]

Basically, i using this code to generate excel file

 

if($_REQUEST["rFormat"]=="2")

{

          header("Content-Type:  application/x-msexcel");

          header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

          header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

}

 

and it works at IE and FF. Only google chrome not work.

[new_php85]

Basically, i using this code to generate excel file

 

if($_REQUEST["rFormat"]=="2")

{

          header("Content-Type:  application/x-msexcel");

          header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

          header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

}

 

and it works at IE and FF. Only google chrome not work.

 

i got the problem

 

it suppose like this

 

if($_REQUEST["rFormat"]=="2")

{

      header("Content-Type:  application/x-msexcel");

      header("Expires: 0");

      header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

      header("Content-Disposition: attachment; filename=email_sms_export.xls");// i missed out this link

}

 

now its works on IE/FF/Google Chrome