?

protected?void?btnExcel_Click(object?sender,?EventArgs?e)
????{
????????//綁定
????????bindgrdExcel();
????????//修改多行表頭
????????ModifygrdHeader();
????????//導(dǎo)出Excel
????????toExcelgrdExcel();

????}
????///?<summary>
????///?Response方法導(dǎo)出Excel，必須加的代碼
????///?</summary>
????///?<param?name="control"></param>
????public?override?void?VerifyRenderingInServerForm(Control?control)
????{
????????//?Confirms?that?an?HtmlForm?control?is?rendered?for
????}
????///?<summary>
????///?綁定grdExcel
????///?</summary>
????void?bindgrdExcel()
????{
????????DataSet?ds?=?db.GetDataSet("procUtility_Excel");
????????grdExcel.DataSource?=?ds.Tables[0];
????????grdExcel.DataBind();
????}
????///?<summary>
????///?導(dǎo)出Excel
????///?</summary>
????void?toExcelgrdExcel()
????{
????????Response.Clear();
????????Response.Buffer?=?true;
????????Response.Charset?=?"GB2312";
????????Response.AppendHeader("Content-Disposition",?"attachment;filename=Qty.xls");
????????//如果設(shè)置為?GetEncoding("GB2312");導(dǎo)出的文件將會出現(xiàn)亂碼！！！
????????Response.ContentEncoding?=?System.Text.Encoding.UTF8;
????????Response.ContentType?=?"application/ms-excel";//設(shè)置輸出文件類型為excel文件。?

????????System.IO.StringWriter?oStringWriter?=?new?System.IO.StringWriter();
????????System.Web.UI.Html32TextWriter?oHtmlTextWriter?=?new?Html32TextWriter(oStringWriter);

????????grdExcel.RenderControl(oHtmlTextWriter);
????????Response.Output.Write(oStringWriter.ToString());
????????Response.Flush();
????????Response.End();
????}
???///?<summary>
????///?自定義多行表頭
???///?</summary>
????void?ModifygrdHeader()
????{
????????try
????????{

????????????this.grdExcel.HeaderRow.Cells.Clear();
????????????TableCell?cell?=?new?TableCell();
????????????cell.Text?=?"<tr??style='background-color:?#006699;font-size:?15px;color:?#FFFFFF;padding:?2pt;'><td?rowspan='2'?style='font-size=15px'>Customer</td><td??rowspan=2??style='font-size=15px'>"?+
?????????????????????????"Size</td><td?rowspan='2'??style='font-size=15px'>TAC?Film</td><td?rowspan='2'??style='font-size=15px'>搭配性產(chǎn)品</td><td?rowspan='2'??style='font-size=15px'>T/B</td><td?rowspan='2'??style='font-size=15px'>Absorption?Angle</td>"?+
?????????????????????????"<td?rowspan='2'??style='font-size=15px'>Dimension_X</td><td?rowspan='2'??style='font-size=15px'>Dimension_Y</td><td?rowspan='2'??style='font-size=15px'>經(jīng)濟(jì)幅寬</td><td?colspan='2'??style='font-size=15px'>1330mm</td><td?colspan='2'??style='font-size=15px'>1475mm</td><td?colspan='2'??style='font-size=15px'>2000mm</td>"?+
?????????????????????????"</tr><tr??style='background-color:?#006699;font-size:?12px;color:?#FFFFFF;padding:?2pt;'><td>片數(shù)/M</td><td>利用率</td><td>片數(shù)/M</td><td>利用率</td><td>片數(shù)/M</td><td>利用率</td>";
?
????????????this.grdExcel.HeaderRow.Cells.Add(cell);
????????}
????????catch?(Exception?e)
????????{
????????????string?url?=?Request.ApplicationPath?+?"/error.aspx?error="?+?e.Message.ToString()?+?"&strurl="?+?Request.Url.ToString()?+?"&way=gridheader";
????????????Response.Redirect(url);
????????}
????}

?

轉(zhuǎn)載于:https://www.cnblogs.com/amadeuslee/archive/2008/08/26/3744469.html

總結(jié)

以上是生活随笔為你收集整理的【Vegas原创】GridView修改表头，并导出Excel(C#版)的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。