js 对多sheet Excel赋值操作

function ExpExcel(){

      var tempStr = "";

      var filePath =""

      var excelname=ReportFileStatus("D:\\张三.xlsx");   // 对Excel多Sheet的操作

      if(excelname=="Ture")

       {

           filePath="D:\\张三.xlsx";

       }

      else

       {

             filePath= "D:\Temp.xlsx";  // 如果不存在当前人的excel就用模板

       }

      var oXL = new ActiveXObject("Excel.application");

      var oWB = oXL.Workbooks.open(filePath);

      oXL.Visible = true;

      var sstep=Getvalue("step");

      switch(sstep)

      {

       case "1":

            oWB.worksheets(1).select();  // 操作不同的sheet

          break;

          .

          .

          .

          .

          .

          .

        }

      var oSheet = oWB.ActiveSheet;

      try{

         oSheet.Cells(3,3).value ="";            //cell赋值

         oSheet.Cells(3,6).value = "";

      }catch(e)

      {

           oWB.Close();

           oXL.Quit();

           oXl=null;

      }

        oSheet.SaveAs("D:\\abc.xlsx");   //另存

        oWB.Visible=false;

        oWB.Close();

        oXL.Quit();

        oXl=null;

        var idtmr = "";

        idtmr = window.setinterval( "cleanup(); ",1);    //销毁对象

}

function Cleanup() {

window.clearInterval(idTmr);

CollectGarbage();

}