www.gusucode.com > 25175 学生成绩管理查询系统码程序 > ADMIN/admin_excel_into.asp

    <!-- #include file="inc.asp" -->
<!-- #include file="../config.asp" -->
<!-- #include file="../conn.asp"-->
<%
'====================================================================
'= 静￠脉版成绩查询管理系统
'powered by 25175
'=-------------------------------------------------------------------
'= 文件名称：admin_post.asp
'= 摘    要：公告管理
cj_webtit="后台管理首页 - EXCEL成绩表在线导入"
cj_webmap="<a href=admin.asp class=Class>后台管理首页 - EXCEL成绩表在线导入"
'= 最后更新：静￠脉
'= 最后日期：2006-3.1
'====================================================================
Call admin_log
cj_select="yes"
%>
<!-- #include file="admin_top.asp" -->
<%
Call admin_yz(3)
%>
<SCRIPT LANGUAGE = JavaScript>

var s=["s1","s2","s3"];
var opt0 = ["－请选择年级－","－请选择班级－","－请选择类型－"];
function setup()
{
 for(i=0;i<s.length-1;i++)
　document.getElementById(s[i]).onchange=new Function("change("+(i+1)+")");
 change(0);
}
//-->
</SCRIPT>

<script language="JavaScript" type="text/JavaScript">
function chk()
{
  if (document.form1.ExName.value=="")
  {
    alert("Excel文件名称不能为空！");
    document.form1.ExName.focus();
    return false;
  }
    if (document.form1.ExTname.value=="")
  {
    alert("Excel数据表文件名称不能为空！");
    document.form1.ExTname.focus();
    return false;
  }
}
</script>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
	<tr>
	<form method="post" name="formexcel" action="show.asp" onSubmit="return chk(this)">
		<td>
			<table width='98%' border="0" cellpadding="2" cellspacing="1" class="border"  align="center">
				 <tr class="title">
					<td align="center" colspan="2">
					<strong>EXCEL成绩表在线导入</strong>
					</td>
				</tr>
				<tr align='center' class="tdbg">
					<td>年级</td>
					<td>
						<select id="s1" name="lj" style="width:180px" tabindex="1">
							<option>－请选择年级－</option>
						</select>
					</td>
				</tr>
				<tr align='center' class="tdbg"> 
					<td>班级</td>
					<td>
						<select id="s2" name="bj" style="width:180px" tabindex="2">
							<option>－请选择班级－</option>
						</select>
					</td>
				</tr>
				<tr align='center' class="tdbg"> 
					<td>考试类型</td>
					<td>
						<select id="s3" name="xq" style="width:180px" tabindex="3">
							<option>－请选择类型－</option>
						</select>
					</td>
				</tr>
				<tr align="center" class="tdbg"> 
				  <td>Excel文件名</td>
				  <td><input name="ExName" value="cj_2004.xls" size="28" readonly></td>
				</tr>
				<tr align="center" class="tdbg">
				  <td>Excel导入数据表名 (如:Sheet1)</td>
				  <td><input name="ExTname" value="sheet1" size="28"></td>
				</tr>
				<tr align="center" class="tdbg">
				  <td>开始导入</td>
				  <td><div class="manager_menu"><a href="javascript:this.document.formexcel.submit();">&nbsp导入数据 </a></div></td>       
				</tr>
			</table>
		</td>
		</form> 
	</tr>
	</tr>
	<tr> <td>  
	
		<table width="98%" border='0' cellpadding='0' cellspacing='0' class='border' align=center>
	  <form name="form1" method="post" action="upprocess.asp?path=<%=Request.QueryString("Path")%>" enctype="multipart/form-data" >
	  <input type="hidden" name="act" value="uploadfile">
		<tr class='title'> 
		  <td align="center"><b>文件上传</td>
		</tr>
		<tr align="center" valign="middle" class='tdbg'> 
		  <td align="left"><div class="manager_menu"><input type="file" name="file1" style="width:300" class="tx1" value="">
		  <a href="javascript:this.document.form1.submit();">&nbsp;提  交 </a>
		</div>
		  </td>
		</tr>
		</form>
	  </table>

	</td>
	</tr>
	<tr><td>
	<iframe name="excel_info" width="100%" height="225" scrolling="no" border="0" frameborder="0" src="fsoexplorer.asp">
浏览器不支持嵌入式框架，或被配置为不显示嵌入式框架。</iframe>
	</td>
	</tr>
</table>
<!--#include file="../inc/copyright.asp"-->