将Excel数据粘贴到html表中 [英] Paste Excel data into html table
问题描述
使用Javascript，如何创建一个HTML表格，可以从excel（或谷歌电子表格）接受数字矩阵数据，通过电子表格中的复制，然后粘贴到浏览器中的表格中。
Using Javascript, how do I create an HTML table that can "accept" numeric matrix data from excel (or google spreadsheet), via "copy" in the spreadsheet and then "paste" into the table in the browser.
推荐答案
这只能在IE上可靠地运行，因为Firefox（可能还有其他人）不允许在没有特别允许的情况下访问剪贴板它;早先粘贴到textarea的建议可能比这更好。
This would only work reliably on IE since Firefox (and likely others) don't allow access to the clipboard without specifically allowing it; the earlier suggestion of pasting into a textarea first might work better than this.
从电子表格复制时，通常用选项卡（chr9）分隔单元格具有CR（chr13）的行。此脚本将剪贴板转换为2D数组，然后从中构建表。不太优雅，但似乎可以将数据复制出Excel。
When you copy from a spreadsheet, generally the cells are separated with a tab (chr9) and the rows with a CR (chr13). This script converts the clipboard into a 2D array and then builds a table from it. Not too elegant but it seems to work copying data out of Excel.
<html>
<head>
<script language="javascript">
function clip() {
// get the clipboard text
var clipText = window.clipboardData.getData('Text');
// split into rows
clipRows = clipText.split(String.fromCharCode(13));
// split rows into columns
for (i=0; i<clipRows.length; i++) {
clipRows[i] = clipRows[i].split(String.fromCharCode(9));
}
// write out in a table
newTable = document.createElement("table")
newTable.border = 1;
for (i=0; i<clipRows.length - 1; i++) {
newRow = newTable.insertRow();
for (j=0; j<clipRows[i].length; j++) {
newCell = newRow.insertCell();
if (clipRows[i][j].length == 0) {
newCell.innerText = ' ';
}
else {
newCell.innerText = clipRows[i][j];
}
}
}
document.body.appendChild(newTable);
}
</script>
</head>
<body>
<input type="button" onclick="clip()">
</body>
</html>
这篇关于将Excel数据粘贴到html表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
