导成EXCEL见下面,其它的类似可得:String sExportFile; //定义导出文件
sExportFile = "C:\\" + Session.SessionID.ToString() + ".xls";
CrystalDecisions.Shared.ExportOptions oExportOptions;//ExportOptions提供属性,以便检索和设置用于导出报表的选项
CrystalDecisions.Shared.DiskFileDestinationOptions oDiskfileDestinationOptions;//DiskFileDestinationOptions提供属性,以便检索和设置导出到磁盘时的文件名
oDiskfileDestinationOptions =new CrystalDecisions.Shared.DiskFileDestinationOptions();
oDiskfileDestinationOptions.DiskFileName = sExportFile;
oExportOptions = oReport.ExportOptions;// 获取 ExportOptions 对象
oExportOptions.DestinationOptions = oDiskfileDestinationOptions;
//设置DestinationOptions为DiskFileDestinationOptions。它可以是DiskFileDestinationOptions、 ExchangeFolderDestinationOptions 或 MicrosoftMailDestinationOptionsoExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;//设置导出目标类型
oExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel;//设置导出格式类型
oReport.Export();
Response.ContentType = "xls";
Response.AddHeader("Content-Disposition","attachment;filename=Report.xls");
Response.WriteFile(sExportFile);
Response.Flush();
Response.Close();
System.IO.File.Delete(sExportFile);
Response.Buffer=true;
Response.Clear();
Response.ContentType="xls";
Response.AddHeader("Content-Length","45");
Response.AddHeader("Content-Disposition", "attachment;filename=Report.xls");
sExportFile = "C:\\" + Session.SessionID.ToString() + ".xls";
CrystalDecisions.Shared.ExportOptions oExportOptions;//ExportOptions提供属性,以便检索和设置用于导出报表的选项
CrystalDecisions.Shared.DiskFileDestinationOptions oDiskfileDestinationOptions;//DiskFileDestinationOptions提供属性,以便检索和设置导出到磁盘时的文件名
oDiskfileDestinationOptions =new CrystalDecisions.Shared.DiskFileDestinationOptions();
oDiskfileDestinationOptions.DiskFileName = sExportFile;
oExportOptions = oReport.ExportOptions;// 获取 ExportOptions 对象
oExportOptions.DestinationOptions = oDiskfileDestinationOptions;
//设置DestinationOptions为DiskFileDestinationOptions。它可以是DiskFileDestinationOptions、 ExchangeFolderDestinationOptions 或 MicrosoftMailDestinationOptionsoExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;//设置导出目标类型
oExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel;//设置导出格式类型
oReport.Export();
Response.ContentType = "xls";
Response.AddHeader("Content-Disposition","attachment;filename=Report.xls");
Response.WriteFile(sExportFile);
Response.Flush();
Response.Close();
System.IO.File.Delete(sExportFile);
Response.Buffer=true;
Response.Clear();
Response.ContentType="xls";
Response.AddHeader("Content-Length","45");
Response.AddHeader("Content-Disposition", "attachment;filename=Report.xls");
解决方案 »
- 弹出登录界面的问题?
- 16进制数据 处理大小端呢?
- 一个算法问题,求高手
- ERP系统的易用性和可用性问题
- C#图文并貌的邮件发送
- 有人知道datalist里的按钮怎么通过SESSION来控制显示的么?
- 一个很简单的递归调用,但我看不明,来帮手理解一下 ThankS
- C#写MP3转PCM格式
- 疑问:VC++6.0和C#.net2003能否协同开发软件
- 编译DLL时提示:未能找到源文件"\target:library",什么原因?
- c#的水晶报表中导出报表出现的一个错误,请帮忙,急!!!
- c#中关于datagrid_pageindexchanged事件与datagrid_itemcommand事件的问题
我还没有试验.