【转】直接把EXCEL粘贴到网页上
?
<html><meta http-equiv="Content-Type" content="text/html; charset=gbk" /><head><script language="javascript">function clip() { var clipText = window.clipboardData.getData('Text'); alert("clipText:"+clipText); clipRows = clipText.split(String.fromCharCode(13)); alert("clipRows:"+clipRows); for (i=0; i<clipRows.length; i++) { clipRows[i] = clipRows[i].split(String.fromCharCode(9)); alert("clipRows["+i+"]:"+clipRows[i]); } 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>从EXCEL中复制一个表格,然后点击本页的“粘贴”按钮。<br/><input type="button" onclick="clip()" value='粘贴' /></body></html>
?来自:http://www.enjoyphp.com/2011/front/javascript/excel-to-web/