//导出EXECL 表格
protected void btnDaochu_Click(object sender, EventArgs e)
{
Export("application/ms-excel", "" + this.dropDanwei.Text.Trim() + this.zuanzeriqi.Value.Trim() + DateTime.Now.ToString() + ".xls");
}
/// <summary>
/// 定义导出Excel的函数
/// </summary>
/// <param name="FileType"></param>
/// <param name="FileName"></param>
private void Export(string FileType, string FileName)
{
dropDanwei.Visible = false;
dropYear.Visible = false;
dropMonth.Visible = false;
btnChaxun.Visible = false;
btnDaochu.Visible = false;
// btnprint.Visible = false;
Label1.Text = dropDanwei.SelectedItem.Text;
Label2.Text = dropYear.SelectedItem.Text;
Label3.Text = dropMonth.SelectedItem.Text;
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
Response.ContentEncoding = System.Text.Encoding.Default;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
StringWriter tw = new StringWriter(sb);
HtmlTextWriter hw = new HtmlTextWriter(tw);
//添加css样式
Response.Buffer = true;
// sb.Append("<html><body>");
sb.Append(" <style type='text/css'> #tabDetail "
+ "{"
+ "align:center;"
+ "height: 78px;"
+ "width: 1014px;"
+ "border:2px #000000 solid;"
+ "text-align:center;"
+ "}");
sb.Append(" #tb3 .right{"
+ "border-left: 0px solid #000000;"
+ "border-top: 0px solid #000000;"
+ "border-bottom: 0px solid #000000;"
+ " border-right: 0px solid #000000;"
+ "}");
sb.Append(" #tb2 .right{"
+ "border-left: 0px solid #000000;"
+ "border-top: 0px solid #000000;"
+ "border-bottom: 0px solid #000000;"
+ " border-right: 0px solid #000000;"
+ "}");
sb.Append("#tb3 .tcleft {"
+ "border-left: 0px solid #000000;"
+ "border-top: 0px solid #000000;"
+ "border-bottom: 0px solid #000000;"
+ " border-right: 1px solid #000000;"
+ "}");
sb.Append("#tb3 .tcbottom {"
+ "border-left: 0px solid #000000;"
+ "border-top: 0px solid #000000;"
+ "border-bottom: 1px solid #000000;"
+ " border-right: 0px solid #000000;"
+ "}");
sb.Append("#tb2 .tcleft {"
+ "border-left: 0px solid #000000;"
+ "border-top: 0px solid #000000;"
+ "border-bottom: 0px solid #000000;"
+ " border-right: 1px solid #000000;"
+ "}");
sb.Append("#tb2 .tcbottom {"
+ "border-left: 0px solid #000000;"
+ "border-top: 0px solid #000000;"
+ "border-bottom: 1px solid #000000;"
+ " border-right: 0px solid #000000;"
+ "}");
sb.Append(" .heji {"
+ "font-weight:bold;"
+ "text-align:center;"
+ "}");
sb.Append(" .jiacu {"
+ "font-weight:bold;"
+ "padding-left:5px;"
+ "}");
sb.Append("#tabDetail td {"
+ "border-bottom: 1px solid #000000; "
+ "border-left: 1px solid #000000;"
+ "}");
sb.Append(" .cellstyle {"
+ "align:center;"
+ "width: 1014px;"
+ "height: 78px;"
+ "border:2px #000000 solid;"
+ "}");
sb.Append(".cellstyle td {"
+ "border-bottom: 1px solid #000000;"
+ "border-left: 1px solid #000000;"
+ "}");
sb.Append(" .tdNameSytle1 {"
+ "padding-left:25px;"
+ "text-align:left;"
+"font-size:13px;"
+ "}");
sb.Append(".tdNameSytleQiZhong {"
+ "padding-left:73px;"
+ "text-align:left;"
+ "}");
sb.Append(".tdHeiTiNameSytle {"
+ "padding-left:5px;"
+ "text-align:left;"
+ "font-weight:bold;"
+ "} ");
sb.Append(".tdShuZiRight {"
+ "text-align:right;"
+ "} ");
sb.Append(" .kemubianhao {"
+ "text-align: center;"
+ "} ");
sb.Append(".tb2 {"
+ "border:none;"
+ "}");
sb.Append(".tb3 {"
+ "border:0px solid #000000;"
+ "} ");
this.tabHeader.RenderControl(hw);
this.ph.RenderControl(hw);
//添加样式
// sb.Append("</body></html>");
Response.Write(sb.ToString());
Response.End();
}
/// <summary>
/// 此方法必重写，否则会出错
/// </summary>
/// <param name="control"></param>
public override void VerifyRenderingInServerForm(Control control)
{
}
浙公网安备 33010602011771号