Posted on 2012-02-28 18:16
哈希 閱讀(306)
評論(0) 編輯 收藏 所屬分類:
Js and Jquery 常用總結
apache-comcat配置虛擬主機和虛擬目錄 jquery autocomplete 自動填充文本框、文本域
JS 導出excel,word實例 2011-10-10 11:55:00| 分類： 默認分類 | 標簽：js excel word |字號大
中
小 訂閱
用js操作offace中的word,excel 必須首先確保你已經(jīng)安裝office，用js操作word，excel 用到了ActiveXObject類，它是專門用來調(diào)用windows操作中的程序的，下面是例子，直接復制到文本文件里，把后綴名改了就可以運行！
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<html xmlns="<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>無標題文檔</title>
<script type="text/javascript" language="javascript">
function ExcelExport(tableid)
{
//檢索瀏覽器
if(navigator.userAgent.indexOf("MSIE")<0){
alert('請用ie瀏覽器進行表格導出');
return ;
}
var oXL = null;
try {
oXL = GetObject("", "Excel.Application");
}
catch (E) {
try {
oXL = new ActiveXObject("Excel.Application");
}
catch (E2) {
alert("請確認:\n1.Microsoft Excel已被安裝.\n2.工具 => Internet 選項=> 安全 => 設置 \"啟用不安全的 ActiveX\"");
return;
}
}
var table = document.getElementById(tableid);
var workbook = oXL.Workbooks.Add();
var sheet = workbook.ActiveSheet;
var sel = document.body.createTextRange(); //激活sheet
//把table中的數(shù)據(jù)移到sel中
sel.moveToElementText(table);
sel.select(); //選中sel中所有數(shù)據(jù)
sel.execCommand("Copy");//復制sel中的數(shù)據(jù)
sheet.Columns("A:Z").ColumnWidth =20;//設置列寬
// sheet.Columns("B").ColumnWidth =35;
sheet.Rows(1).RowHeight = 35;//設置表頭高
//將sel中數(shù)據(jù)拷貝到sheet工作薄中
sheet.Paste();
oXL.Visible = true;
//sheet.Save("F:\\TEST.XLS" );
//通過打印機直接將Excel數(shù)據(jù)打印出來
//sheet.Printout;
//ax.UserControl = true;
oXL.Quit();
oXL=null;
}
</script>
</head>
<body>
<table width="100%" border="1" id="mytable">
<tr>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
</tr>
<tr>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
</tr>
<tr>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
</tr>
<tr>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
</tr>
<tr>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
<td>nihao</td>
</tr>
</table>
<form id="form1" name="form1" method="post" action="">
<label>
<input type="button" name="Submit" value="導出excel" onclick="ExcelExport('mytable')" />
</label>
</form>
<p> </p>
</body>
</html>