xlsx file has error that file in use by another user

Question

Hi  I am getting an error while browsing a xlsx file through my code in c#. I got the error  file in process  used by another user. I'm using gembox code not ms excel interop. following is my code lines where i get error: ExcelFile ef = new ExcelFile(); SpreadsheetInfo.SetLicense(XXXX-XXXX-XXXX-XXXX); ef = ExcelFile.Load(this.m_filePath); Thank you..

vaibhav Hedaoo · Answer

hi sunita I have also deal with same problem. That file might be open in background try to close it through task manager and add code to close the file before that programme ends up

Mario Zorica · Answer

Hi Sunita well you need to find out who is locking your XLSX file. You can try some suggestions on StackOverflow in order to detect that process: http://stackoverflow.com/questions/3386157/file-is-used-by-another-process-how-to-know-which-process I personaly use Unlocker . Also I would like to add that in case you are using Excel Interop before that posted snippet code then you should check if you releasing all the interop objects correctly check the following for some additional information: http://stackoverflow.com/questions/158706/how-to-properly-clean-up-excel-interop-objects