'set names \'utf8\''));
$count=$db->query(select * from test);
$data=$count->fetchall(pdo::fetch_assoc);
//print_r($res);die;
require_once 'classes/phpexcel.php';
require_once 'classes/phpexcel/reader/excel2007.php';
require_once 'classes/phpexcel/reader/excel5.php';
include_once 'classes/phpexcel/iofactory.php';
//创建新的phpexcel对象
    $objphpexcel = new phpexcel();
    $objprops = $objphpexcel->getproperties();
//设置表头
    $i=0;
    foreach($data as $k=>$v){
        //print_r($v);die;
        if($i
            $arrd=array_keys($v);
            //print_r($arrd);die;
            $key = ord(a);
            foreach($arrd as $kk=>$vv){
                $colum = chr($key);
                $objphpexcel->setactivesheetindex(0) ->setcellvalue($colum.'1', $vv);
                $key += 1;
            }
        }
        $i++;
    }
$column = 2;
    $objactsheet = $objphpexcel->getactivesheet();
foreach($data as $key => $rows){ //行写入
        $span = ord(a);
        foreach($rows as $keyname=>$value){// 列写入
            $j = chr($span);
            $objactsheet->setcellvalue($j.$column, $value);
            $span++;
        }
        $column++;
    }
//下载
    //将输出重定向到一个客户端web浏览器(excel2007)
    $filename = iconv(utf-8, gb2312, bao.xls);
    header(content-disposition: attachment; filename=\$filename\);
    header('cache-control: max-age=0');
    $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel2007');
    $objwriter->save('php://output'); //文件通过浏览器下载