Getting error while Exporting html table to excel

Question

Im getting the following error while exporting an html table to excel; SCRIPT429: Automation server can't create object... This function was working fine but when i restarted my pc and the the application it stopped working not sure whats going on.

function write_to_excel() {
str = "";
var myTable = document.getElementById('myTable');
var rows = myTable.getElementsByTagName('tr');
var rowCount = myTable.rows.length;
var colCount = myTable.getElementsByTagName("tr")[0]
        .getElementsByTagName("th").length;

var ExcelApp = new ActiveXObject("Excel.Application"); //Debug shows error at this  line
var ExcelWorkbook = ExcelApp.Workbooks.Add();
var ExcelSheet = ExcelWorkbook.ActiveSheet;

ExcelApp.Visible = true;
ExcelSheet.Range("A1", "Z1").Font.Bold = true;
ExcelSheet.Range("A1", "Z1").Font.ColorIndex = 23;

// Format table headers
for ( var i = 0; i < 1; i++) {
    for ( var j = 0; j < colCount - 1; j++) {
        str = myTable.getElementsByTagName("tr")[i]
                .getElementsByTagName("th")[j].innerHTML;
        ExcelSheet.Cells(i + 1, j + 1).Value = str;
    }
    ExcelSheet.Range("A1", "Z1").EntireColumn.AutoFit();
}
for ( var i = 1; i < rowCount; i++) {
    for ( var k = 0; k < colCount - 1; k++) {
        str = rows[i].getElementsByTagName('td')[k].innerHTML;
    ExcelSheet.Cells(i + 1, k + 1).Value =  myTable.rows[i].cells[k].innerText;
    }
    ExcelSheet.Range("A" + i, "Z" + i).WrapText = true;
    ExcelSheet.Range("A" + 1, "Z" + i).EntireColumn.AutoFit();
}

return;
  }

epascarello · Accepted Answer · 2013-03-28 19:32:40Z

3

Automation server can't create object.

Means your ActiveX settings are too high so the code will not run.

answered Mar 28, 2013 at 19:32

epascarello

208k20 gold badges206 silver badges246 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Fahad Over a year ago

Is there a way to get around this problem without changing the setting i would to tell all the user to fix the ActiveX setting. I just need export to excel function that works on IE

Fahad Over a year ago

@Teemu Thanks for your comment what I meant was is there another way to export a table to excel that doesn't require ActiveeXObject. Ive tried couple other codes without ActiveXObject but they only work in chrome and firefox. So far all I'm finding is with ActiveXobject for IE.

epascarello Over a year ago

Send the data to the server and have your server make the file and return it to the client.

Josh Campbell Over a year ago

@epascarello , can you elaborate on what you mean by "...have your server make the file and return it..." as I have the same issue as above. The code I am working with is classic ASP and bloated beyond imagination, so a research starting point link would be helpful.

epascarello Over a year ago

@JoshCampbell Post a form to the server and with ASP it would be something like

Response.ContentType = "application/vnd.ms-excel"  Response.AddHeader "Content-Disposition", "attachment; filename=excelTest.xls"

. There are plenty of exaples on generating the file.

Collectives™ on Stack Overflow

Getting error while Exporting html table to excel

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related