Export table from gridview to Excel perticular cells only

See more:

C#

ASP.NET

sir
I write a programe export gridview to excel.I have an button controle when iam click the button table will be displayed in the Excel

The coding is below

<br />
 protected void btnExcel2_Click(object sender, EventArgs e)<br />
        {<br />
            string s = "select  student.id,name,m1,m2,m3,semister,tot from student,studentmarks where student.id=studentmarks.id";<br />
            SqlDataAdapter da = new SqlDataAdapter(s, con);<br />
            DataTable dt = new DataTable();<br />
            da.Fill(dt);<br />
            using (var wrt = new StreamWriter(@"D:\kranthi tasks in windos\exceltonotepad\exceltonote\exceltonote\date.xls"))<br />
            {<br />
                for (int i = 0; i < dt.Columns.Count; i++)<br />
                {<br />
                    wrt.Write(dt.Columns[i].ToString().Trim() + "\t");<br />
                }<br />
                wrt.WriteLine();<br />
                for (int j = 0; j < dt.Rows.Count; j++)<br />
                {<br />
                    if (dt.Rows[j][0].ToString() != null)<br />
                    {<br />
                        wrt.Write(dt.Rows[j][0].ToString().Trim());<br />
                        for (int i = 1; i < dt.Columns.Count; i++)<br />
                        {<br />
                            wrt.Write("\t" + dt.Rows[j][i].ToString().ToString().Trim());<br />
                        }<br />
                        wrt.WriteLine();<br />
                    }<br />
                }<br />
            }<br />
            Process.Start(@"D:\kranthi tasks in windos\exceltonotepad\exceltonote\exceltonote\date.xls");<br />
        }<br />

and it display in excel like this

id name m1 m2 m3 semister tot
1 Govind 90 90 100 I 280
1 Govind 90 90 100 II 280
1 Govind 90 90 100 III 280
1 Govind 90 90 100 IV 280
1 Govind 90 90 100 VI 280
1 Govind 90 90 100 VII 280
1 Govind 90 90 100 VIII 280
1 Govind 90 90 100 IX 280
2 Krishna 90 90 100 I 280
2 Krishna 90 90 100 II 280
2 Krishna 90 90 100 III 280
2 Krishna 90 90 100 IV 280
2 Krishna 90 90 100 VI 280
2 Krishna 90 90 100 VII 280
2 Krishna 90 90 100 VIII 280


but i want Display folling way in excel

id name m1 m2 m3 semister tot
1 Govind 90 90 100 I 280
90 90 100 II 280
90 90 100 III 280
90 90 100 IV 280
90 90 100 VI 280
90 90 100 VII 280
90 90 100 VIII 280
90 90 100 IX 280
2 Krishna 90 90 100 I 280
90 90 100 II 280
90 90 100 III 280
90 90 100 IV 280
90 90 100 VI 280
90 90 100 VII 280
90 90 100 VIII 280

Pls help me