js导出excel

function Pushexceldata(){
var jsonstr={
"os":"Android",
}
$.ajax({
        url: '/QAdevices/ManagerServlet',//ajax提交路径
        type: 'post',//提交方式
        data: {type:"searchDeviceInfoByConditions2",content:JSON.stringify(jsonstr),token:peopleinfo.email},//提交参数
        //async: false,
        success: function (result) {//ajax请求完成时执行，result为返回的结果
        if(result!=null){
console.log("get getDeviceInfobytag ok!");
if(result.success=="true"){
getDevicesExcel(result.value);
alert("excel导出到/Users/liuqihong/Documents/项目，成功")
}else{
popErrorbox(result.value,"");
}
}else{
console.log("get getDeviceInfobytag  failed!");
}
        },
        error: function () {
        console.log("create getDeviceInfobytag ajax请求处理错误");
        }
     });
}


function getDevicesExcel(data){
var appExcel;
try{
appExcel = new ActiveXObject("Excel.Application");
}catch(e){
alert("无法启动excel！")
}

    var oWB = appExcel.Workbooks.Add();
    //获取workbook对象
    var oSheet = oWB.ActiveSheet;
    //添加每一列的名称
    var listname = new Array("编号","设备编号","品牌名称","品牌","系统","系统版本","cpu","cpu型号","内存大小","屏幕尺寸","分辨率高","分辨率宽","imei1","imei2","sn","是否越狱","颜色","前置摄像头","后置摄像头","数据线","充电器","耳机","电池","手机壳","入库时间","设备管理员","借用人","状态","备注");
    for(var i = 0 ; i <listname.length;i++){
    oSheet.Cell(1,i+1).Value = listname[i];
    }
    //添加列明备注
    var des = new Array("必填","必填","必填","必填","android/ios","必填","厂商","厂商+型号","","","","","必填","","","0=否，1=是","","单位万","单位万","0=否，1=是","0=否，1=是","0=否，1=是","0=否，1=是","0=否，1=是","","","","状态(0完好 1破损 2老旧 3待修复 4已坏)","");
    
    for(var i = 0;i<des.length;i++){
    oSheet.Cell(2,i+1).Value = des[i];
    }
    //填充excel的数据
    $.each(data,function(i,item){
    list = getdata(item);
    for (var j = 0;j<list.length;j++){
    oSheet.Cell(i+3,j+1).Value=list[j];
    }
   
    })
    appExcel.Visible = true;
    var fname =appExcel.Application.GetSaveAsFilename("/Users/liuqihong/Documents/项目/test.xls", "Excel Spreadsheets (*.xls), *.xls"); 
    appExcel.SaveAs(fname)
    appExcel.Close();
    appExcel.Quit();
   
}
//excel每行添加数据
function getdata(item){
var list = new Array();
list[0]=item.deviceid;
list[1]=item.tag;
list[2]=item.model;
list[3]=item.brand;
list[4]=item.os;
list[5]=item.osversion;
list[6]=item.cpu;
list[7]=item.cpumodel;
list[8]=item.mem;
list[9]=item.screensize;
list[10]=item.resolution_high;
list[11]=item.resolution_width;
list[12]=item.imei1;
list[13]=item.imei2;
list[14]=item.sn;
list[15]=item.root;
list[16]=item.color;
list[17]=item.frontcam;
list[18]=item.backcam;
list[19]=item.usbcable;
list[20]=item.charger;
list[20]=item.headset;
list[20]=item.battery;
list[20]=item.phoneshell;
list[20]=item.adddate;
list[20]=item.managername;
list[20]=item.name;
list[20]=item.devicestatus;
list[20]=item.devicenotes;
return list
}