$list = ["123","123","123","123","123","123","123"];

$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
$worksheet   = $spreadsheet->getActiveSheet();
$list        = array_chunk($list, 1000);
$row         = 1;

foreach ($list as $k => $mobiles) {
    foreach ($mobiles as $n => $m) {
        $worksheet->setCellValueByColumnAndRow(1, $row++, $m."\t");
    }
}

$writer = ExcelFactory::createWriter($spreadsheet,'Csv');
header('Content-Description: File Transfer');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename=test' . '-' . time() . '.csv');
header('Cache-Control: max-age=0');
$writer->setUseBOM(true);
$writer->save('php://output');

exit;

阿里云OSS php下载excel

$ossClient = $this->OSSService::getClient();
$context   = $ossClient->getObject(OSSService::PAYMENT_BUCKET, self::getSmsExcelPath($id));
header("Content-type: application/octet-stream");
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="短信列表-' . $id . '.xlsx"');
header('Cache-Control: max-age=0');
header('Content-Type: application/vnd.ms-excel');
echo $context;
Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