I've been using the Microsoft.Office.Interop.Excel dll to work with Excel in my offline C# programs. When I made the move to ASP.Net website applications, I found that this dll no longer worked because of issues with server-side security. This is why I decided to start using ClosedXML. I've found multiple uses for ClosedXML but there is one issue.
How would I retrieve the active/selected cell from the spreadsheet?
I am trying to add this feature because my users need to click on the spreadsheet and update cells with values calculated by the C# code.
What I have tried:
I have tried using sheet.RangeUsed, but that gives the range of entire sheet