Export MVC HTML to excel
1: ADD <div id="dvData">
line in your page.
2: ADD
1: ADD <div id="dvData">
line in your page.
2: ADD
<script src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function () { $("#btnExport").click(function (e) { exportTable($('#dvData').html(), 'finance-ticket.xls'); }); }); function exportTable(myTable, filename) { //IE if (isIE()) { csvData = myTable; if (window.navigator.msSaveBlob) { var blob = new Blob([csvData], { type: "text/html" }); navigator.msSaveBlob(blob, filename); } } //other browser else { window.open("data:application/vnd.ms-excel," + encodeURIComponent(myTable)); } } function isIE() { var isIE11 = navigator.userAgent.indexOf(".NET CLR") > -1; var isIE11orLess = isIE11 || navigator.appVersion.indexOf("MSIE") != -1; return isIE11orLess; } </script>
3: <input type="button" id="btnExport" value="Export" />
Then just click on the button you will get html in excel format.
No comments:
Post a Comment