excel csv 导出

‘

    public function result_export($title,$list,$field){

//调用PHP_Excel

Vendor("PhpExcel.PHPExcel");

$objExcel = new PHPExcel(); 

$objWriter = new PHPExcel_Writer_Excel2007($objExcel);

$objExcel->setActiveSheetIndex(0);

$objActSheet = $objExcel->getActiveSheet(); 

$objActSheet->setTitle($title);

$letter = 'A';

foreach($field as $values){

$objActSheet->setCellValue($letter.'1',$values);

++$letter;

}

if(is_array($list)){

foreach($list as $k=>$v){

$letter = 'A';

$k = $k+2;

reset($field);

foreach($field as $key=>$value){

$objActSheet->setCellValueExplicit($letter.$k,$v[$key],PHPExcel_Cell_DataType::TYPE_STRING);//setCellValue($letter.$k,$v[$key])

++$letter;

}

}

}

$objExcel->setActiveSheetIndex(0);

spl_autoload_register(array('Think','autoload'));//必须的，不然ThinkPHP和PHPExcel会冲突

header("Content-Type:application/force-download"); 

header("Content-Type:application/octet-stream"); 

header("Content-Type:application/download");

header('Content-Disposition:inline;filename="'.mb_convert_encoding($title,'gb2312','UTF-8').'.xlsx"');

header("Content-Transfer-Encoding: binary");

header("Last-Modified:".gmdate("D, d M Y H:i:s")."GMT");

header("Cache-Control:must-revalidate,post-check=0,pre-check=0");

header("Pragma: no-cache"); 

$objWriter->save('php://output');

}

   

    public function result_export_csv($title,$list,$field){

$filename = $title.".csv";

        header("Content-type:text/csv");

        header("Content-Disposition:attachment;filename=".$filename);

        header('Cache-Control:must-revalidate,post-check=0,pre-check=0');

        header('Expires:0');

        header('Pragma:public');

        $data = implode(',',$field).PHP_EOL;

        if(is_array($list)){

foreach($list as $k=>$v){

reset($field);

                $row = '';

foreach($field as $key=>$value){

$row .= $v[$key].',';

}

                $data .= rtrim($row,',').PHP_EOL;

}

}

        echo $data;

}

’