#region 将表格转换成EXCEL或者Word的形式
/// <summary>
/// 说明:将表格转换成EXCEL形式
/// 参数:ctrl(控制定位);FileType(需导出后的文件类型);FileName(导出时的命名)
/// 调用方式ConvertToExcel(toPrint, "vnd.ms-excel", "入库记录" + ".xls");
/// </summary>
public static void ConvertToExport(Control ctrl, string FileType, string FileName)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
HtmlForm form = new HtmlForm();
ctrl.EnableViewState = false;
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(ctrl);
page.RenderControl(htw);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.ContentType = FileType;
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename="+FileName+".xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = Encoding.Default;
HttpContext.Current.Response.Write(sb.ToString());
HttpContext.Current.Response.End();
}
#endregion
通用的
ConvertToExport(grid, "vnd.ms-excel", "文件名称");//调用方法
/// <summary>
/// 说明:将表格转换成EXCEL形式
/// 参数:ctrl(控制定位);FileType(需导出后的文件类型);FileName(导出时的命名)
/// 调用方式ConvertToExcel(toPrint, "vnd.ms-excel", "入库记录" + ".xls");
/// </summary>
public static void ConvertToExport(Control ctrl, string FileType, string FileName)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
HtmlForm form = new HtmlForm();
ctrl.EnableViewState = false;
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(ctrl);
page.RenderControl(htw);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.ContentType = FileType;
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename="+FileName+".xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = Encoding.Default;
HttpContext.Current.Response.Write(sb.ToString());
HttpContext.Current.Response.End();
}
#endregion
通用的
ConvertToExport(grid, "vnd.ms-excel", "文件名称");//调用方法