var xlsApp=new ActiveXObject("Excel.Application")
var xlsSht=xlsApp.Open("d:\\test.xls");
var sheet=xls.sheets["sheet2"];
alert(sheet.cells(1,1).value);
var xlsSht=xlsApp.Open("d:\\test.xls");
var sheet=xls.sheets["sheet2"];
alert(sheet.cells(1,1).value);
var xlsSht=xlsApp.Open("d:\\test.xls");
就错了,还有:
var sheet=xls.sheets["sheet2"];
其中的xls没有定义!哪位过来改改?
ExcelApp.DisplayAlerts = false;
ExcelWorkbooks = ExcelApp.Workbooks;
alert("下面示例:打开一个已有的Excel文件");
ExcelWorkbooks.open("C:\\1.xls");
ExcelWorkbooks("1.xls").Activate;alert("下面示例:修改该文件第二张工作表的名称");
ExcelApp.Sheets(1).Name = "lemon801,^_^";ActiveSheet = ExcelWorkbooks("1.xls").Sheets(1);
ActiveSheet.Name = "修改的第一张工作表名称";alert(ExcelApp.Sheets(1).Cells(1, 1).Value , 0 , "下面显示第一张工作表的第1.1单格的值");