Export Table to Excel using jQuery

Asked May 30 '14 at 06:19

Active May 30 '14 at 07:13

Viewed 595 times

I have an html page in which there is a table and i want to export the table data to Excel file.

I used the following code:

<head>
<title>Email application</title>
<script src="Scripts/jquery-2.1.1.js"></script>
<script src="Scripts/jquery-2.1.1.min.js"></script>
<script type="text/javascript">
    $("#BtnSendMessage").click(function(e) {            
        window.open('data:application/vnd.ms-excel,' + encodeURIComponent($('#TblExport').html()));            
        e.preventDefault();            
    })    </script></head>

My Html Page:

<body>    
<table id="TblExport">
    <tr>            
        <td><input type="text" id="TxtName" /></td>
        <td><input type="text" id="TxtEmail" /></td>
    </tr>
    <tr>
        <td colspan="2">
            <textarea id="TxtMessage"></textarea>
        </td>
    </tr>
    <tr>
        <td><input type="button" id="BtnSendMessage" value="SendMessage" /></td>
        <td><label id="LblErrorMessage"></label></td>
    </tr>
</table>

Now, after clicking on the button nothing is happening..

edited May 30 '14 at 07:13

asked May 30 '14 at 06:19

Nimit Joshi

Would be helpful if you could set up a jsfiddle. :) – JakeSidSmith May 30 '14 at 06:24
Have you included the references to the script to call btechco_excelexport? – Sherin Mathew May 30 '14 at 06:45
On a high level `$datatype` is undefined. i.e. you have missed some js file. What is `btechco_excelexport`? Where is it coming from? – Shubh May 30 '14 at 06:54
@Popeye i have edited my code.. – Nimit Joshi May 30 '14 at 07:14
@SherinMathew i have edited my code – Nimit Joshi May 30 '14 at 07:14
http://jsfiddle.net/sherin81/dE7AV/ - i have created a fiddle. I can see that an excel file is getting opened with the html. What is that you are expecting? – Sherin Mathew May 30 '14 at 08:07
@SherinMathew i need to store only values inserted on that textboxes. – Nimit Joshi May 30 '14 at 08:21
Please refer the answer in http://stackoverflow.com/questions/16078544/export-to-csv-using-jquery-and-html/16203218#16203218. Kindly let us know if you still need assistance. – Sherin Mathew May 30 '14 at 08:26

Export Table to Excel using jQuery

0 Answers0