Export GridView Data to Excel

Dear All Experts,

I need to export Gridview Data to excel by JavaScript code with supporting Arabic language

in ASP.net
Asrar AzmiWeb DeveloperAsked:
Who is Participating?
Kalpesh ChhatralaConnect With a Mentor Software ConsultantCommented:
you can start with below code. you need to modify as per your requirement.

  function XlsExport()
        try {
            var i;
            var j;
            var mycell;
            var tableID = "tblGridView";

            var objXLS = new ActiveXObject("Excel.Application");
            var objWB = objXLS.Workbooks.Add();
            var objWS = objWB.ActiveSheet;

            for (i = 0; i < document.getElementById('<%= tblAuditReport.ClientID %>').rows.length; i++) {
                for (j = 0; j < document.getElementById('<%= tblAuditReport.ClientID %>').rows(i).cells.length; j++) {
                    mycell = document.getElementById('<%= tblAuditReport.ClientID %>').rows(i).cells(j);
                    objWS.Cells(i + 1, j + 1).Value = mycell.innerText;

            //objWS.Range("A1", "L1").Font.Bold = true;

            objWS.Range("A1", "Z1").EntireColumn.AutoFit();

            objXL.Visible = true;

        catch (err)



Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.