Excel export with exceed grid

[User (Old forums)]

#17646 |

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)

[Xceed Support]

#17647

Hi Saifee,

Are you able to send me a small self contained sample application which demonstrates the crash that you are experiencing? With this information, I will be able to further investigate into the matter and provide you with a possible solution to your concern.

Also, do you get the same crash when using the export feature from the Grid for .NET sample applications that were installed on your hard drive?

Imported from legacy forums. Posted by Marc [Xceed] (had 993 views)

[Author]

Posts