这段时间在做项目时一直需要把页面里显示的内容导出到EXCEL中,在此,我用JavaScript脚本在客气端来实现这一功能,具体代码如下:
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script language="javascript">
function OpenWord()
{
Layer1.style.border=0
word = new ActiveXObject('Word.Application');
word.Application.Visible = true;
var mydoc=word.Documents.Add('',0,1);
myRange =mydoc.Range(0,1)
var sel=Layer1.document.body.createTextRange()
sel.select()
Layer1.document.execCommand('Copy')
sel.moveEnd('character')
myRange.Paste();
location.reload()
word.ActiveWindow.ActivePane.View.Type=9
}
</script>
</head>
<body>
<div id="Layer1">
<input type="button" name='button_export' title='导出到word' οnclick="OpenWord()" value="导出到word"></div>
</div>
<br />
<br />
<table id="jiapeng" border="1" cellspacing="0" cellpadding="0" bgcolor="#61FF13">
<tr style="text-align: center;">
<td>
编号</td>
<td>
姓名</td>
<td>
性别</td>
<td>
年龄</td>
</tr>
<tr style="text-align: center;">
<td>
1</td>
<td>
贾鹏</td>
<td>
男</td>
<td>
23</td>
</tr>
<tr style="text-align: center;">
<td>
2</td>
<td>
YoungBaby</td>
<td>
23</td>
<td>
男</td>
</tr>
</table>
</body>
</html>