基于php导出到Excel或CSV的详解（附utf8、gbk编码转换）php导⼊到excel乱码是因为utf8编码在xp系统不⽀持所有utf8编码转码⼀下就完美解决了Php代码复制代码代码如下:<?phpheader("Content-Type: application/vnd.ms-excel; charset=UTF-8");header("Pragma: public");header("Expires: 0");header("Cache-Control: must-revalidate, post-check=0, pre-check=0");header("Content-Type: application/force-download");header("Content-Type: application/octet-stream");header("Content-Type: application/download");header("Content-Disposition: attachment;filename=11.xls ");header("Content-Transfer-Encoding: binary ");>Php代码复制代码代码如下:<?$filename="php导⼊到excel-utf-8编码";$filename=iconv("utf-8", "gb2312", $filename);echo $filename;>Php代码复制代码代码如下:<?phpheader("Content-Type: application/vnd.ms-excel; charset=UTF-8");header("Pragma: public");header("Expires: 0");header("Cache-Control: must-revalidate, post-check=0, pre-check=0");header("Content-Type: application/force-download");header("Content-Type: application/octet-stream");header("Content-Type: application/download");header("Content-Disposition: attachment;filename=11.xls ");header("Content-Transfer-Encoding: binary ");>Php代码复制代码代码如下:0.<?0.$filename="php导⼊到excel-utf-8编码";0.echo $filename;0.?>访问⽹站的时候就下载到excel⾥⾯要弄单元格区别的话⽤table表格做⽹页的就可以了====================== 其他⽅法 =============================复制代码代码如下:0.<?php0.header("Content-type:application/vnd.ms-excel");0.header("Content-Disposition:filename=php2excel.xls");0.echo "A1/t B1/t C1/n";0.echo "A2/t B2/t C2/n";0.echo "A3/t B3/t C3/n";0.echo "A4/t B4/t C4/n";0.?>复制代码代码如下:<?php$action =$_GET['action'];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>";>也可以做⼀个封闭函数：复制代码代码如下:function exportToCsv($csv_data, $filename = 'export.csv') {$csv_terminated = "/n";$csv_separator = ",";$csv_enclosed = '"';$csv_escaped = "//";// Gets the data from the database$schema_insert = '';$out = '';// Format the dataforeach ($csv_data as $row){$schema_insert = '';$fields_cnt = count($row);//printr($row);$tmp_str = '';foreach($row as $v){$tmp_str .= $csv_enclosed.str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $v).$csv_enclosed.$csv_separator;} // end for$tmp_str = substr($tmp_str, 0, -1);$schema_insert .= $tmp_str;$out .= $schema_insert;$out .= $csv_terminated;} // end whileheader("Cache-Control: must-revalidate, post-check=0, pre-check=0");header("Content-Length: " . strlen($out));header("Content-type: text/x-csv");header("Content-Disposition:filename=$filename");echo $out;/*$csv_data = array(array('Name', 'Address'));array_push($csv_data, array($row['name'],$row['address']));...exportToCsv($csv_data,'new_file.csv');*/复制代码代码如下:<?/*** Simple class to properly output CSV data to clients. PHP 5 has a built* in method to do the same for writing to files (fputcsv()), but many times* going right to the client is beneficial.** @author Jon Gales*/class CSV_Writer {public $data = array();public $deliminator;/*** Loads data and optionally a deliminator. Data is assumed to be an array* of associative arrays.** @param array $data* @param string $deliminator*/function __construct($data, $deliminator = ","){if (!is_array($data)){throw new Exception('CSV_Writer only accepts data as arrays');}$this->data = $data;$this->deliminator = $deliminator;}private function wrap_with_quotes($data){$data = preg_replace('/"(.+)"/', '""$1""', $data);return sprintf('"%s"', $data);}/*** Echos the escaped CSV file with chosen delimeter** @return void*/public function output(){foreach ($this->data as $row){$quoted_data = array_map(array('CSV_Writer', 'wrap_with_quotes'), $row); echo sprintf("%s/n", implode($this->deliminator, $quoted_data));}}/*** Sets proper Content-Type header and attachment for the CSV outpu** @param string $name* @return void*/public function headers($name)header('Content-Type: application/csv');header("Content-disposition: attachment; filename={$name}.csv");}}/*//$data = array(array("one","two","three"), array(4,5,6));$data[] = array("one","two","three");$data[] = array(4,5,6);$csv = new CSV_Writer($data);$csv->headers('test');$csv->output();*/复制代码代码如下:<?phprequire_once 'Spreadsheet/Writer.php';$workbook = new Spreadsheet_Excel_Writer();/* ⽣成 CSV$filename = date('YmdHis').'.csv';$workbook->send($filename); // 发送 Excel ⽂件名供下载*/// ⽣成 Excel$filename = date('YmdHis').'.xls';$workbook->send($filename); // 发送 Excel ⽂件名供下载$workbook->setVersion(8);$workbook->setBIFF8InputEncoding('UTF-8');$worksheet =& $workbook->addWorksheet("Sheet-1");$data[]= array('id','username','company','email','mob','daytime','intent');$data[] = array(1,'⽼梁','**⼯作室','','1363137966*',time(),'y');$total_row = count($data);$total_col = count($data[0]);for ($row = 0; $row < $total_row; $row ++) {for ($col = 0; $col < $total_col; $col ++) {$worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-1 中写⼊数据 }}/*$worksheet =& $workbook->addWorksheet("Sheet-2");$data[]= array('id','username','company','email','mob','daytime','intent');$data[] = array(1,'⽼梁','**⼯作室','','1363137966*',time(),'y');$total_row = count($data);$total_col = count($data[0]);for ($row = 0; $row < $total_row; $row ++) {for ($col = 0; $col < $total_col; $col ++) {$worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-2 中写⼊数据 }}*/$workbook->close(); // 完成下载>读取Excel⽂件function Read_Excel_File($ExcelFile,$Result)$ExcelFile Excel⽂件名$Result 返回的结果函数返回值正常返回0，否则返回错误信息返回的值数组$result[sheet名][⾏][列] 的值为相应Excel Cell的值function Create_Excel_File($ExcelFile,$Data) $ExcelFile Excel⽂件名$Data Excel表格数据请把函数写在PHP脚本的开头例1：复制代码代码如下:<?require "excel_class.php";Read_Excel_File("Book1.xls",$return);for ($i=0;$i<count($return[Sheet1]);$i++){for ($j=0;$j<count($return[Sheet1][$i]);$j++) {echo $return[Sheet1][$i][$j]."|";}echo "<br>";}>例2：复制代码代码如下:<?require "excel_class.php";Read_Excel_File("Book1.xls",$return); Create_Excel_File("ddd.xls",$return[Sheet1]); >。
![[phpexcel]PHP导出EXCEL快速开发指南](https://img.taocdn.com/s1/m/fea99b77f242336c1eb95e83.png)
