导成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");