Export WinGrid™ Data to Excel with Ease

Click to learn about Printing and Exporting to Excel

Export row data, headers, and summaries from the WinGrid™ to a binary-compatible Excel spreadsheet (.XLS), which can be opened inside Excel 97 or later.  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. Taking advantage of 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.

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, enabling you to share spreadsheets with a worldwide audience of users.
  • 100% Managed Code - The export engine runs without unmanaged code access security permission.