dongzhang5787 2015-06-06 07:39
浏览 200

从php创建的“xlsx”文件在excel中打开时会出现格式错误

Initially I created downloadable "xls" file from php and it is opening in Excel. But when I create xlsx file, it is stored with the correct file name and extension but it gives error "Excel cannot open the file 'myfile.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted"

Header info settings code of my PHP is:

    header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    header("Content-Disposition: attachment;filename=\"filename.xlsx\"");
    header("Pragma: no-cache");
    header("Expires: 0");

And the code that enters values in excel file is:

 // 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 mysql_field_name($result, $i) . "\t";
}
print("
");
// End of printing column names

// Start while loop to get data
while($row = mysql_fetch_row($result))
{

$schema_insert = "";
for($j=0; $j<mysql_num_fields($result); $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("/
|
|
|/", " ", $schema_insert);
 $schema_insert .= "\t";
 print(trim($schema_insert));
 print "
";
  }

What could be the problem in it?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥50 potsgresql15备份问题
    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错
    • ¥15 单片机学习顺序问题!!
    • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上