Есть ли в Excel какой-либо API, который мой код C# может вызывать, чтобы определить, читает ли кто-либо/записывает из/в ⇐ C#

[Anonymous]

We have a Windows 2016 virtual server that is running with OneDrive service. The OneDrive is used to sync the Excel files stored in the corporate SharePoint. We are developing C# code on the virtual server.

The purpose of the code is to read/write from/to an Excel file located in OneDrive. The problem is that at the time of code running, if there is one or more users are reading/writing from/to the Excel file from SharePoint or from their own OneDrive (installed in their own laptops), the OneDrive in the virtual server would show sync error. This causes all users are not able to see the updates done by our code.

So my question is: does Excel have any API that my C# code can invoke to identify whether anyone is reading the shared Excel file or not? By identifying this, our code can determine if continue to run OR notify the user to quit the Excel file.

See attachment for illustration for easy read.

I have tried nothing. and I expect to learn an API that can be added to my C# code to identify the user(s) who is(are) reading the shared Excel file.


Источник: https://stackoverflow.com/questions/780 ... -anyone-is