首页 > 技术文章 > php写excel

hssbsw 2013-11-06 21:23 原文

$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');

推荐阅读