//include "stu_list.php"; include "../lw_inc/lw_conn.php"; include "../lw_inc/obj_name.php"; /*$cla=$_GET['clas']; if($cla==''){ exit('操作失败'); } $class=obj_name($cla); $class='班级:'.$class; $cla='1010101';*/ $num = $_GET['iidd2']; //$num='201392503039'; $sql = "select stu_gra,user_name,stu_sex,entrydate,gradate from user_stu where stu_id='{$num}'"; $query = mysql_query($sql); $re = mysql_fetch_assoc($query); $class = obj_name($re['stu_gra']); $filenm = $re['user_name'] . '成绩单.xls'; $year = date('Y'); $term = array(); $sql = "select distinct cou_term from cou_choose where cou_choose_stu='{$num}'"; $query = mysql_query($sql); while ($ret = mysql_fetch_row($query)) { array_push($term, $ret[0]); //echo('<p>'.$ret[0]); } $workbook = new Spreadsheet_Excel_Writer(); $format_title =& $workbook->addFormat(); $format_title->setBold(); $format_title->setSize('16'); $format_title->setAlign('merge'); $format_text =& $workbook->addFormat();
exit('操作失败'); } $class=obj_name($cla); $class='班级:'.$class; $cla='1010101';*/ $num = $_GET['iidd2']; //$num='201392503039'; //echo $num; $sql = "select stu_clas,user_name,stu_sex,entrydate,gradate from user_stu where stu_id='{$num}'"; $query = mysql_query($sql); $re = mysql_fetch_assoc($query); $re['user_name'] = encoding($re['user_name']); $re['stu_sex'] = encoding($re['stu_sex']); $re['entrydate'] = encoding($re['entrydate']); $re['gradate'] = encoding($re['gradate']); $class = obj_name($re['stu_clas']); $class = encoding($class); $filenm = $re['user_name']; //$filenm=encoding($filenm); $filenm = $filenm . '成绩单.xls'; date_default_timezone_set('PRC'); $year = date('Y'); $term = array(); $sql = "select distinct cou_term from cou_choose where cou_choose_stu='{$num}'"; $query = mysql_query($sql); while ($ret = mysql_fetch_row($query)) { array_push($term, $ret[0]); //echo('<p>'.$ret[0]); } $workbook = new Spreadsheet_Excel_Writer(); //$workbook->setVersion(8);
<?php require_once 'Spreadsheet/Excel/Writer.php'; //include "stu_list.php"; session_start(); include "../lw_inc/lw_conn.php"; include "../lw_inc/obj_name.php"; $cla = $_GET['clas']; if ($cla == '') { exit('操作失败'); } date_default_timezone_set('PRC'); $class = obj_name($cla); $class = encoding($class); //$class='班级:'.$class; //$cla='1010101'; $sql = "select stu_id,user_name,stu_sex,nature,stu_nation,en_name,stu_bir,passport_id,stu_address1,stu_address2,contact_way from user_stu where stu_clas='{$cla}'"; $query = mysql_query($sql); //$re=mysql_fetch_assoc($query); $workbook = new Spreadsheet_Excel_Writer(); $format_bold =& $workbook->addFormat(); $format_bold->setBold(); $format_bold->setBorder(2); $format_bold_1 =& $workbook->addFormat(); $format_bold_1->setBold(); $format_bold_1->setBorder(1); $format_merge_b_1 =& $workbook->addFormat(); $format_merge_b_1->setBold(); $format_merge_b_1->setBorder(1); $format_merge_b_1->setAlign('merge'); $format_title =& $workbook->addFormat();