View Example: Export a Report to XLS Format If you create a report in the Visual Studio Designer: change the options in the Properties panel.If you create a report in code: create a XlsExportOptions object, specify export options for this object, then pass the object to the XtraReport.ExportToXls or XtraReport.ExportToXlsAsync methods as the second argument.To change the default options, do the following: If you specify only the path/stream, the report is exported to XLS format with the default options. Specify the path/stream to which the report should be exported as the first argument in these methods. Use the XtraReport.ExportToXls or XtraReport.ExportToXlsAsync methods to export a report to XLS format. Specify export options in the Export Options dialog, expand the Export To drop-down list in the toolbar, and select XLS. You can export a report from ASP.NET Web Forms Document Viewer, ASP.NET MVC Document Viewer, or ASP.NET Core Document Viewer. Export from Document Viewer (Web Platforms) Specify export mode and options in the invoked XLS Export Options dialog and click OK. Expand the drop-down list of export formats and select XLS File. You can export a report from the Visual Studio Preview tab, WinForms Print Preview, and WPF Print Preview. Export from Preview (Visual Studio, WinForms, WPF) To export data to XLS without exact layout replication, use the Spreadsheet Document API instead of the reporting export engine. Refer to the following section for more details: Merged Cells And Extra Columns/Rows: Troubleshooting. Report layouts with misaligned columns, empty spaces, and misaligned headers and footers might produce merged cells and extra columns/rows in the exported XLS file. Export options listed in this article generate WYSIWYG output.
Press the Run button or F5 to run the example application.Ĭall the UseAsyncEngine method at application startup to use asynchronous counterparts of Reporting API interfaces and methods. Note: If you change the version of DevExpress NuGet packages used in the example application, make sure you also specify the matching minor versions for DevExpress client libraries in the package.json file. For the Angular project, navigate to the ClientApp directory and run npm install.
#Devexpress copy report file install#
For the ASP.NET Core MVC project, run npm install in the project's root folder.Register the NuGet feed as a package sources.Use the following steps to configure NuGet: To run the example application, you need to install packages from the DevExpress NuGet feed.
#Devexpress copy report file code#
Token-based Authorization for Print and Export Operations.You can use the example code in your web application and modify it for different scenarios. - Implements services and business logic for the MVC and Angular projects.- An ASP.Net Core application with an Angular frontend.
This application is split into three projects: This repository also contains an example application that demonstrates the described techniques. This README file describes best practices to follow when you develop a web application with DevExpress reporting controls. ASP.NET Core Reporting - Best Practices Introduction
0 kommentar(er)
