如何将表单数据发送到电子表格。 XLS
我有一个形式做了一个网站,但形式只发送填写表格的网站的信息:http://submit.jotformz.com/submit/21933800226649/,我想填写表单中的数据应保存在电子表格中。 XLS,每次有人填写并发送新信息作为行10
我窗体的代码的自动添加是这样的:
<script src="http://max.jotfor.ms/min/g=jotform?3.0.3715" type="text/javascript"></script>
<script type="text/javascript">
JotForm.init();
</script>
<link href="http://max.jotfor.ms/min/g=formCss?3.0.3715" rel="stylesheet" type="text/css" />
<link type="text/css" rel="stylesheet" href="http://jotformz.com/css/styles/nova.css?3.0.3715" />
<style type="text/css">
.form-label{
width:150px !important;
}
.form-label-left{
width:150px !important;
}
.form-line{
padding-top:12px;
padding-bottom:12px;
}
.form-label-right{
width:150px !important;
}
.form-all{
width:690px;
color:#555 !important;
font-family:'Lucida Grande';
font-size:14px;
}
</style>
<form class="jotform-form" action="http://submit.jotformz.com/submit/21933800226649/" method="post" name="form_21933800226649" id="21933800226649" accept-charset="utf-8">
<input type="hidden" name="formID" value="21933800226649" />
<div class="form-all">
<ul class="form-section">
<li class="form-line" id="id_1">
<label class="form-label-left" id="label_1" for="input_1"> Nome: </label>
<div id="cid_1" class="form-input">
<input type="text" class="form-textbox" id="input_1" name="q1_nome" size="20" />
</div>
</li>
<li class="form-line" id="id_3">
<label class="form-label-left" id="label_3" for="input_3"> Opções </label>
<div id="cid_3" class="form-input">
<div class="form-single-column"><span class="form-radio-item" style="clear:left;"><input type="radio" class="form-radio" id="input_3_0" name="q3_opcoes" value="Opção 1" />
<label for="input_3_0"> Opção 1 </label></span><span class="clearfix"></span><span class="form-radio-item" style="clear:left;"><input type="radio" class="form-radio" id="input_3_1" name="q3_opcoes" value="Opção 2" />
<label for="input_3_1"> Opção 2 </label></span><span class="clearfix"></span><span class="form-radio-item" style="clear:left;"><input type="radio" class="form-radio" id="input_3_2" name="q3_opcoes" value="Opção 3" />
<label for="input_3_2"> Opção 3 </label></span><span class="clearfix"></span>
</div>
</div>
</li>
<li class="form-line" id="id_5">
<label class="form-label-left" id="label_5" for="input_5"> Comentarios </label>
<div id="cid_5" class="form-input">
<textarea id="input_5" class="form-textarea" name="q5_comentarios" cols="40" rows="6"></textarea>
</div>
</li>
<li class="form-line" id="id_4">
<label class="form-label-left" id="label_4" for="input_4"> Idioma </label>
<div id="cid_4" class="form-input">
<select class="form-dropdown" style="width:150px" id="input_4" name="q4_idioma">
<option> </option>
<option value="Portugues"> Portugues </option>
<option value="Ingles"> Ingles </option>
</select>
</div>
</li>
<li class="form-line" id="id_2">
<div id="cid_2" class="form-input-wide">
<div style="margin-left:156px" class="form-buttons-wrapper">
<button id="input_2" type="submit" class="form-submit-button">
Enviar
</button>
</div>
</div>
</li>
<li style="display:none">
Should be Empty:
<input type="text" name="website" value="" />
</li>
</ul>
</div>
<input type="hidden" id="simple_spc" name="simple_spc" value="21933800226649" />
<script type="text/javascript">
document.getElementById("si" + "mple" + "_spc").value = "21933800226649-21933800226649";
</script>
</form>
我只需要一些简单.. 可能有人给予帮助?
好吧,但是我如何为我的表单执行此操作,将数据发送到电子表格? 我不明白.. – user616324 2012-07-13 16:43:46
在这里阅读:http://www.tizag.com/phpT/forms.php/然后,把你从两篇文章中学到的东西放在一起。 – 2012-07-13 16:49:28
谢谢,但是您还没有准备好一个简单的示例表单和一个电子表格工作?所以我可以创建这个例子,因为我不太了解php语言,那么从头开始的代码很复杂,甚至不知道从哪里开始。 你能给我发送一个带有3的表单域的例子,它有一个按钮可以发送,它直接进入工作表? – user616324 2012-07-13 18:34:06
为了这个工作,你将不得不从收集的形式信息,并一起解析服务器上的电子表格。你使用了什么后端技术(ASP.NET,php等)? – 2012-07-13 14:34:07
我正在使用PHP ... – user616324 2012-07-13 14:43:27