How should I dispose the target object?
The file is kept locked...and cannot be accessed later by other code.
Dim fileName As String = Server.MapPath("~/userfiles/file/excel/" & Session.SessionID & ".xlsx")
Dim formatProvider As IWorkbookFormatProvider = New XlsxFormatProvider()
Using output As New FileStream(fileName, FileMode.Create)
formatProvider.Export(workbook, output)
End Using
1 Answer, 1 is accepted
0
Hi,
The way the export is done here is correct and there shouldn't be anything additional needed for it to dispose the file stream properly. It seems to me that most likely there is something else in the application which is locking the file. In case you are unable to determine such a place and have a reason to think that the format provider is causing the lock, can you please prepare a sample project isolating the issue and send it our way? I am sure it can be a hassle to reproduce the server behavior, but it would indeed be of great help.
Regards,
Anna
Progress Telerik
The way the export is done here is correct and there shouldn't be anything additional needed for it to dispose the file stream properly. It seems to me that most likely there is something else in the application which is locking the file. In case you are unable to determine such a place and have a reason to think that the format provider is causing the lock, can you please prepare a sample project isolating the issue and send it our way? I am sure it can be a hassle to reproduce the server behavior, but it would indeed be of great help.
Regards,
Anna
Progress Telerik