如何拆分剪贴板中复制的Excel数据到数组,并赋值到下方的table中?
<script>
function Paste(){
var ClipboardText=window.clipboardData.getData('Text');
var ClipboardText=ClipboardText.replace(/[\r\n]/g, ",");
var Rows=ClipboardText.split(",");
for(var iRow=0;iRow<Rows.length;iRow++) {
var Cells=Rows[iRow].split('\t');
for(var iCol=0;iCol<Cells.length;iCol++)
alert(Cells[iCol]);
}
}
</script>
<input id="Test"></input><input type="button" value="Paste" onclick="Paste();"></input>
<table>
<tr><td><input></input><input></input></td></tr>
<tr><td><input></input><input></input></td></tr>
</table>