How to get the active cell from excel spreadsheet with closedxml

Question

1.00/5 (2 votes)

See more:

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

Posted 16-Oct-18 6:43am

Member 13396929

Updated 16-Oct-18 6:51am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2018-10-16T06:51:00

You can't.

ClosedXML doesn't deal with an interactive Excel instance. It simply reads and modifies the contents of the file. The user can't see or interact with the file you're manipulating.

And no, you can't use Office Interop to do that either. Your code is running on the server, so if you brought up an interactive Excel instance, the user would never see it.

Dave Kreskowiak · Answer 2 · 2018-10-16T06:52:00

Solution 2

When you working with the Excel sheet on the server, there is no such thing as the "active cell".

Since server-side code also has no way of interacting with an instance of Excel on the client.

Posted 16-Oct-18 6:52am

Dave Kreskowiak