PhpOffice/PhpSpreadsheet 导出csv 阿里云OSS php下载excel
·
$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;
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)