''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

Question

''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

Santosh Umarani 81

Hi,

While using the code :
Worksheet WSheet { get; }
WSheet.Range["A1", WSheet.Cells[content.GetLength(0), content.GetLength(1)]].Value = content;
This code is running perfectly fine in the machine where I am running the code.
But when I try to run this exe in another machine, I am getting the following exception:

Exception: Type='RuntimeBinderException'. Message=''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

at CallSite.Target(Closure , CallSite , Worksheet )
at System.Dynamic.UpdateDelegates.UpdateAndExecute1T0,TRet

Does usage of WSheet.Range dependent on the version of Office ? or any other such dependency is there ? How can I resolve this issue ?
Kindly waiting for your response.

Thanks,
Santosh

Santosh Umarani 81 Reputation points

2021-08-06T12:38:21.05+00:00

Thanks for response karenpayneoregon.

As I have to change the entire application which was running fine until now, if you can tell me the pre requisite or dependency to run the WSheet.Range , I will make the changes in new environment and will make the application to run.
Kindly waiting for your response.
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2021-08-06T13:06:15.81+00:00
I don't have a bulletproof solution to remedy this other than inspecting versions of Excel between computers.

This is the exact reason I moved away from Interop.Excel around ten years ago and moved to a commercial library Aspose.Cells then drop it for GemBox Excel library but would never recommend using either as they are expensive.

You might check the version using this code

public static string ExcelVersion() { Excel.Application application = new Excel.Application(); return application.Version; }

Example call using Version class

Version version = new Version(ExcelOperations.ExcelVersion()); Debug.WriteLine($"{version.Major}, {version.Minor}");
Santosh Umarani 81 Reputation points

2021-08-15T12:09:59.927+00:00

Thank you DanielZhang-MSFT and karenpayneoregon for the response.

I updated the Microsoft office version in the machine where I am running the application. Now in the path "C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\<version>" the dll "Microsoft.Office.Interop.Excel.dll" is present.
However, when I ran the application, I am still getting the error:

Exception: Type='RuntimeBinderException'. Message=''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

at CallSite.Target(Closure , CallSite , Worksheet )
at System.Dynamic.UpdateDelegates.UpdateAndExecute1[T0,TRet](CallSite site, T0 arg0)

Can you please let me know what else I am missing or need to update ?

Kindly waiting for your response.

Thanks,
Santosh
Daniel Zhang-MSFT 9,656 Reputation points

2021-08-16T02:08:19.427+00:00

Hi @Santosh Umarani ,
Have you checked my answer in detail? And please refer to the link provided.
Best Regards,
Daniel Zhang

2 answers

Your answer

Santosh Umarani 81 Reputation points

2021-08-06T12:38:21.05+00:00

Thanks for response karenpayneoregon.

As I have to change the entire application which was running fine until now, if you can tell me the pre requisite or dependency to run the WSheet.Range , I will make the changes in new environment and will make the application to run.
Kindly waiting for your response.
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2021-08-06T13:06:15.81+00:00

I don't have a bulletproof solution to remedy this other than inspecting versions of Excel between computers.

This is the exact reason I moved away from Interop.Excel around ten years ago and moved to a commercial library Aspose.Cells then drop it for GemBox Excel library but would never recommend using either as they are expensive.

You might check the version using this code

public static string ExcelVersion() { Excel.Application application = new Excel.Application(); return application.Version; }

Example call using Version class

Version version = new Version(ExcelOperations.ExcelVersion()); Debug.WriteLine($"{version.Major}, {version.Minor}");
Santosh Umarani 81 Reputation points

2021-08-15T12:09:59.927+00:00

Thank you DanielZhang-MSFT and karenpayneoregon for the response.

I updated the Microsoft office version in the machine where I am running the application. Now in the path "C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\<version>" the dll "Microsoft.Office.Interop.Excel.dll" is present.
However, when I ran the application, I am still getting the error:

Exception: Type='RuntimeBinderException'. Message=''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

at CallSite.Target(Closure , CallSite , Worksheet )
at System.Dynamic.UpdateDelegates.UpdateAndExecute1[T0,TRet](CallSite site, T0 arg0)

Can you please let me know what else I am missing or need to update ?

Kindly waiting for your response.

Thanks,
Santosh
Daniel Zhang-MSFT 9,656 Reputation points

2021-08-16T02:08:19.427+00:00

Hi @Santosh Umarani ,
Have you checked my answer in detail? And please refer to the link provided.
Best Regards,
Daniel Zhang

Answer 1

Daniel Zhang-MSFT 9,656

Hi SantoshUmarani-1390,
From this document, you can know that the Range property is for an application-level add-in.
And maybe you can try get_Range method that McLean Schofield has pointed in this thread.
Best Regards,
Daniel Zhang

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Karen Payne MVP 35,586 Volunteer Moderator

This is one reason not to use Interop.Excel as versions can cause issues such as your current issue. A better solution when working with .xlsx is to either use Open XML for Excel or a third party library such as SpreadSheetLight or EPPlus, both are free.

Some examples https://github.com/karenpayneoregon/ExcelUnleashed

Share via

''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

Exception: Type='RuntimeBinderException'. Message=''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

Exception: Type='RuntimeBinderException'. Message=''Microsoft.Office.Interop.Excel.Worksheet' does not contain a definition for 'Range''

2 answers

Your answer