如何在1 ms-excel文件中将2个网格视图导出为2个单独的工作表? [英] How do I export 2 gridviews into 2 seperated sheets in 1 ms-excel file?
本文介绍了如何在1 ms-excel文件中将2个网格视图导出为2个单独的工作表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨成员,
如何在1 ms-excel文件中将2个网格视图(GridView1和GridView2)导出为2个单独的工作表?目前,我只能将1个gridview导出到excelsheet,其文件名与工作表名称相同。但我想将2个网格视图分成两个单独的工作表,我希望自己定义/设置工作表名称。谢谢。
Hi members,
How do I export 2 gridviews (GridView1 & GridView2) into 2 seperated sheets in 1 ms-excel file? Currently, I'm able to export only 1 gridview to an excelsheet which the filename is the same as the sheet name. But I would like to 2 gridviews into 2 seperated sheets which I would like sheet name to be define/set by myself. thanks.
public void ExportGridToExcel()
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName ="Export"+DateTime.Now+".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition","attachment;filename=" + FileName);
GridView1.GridLines = GridLines.Both;
GridView1.HeaderStyle.Font.Bold = true;
GridView1.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
return;
}
推荐答案
如果您使用 Interop $,您可以添加工作表c $ c>或 OpenXML
。
也看看这里 - 将数据集导出到多个Excel表格 [ ^ ]
You can add sheets if you useInterop
orOpenXML
.
Also have a look here - Export DataSet to Multiple Excel Sheets[^]
这篇关于如何在1 ms-excel文件中将2个网格视图导出为2个单独的工作表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文