header(''Content-Type: application/vnd.ms-excel; charset=utf8'');

header(''Content-Type: application/vnd.ms-excel; charset=gbk'');

header(''Content-Type: application/vnd.ms-excel; charset=gb18030'');

echo mb_convert_encoding(implode('','', array_values($titles)), ''gb18030'') . "\n";

/**     
* 用于生成excel文件的函数     
* author:walker     
* @param $data 生成excel的数据(二维数组形式)     
* @param null $savefile 生成excel的文件名(保不指定,则为当前时间戳)     
* @param null $title 生成excel的表头(一维数组形式)     
* @param string $sheetname 生成excel的sheet名称(缺省为sheet1)     
*/    
function exportExcel($data,$savefile=null,$title=null,$sheetname='sheet1'){        
//若没有指定文件名则为当前时间戳        
if(is_null($savefile)){            
$savefile=time();        
}        
//若指字了excel表头，则把表单追加到正文内容前面去        
if(is_array($title)){            
array_unshift($data,$title);        
}        import('Org.Util.PHPExcel');		
import('Org.Util.PHPExcel.IOFactory');        
import('PHPExcel.Util.PHPExcel.Reader.Excel5');        
$objPHPExcel = new \PHPExcel();        
//Excel内容        
foreach($data as $k => $v){            
$obj=$objPHPExcel->setActiveSheetIndex(0);            
$row=$k+1;//行            
$nn=0;            
foreach($v as $vv){                
$col=chr(65+$nn);//列                
$vv = iconv("UTF-8", "GB2312//IGNORE",$vv);                
$obj->setCellValue($col.$row,$vv);//列,行,值                
$nn++;            
}        
}        
$objPHPExcel->getActiveSheet()->setTitle($sheetname);        
$objPHPExcel->setActiveSheetIndex(0);        
header('Content-Type: application/vnd.ms-excel');        
header('Content-Disposition: attachment;filename="'.$savefile.'.xls"');        
header("Content-Type: application/vnd.ms-excel; charset=UTF-8");        
header('Cache-Control: max-age=0');        
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        
$objWriter->save('php://output');        
exit;    }     
/**     
*     
* 导出Excel     
*/    
function expUser(){//导出Excel        
$xlstitle  = array('id','商品编码','模板编号','商品名称','总库存','当前库存','供应商');        
$xlssql = M('erp_inventory');        
$xlsData  = $xlssql->getField('id,p_code,mid,pname,banlance,cur_banlance,factory');
//         show_bug($xlsData);die;       
$this->exportExcel($xlsData,time(),$xlstitle);             
}

include 'Plugin/PHPExcel/Classes/PHPExcel.php';
//        import('Org.Util.PHPExcel.IOFactory');
//        import('PHPExcel.Util.PHPExcel.Reader.Excel5');
$data = array(  array('中','文','c'),  array('a','b','c'),  array('a','b','c'),);
$sheetname = '123';
$savefile = time();        
$objPHPExcel = new PHPExcel();        
//Excel内容        
foreach($data as $k => $v){            
$obj=$objPHPExcel->setActiveSheetIndex(0);            
$row=$k+1;//行            
$nn=0;            
foreach($v as $vv){                
$col=chr(65+$nn);//列$vv = iconv('gbk', 'utf-8', $vv);                
$obj->setCellValue($col.$row,$vv);//列,行,值                
$nn++;            
}        
}        
$objPHPExcel->getActiveSheet()->setTitle($sheetname);        
$objPHPExcel->setActiveSheetIndex(0);        
header('Content-Type: application/vnd.ms-excel');        
header('Content-Disposition: attachment;filename="'.$savefile.'.xls"');        
header("Content-Type: application/vnd.ms-excel; charset=UTF-8");        
header('Cache-Control: max-age=0');        
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        
$objWriter->save('php://output');

