Export to excel gridview based on specific column.?

Question

hello dear
i m in problems.
i need to export gridview to excel based on specidic column such as WONo, Description, QtyWo. how can i do it ? if any body help me best regurds.

VIEW	Update	WOId	WONo	PRNo	Description	QtyWo	Date	Price	Approval	WOSL	Usersn
13	13	13	WO-1	PR-1	FB LABEL_NANO TAG	15000	5/15/2013	20.0000	True	52
13	13	13	WO-1	PR-1	Master carton 52*80_....	5000	5/15/2013	20.0000	True	53
14	14	14	Wo-ch	PR-ch	Gray color_Gray colo....	500	5/19/2013	20.0000	True	54	rowshan
15	15	15	PRE1888-WO-1	PRE1888-PR-01	MASTER CARTON UNPRIN....	5000	5/11/2013	100.0000	False	55	rowshan
15	15	15	PRE1888-WO-1	PRE1888-PR-01	MASTER CARTON UNPRIN....	4000	5/11/2013	200.0000	False	56	rowshan
18	18	18	WO-Yea	PR-Y	10% cotton_	200	5/27/2013	10.0000	False	57	rowshan
18	18	18	WO-Yea	PR-Y	10% cotton_100% cott....	1000	5/27/2013	10.0000	False	58	rowshan
19	19	19	PRE1888-WO-02	PRE1888-PR-02	FB LABEL_HAND TAG	16500	5/26/2013	12500.0000	False	59
19	19	19	PRE1888-WO-02	PRE1888-PR-02	WK-STRICKER_NANO TAG	10000	5/26/2013	1222.0000	False	60
18	18	18	WO-Yea	PR-Y	10% cotton_	300	5/27/2013	20.0000	False	61

					Grand Total	57500

Ravi Shekhar · Answer

Use below code... public void ExportData(DataTable dset) { HttpResponse response = HttpContext.Current.Response; // first let's clean up the response.object response.Clear(); response.Charset = ; // set the response mime type for excel //Dim filename As String = Record.xls string filename = Report( +  + DateTime.Now.ToString(dd-MM-yyyy) + ).xls; response.ContentType = application/vnd.ms-excel; response.AddHeader(Content-Disposition attachment;filename=\ + filename + \); // create a string writer using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // instantiate a datagrid DataGrid dg = new DataGrid(); dg.DataSource = dset; dg.DataBind(); dg.RenderControl(htw); response.Write(sw.ToString()); response.End(); } } }