Export To Excel Using Jquerry

function download(strData, strFileName, strMimeType) {
    var D = document,
        a = D.createElement("a");
    strMimeType = strMimeType || "application/octet-stream";

    if (navigator.msSaveBlob) { // IE10+
        return navigator.msSaveBlob(new Blob([strData], { type: strMimeType }), strFileName);
    } /* end if(navigator.msSaveBlob) */

    if ('download' in a) { //html5 A[download]
        if (window.URL) {
            a.href = window.URL.createObjectURL(new Blob([strData]));

        } else {
            a.href = "data:" + strMimeType + "," + encodeURIComponent(strData);
        }
        a.setAttribute("download", strFileName);
        a.innerHTML = "downloading...";
        D.body.appendChild(a);
        setTimeout(function () {
            a.click();
            D.body.removeChild(a);
            if (window.URL) { setTimeout(function () { window.URL.revokeObjectURL(a.href); }, 250); }
        }, 66);
        return true;
    } /* end if('download' in a) */


    //do iframe dataURL download (old ch+FF):
    var f = D.createElement("iframe");
    D.body.appendChild(f);
    f.src = "data:" + strMimeType + "," + encodeURIComponent(strData);

    setTimeout(function () {
        D.body.removeChild(f);
    }, 333);
    return true;
}


Usage :-

$("#btnExportExcel").click(function (e) {
   
        download($('#gvContent').html(), reports + ".xls", "application/vnd.ms-excel");

    });
($('#gvContent').html()--------> It Is Table Div.
reports + ".xls" ------> Doenleded File Name.

Comments

Popular posts from this blog

SP People Picker Validation

Create multiple web parts in one SPFx Solution

SPFX With Graph API To Pull Azure Active Directory Group Users