Windows Forms Grid Excel Exporter Control

Click here to watch the printing and exporting to Excel control video. (Duration: 2:16)

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

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.

 

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.