流程操作人老实抱怨OA的明细表单数据上传要么只能一行一行key,要么Excel导入,没有像操作Excel复制黏贴的那种畅快感。按下面的代码能完全像Excel一样复制黏贴,用户都说好用!!!
以下是代码:
var silterralId = WfForm.convertFieldNameToId("silterralid", "detail_2"); var scribeId = WfForm.convertFieldNameToId("scribeid", "detail_2"); var vId = WfForm.convertFieldNameToId("vid", "detail_2"); document.addEventListener('paste', function (e) { var clipboard = e.clipboardData.getData('text'); if(!clipboard) return; var rows = clipboard.split('\n'); rows.forEach(function(row, index){ if(!row.trim()) return; var cols = row.split('\t'); if(index >=0){ var addObj = {}; addObj[silterralId] = {value:cols[0]}; addObj[scribeId] = {value:cols[1]}; addObj[vId] = {value:cols[2]}; WfForm.addDetailRow("detail_2", addObj); } }); });