Hi,
I am using Xceed Grid (ver-3.8.11214.17010 ) for Windows to export the grid data to excel file. Below is the code used.
After writing the name of the file in the dialog, the application just crashes. Excel version used is 2003.
Please help me resolve this issue.
Dim
excel As Exporting.ExcelExporter = New Exporting.ExcelExporter()
Dim dir As String
Dim saveDialog As SaveFileDialog = New SaveFileDialog()
With saveDialog
.AddExtension =
True
.CheckPathExists =
True
.DefaultExt =
“xls”
.OverwritePrompt =
True
.Filter =
“Excel|*.xls”
If .ShowDialog() = Windows.Forms.DialogResult.OK Then
dir = .FileName
Else
Exit Sub
End If
End With
excel.IncludeColumnHeaders =
True
excel.CellDataFormat = Exporting.CellDataFormat.Value
excel.Export(GridCtrl, dir)
Imported from legacy forums. Posted by Saifee (had 1187 views)