如何将Html表单数据转换为Excel表单。这是我的代码。我有5个表格。请提供用于存储在Excel中的脚本 [英] How to convert Html form data to a Excel sheet. Here is my code. I have 5fields in form. Pls provide script for storing in excel
本文介绍了如何将Html表单数据转换为Excel表单。这是我的代码。我有5个表格。请提供用于存储在Excel中的脚本的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<html>
<head>
<title>Employee Regitration Form</title>
<style type="text/css">
.container {
width: 500px;
clear: both;
}
.container input {
width: 100%;
clear: both;
}
</style>
<link rel = "stylesheet" type="text/css">
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript" src="jquery.validate.min.js"></script>
<script type="text/javascript"> $(document).ready(function(){ $("#subForm").validate(); }); </script>
<link rel="stylesheet" href="jquery-ui.css">
<script src="jquery-1.10.2.js"></script>
<script src="jquery-ui.js"></script>
<script type="text/javascript">
$(function() {
$( "#datepicker" ).datepicker();
});
$(document).ready(function ()
{
$("#btnExport").click(function ()
{
$("#tblExport").btechco_excelexport
({
containerid: "tblExport"
, datatype: $datatype.Table
});
});
});
function validate()
{
if( document.myForm.Name.value == "Default" )
{
alert( "Please provide your name!" );
document.myForm.Name.focus() ;
return false;
}
else if( document.myForm.EMail.value == "" )
{
alert( "Please provide your Email!" );
document.myForm.EMail.focus() ;
return false;
}
else if( document.myForm.Empnum.value == "" ||
isNaN( document.myForm.Empnum.value ) ||
document.myForm.Empnum.value.length != 6 )
{
alert( "Please provide a valid employee number" );
document.myForm.Empnum.focus() ;
return false;
}
else if( document.myForm.LeaveType.value == "Default" )
{
alert( "Please provide your LeaveType!" );
return false;
}
else
return( true );
alert( "Success!" );
}
</script>
</head>
<body>
<form name="myForm" action=Success.html style="background-color:#E6E6FA" align="center" >
<table align="center" id="tblExport" cellspacing="2" cellpadding="2" border="1">
<tr>
<td align="right">Name</td>
<td><select name="Name">
<option value="Default">Default</option>
<option value="Sudharsan">Sudharsan</option>
<option value="Bhargav">Bhargav</option>
<option value="Vishnu">Vishnu</option>
</select>
</td>
</tr>
<tr>
<td align="right">EMail</td>
<td><input type="text" name="EMail" /></td>
</tr>
<tr>
<script language="JavaScript" src="ts_picker.js"> </script>
<td align="right">Date</td>
<td><input type="text" name="timestamp" id="datepicker" value="" />
<a href="java<!-- no -->script:show_calendar('document.tstest.timestamp', document.tstest.timestamp.value);"><img src="C:\Users\605061161\Desktop\Sudharsan doc\Palani.proj\datepick\cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the timestamp"></a>
</td>
</tr>
<tr>
<td align="right">Empnum</td>
<td><input type="text" name="Empnum" /></td>
</tr>
<tr>
<td align="right">LeaveType</td>
<td>
<select name="LeaveType">
<option value="-1" selected>[choose yours]</option>
<option value="1">Sick Leave</option>
<option value="2">Casual Leave</option>
<option value="3">Earned Leave</option>
<option value="3">Flexy</option>
</select>
</td>
</tr>
<tr>
<td align="right"></td>
<td><input type="submit" value="Submit" /></td>
<input type="button" name=save value="Save" >
</tr>
</table>
</form>
</body>
</html>
推荐答案
(document).ready(function(){
(document).ready(function(){
( #subForm)验证()。 }); < / script >
< link rel = stylesheet href = jquery-ui.css >
< script src = jquery-1.10.2.js > < /脚本跨度>>
< script src = jquery-ui.js > < / script >
< script type = text / javascript >
("#subForm").validate(); }); </script> <link rel="stylesheet" href="jquery-ui.css"> <script src="jquery-1.10.2.js"></script> <script src="jquery-ui.js"></script> <script type="text/javascript">
(function(){
(function() {
这篇关于如何将Html表单数据转换为Excel表单。这是我的代码。我有5个表格。请提供用于存储在Excel中的脚本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文