PHPexcel数据库导出数据实例

来源：互联网发布：德州扑克算法编辑：程序博客网时间：2024/05/17 01:01
error_reporting(E_ALL);ini_set('display_errors', TRUE);ini_set('display_startup_errors', TRUE);date_default_timezone_set('PRC');/** Include PHPExcel */require_once dirname(__FILE__) . '/../Classes/PHPExcel.php';// Create new PHPExcel object$objPHPExcel = new PHPExcel();$file = "top.xlsx";$sheetPage = 5;$sheetLimit = 100;$t = 0;$objPHPExcel->setActiveSheetIndex(0);$objPHPExcel->getActiveSheet()->setTitle('top_0');//设置当前工作表的标题for ($i = 1; $i <= $sheetPage; $i++) {   $url = 'http://xxxx.xx.com.cn;#数据接口   $data = curl_get($url);   $data && $data = json_decode($data, true);   if ($data['data']) {       foreach ($data['data'] as $key => $val) {           $t++;           #$j = $key + 1;           $j = $t;           #$objPHPExcel->setActiveSheetIndex(0);           $objPHPExcel->getActiveSheet()->setCellValue('A' . $j, $val['rel_pro']);           $objPHPExcel->getActiveSheet()->setCellValue('B'.  $j, $val['title'])           $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $val['game_com']);            $objPHPExcel->getActiveSheet()->setCellValue('C' . $j, $val['ope_com']);            $objPHPExcel->getActiveSheet()->setCellValue('D' . $j, game_type($val['game_type']));            $objPHPExcel->getActiveSheet()->setCellValue('E' . $j, picture_style($val['picture_style']));            $objPHPExcel->getActiveSheet()->setCellValue('F' . $j, game_origin($val['game_origin']));        }        /*       #增加工作表       if(count($data['data']) == $sheetLimit){           $objPHPExcel->createSheet();//创建一个新的工作表           $objPHPExcel->setActiveSheetIndex($i);           $objPHPExcel->getActiveSheet()->setTitle('top_' . $i);//设置当前工作表的标题       }       */   }}$objPHPExcel->setActiveSheetIndex(0);$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');$objWriter->save($file);echo "save success . total ".$t;exit;
0 0