export huge html data into excel

exporting huge data around 1500 rows into excel

by AnilAwadh

HTML

<button id="myButtonControlID">Export Table data into Excel</button>
<div id="divTableDataHolder">
    <title>Demo for huge data</title>
    <table>
        <tbody>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
            </tr>
            <tr>
                <td>abc</td>
                <td>12</td>
                <td>Delhi</td>
                <td>India</td>
                <td>Earth</td>
...

CSS

table
{
    border: 1px solid black;    
}
th
{
    border: 1px solid black;
    padding: 5px;
    background-color:skyblue;
    color: white;  
}
td
{
    border: 1px solid black;
    padding: 5px;
    color: green;
}

JavaScript

$("[id$=myButtonControlID]").click(function(e) {
    window.open('data:application/vnd.ms-excel,' + encodeURIComponent( $('div[id$=divTableDataHolder]').html()));
    e.preventDefault();
});