而不是生成.xls文件我在服务器端获得.php文件

I'm using following headers to generate excel file from database MySQL using PHP

header("Content-type: application/octet-stream");
header("Content-Type: application/vnd-ms-excel");
header("Content-disposition: attachments;filename=xxx.xls");

in localhost the output is xxx.xls which is correct file but in the server side i am getting xxx.php file (i am using a cpanel account for ftp) guys please help me with a solution

simply use

header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="file.xls"');

Simply you can use the following php code. You have to give an array with key value pair

      $data = array("Name"=> "foo", "age" => 25);
      $filename = "My File Name" . date('Ymd') . ".xls";

     header("Content-Disposition: attachment; filename=\"$filename\"");
     header("Content-Type: application/vnd.ms-excel");

     $flag = false;
     foreach($data as $row) {
        if(!$flag) {
            // display field/column names as first row
            echo implode("\t", array_keys($row)) . "
";
            $flag = true;
        }

        foreach ($row as $value){

            echo $value;
            echo "\t";
        }
        echo "
";
     }
     exit;