我正在尝试使用php- .txt表生成.txt文件的excel,我首先创建的是.txt数据数组,而不是使用php-电子表格将.txt数据写入excel,但在打开该excel时,我得到了以下错误消息。
由于文件格式或扩展名无效,所以
Excel无法打开该文件,请确认该文件尚未损坏,并且文件扩展名与文件格式匹配。
$lines = array();
$fopen = fopen('read.txt', 'r');
while (!feof($fopen)) {
$line=fgets($fopen);
$line=trim($line);
$lines[]=$line;
}
fclose($fopen);
$finalOutput = array();
foreach ($lines as $string)
{
$string = preg_replace('!\s+!', ' ', $string);
$row = explode(" ", $string);
array_push($finalOutput,$row);
}
echo "<pre>";
print_r($finalOutput);
echo "</pre>";
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Writer\Xls;
use PhpOffice\PhpSpreadsheet\Writer\Csv;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->fromArray($finalOutput, NULL, 'A1');
// redirect output to client browser
header('Content-Disposition: attachment;filename="myfile.xlsx"');
header('Cache-Control: max-age=0');
$writer = new Xlsx($spreadsheet);
$writer->save('php://output');发布于 2022-10-19 08:18:38
请在生成xlsx文件的标题之前删除/注释脚本中的所有数据输出语句。请记住,在发送任何实际输出之前,应该调用header()。您可以参考以下链接(正式文件):
https://www.php.net/manual/en/function.header.php
(1)因此,请注明以下3行
echo "<pre>";
print_r($finalOutput);
echo "</pre>";(2)可选的-另一方面,对于您的情况,如果不需要使用xls和csv,tyen也要注意这两行。
use PhpOffice\PhpSpreadsheet\Writer\Xls;
use PhpOffice\PhpSpreadsheet\Writer\Csv;所以改变到
<?php
$lines = array();
$fopen = fopen('read.txt', 'r');
while (!feof($fopen)) {
$line=fgets($fopen);
$line=trim($line);
$lines[]=$line;
}
fclose($fopen);
$finalOutput = array();
foreach ($lines as $string)
{
$string = preg_replace('!\s+!', ' ', $string);
$row = explode(" ", $string);
array_push($finalOutput,$row);
}
// echo "<pre>";
// print_r($finalOutput);
// echo "</pre>";
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
//use PhpOffice\PhpSpreadsheet\Writer\Xls;
//use PhpOffice\PhpSpreadsheet\Writer\Csv;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->fromArray($finalOutput, NULL, 'A1');
// redirect output to client browser
header('Content-Disposition: attachment;filename="myfile.xlsx"');
header('Cache-Control: max-age=0');
$writer = new Xlsx($spreadsheet);
$writer->save('php://output');https://stackoverflow.com/questions/74121324
复制相似问题