javascript操作并打开Excel实例代码
例子，javascript脚本操作打开excel文件。
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<TITLE>top30销售业绩表--www.jiaochengji.com</TITLE>
</HEAD>
<BODY>
<input name="shanghai" type="button" class="but" id="shanghai" onClick="StartExcel('上海')" value="上海店">
<SCRIPT LANGUAGE="Javascript">
var idTmr = "";
function StartExcel(strFileName)
{
var oExcel;
var oWorkbook;
var strAllName;
oExcel = new ActiveXObject("Excel.Application");
//if(strFileName=null || strFileName="")
//{return;
//}
strAllName="\\\\ep-hgh\\Top30销控表\\TOP30招商续约销控表-"+strFileName+".xls";
oExcel.Workbooks.Open(strAllName);
//oExcel.Workbooks.Open("file://ep-hgh/Top30销控表/TOP30招商续约销控表-上海.xls");
oExcel.DisplayAlerts = false;
oExcel.Visible = true;
//oExcel.Quit();
//oExcel = null;
//防EExcel死进程的关键！！必须！！！downmoon严重声明
idTmr = window.setInterval("Cleanup();",1000);
}
function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}
</SCRIPT>
</BODY>
</HTML>
例2，用javascript将数据导入Excel：
<input type="button" name="out_excel" onclick="AutomateExcel();" value="导出到excel" class="notPrint">
导出到Excel代码：
<SCRIPT LANGUAGE="javascript">
<!--
function AutomateExcel()
{
// Start Excel and get Application object.
var oXL = new ActiveXObject("Excel.Application");
// Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.all.data;
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
// Add table headers going cell by cell.
for (i=0;i<hang;i++)
{
for (j=0;j<lie;j++)
{
//oSheet.Cells(i+1,j+1).Font.Bold = True
//oSheet.Cells(i+1,j+1).Font.Size = 50
//oSheet.Cells(i+1,j+1).Alignment = 2
oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText;
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
//-->
</SCRIPT>
<table border="1" width="100%" id="data">
<tr>
<td> 姓名</td>
<td colspan="2">年龄</td>
<td>出生日期</td>
</tr>
<tr>
<td>6</td>
<td>25</td>
<td colspan="2">8</td>
</tr>
<tr>
<td height="22">1</td>
<td height="22">2</td>
<td colspan="2" height="22">4</td>
</tr>
</table>
您可能感兴趣的文章：
javascript excel操作类实现代码
[C#]结束Excel的进程的方法
javascript操作并打开Excel实例代码
PHP中操作Excel实例代码
解决php下载excel无法打开的问题
javascript操作excel文件方法详解
PHP导入与导出Excel文件的方法
javascript操作excel知识点总结
php导出word文档与excel表格文件
python怎么读取excel表格