Infragistics WinGridExcelExporter

Export grid data to MS Excel with ease.
Events and properties allow you to control how layouts and appearances apply to data before export, and can be used to filter out unwanted rows or columns. Using many of Excel's advanced formatting features, the exporter component generates expandable row groups, column headers, summary rows, frozen columns, and more to best recreate the presentation in WinGrid. WinCalcManager formulas present in your WinGrid translate into equivalent Excel formulas, continuing to calculate when the user opens an exported Worksheet.

WinGridExcelExporter 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.

WinGridExcelExporter features at a glance:

• Instant Exports - Export WinGrid data to Excel with as little as one method call.
• Event-Driven Export Control - WinGridExcelExporter events allow customization of exported data before any row, column or cell is written to the worksheet.
• High Fidelity - WinGridExcelExporter replicates the WinGrid data presentation using comparable Excel formatting features, such as using row grouping to create a nested, hierarchical view on normally flat 2-dimensional worksheets. (CardView is not supported.)
• 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.
• Seamless Formula Translation – WinCalcManager formulas in the WinGrid can be automatically converted into the equivalent Excel function (i.e., [Price]+[SalesTax] exports as =SUM(A1:A2)).
• 100% Managed Code - The export engine runs without unmanaged code access security permission.

* - Support of Microsoft Excel 2007 .XLSX and .XLSM file formats requires .NET Framework 3.0, and is only included when using the CLR 3.0 builds of the Infragistics.Excel and Excel Exporter assemblies.