以前写的,转过来。
<
Html
>
< HEAD >
< TITLE > javascript向excel中添加数据 </ TITLE >
< SCRIPT LANGUAGE = JavaScript > ...
/**//*
使用javascript调用excel二次开发组件,向excel中添加数据
*/
function addfile()...{
var exApp = new ActiveXObject("Excel.Application"); //创建实例
var exWBook = exApp.workbooks.open("c:/001.xls") //打开文档
var exWSheet = exWBook.Worksheets(1); //绑定表
exWSheet.Cells(4, 1).Value = "a"; //附值
exWSheet.Cells(4, 2).Value = "s";
exWSheet.Cells(4, 3).Value = "d";
exWSheet.Cells(4, 4).Value = "f";
exWSheet.Cells(4, 5).Value = "g";
exWBook.Close (savechanges=true);
//exWSheet.Close();
//exApp.Close();
exApp.Quit();
exApp = null;
//释放excel进程,关闭当前浏览器后有效。
}
</ SCRIPT >
</ HEAD >
< BODY BGCOLOR ="white" >
< SCRIPT LANGUAGE = JavaScript > ...
addfile();
</ SCRIPT >
</ BODY >
</ HTML >
< HEAD >
< TITLE > javascript向excel中添加数据 </ TITLE >
< SCRIPT LANGUAGE = JavaScript > ...
/**//*
使用javascript调用excel二次开发组件,向excel中添加数据
*/
function addfile()...{
var exApp = new ActiveXObject("Excel.Application"); //创建实例
var exWBook = exApp.workbooks.open("c:/001.xls") //打开文档
var exWSheet = exWBook.Worksheets(1); //绑定表
exWSheet.Cells(4, 1).Value = "a"; //附值
exWSheet.Cells(4, 2).Value = "s";
exWSheet.Cells(4, 3).Value = "d";
exWSheet.Cells(4, 4).Value = "f";
exWSheet.Cells(4, 5).Value = "g";
exWBook.Close (savechanges=true);
//exWSheet.Close();
//exApp.Close();
exApp.Quit();
exApp = null;
//释放excel进程,关闭当前浏览器后有效。
}
</ SCRIPT >
</ HEAD >
< BODY BGCOLOR ="white" >
< SCRIPT LANGUAGE = JavaScript > ...
addfile();
</ SCRIPT >
</ BODY >
</ HTML >