function write_to_excel() { str = ""; var mytable = document.getElementById("tbExport"); var rowCount = mytable.rows.length; var colCount = mytable.getElementsByTagName("tr")[0].getElementsByTagName("th").length; var ExcelApp = new ActiveXObject("Excel.Application"); var ExcelSheet = new ActiveXObject("Excel.Sheet"); //ExcelSheet.Application.Visible = true; for (var i = 0; i < rowCount; i++) { for (var j = 0; j < colCount; j++) { if (i == 0) { str = mytable.getElementsByTagName("tr")[i].getElementsByTagName("th")[j].innerText; } else { str = mytable.getElementsByTagName("tr")[i].getElementsByTagName("td")[j].innerText; } ExcelSheet.ActiveSheet.Cells(i + 1, j + 1).Value = str; } } ExcelSheet.autofit; ExcelSheet.Application.Visible = true; DisplayAlerts = true; CollectGarbage(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)