当前位置: 代码迷 >> Web前端 >> 【转】直接把EXCEL粘贴到网页下
  详细解决方案

【转】直接把EXCEL粘贴到网页下

热度:101   发布时间:2012-10-16 09:57:37.0
【转】直接把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/

  相关解决方案