Export to excel gridview based on specific column.?

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.

<table class="style1">
<tbody>
<tr>
<td colspan="4">
<div id="ContentPlaceHolder1_divbix">
<div>
<table id="ContentPlaceHolder1_GridView1" border="1" rules="all" cellspacing="0" style="width: 900px; border-collapse: collapse;">
<tbody>
<tr style="background-color: #9933ff; color: aqua;">
<th scope="col">VIEWth> <th scope="col">Updateth> <th scope="col">WOIdth> <th scope="col">WONoth> <th scope="col">PRNoth> <th scope="col">Descriptionth> <th scope="col">QtyWoth> <th scope="col">Dateth> <th scope="col">Priceth> <th scope="col">Approvalth> <th scope="col">WOSLth> <th scope="col">Usersnth>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_0" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl02$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_0">13label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_0" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl02$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_0">13label>span> td>
<td title="13">13td>
<td title="WO-1">WO-1td>
<td title="PR-1">PR-1td>
<td title="FB LABEL_NANO TAG">FB LABEL_NANO TAGtd>
<td title="15000">15000td>
<td title="5/15/2013">5/15/2013td>
<td title="20.0000">20.0000td>
<td title="True">Truetd>
<td title="52">52td>
<td title=" "> td>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_1" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl03$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_1">13label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_1" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl03$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_1">13label>span> td>
<td title="13">13td>
<td title="WO-1">WO-1td>
<td title="PR-1">PR-1td>
<td title="Master carton 52*80_NANO TAG">Master carton 52*80_....td>
<td title="5000">5000td>
<td title="5/15/2013">5/15/2013td>
<td title="20.0000">20.0000td>
<td title="True">Truetd>
<td title="53">53td>
<td title=" "> td>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_2" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl04$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_2">14label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_2" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl04$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_2">14label>span> td>
<td title="14">14td>
<td title="Wo-ch">Wo-chtd>
<td title="PR-ch">PR-chtd>
<td title="Gray color_Gray color">Gray color_Gray colo....td>
<td title="500">500td>
<td title="5/19/2013">5/19/2013td>
<td title="20.0000">20.0000td>
<td title="True">Truetd>
<td title="54">54td>
<td title="rowshan">rowshantd>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_3" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl05$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_3">15label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_3" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl05$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_3">15label>span> td>
<td title="15">15td>
<td title="PRE1888-WO-1">PRE1888-WO-1td>
<td title="PRE1888-PR-01">PRE1888-PR-01td>
<td title="MASTER CARTON UNPRINTED - 50X27 30.5_">MASTER CARTON UNPRIN....td>
<td title="5000">5000td>
<td title="5/11/2013">5/11/2013td>
<td title="100.0000">100.0000td>
<td title="False">Falsetd>
<td title="55">55td>
<td title="rowshan">rowshantd>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_4" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl06$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_4">15label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_4" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl06$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_4">15label>span> td>
<td title="15">15td>
<td title="PRE1888-WO-1">PRE1888-WO-1td>
<td title="PRE1888-PR-01">PRE1888-PR-01td>
<td title="MASTER CARTON UNPRINTED - 58X37 22.5_">MASTER CARTON UNPRIN....td>
<td title="4000">4000td>
<td title="5/11/2013">5/11/2013td>
<td title="200.0000">200.0000td>
<td title="False">Falsetd>
<td title="56">56td>
<td title="rowshan">rowshantd>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_5" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl07$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_5">18label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_5" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl07$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_5">18label>span> td>
<td title="18">18td>
<td title="WO-Yea">WO-Yeatd>
<td title="PR-Y">PR-Ytd>
<td title="10% cotton_">10% cotton_td>
<td title="200">200td>
<td title="5/27/2013">5/27/2013td>
<td title="10.0000">10.0000td>
<td title="False">Falsetd>
<td title="57">57td>
<td title="rowshan">rowshantd>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_6" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl08$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_6">18label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_6" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl08$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_6">18label>span> td>
<td title="18">18td>
<td title="WO-Yea">WO-Yeatd>
<td title="PR-Y">PR-Ytd>
<td title="10% cotton_100% cotton">10% cotton_100% cott....td>
<td title="1000">1000td>
<td title="5/27/2013">5/27/2013td>
<td title="10.0000">10.0000td>
<td title="False">Falsetd>
<td title="58">58td>
<td title="rowshan">rowshantd>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_7" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl09$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_7">19label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_7" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl09$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_7">19label>span> td>
<td title="19">19td>
<td title="PRE1888-WO-02">PRE1888-WO-02td>
<td title="PRE1888-PR-02">PRE1888-PR-02td>
<td title="FB LABEL_HAND TAG">FB LABEL_HAND TAGtd>
<td title="16500">16500td>
<td title="5/26/2013">5/26/2013td>
<td title="12500.0000">12500.0000td>
<td title="False">Falsetd>
<td title="59">59td>
<td title=" "> td>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_8" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl10$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_8">19label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_8" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl10$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_8">19label>span> td>
<td title="19">19td>
<td title="PRE1888-WO-02">PRE1888-WO-02td>
<td title="PRE1888-PR-02">PRE1888-PR-02td>
<td title="WK-STRICKER_NANO TAG">WK-STRICKER_NANO TAGtd>
<td title="10000">10000td>
<td title="5/26/2013">5/26/2013td>
<td title="1222.0000">1222.0000td>
<td title="False">Falsetd>
<td title="60">60td>
<td title=" "> td>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_9" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl11$ChbView" /><label for="ContentPlaceHolder1_GridView1_ChbView_9">18label>span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_9" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl11$ChbUpdate" /><label for="ContentPlaceHolder1_GridView1_ChbUpdate_9">18label>span> td>
<td title="18">18td>
<td title="WO-Yea">WO-Yeatd>
<td title="PR-Y">PR-Ytd>
<td title="10% cotton_">10% cotton_td>
<td title="300">300td>
<td title="5/27/2013">5/27/2013td>
<td title="20.0000">20.0000td>
<td title="False">Falsetd>
<td title="61">61td>
<td title=" "> td>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_10" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl12$ChbView" />span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_10" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl12$ChbUpdate" />span> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
tr>
<tr>
<td><span style="background-color: activecaption; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbView_11" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl13$ChbView" />span> td>
<td><span style="background-color: red; color: aqua; font-weight: bold;"><input id="ContentPlaceHolder1_GridView1_ChbUpdate_11" type="checkbox" name="ctl00$ContentPlaceHolder1$GridView1$ctl13$ChbUpdate" />span> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title="Grand Total">Grand Totaltd>
<td title="57500">57500td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
<td title=" "> td>
tr>
tbody>
table>
div>
div>
td>
tr>
<tr>
<td class="style5"> td>
<td class="style6"> td>
<td> td>
tr>
tbody>
table>

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ravi Shekhar13y ago
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();
        }
    }

}
0