Databases
StackOverflow2013
Postsdbo
POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
    primarykey
    data
    text
    <p>I want to mock the Microsoft.Office.Interop.Excel.Range (and the other Microsoft.Office.Interop.Excel interfaces) to unit test my application. I'm using Moq 4.0.10827 with .NET 4 in C#.</p> <p>In my unit test, I attempt to set up the behavior of the mock as follows:</p> <pre><code> var range = new Mock&lt;Microsoft.Office.Interop.Excel.Range&gt;(); range.Setup(r =&gt; r.get_Value(1)).Returns("Something"); var classBeingTested = new MyClass(range.Object); </code></pre> <p>In the code being unit tested, I'm using the Range as follows:</p> <pre><code> public MyClass(Range range) { var value = range[1].ToString(); } </code></pre> <p>When the test runs, it produces the following exception:</p> <pre><code> Error: Missing method 'instance object [My.Example.Implementation.MyClass] Microsoft.Office.Interop.Excel.Range::get__Default(object,object)' from class 'Castle.Proxies.RangeProxy'. </code></pre> <p>How can I implement this mocking successfully? I realize that isolating the Excel Interop functionality with a pattern such as <a href="https://stackoverflow.com/a/9486226/1548950">https://stackoverflow.com/a/9486226/1548950</a> is a potential solution; however, I'd be happier with being able to create mocks from the Microsoft.Office.Interop.Excel interfaces.</p> <p><strong>EDIT: More details on this issue</strong></p> <p>OK, this is strange. I've created a project to test the suggestion by jimmy_keen. It works. However, when I use the same suggestion to test the project I had issues with, it throws the following exception:</p> <pre><code>Error: Missing method 'instance object [My.Example.Implementation.MyClass] Microsoft.Office.Interop.Excel.Range::get__Default(object,object)' from class 'Castle.Proxies.RangeProxy'. </code></pre> <p>Since jimmy_keen's suggestion worked fine on other projects, I started suspecting that there is something wrong with the project I'm testing the code with. So, I created a test solution that demonstrates the problem in detail: <a href="http://www7.zippyshare.com/v/70834394/file.html" rel="nofollow noreferrer">http://www7.zippyshare.com/v/70834394/file.html</a></p> <p>The root of the problem seems to be that the project contains another class (that is not being unit tested) with essentially the following code:</p> <pre><code>using Microsoft.Office.Interop.Excel; namespace Project { public class UnTestedClass { public UnTestedClass(Worksheet sheet) { var foo = sheet.Range["Description"].Column; } } } </code></pre> <p>I don't understand why this causes the issue, because I'm not using UnTestedClass in the unit test at all. Am I missing something in how I should use Moq, or have I stumbled upon a bug?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USLauri Harpf
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
      1. USAphelion
      1. VTFavorite
    1. CO+1 This is strange, I'm guessing it has something to do with COM objects. As soon as I reference the excel interop, I can no longer reference my Moq library... Weird...
      singulars
      1. POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
      1. USjsmith
    2. COAfter some work on this, I'm now moving towards isolating the Microsoft.Office.Interop.Excel functionality with my own custom classes & interfaces instead of mocking Microsoft.Office.Interop.Excel.* directly. While the answer to this question does solve the immediate issues, mocking Microsoft.Office.Interop.Excel.* ultimately just begun to require too much setup work to make it useful.
      singulars
      1. POHow to mock Microsoft.Office.Interop.Excel.Range with Moq?
      1. USLauri Harpf
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload