直接輸入的Excel表格
信息來源:
優度網絡 發布日期:2009/4/2 瀏覽數量:
1001次
文章導讀:
<html>
<head>
<title>直接輸入的Excel表格</title>
<script language="javascript" type="text/javascript">
function hilite(obj) {
//選擇包含<input>的<td>標記
obj = document.getElementById("td"+obj.name.toString());
obj.style.border = '2px solid #007EFF'; //加粗、變色
}
function delite(obj) {
obj = document.getElementById("td"+obj.name.toString());
obj.style.border = '1px solid #ABABAB'; //恢復回原來的邊框
}
</script>
<style>
<!--
table.formdata{
border:1px solid #5F6F7E;
border-collapse:collapse;
font-family:Arial;
}
table.formdata caption{
text-align:left;
padding-bottom:6px;
}
table.formdata th{
border:1px solid #5F6F7E;
background-color:#E2E2E2;
color:#000000px;
text-align:left;
font-weight:normal;
padding:2px 8px 2px 6px;
margin:0px;
}
table.formdata td{
margin:0px;
padding:0px;
border:1px solid #ABABAB; /* 單元格邊框 */
}
table.formdata input{
width:100px;
padding:1px 3px 1px 3px;
margin:0px;
border:none; /* 輸入框不要邊框 */
font-family:Arial;
}
.btn{
border:1px solid #0083f2;
font-family:Arial;
}
-->
</style>
</head>
<body>
<form method="post">
<table class="formdata">
<caption>公司銷售統計表 2004~2007</caption>
<tr>
<th></th>
<th scope="col">2004</th>
<th scope="col">2005</th>
<th scope="col">2006</th>
<th scope="col">2007</th>
</tr>
<tr>
<th scope="row">硬盤(Hard Disk)</th>
<td id="tdharddisk2004"><input type="text" name="harddisk2004" id="harddisk2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdharddisk2005"><input type="text" name="harddisk2005" id="harddisk2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdharddisk2006"><input type="text" name="harddisk2006" id="harddisk2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdharddisk2007"><input type="text" name="harddisk2007" id="harddisk2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
<tr>
<th scope="row">主板(Mainboard)</th>
<td id="tdmainboard2004"><input type="text" name="mainboard2004" id="mainboard2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdmainboard2005"><input type="text" name="mainboard2005" id="mainboard2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdmainboard2006"><input type="text" name="mainboard2006" id="mainboard2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdmainboard2007"><input type="text" name="mainboard2007" id="mainboard2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
<tr>
<th scope="row">內存條(Memory Disk)</th>
<td id="tdmemory2004"><input type="text" name="memory2004" id="memory2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdmemory2005"><input type="text" name="memory2005" id="memory2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdmemory2006"><input type="text" name="memory2006" id="memory2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdmemory2007"><input type="text" name="memory2007" id="memory2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
<tr>
<th scope="row">機箱(Case)</th>
<td id="tdcase2004"><input type="text" name="case2004" id="case2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdcase2005"><input type="text" name="case2005" id="case2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdcase2006"><input type="text" name="case2006" id="case2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdcase2007"><input type="text" name="case2007" id="case2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
<tr>
<th scope="row">電源(Power)</th>
<td id="tdpower2004"><input type="text" name="power2004" id="power2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdpower2005"><input type="text" name="power2005" id="power2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdpower2006"><input type="text" name="power2006" id="power2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdpower2007"><input type="text" name="power2007" id="power2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
<tr>
<th scope="row">CPU風扇(CPU Fan)</th>
<td id="tdcpufan2004"><input type="text" name="cpufan2004" id="cpufan2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdcpufan2005"><input type="text" name="cpufan2005" id="cpufan2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdcpufan2006"><input type="text" name="cpufan2006" id="cpufan2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdcpufan2007"><input type="text" name="cpufan2007" id="cpufan2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
<tr>
<th scope="row">總計(Total)</th>
<td id="tdtotal2004"><input type="text" name="total2004" id="total2004" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdtotal2005"><input type="text" name="total2005" id="total2005" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdtotal2006"><input type="text" name="total2006" id="total2006" onFocus="hilite(this);" onBlur="delite(this);"></td>
<td id="tdtotal2007"><input type="text" name="total2007" id="total2007" onFocus="hilite(this);" onBlur="delite(this);"></td>
</tr>
</table>
<p><input type="submit" name="btnSubmit" id="btnSubmit" value="Add Data" class="btn">
<input type="reset" value="Reset All" class="btn"></p>
</form>
</body>
</html>