This one is easy to reproduce. Just create a new spreadsheet “Test.xlsx”, open it in Excel, and then execute the following code:
var workbook = new Workbook(@"C:\Users\Willem-Jan\Desktop\Test.xlsx");
We’re using Aspose.Cells for .NET Core. Until Aspose.Cells v21.12.0 it was possible to read Excel files while they are open in Excel. However, since Aspose.Cells v22.1.0 the following exception is thrown:
System.IO.IOException: ‘The process cannot access the file ‘C:\Users\Willem-Jan\Desktop\Test.xlsx’ because it is being used by another process.’
If you close Excel, there are no problems. Being able to read spreadsheets while they are open in Excel is an important feature for us.
Can you investigate this issue and provide a fix?