asp.net导出excel-----问题严重
是统计总数和汇总信息。我想在导出数据时，按datagrid的显示来导出。
第一页
[align=center][/align]
---------------------------------------------------------提入行号标志金额票据号帐号交易码流水号提入账号提出账号---------------------------------------------------------
50052借方2,100.0028435005288880 01390'500528888'2703345309000002785
---------------------------------------------------------
60108借方1,350.0059926010888880 01400'601088888 '2703345309000002785
----------------------------------------------------------
70289借方261.4268317028988880 01410'702898888'2703345309000002785
----------------------------------------------------------
70297借方2,800.0021877029788880 01420'702978888'2703345309000002785
----------------------------------------------------------
退票笔数0退票金额0
----------------------------------------------------------
合计借方笔数借方金额贷方笔数贷方金额提出总笔数----------------------------------------------------------
46,511.42004
----------------------------------------------------------
第二页
----------------------------------------------------------
提入行号标志金额票据号帐号交易码流水号提入账号提出账号
----------------------------------------------------------
60111借方40,000.0033556011188880 01450'601118888 '202618888
-----------------------------------------------------------
退票笔数0退票金额0
-----------------------------------------------------------
合计借方笔数借方金额贷方笔数贷方金额提出总笔数
----------------------------------------------------------
140,000.00001
-----------------------------------------------------------
[解决办法]
用OWC组件试试。
[解决办法]
刚才做了一个用输出流就可以了：示例代码如下
//用输出流输出数据
private void DataTableToExcel(System.Data.DataTable dtData)
{
System.Web.UI.WebControls.DataGrid dgExport = null;
//当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
curContext.Response.Charset = "";
curContext.Response.BufferOutput = true;
curContext.Response.Clear();
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
//返回客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
