} return iconv('gb2312', 'utf-8', $str); } //从数据库输出数据处理方式 //从数据库读取数据如: $con = mysql_connect("localhost", "root", "123456"); mysql_select_db('test', $con); //$db = new Mysql($dbconfig); $result = mysql_query('SELECT * FROM user'); $user_info = array(); while ($row = mysql_fetch_array($result)) { $user_info[] = $row; } //print_r($user_info); $count = count($user_info); for ($i = 2; $i <= $count + 1; $i++) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, convertUTF8($user_info[$i - 2][0])); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, convertUTF8($user_info[$i - 2][1])); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, convertUTF8($user_info[$i - 2][2])); // $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, convertUTF8($user_info[$i-2][4])); // $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, convertUTF8(date("Y-m-d", $row[$i-2][5]))); // $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, convertUTF8($user_info[$i-2][6])); // $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, convertUTF8($user_info[$i-2][7])); // $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, convertUTF8($user_info[$i-2][8])); } //在默认sheet后,创建一个worksheet echo date('H:i:s') . " Create new Worksheet object\n"; $objPHPExcel->createSheet(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); //$objWriter->save('php://output'); $objWriter->save("xxx.xlsx");
$j = $i; foreach ($data as $value) { $j = $i; $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $value['name']); $techs = $value["keywords"]; if (is_array($techs)) { foreach ($techs as $tech) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, convertUTF8($tech['name']))->setCellValue('C' . $i, convertUTF8($tech['weight']))->setCellValue('D' . $i, convertUTF8($tech['pass_score']))->setCellValue('E' . $i, convertUTF8($tech['pass_score'] <= $tech['_score'] ? '是' : '否')); $i++; } $objPHPExcel->getActiveSheet()->mergeCells('A' . $j . ':' . 'A' . ($i - 1)); } } $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, convertUTF8("总得分:" . $scores)); $objPHPExcel->getActiveSheet()->mergeCells('A' . $i . ':E' . $i); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . ($i + 1), convertUTF8("结果:" . $meet . $pro_level)); $objPHPExcel->getActiveSheet()->mergeCells('A' . ($i + 1) . ':E' . ($i + 1)); } // Rename worksheet $objPHPExcel->getActiveSheet()->setTitle('Simple'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Save Excel 2007 file $callStartTime = microtime(true); ob_end_clean(); header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate, post-check=0, pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream");