我使用javascript
和activeX
来保存和编辑excel文档的数据。到目前为止一切正常。但现在我想写一个新版本,我可以更新一个特定的单元格,并保持其他单元格的位置。
这是我正在使用的代码:
function Write() {
var Excel, Book; // Declare the variables
Excel = new ActiveXObject("Excel.Application"); // Create the Excel application object.
Excel.Visible = false; // Make Excel invisible.
Book = Excel.Workbooks.Add() // Create a new work book.
Book.ActiveSheet.Cells(1,1).Value = document.A1.value;
Book.SaveAs("G:/whiteboard.xls");
Excel.Quit(); // Close Excel with the Quit method on the Application object.
alert("Uppgifter sparade");
}
我要保存,而不是保存为。
有什么想法吗?
如果有人还在找这个。使用excelObj.ActiveWorkbook.Save();
保存Excel文件。下面是一个例子。
function saveExcel() {
var excel = new ActiveXObject("Excel.Application");
excel.Visible = false;
var fso = new ActiveXObject("Scripting.FileSystemObject");
var path = "file:\\C:\Users\User\Desktop\TestFile.xls";
var excel_file = excel.Workbooks.Open(path);
var excel_sheet = excel_file.Worksheets(1);
//Editing all cells from Row 6 to 10 and Column 1 to 5
for (var row = 6; row <=10; row++) {
for (var col = 1; col <=5 ; col++) {
excel_sheet.Cells(row,col).Value = "Setting New Cell Data";
};
};
//Save Excel
excel.ActiveWorkbook.Save();
alert("Excel Saved!");
//showing excel are editing is done.
excel.Visible = true;
excel = null;
excel_file = null;
};