MVC

Export MVC HTML to excel

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