auto input from excel
// ==UserScript==
// @name drying
// @namespace http://blog.benull.top
// @version 0.1
// @description auto input from excel
// @author benull
// @match http://njxt.jxaas.ac.cn/jxadmin/index.aspx
// @grant none
// @require https://cdn.bootcss.com/xlsx/0.15.6/xlsx.core.min.js
// @require https://cdn.bootcss.com/jquery/3.1.1/jquery.min.js
// ==/UserScript==
(function() {
'use strict';
var $$$ = jQuery.noConflict();
var input_html = "<div id='control' style='background-color:yellow;width: 300px;height: 200px;position: fixed;z-index: 2;left:33%;top:37%' ><input type='file' id='xlsxfile' style='width:200px;height:30px' /></br><span id='info' style='width: 300px;height: 30px;font-size: 18px;display: inline-block;' >等待处理数据</span></br><button type='button' id='start' style='width:120px;height:30px;margin:0;padding:0' >开始录入</button></div>";
var datas = new Array();
var index = 0;
var interval = null;
$(function(){
//add file input
$$$('body').prepend(input_html);
//upload file
})
$$$('#xlsxfile').change(function(){
var reader = new FileReader();
reader.readAsBinaryString(document.getElementById("xlsxfile").files[0]);
reader.onloadend = function (evt) {
if(evt.target.readyState == FileReader.DONE){
var data = reader.result;
var workbook = XLSX.read(data, { type: 'binary' });
}
var sheet_name_list = workbook.SheetNames;
datas = XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]], {header:1});
console.log(datas);
}
console.log('file upload success');
});
function setting(){
if (index<datas.length){
var data = datas[index]
console.log(data)
$$$("#mainframe").contents().find('#txtAddTime').val(data[6]);
$$$("#mainframe").contents().find('#Textname').val(data[2]);
$$$("#mainframe").contents().find('#txttel').val(data[3]);
$$$("#mainframe").contents().find('#txtaddress').val(data[4]);
$$$("#mainframe").contents().find('#txtNum').val(data[5]);
$$$("#mainframe").contents().find('#btnSubmit').click();
index = index + 1
}else{
clearInterval(interval)
}
}
$$$('#start').click(function(){
interval = setInterval(setting,2000);
});
})();