I wanted to generate an excel sheet once a user clicks on a button . Basically i want to do exactly what is dicussed here

how to pass html table values to excel sheet cells
(Kalle H. Väravas answer )

JavaScript to export HTML tables to Excel

But somehow nothing happens when i click on the button . I am using Mozilla browser . My code needs ActiveXObject enabled . DO i need to do something extra to get it done . ?

I created this fiddle for testing . If this works i will try out my real code . if this works for you then also please let me know . Thanks

jFiddle

Code :

JS :

<script type=text/javascript>

    function CreateExcelSheet() {

        var i, j, str,

                myTable = document.getElementById('mytable'),

                rowCount = myTable.rows.length,

                excel = new ActiveXObject('Excel.Application');// Activates Excel

        excel.Workbooks.Add(); // Opens a new Workbook

        excel.Application.Visible = true; // Shows Excel on the screen

        for (i = 0; i < rowCount; i++) {

            for (j = 0; j < myTable.rows[i].cells.length; j++) {

                str = myTable.rows[i].cells[j].innerText;

                excel.ActiveSheet.Cells(i + 1, j + 1).Value = str; // Writes to the sheet

            }

        }

        return;

    }

</script>

Html :

<table id =myTable >

            <tr>

                <td>1</td>

                <td>Jan</td>

                <td>01/04/2012</td>

                <td>Approved</td>

            </tr>

            <tr>

                <td>2</td>

                <td>Feb</td>

                <td>01/04/2012</td>

                <td>Approved</td>

            </tr>

        </table>

        <form>

            <input type=button onclick=CreateExcelSheet(); value=Create Excel Sheet >

        </form>