导出EXCEL

            Response.ClearContent();
            Response.AddHeader("content-disposition", "attachment; filename=SearchPT.xls");
            Response.ContentType = "application/ms-excel";
            StringWriter stringWriter = new StringWriter();
            HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);

 

            Datagrid.RenderControl(htmlTextWriter);

            Response.Write(stringWriter.ToString());
            Response.End();

 

 

        void gridToExcel_ItemDataBound(object sender, DataGridItemEventArgs e)
        {
            //文本：vnd.ms-excel.numberformat:@
            //日期：vnd.ms-excel.numberformat:yyyy/mm/dd
            //数字：vnd.ms-excel.numberformat:#,##0.00
            //货币：vnd.ms-excel.numberformat:￥#,##0.00
            //百分比：vnd.ms-excel.numberformat: #0.00%
            e.Item.Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@");  //0-Pick Ticket#
            e.Item.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@");  //1-customer

            if (e.Item.ItemType == ListItemType.Header)
            {
                for (int i = 0; i < ShipmentDatagrid.Columns.Count; i++)
                {
                    e.Item.Cells[i].Text = ShipmentDatagrid.Columns[i].HeaderText;//remove grid sort link
                    e.Item.Cells[i].Attributes.Add("style", "background-color: #B5C5D4;font-weight: bold");
                }
            }
        }