我用js写了一个创建excel的方法,很多都是按网上的步骤来的,可出问题,大家帮我看看!!function getmytabel(){
try{
var xls=new ActiveXObject("Excel.Application");
var owb=xls.Workbooks.Add();
var sheets=owb.ActiveSheet;
}catch(e){
alert("wrong");
}
xls.Visiable=true;
sheets.ActiveSheet.Cells(1,1).Value="heelo";
alert(sheets.ActiveSheet.Cells(1,1).Value);
sheets.SaveAs("c:\\test.xls");
sheets.Application.Quit();
//for(var i=0;i<objTable.rows.length;i++){
alert("----------------->");
//}
}
try{
var xls=new ActiveXObject("Excel.Application");
var owb=xls.Workbooks.Add();
var sheets=owb.ActiveSheet;
}catch(e){
alert("wrong");
}
xls.Visiable=true;
sheets.ActiveSheet.Cells(1,1).Value="heelo";
alert(sheets.ActiveSheet.Cells(1,1).Value);
sheets.SaveAs("c:\\test.xls");
sheets.Application.Quit();
//for(var i=0;i<objTable.rows.length;i++){
alert("----------------->");
//}
}
应为:xls.Visible=true;错误2:sheets.ActiveSheet.Cells(1,1).Value="heelo";
sheets本身已定义为当前sheet,则不需要ActiveSheet
应为:sheets.Cells(1,1).Value="heelo";
try{
var xls=new ActiveXObject("Excel.Application");
var owb=xls.Workbooks.Add();
var sheets=owb.ActiveSheet;
}catch(e){
alert("wrong");
}
xls.Visible=true;
sheets.Cells(1,1).Value="heelo";
//alert(sheets.ActiveSheet.Cells(1,1).Value);
sheets.SaveAs("c:\\test.xls");
sheets.Application.Quit();IE7测试通过
var xls=new ActiveXObject("Excel.Application");
var owb=xls.Workbooks.Add();
var sheets=owb.ActiveSheet; 里有问题,所以各位大侠快快帮帮我啊,很痛苦啊!