public function dade(Request $request){
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('D:\PDA任务库.xlsx');
$obj = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Html');
//直接输出桌面
//echo $obj->save("php://output");
//保存到服务器
$date = date("Ymd");
$Absolute_Path=$_SERVER['SCRIPT_FILENAME'];
$user_path = substr($Absolute_Path,0,-9)."public/storage/html/{$date}";//保存路径
if(!is_dir($user_path)){
mkdir($user_path,0777,true);
}
$dates = date("YmdHis");
$filename = "{$user_path}/{$dates}.html";
$obj->save($filename);
return json(['code'=>200,'url'=>$user_path]);
//直接输出到桌面
//echo file_get_contents($filename);
}
php使用PhpSpreadsheet把文档转换成html预览
最新推荐文章于 2024-05-30 12:54:24 发布