phpexcel导出

这里只粘贴了使用的代码，里面需要引用phpexcel，在上面搜索phpexcel就有很多下载的

/**

     * 客户导出

     *

     **/

    public function excelExport($customerList=false){

        C('OUTPUT_ENCODE', false);

        import("ORG.PHPExcel.PHPExcel");

        $objPHPExcel = new PHPExcel();    

        $objProps = $objPHPExcel->getProperties();

        $objPHPExcel->setActiveSheetIndex(0);     

        $objActSheet = $objPHPExcel->getActiveSheet(); 

           

        $objActSheet->setTitle('Sheet1');

        $ascii = 65;

        $cv = '';

        //联系人字段

        $contacts_fields_list = array();

        $contacts_fields_list[0]['field'] = 'name';

        $contacts_fields_list[0]['name'] = '用户名';

        $contacts_fields_list[1]['field'] = 'telephone';

        $contacts_fields_list[1]['name'] = '电话';

        

        foreach($contacts_fields_list as $field){

            $objActSheet->setCellValue($cv.chr($ascii).'1', $field['name']);

            $ascii++;

            if($ascii == 91){

                $ascii = 65;

                $cv .= chr(strlen($cv)+65);

            }

        }

        

        /*$where['owner_role_id'] = array('in',implode(',', getSubRoleId()));

        $where['is_deleted'] = 0;*/

        $list = M('user')->select();

        $ascii = 65;

        $cv = '';

        $i = 2;

        foreach($list as $val){

            foreach($contacts_fields_list as $valu){

                //防止使用科学计数法，在数据前加空格

                if($valu['field'] == 'telephone' || $valu['field'] =='qq'){

                    $objActSheet->setCellValue($cv.chr($ascii).$i, ' '.$val[$valu['field']]);

                }else{

                    $objActSheet->setCellValue($cv.chr($ascii).$i, $val[$valu['field']]);

                }

                

                $ascii++;

                if($ascii == 91){

                    $ascii = 65;

                    $cv .= chr(strlen($cv)+65);

                }

            }

            $ascii = 65;

            $cv = '';

            $i++;

        } 


        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

        ob_end_clean();

        header("Content-Type: application/vnd.ms-excel;");

        header("Content-Disposition:attachment;filename=5kcrm_user_".date('Y-m-d',mktime()).".xls");

        header("Pragma:no-cache");

        header("Expires:0");

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

    }

这里只粘贴了使用的代码，里面需要引用phpexcel，在上面搜索phpexcel就有很多下载的

再来一个简单的导出的方法：

public function oexcel()

    {

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

        header('Content-Disposition: attachment; filename=user.xls');

        header('Pragma: no-cache');

        header('Expires: 0');

        $title = array('手机', '昵称');

        $data = M('user')->field("login,uname")->select();

        echo iconv('utf-8', 'gbk', implode("\t", $title)), "\n";

        foreach ($data as $value) {

            echo iconv('utf-8', 'gbk', ' '.implode("\t", $value)), "\n";

        }


    }