摘要:print與匯出excel in js
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>無標題文件</title>
<style type="text/css">
table{ background-image:url(bgt.jpg);}
body { background-image: url(bgp.jpg);}
</style>
<script language="javascript">
function load(){
alert("X");
var ExcelSheet;
ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = true;
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1";
ExcelSheet.SaveAs("C:\\TEST.XLS");
ExcelSheet.Application.Quit();// 1
}
</script>
</head>
<body onload="load()"></body>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 id=wb name=wb width=0></OBJECT>
<input type=button value=打印预览 onclick="wb.execwb(7,1)">
<input type=button onClick=document.all.wb.ExecWB(6,1) value="打印">//
<table width="75%" border="1" background-image:url(bgt.jpg)>
<th >太陽星座</th>
<th>星座</th>
<th>出生對應日期</th>
<th>星座花束</th>
<th>星座密碼：情人解析</th>
<tr>
<td width="12%">魔羯座</td>
<td width="7%">土向</td>
<td width="18%">12/22-01/20</td>
<td width="21%">滿天星</td>
<td width="42%">做事拘謹、個性保守</td>
</tr>
<tr>
<td>水瓶座</td>
<td>風向</td>
<td>01/21-02/19</td>
<td>瑪格麗特</td>
<td>理性智慧、喜好自由</td>
</tr>
<tr>
<td>雙魚座</td>
<td>水向</td>
<td>02/20-03/20</td>
<td>鬱金香</td>
<td>體貼溫柔、浪漫善良</td>
</tr>
<tr>
<td height="28">牡羊座</td>
<td>火向</td>
<td>03/21-04/20</td>
<td>木堇</td>
<td>熱情率真、樂觀進取</td>
</tr>
<tr>
<td>金牛座</td>
<td>土向</td>
<td>04/21-05/21</td>
<td>牽牛花</td>
<td>擇善固執、堅貞不移</td>
</tr>
<tr>
<td>雙子座</td>
<td>風向</td>
<td>05/22-06/21</td>
<td>玫瑰</td>
<td>追求新知、我行我速</td>
</tr>
<tr>
<td>巨蟹座</td>
<td>水向</td>
<td>06/22-07/23</td>
<td>桔梗</td>
<td>戀家一族、情緒左右</td>
</tr>
<tr>
<td>獅子座</td>
<td>火向</td>
<td>07/24-08/23</td>
<td>向日葵</td>
<td>王者風範、唯我獨尊</td>
</tr>
<tr>
<td>處女座</td>
<td>土向</td>
<td>08/24-09/23</td>
<td>大理花</td>
<td>性情極端、要求完美</td>
</tr>
<tr>
<td>天秤座</td>
<td>風向</td>
<td>09/24-10/23</td>
<td>波斯菊</td>
<td>若即若離、捉摸不定</td>
</tr>
<tr>
<td>天蠍座</td>
<td>水向</td>
<td>10/24-11/22</td>
<td>秋海棠</td>
<td>敢愛敢恨、恩怨分明</td>
</tr>
<tr>
<td>射手座</td>
<td>火向</td>
<td>11/23-12/21</td>
<td>蝴蝶蘭</td>
<td>獨來獨往、不受拘束</td>
</tr>
</table>
<form id="form1" name="form1" method="post" action="">
</form>
</body>
</html>