WPF Data Presenter Excel® Exporter Control

Export row data, headers, and summaries from the xamDataPresenter™ to an Excel-compatible spreadsheet (.XLSX or .XLS file format). One call to the export method on the non-visual DataPresenterExcelExporter™ component (perhaps in response to a button click event or WPF command) is all it takes to export your data presenter to an Excel file.

Since XAML can describe how to present cells more richly than in Excel, not everything automatically carries over into Excel.  For example, if you rely on inherited brush resources for the background of your cell presenter then it will not automatically carryover.  We simplify how many appearances carryover into Excel by providing you with attached export appearance properties that enable you to control how data is displayed by the exported worksheet, and can be used to filter out unwanted records, fields or aspects of the data as it was seen in WPF.

DataPresenterExcelExporter builds on top of our Infragistics.Excel BIFF8 import/export engine and its extensive object model, a powerful 100% managed code library without dependencies on Microsoft Office® that eliminates heavy overhead and enables applications to run without unmanaged code access security permission.

Key Features at a Glance

• Instant Exports - Export xamDataPresenter data to Excel with as little as one method call.
• Control over Exported Appearance - DataPresenterExcelExporter events and attached properties allow customization of exported data before any record, field or cell is written to the worksheet.
• Compatibility - The export engine writes .XLS files in the BIFF8 file format compatible with Microsoft Excel 97 and later, and .XLSX/.XLSM files compatible with Microsoft Excel 2007 and later, enabling you to share spreadsheets with a worldwide audience of users.
• 100% Managed Code - The export engine runs without unmanaged code access security permission.