Version

Exporting to xlsx format (Using CLR 3.5)

The Export method of the WinGridExcelExporter™ component accepts the WorkBookFormat parameter which defines the format type as Excel2007 or Excel97To2003.

For more information on project dependencies and references when exporting to the xlsx format, please review the topic Office® 2007 xlsx file generation references and dependencies.

The example code below shows you how to export WinGrid into the xlsx file format using the WinGridExcelExporter

In Visual Basic:

Private Sub btnExport_Click (ByVal sender As System. Object, _
  ByVal e As System.EventArgs) Handles btnExport.Click
    Me.UltraGridExcelExporter1.Export (Me.ultraGrid1, "C:\GridData.xlsx", Infragistics.Documents.Excel.WorkbookFormat.Excel2007)
End Sub

In C#:

private void btnExport_Click (object sender, EventArgs e)
{
this.ultraGridExcelExporter1.Export (this.ultraGrid1, @"C:\GridData.xlsx", Infragistics.Documents.Excel.WorkbookFormat.Excel2007);
}