RadSpreadSheet, Exception: The process cannot access the file "xxxx" because it is being used by another process

[Adam]

Hello,

i am trying to show content of excel file in RadSpreadSheet. For first attempt its working fine, but if i decide to change something in excel file i can't do it, because RadSpreadSheet keep the excel file open. How can I lost connection to my excel, edit it, and reopen edited file again? I have tried everytime when i need to open excel create new instance OF RadSpreadSheet, but it doesn't work. Please look at the code below.


The code is basicly managed as: When i show UserControl  (Visible = true), i want to create new instance of RadSpreadSheet for losing existing connection and have option load the file what i edited. Please understand as cycle:  Open excel file in RadSpreadSheet, than i need to have options: edit / delete or recreate excel file and open the edited excel file again in RadSpreadSheet. But it doesn't work because new intance of RadSpreadSheet is empty and there is not loaded file or it throw exception: "The process cannot access the file "xxxx" because it is being used by another process".  Via code is it: User create excel file than this file is loaded to RadSpreadSheet (everything okay) and than has option to print this excel or go back and edit excel file again (when it eddited, the program drop with exception thats this file is used in another process) Personally i think when i load file and it is showing in RadSpreadSheet, and after that i want to edit file, the RadSpreadSheet has still connection to this file. The new instances of RadSpreadSheet is not solution of losing connection.

Last and not least i am sorry for my mistakes in English
Thank you for any response and your time. 

[Nadya | Tech Support Engineer]

Hello, Adam,

Thank you for writing.

In .NET and Windows, the applications are usually locking the files they are working with in order to prevent other applications from changing them as this may corrupt the files. You need to make sure that the file is not used in order to avoid this exception. Detailed information about this exception can be found in the following forum post: c# - IOException: The process cannot access the file 'file path' because it is being used by another process - Stack Overflow

What I can suggest is to reload the file again every time when you have finished editing it. Let's say that you open the Excel file, when you are ready editing, it then close it and reload again in RadSpreadSheet. For exampe, you can do this on a button click

I hope this information is useful. If you have any other questions, please let me know.

Regards,
Nadya | Tech Support Engineer
Progress Telerik