2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
Excel exportProblem When the version is not specified, the following error occurs on opening the Excel document. Figure 1: Error Solution To export the Grid to Excel with .xlsx file extension, specify the workbook version. In the following code, the workbook version is specified as 2007 in the button click event. C# private void exportBtn_Click(object sender, EventArgs e) { //support to export the grid to excel GridExcelConverterControl converter = new GridExcelConverterControl(); ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2007; IWorkbook workBook = ExcelUtils.CreateWorkbook(1); workBook.Version = ExcelVersion.Excel2007; IWorksheet sheet = workBook.Worksheets[0]; //used to convert grid to excel converter.GridToExcel(this.gridControl1, sheet, ConverterOptions.Default); //used to save the file workBook.SaveAs("sample.xlsx"); //used to open the file Process.Start("sample.xlsx"); } VB Private Sub exportBtn_Click(ByVal sender As Object, ByVal e As EventArgs) 'support to export the grid to excel Dim converter As New GridExcelConverterControl() Dim excelEngine As New ExcelEngine() Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2007 Dim workBook As IWorkbook = ExcelUtils.CreateWorkbook(1) workBook.Version = ExcelVersion.Excel2007 Dim sheet As IWorksheet = workBook.Worksheets(0) 'used to convert grid to excel converter.GridToExcel(Me.gridControl1, sheet, ConverterOptions.Default) 'used to save the file workBook.SaveAs("sample.xlsx") 'used to open the file Process.Start("sample.xlsx") End Sub
Reference link: https://help.syncfusion.com/windowsforms/grid-control/exporting |
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.