html 表单保存到excel,HTML表单到Excel电子表格(数据库)

我想要一些不修改此代码的帮助

function fillHidTable(){

var htqf; //-- hidden field

var rf; //-- retrieved field

for ( var i = 1; i < 5; i++ ) {

rf = "htqf"+i;

document.getElementById(rf).innerHTML = document.getElementById("Q"+i+"CALC").value;

}

tableToExcel('hidTable', 'Analysis Results');

}

var tableToExcel = (function() {

var uri = 'data:application/vnd.ms-excel;base64,'

, template = '

'

, base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }

, format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }

return function(table, name) {

if (!table.nodeType) table = document.getElementById(table)

var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}

window.location.href = uri + base64(format(template, ctx))

}

})()

HTML Form Data to Excel

.divCenMid{font-family:Arial,sans-serif;font-size:14pt;font-style:normal;font-weight:700;text-align:center;vertical-align:middle;margin:0;}

.allbdrCenMid{border:.75pt solid windowtext;color:#000;font-family:Arial,sans-serif;font-size:10pt;font-style:normal;font-weight:400;text-align:center;vertical-align:middle;margin:0;}

.allbdrCenTop{border:.75pt solid windowtext;color:#000;font-family:Arial,sans-serif;font-size:10pt;font-style:normal;font-weight:400;text-align:center;vertical-align:top;margin:0;}

.allbdrLtMid{border:.75pt solid windowtext;color:#000;font-family:Arial,sans-serif;font-size:10pt;font-style:normal;font-weight:400;text-align:left;vertical-align:middle;margin:0;}

.allbdrLtTop{border:.75pt solid windowtext;color:#000;font-family:Arial,sans-serif;font-size:10pt;font-style:normal;font-weight:400;text-align:left;vertical-align:top;margin:0;}

QMS Assessment
No Criteria Question Score
Q1 Quality Unit Independency Do you have the Quality Unit?
Q2 Apply PICS GMP Which GMP regulation do you use?
Q3 Deviation or Non-conformance Do you have a deviation or non-conformance procedure?
Q4 Complaint Do you have a customer complaint procedure?

No.QuestionScore

Q1Do you have the Quality Unit?-Q2Apply PICS GMP?-Q3Do you have a deviation or non-conformance procedure?-Q4Do you have a customer complaint procedure?-

它创建了一个基于Web的表单,我可以使用和编辑,但有一种方法我可以更改最后一个按钮将excel表保存到单元格中以创建更多的数据库,是否有一种方法可以保存它到一个特定的文件,并让它填写或附加数据。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值