php导出excel全部在一起,在php中导出到excel在所有计算机中都不能正常工作

我正在尝试使用php将数据从数据库导出到excel。但是它的导入是正确的,并且可以完美地打开文件。但在少数机器和安卓手机中,它根本不起作用

它显示了无效扩展的错误。

这是我正在使用的代码

$result = mysqli_query($db, "SELECT Distinct a.*,b.* FROM OrderCalculation a right join crm_order b on a.orderid = b.orderno");

$file_ending = "xls";

//header info for browser

header("Content-Type: application/xls");

header("Content-Disposition: attachment; filename=$filename.xls");

header("Pragma: no-cache");

header("Expires: 0");

/*******Start of Formatting for Excel*******/

//define separator (defines columns in excel & tabs in word)

$sep = "\t"; //tabbed character

//start of printing column names as names of MySQL fields

//for ($i = 0; $i < mysql_num_fields($result); $i++) {

//echo mysqli_fetch_field_direct($result,$i) . "\t";

//}

//print("\n");

//end of printing column names

//start while loop to get data

while($row = mysqli_fetch_array($result))

{

$schema_insert = "";

for($j=0; $j

{

if(!isset($row[$j]))

$schema_insert .= "NULL".$sep;

elseif ($row[$j] != "")

$schema_insert .= "$row[$j]".$sep;

else

$schema_insert .= "".$sep;

}

$schema_insert = str_replace($sep."$", "", $schema_insert);

$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);

$schema_insert .= "\t";

print(trim($schema_insert));

print "\n";

}

如有任何帮助,我们将不胜感激。

谢谢