include 'Plugin/PHPExcel/Classes/PHPExcel.php';
//        import('Org.Util.PHPExcel.IOFactory');
//        import('PHPExcel.Util.PHPExcel.Reader.Excel5');
$data = array(  array('中','文','c'),  array('a','b','c'),  array('a','b','c'),);
$sheetname = '123';
$savefile = time();        
$objPHPExcel = new PHPExcel();        
//Excel内容        
foreach($data as $k => $v){            
$obj=$objPHPExcel->setActiveSheetIndex(0);            
$row=$k+1;//行            
$nn=0;            
foreach($v as $vv){                
$col=chr(65+$nn);//列
$vv = iconv('gbk', 'utf-8', $vv);                
$obj->setCellValue($col.$row,$vv);//列,行,值                
$nn++;            
}        
}        
$objPHPExcel->getActiveSheet()->setTitle($sheetname);        
$objPHPExcel->setActiveSheetIndex(0);        
header('Content-Type: application/vnd.ms-excel');        
header('Content-Disposition: attachment;filename="'.$savefile.'.xls"');        
header("Content-Type: application/vnd.ms-excel; charset=UTF-8");        
header('Cache-Control: max-age=0');        
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        
$objWriter->save('php://output');

include 'Plugin/PHPExcel/Classes/PHPExcel.php';
//        import('Org.Util.PHPExcel.IOFactory');
//        import('PHPExcel.Util.PHPExcel.Reader.Excel5');$data = array(  array('中','文','c'),  array('a','b','c'),  array('a','b','c'),);
$sheetname = '123';
$savefile = time();        
$objPHPExcel = new PHPExcel();        
//Excel内容        
foreach($data as $k => $v){            
$obj=$objPHPExcel->setActiveSheetIndex(0);            
$row=$k+1;//行            
$nn=0;            
foreach($v as $vv){                
$col=chr(65+$nn);//列$vv = iconv('gbk', 'utf-8', $vv);                
$obj->setCellValue($col.$row,$vv);//列,行,值                
$nn++;            
}        
}        
$objPHPExcel->getActiveSheet()->setTitle($sheetname);        
$objPHPExcel->setActiveSheetIndex(0);        
header('Content-Type: application/vnd.ms-excel');        
header('Content-Disposition: attachment;filename="'.$savefile.'.xls"');        
header("Content-Type: application/vnd.ms-excel; charset=UTF-8");        
header('Cache-Control: max-age=0');        
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        
$objWriter->save('php://output');

function exportexcel($data=array(),$title=array(),$filename='report'){    
header("Content-type:application/octet-stream");    
header("Accept-Ranges:bytes");    
header("Content-type:application/vnd.ms-excel");      
header("Content-Disposition:attachment;filename=".$filename.".xls");    
header("Pragma: no-cache");    header("Expires: 0");    
//导出xls 开始    if (!empty($title)){        
foreach ($title as $k => $v) {            
$title[$k]=iconv("UTF-8", "GB2312",$v);        
}        
$title= implode("\t", $title);        
echo "$title\n";    }    
if (!empty($data)){        
foreach($data as $key=>$val){            
foreach ($val as $ck => $cv) {                
$data[$key][$ck]=iconv("UTF-8", "GB2312", $cv);            
}            
$data[$key]=implode("\t", $data[$key]);                    
}       
echo implode("\n",$data);    
} 
}

<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=export_data.xls");

echo   "姓名"."\t";  
echo   "繁體"."\t";  
echo   "博客"."\t";  
echo   "\n";  
echo   "jason"."\t";  
echo   "@"."\t";  
echo   "javaeye"."\t";  
?>

header("Content-type:application/vnd.ms-excel;charset=UTF-8");

echo iconv("当前编码","GB18030","此博客来源于javaeye,by jason");

<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">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
	<head>
		<meta http-equiv="Content-type" content="text/html;charset=UTF-8" />
		<style id="Classeur1_16681_Styles"></style>
	</head>
	<body>
		<div id="Classeur1_16681" align=center x:publishsource="Excel">
			<table x:str border=0 cellpadding=0 cellspacing=0 width=100%>
				<tr><td class=xl2216681 nowrap>1234</td><td class=xl2216681 nowrap>Robbin会吐口水</td></tr>
				<tr><td class=xl2216681 nowrap>5678</td><td class=xl2216681 nowrap>javaeye网站</td></tr>
			</table>
		</div>
	</body>
</html>

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=export_data.xls");