php產生excel或php產生csv

標籤：

一、php產生excel

使用phpexcel類檔案產生

 

二、php產生csv

<?php
$action ="make";
if ($action==‘make‘){
$fp = fopen("demo_csv.csv","a"); //開啟csv檔案，如果不存在則建立
$title = array("First_Name","Last_Name","Contact_Email","Telephone"); //第一行資料

$data_1 = array("42343","423432","4234","4234");
$data_2 = array("4234","Last_Name","Contact_Email","Telephone");

$title = implode(",",$title); //用 ‘ 分割成字串
$data_1 = implode(",",$data_1); // 用 ‘ 分割成字串
$data_2 = implode(",",$data_2); // 用 ‘ 分割成字串

$data_str =$title."\r\n".$data_1."\r\n".$data_2."\r\n"; //加入分行符號
fwrite($fp,$data_str); // 寫入資料
fclose($fp); //關閉檔案控制代碼
echo "產生成功";
}
echo "<br>";
echo "<a href=‘?action=make‘>產生csv檔案</a>";
?>

php產生excel或php產生csv