将Excel数据粘贴到html表中 | 将Excel数据粘贴到html表

本文介绍了将Excel数据粘贴到html表中的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

使用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表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！