Problems exporting HTML table to Excel

Question

I have a table in which one td element has an anchor tag inside it for a number.

<td><a href="">213123</a></td>

I am exporting my table data elements to Excel. When the table is exported it is also printing the anchor tag along with the number. Is there a way that I could avoid the anchor tag in Excel sheet and just display the number in the column?

I am using the following code:

function export_to_excel( ptablebody) {

    str="";
    var ExcelApp = new ActiveXObject("Excel.Application");
    var ExcelSheet = new ActiveXObject("Excel.Sheet");
    ExcelSheet.Application.Visible = true;

    var myTableHead = document.getElementById(ptablebody);
    var rowCount = myTableHead.rows.length;

    var colCount = myTableHead.getElementsByTagName("tr")[0].getElementsByTagName("td").length; 

    for(var i=0; i<rowCount; i++) {   
        for(var j=0; j<colCount; j++) {           
            str= myTableHead.getElementsByTagName("tr")[i].getElementsByTagName("td")[j].innerHTML;
            ExcelSheet.ActiveSheet.Cells(i+1,j+1).Value = str;
        }
    }
}

How are you exporting?

Nivas
– Nivas

2011-07-05 08:15:01 +00:00
Commented Jul 5, 2011 at 8:15 — Nivas
– Nivas, Commented Jul 5, 2011 at 8:15
@nivas I modified my post with the code i am using.

user755043
– user755043

2011-07-05 08:36:04 +00:00
Commented Jul 5, 2011 at 8:36 — user755043
– user755043, Commented Jul 5, 2011 at 8:36

Danny · Accepted Answer · 2011-07-28 15:14:16Z

1

I think you want innerText (or on firefox textContent) instead of innerHtml

answered Jul 28, 2011 at 15:14

Danny

7,5379 gold badges49 silver badges71 bronze badges

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

Collectives™ on Stack Overflow

Problems exporting HTML table to Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related