文章标题

/**
*excel的导出
*/
function test_excel()
{
include_once(IWEB_PATH.’core/util/PHPExcel.php’);

    $modelObj = new IModel('test');
    $data = $modelObj->query(false,"id,name,price,stock");
    // print_r($data);die;

    // $data=array(
    //     0=>array(
    //         'id'=>1001,
    //         'username'=>'张飞',
    //         'password'=>'123456',
    //         'address'=>'三国时高老庄250巷101室'
    //     ),
    //     1=>array(
    //         'id'=>1002,
    //         'username'=>'关羽',
    //         'password'=>'123456',
    //         'address'=>'三国时花果山'
    //     ),
    //     2=>array(
    //         'id'=>1003,
    //         'username'=>'曹操',
    //         'password'=>'123456',
    //         'address'=>'延安西路2055弄3号'
    //     ),
    //     3=>array(
    //         'id'=>1004,
    //         'username'=>'刘备',
    //         'password'=>'654321',
    //         'address'=>'愚园路188号3309室'
    //     )
    // );

    $objPHPExcel=new PHPExcel();
    $objPHPExcel->getProperties()->setCreator('http://www.shop.com')
        ->setLastModifiedBy('http://www.shop.com')
        ->setTitle('Office 2007 XLSX Document')
        ->setSubject('Office 2007 XLSX Document')
        ->setDescription('Document for Office 2007 XLSX, generated using PHP classes.')
        ->setKeywords('office 2007 openxml php')
        ->setCategory('Result file');
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A1','ID')
        ->setCellValue('B1','用户名')
        ->setCellValue('C1','售价')
        ->setCellValue('D1','库存');

    $i=2;
    foreach($data as $k=>$v){
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A'.$i,$v['id'])
            ->setCellValue('B'.$i,$v['name'])
            ->setCellValue('C'.$i,$v['price'])
            ->setCellValue('D'.$i,$v['stock']);
        $i++;

    }

    //表名
    $objPHPExcel->getActiveSheet()->setTitle('三年级2班');

    $objPHPExcel->setActiveSheetIndex(0);

    //文件名
    $filename=urlencode('222222').'_'.date('Y-m-dHis');



    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment;filename="'.$filename.'.xlsx"');
    header('Cache-Control: max-age=0');
    $objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');




    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="'.$filename.'.xls"');
    header('Cache-Control: max-age=0');
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');


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

    exit;


}

}

/**
*导入excel
*/
function add_excel()
{
//包含文件
require_once IWEB_PATH.’core/util/excel/PHPExcel.php’;
require_once IWEB_PATH.’core/util/excel/PHPExcel/IOFactory.php’;
require_once IWEB_PATH.’core/util/excel/PHPExcel/Reader/Excel5.php’;
print_r($_FILES);die; //接收前台文件$ex = $_FILES[‘excel’];
}