<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>