<?php $fileName = "fileName"; header("Content-Type:text/csv;charset=UTF-8"); //'text/csv'是CSV文件，'application/vnd.ms-excel'是excel文件 header("Content-Disposition: attachment; filename=" . $fileName . ".csv"); //$fileName文件名，“.csv”文件扩展名也可是".xls"excel文件 header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); header('Expires:0'); header('Pragma:public'); echo "\n" . iconv("utf-8", "gbk", "大连,") . "\t" . iconv("utf-8", "gbk", "大连2"); //echo就是输出内容到文件中，"\n"是换行，"\t"在excel文件里是换格，","在CSV文件里是换格 //生成或补充CSV文件也可用如下方法 $fileName = "test.csv"; $file = fopen($fileName, 'a');//打开指定csv文件，没有则创建 $fields = array( "txt11" , "txt21" , "txt31"); fputcsv ( $file , $fields );//在打开的csv文件内容末尾另起一行，添加数组中内容，数组一个元素代表一个单元格 $fields = array( "txt12" , "txt22" , "txt32"); fputcsv ( $file , $fields );//再另起一行添加数组内容 fclose ( $file );//关闭文件句柄 //生成excel还有如下方法 $filename = "导出数据表"; $filename_type = 'xls'; header ( "Content-Type: application/vnd.ms-excel" ); Header ( "Accept-Ranges:bytes" ); Header ( "Content-Disposition:attachment;filename=" . $filename . "." . $filename_type ); // $filename导出的文件名 header ( "Pragma: no-cache" ); header ( "Expires: 0" ); echo ' <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="expires" content="Mon, 06 Jan 1999 00:00:01 GMT"> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <!--[if gte mso 9]><xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name></x:Name> <x:WorksheetOptions> <x:DisplayGridlines/> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> </x:ExcelWorkbook> </xml><![endif]--> </head>' ; echo "<table>"; echo " <tr> <td>".iconv ( "utf-8", "gbk", "标题一 ")."</td> <td>".iconv ( "utf-8", "gbk", "标题二 ")."</td> <td>".iconv ( "utf-8", "gbk", "标题三")."</td> </tr> "; echo " <tr> <td>".iconv ( "utf-8", "gbk", '内容一' )."</td> <td style='vnd.ms-excel.numberformat:@'>12345678910123456</td> <td style='vnd.ms-excel.numberformat:yyyy-mm-dd'>2016/10/24</td> </tr> "; echo "</table>"; exit (); //<td>即代表换格，<tr>代表换行 //style='vnd.ms-excel.numberformat:@'表示避免将表格中长数字用科学计数显示 //style='vnd.ms-excel.numberformat:yyyy-mm-dd' 表示将表格中内容按指定样式显示