php写excel

        $this->loadexcel();
        $objPHPExcel = new PHPExcel();
        $objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
        $objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
        $objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test1 Document");
        $objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test1 Document");
        $objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
        
        $objPHPExcel->setActiveSheetIndex(0);
        foreach($posts_list as $k=>$p){
            $objPHPExcel->getActiveSheet()->SetCellValue('A'.$k, $p['domain']);
        }
        //$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello1');
        $objPHPExcel->getActiveSheet()->setTitle('Simple');
        $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
        
        $objWriter->save(EA_DIR_DATA . 'test.xlsx');

posted @ 2013-08-26 14:41  min_cj  阅读(263)  评论(0)    收藏  举报