I am able to export a datagridview from my vb.net application. The file gets created, but when I try to open it, it says the file is 'Read-only' thru the exporter_ExportFailed event.
In fact only the folder is opened after the export process is over. XL file is seen in the folder but it is not even opened by the system. Also it takes always about 58 secs even if the DGView has only four lines !
The PDF and the Html export is working fine and are quite quick.
This is the code I am using:
Dim settings As DGVEExcelExportSettings = New DGVEExcelExportSettings()
Dim exporter As DGVEExcelExporter = New DGVEExcelExporter()
AddHandler exporter.ExportFailed, AddressOf exporter_ExportFailed
DGVEExportingManager.ExportersDirectoryName = "C:\VWSDATA\" & WORKID
FNAME = "C:\VWSDATA\" & WORKID & "\" & FNAME
settings.ExportFileName = FNAME
settings.OpenFileAfterGeneration = True 'Open generated file after export
settings.OpenFolderAfterGeneration = True
exporter.Export(DGV, settings)
Please Help.
Let me also add this - your 'DGView' add-in is quite good and I want to buy it soon !
Rgds
Renga