• Forums
• Home

Search Rate this topic:   Comments (optional) Sort Posts:  Oldest to newest Newest to oldest

03-07-2010, 10:27 PM Parthi Joined on 09-30-2009 Bangalore Posts 33 Export to Excel in C# Hi, I am using Data Dynamics Reports Version : 1.6.1588.0. I am able to export the Report to excel through DataDynamics. But i am not able to export the Reports to Excel through C#. Is there a way to achieve this? Do sent me some sample Reports for the above requirements. Thanks parthi    Report

03-08-2010, 6:29 AM Amit Pal Joined on 12-11-2008 Posts 855 Re: Export to Excel in C# Attachment: RenderToExcel.zip Parthi, You may use following code snippet to render the report to excel via code: //Load the RDLX in the Report Definition DataDynamics.Reports.ReportDefinition _reportDef = new DataDynamics.Reports.ReportDefinition(new System.IO.FileInfo(Application.StartupPath + @"..\..\..\Report1.rdlx")); //Load the Report Definition in the Report Runtime DataDynamics.Reports.ReportRuntime _reportRuntime = new DataDynamics.Reports.ReportRuntime(_reportDef); string exportFile = System.IO.Path.GetTempFileName() + ".xls"; //Create a new FileInfo object System.IO.FileInfo myFile = new System.IO.FileInfo(exportFile); //Create an onject of ExcelTransformationDevice DataDynamics.Reports.Rendering.Excel.ExcelTransformationDevice _renderingExtension = new DataDynamics.Reports.Rendering.Excel.ExcelTransformationDevice(); //Create an object of FileStreamProvider DataDynamics.Reports.Rendering.IO.FileStreamProvider _provider=new DataDynamics.Reports.Rendering.IO.FileStreamProvider(myFile.Directory, System.IO.Path.GetFileNameWithoutExtension(myFile.Name)); //Render the report to the ExcelTransformationDevice Object _reportRuntime.Render(_renderingExtension, _provider); //Open the rendered report in Excel System.Diagnostics.Process.Start(exportFile); Also find attached a sample application in which I have implemented the desired functionality. Amit Pal GrapeCity- DataDynamics    Report

GrapeCity » Product Support » Data Dynamics R... » Re: Export to Excel in C#

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Announcements |- ActiveBar Announcements |- ActiveReports Announcements |- ActiveReports for .NET Announcements |- ActiveSizer Announcements |- Data Dynamics WebSite Announcements |- DynamiCube Announcements |- SharpGraph for .NET Announcements |- SharpGrid Announcements |- SharpUI for .NET Announcements |- Data Dynamics Reports Announcements |- GrapeCity ActiveAnalysis Announcements Frequently Asked Questions |- ActiveReports 2.0 FAQ |- ActiveSizer FAQ |- DynamiCube FAQ |- SharpGrid FAQ |- ActiveReports for .NET FAQ |- ActiveBar FAQ |- SharpUI for .NET FAQ Product Support |- ActiveBar Support |- Data Dynamics Analysis Support |- ActiveReports 6 Support |- GrapeCity ActiveAnalysis Support |- ActiveReports for .NET 3.0 Support |- ActiveReports for .NET 2.0 Support |- ActiveReports for .NET Support |- ActiveReports 2.0 (Visual Basic 6.0) Support |- ActiveSizer Support |- DynamiCube Support |- SharpGraph for .NET Support |- SharpGrid Support |- SharpUI for .NET Support |- Data Dynamics Reports Support Knowledge Base |- KnowledgeBase for SharpUI for .NET |- KnowledgeBase for ActiveCube |- KnowledgeBase for ActiveReports |- KnowledgeBase for ActiveBar |- KnowledgeBase for ActiveReports for .NET |- KnowledgeBase for SharpGrid |- KnowledgeBase for ActiveSizer |- KnowledgeBase for DynamiCube |- KnowledgeBase for SharpGraph for .NET |- KnowledgeBase for Data Dynamics Reports Forum Archives |- ActiveReports for .NET 2.0 Visual Studio .NET 2005 Support |- ActiveBar 3.0 Beta Support |- support.activebar2.general |- support.activereports.general |- support.activereports.net |- support.activereports2.stdedition |- support.activereports2.proedition |- support.activesizer.general |- support.announcements |- support.dcube.c++ |- support.dcube.delphi |- support.dcube.ie |- support.dcube.misc |- support.dcube.vb |- support.dcube.vfp |- support.sharpgrid.general Product Downloads |- ActiveSizer Downloads |- SharpUI for .NET Downloads |- ActiveReports for .NET Downloads |- ActiveCube Downloads |- ActiveReports Downloads |- ActiveBar Downloads |- SharpGrid Downloads |- ActiveReports for .NET 2.0 Downloads |- SharpGraph for .NET Downloads |- DynamiCube Downloads |- ActiveReports for .NET 3.0 Downloads |- ActiveReports 6 Downloads |- Data Dynamics Reports Downloads Web Site Feedback |- Web Site Feedback Employment Opportunities |- Employment Opportunities