Javascript导出EXCEL

 

<script charset="utf-8" type="text/javascript" >

var ExcelHelper = {
 
 //导出到Excel
 exportToExcel : function(xls_template_path) {
  var xls = new ActiveXObject("Excel.Application");
  xls.Visible = true;         //设置excel可见属性
  var xBook = xls.Workbooks.Open(xls_template_path); //这里的Add方法里的参数是模板的路径
  var xSheet = xBook.ActiveSheet;
  var table = document.getElementById("tableExcel");
  for(var i=1;i<table.rows.length;i++){
   for(var k=0;k<table.rows(i).cells.length;k++){
    xBook.ActiveSheet.Columns(k+1).HorizontalAlignment = 3;
    xSheet.cells(i+1,k+1).value = table.rows(i).cells(k).innerText;
   }
  }
  
  //xBook.ActiveSheet.Columns(3).HorizontalAlignment = 3;
  //xBook.Worksheets(1).Columns(2).Font.Bold = true;
  xls.Visible = true;
  xls.UserControl = true;
 },
 
 toExcel : function() {
  var xls = new ActiveXObject("Excel.Application");
  var xBook =  xls.Workbooks.Add();      //新增工作簿
  var xSheet = xBook.ActiveSheet;       //创建工作表
  var table = document.getElementById("tableExcel");
  xSheet.Name = "测试表";
  for(var i=0;i<table.rows.length;i++){
   for(var k=0;k<table.rows(i).cells.length;k++){
    xSheet.cells(i+1,k+1).value = table.rows(i).cells(k).innerText;
   }
  }
  xBook.ActiveSheet.Columns(3).HorizontalAlignment = 2;
  xBook.Worksheets(1).Columns(2).Font.Bold = true;
  xls.Visible = true;
  xls.UserControl = true;
  
   // 保存表格。
  //xSheet.SaveAs("d:\\TEST.xlsx");
  // 用 Application 对象用 Quit 方法关闭 Excel。
  //xSheet.Application.Quit();
 
  //xSheet.Application.Quit();
  //xls.Quit();
  //xls=null;
 }
};

</script>