Answer 1

Hi

Very less info

1) Have you installed an sample excel  plugin written by gautam (http://blogs.msdn.com/b/gautamg/archive/2010/01/05/3-introducing-sample-excel-extension.aspx)?

2) What office version does this excel sheet belong.

3) What is the stack trace from Event viewer?

Thanks

Siddhartha

Answer 2

1) The links to that sample excel  plugin at the top of the page are broken. The link at the bottom of the page never worked for me. I used this download http://code.msdn.microsoft.com/excelCUITechProv

2) I'm using Office Professional Plus 2010 

In this sample excel plugin the playback selects cell  B2 and types Hello World. The only way I can get this test  to pass is by setting the focus on the Cell B2 object.

So the test fails unless I add the following code:

uISheet122Cell.SetFocus();

Test method SampleTestProject.CodedUITest1.CodedUITestMethod1 threw exception: 

System.NullReferenceException: Object reference not set to an instance of an object.

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetPropertyValue(String propertyName)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetProperty(String propertyName)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetPropertyInternal[T](String propertyName)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.get_BoundingRectangle()

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.CaptureImage()

Microsoft.VisualStudio.TestTools.UITesting.Playback.CaptureScreenShot(UITestControl control)

Microsoft.VisualStudio.TestTools.UITesting.Playback.GetUITestControlString(UITestControl control)

Microsoft.VisualStudio.TestTools.UITesting.Playback.AddUITestControlDescriptionToException(SystemException exception, IPlaybackContext context)

Microsoft.VisualStudio.TestTools.UITesting.Playback.MapAndThrowException(SystemException exception, IPlaybackContext context)

Microsoft.VisualStudio.TestTools.UITesting.Playback.MapAndThrowException(SystemException exception, String actionName, UITestControl uiControl)

Microsoft.VisualStudio.TestTools.UITesting.Playback.MapAndThrowException(SystemException exception, String actionName, Object parameterValue, UITestControl uiControl)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetPropertyValue(String propertyName)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetProperty(String propertyName)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetPropertyInternal[T](String propertyName)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.get_Enabled()

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.GetEnabledWithoutWFR()

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.WaitForControlEnabled(Int32 millisecondsTimeout)

Microsoft.VisualStudio.TestTools.UITesting.UITestControl.SendKeys(String text, ModifierKeys modifierKeys, Boolean isEncoded, Boolean isUnicode)

Microsoft.VisualStudio.TestTools.UITesting.Keyboard.SendKeysImplementation(UITestControl control, String text, ModifierKeys modifierKeys, Boolean isEncoded, Boolean isUnicode)

Microsoft.VisualStudio.TestTools.UITesting.Keyboard.SendKeysImplementationWrapper(UITestControl control, String text, ModifierKeys modifierKeys, Boolean isEncoded, Boolean isUnicode)

Microsoft.VisualStudio.TestTools.UITesting.Keyboard.SendKeys(UITestControl control, String text, ModifierKeys modifierKeys)

SampleTestProject.UIMap.ClickB2andtypeHelloWorld() in C:\Users\seans\Documents\Visual Studio 2010\Projects\CodedUITestOfExcel\SampleTestProject\UIMap.Designer.cs: line 69

SampleTestProject.CodedUITest1.CodedUITestMethod1() in C:\Users\seans\Documents\Visual Studio 2010\Projects\CodedUITestOfExcel\SampleTestProject\CodedUITest1.cs: line 31

E, 312, 30, 2010/07/20, 10:08:08.978, 164781546449, QTAgent32.exe, GetClassName for handle 198634 failed
E, 312, 30, 2010/07/20, 10:08:08.979, 164781549998, QTAgent32.exe, GetClassName for handle 198634 failed
GetClassName for handle 198634 Writelineed
E, 312, 30, 2010/07/20, 10:08:08.986, 164781564642, QTAgent32.exe, GetClassName for handle 198634 failed
E, 312, 30, 2010/07/20, 10:08:08.996, 164781590159, QTAgent32.exe, GetClassName for handle 198634 failed
E, 312, 30, 2010/07/20, 10:08:09.043, 164781698709, QTAgent32.exe, Window 198634 not responding. Last Win32 error 2
E, 312, 30, 2010/07/20, 10:08:09.049, 164781712222, QTAgent32.exe, GetClassName for handle 198634 failed
E, 312, 30, 2010/07/20, 10:08:09.063, 164781745399, QTAgent32.exe, Window 198634 not responding. Last Win32 error 2
E, 312, 30, 2010/07/20, 10:08:09.063, 164781745895, QTAgent32.exe, GetClassName for handle 198634 failed
W, 312, 30, 2010/07/20, 10:08:09.877, 164783647934, QTAgent32.exe, IEDOM : StopSession of the plugin called before StartSession
W, 312, 30, 2010/07/20, 10:08:09.877, 164783648077, QTAgent32.exe, UIA : StopSession of the plugin called before StartSession

3) Event Viewer when uISheet122Cell() is commented out:

The test fails here

Answer 3

The test  that comes with the sample plug-in fails, but I can use the property  provider cross-hair to select  a cell  in an excel  worksheet. However, if I try to generated code for an assertion on a cell I get the following error dialog "Object reference not set to an instance of an object"

This now happens when I ever I try to record a test on excel.

Let me know what other information I can provide

Thanks for your help 

Answer 4

ExtensionFramework : Technology Manager with name Excel is not registered

That's the problem I'm having, how do I register the Technology manager? I have the appropriate dlls in the appropriate folders

Answer 5

Answer 6

Have you installed the Excel plugin properly? The extension  dll should be in Program Files (x86)\Common Files\microsoft shared\VSTT\10.0\UITestExtensionPackages for 64 bit OS and in C:\Program Files\Common Files\microsoft shared\VSTT\10.0\UITestExtensionPackages on 32 bit OS.

Thanks

Siddhartha

Answer 7

Yes it is.

Following is the error message:

Test method SampleTestProject.CodedUITest1.CodedUITestMethod1 threw exception: 
System.ArgumentException: The following is not a valid technology name: Excel. To search for a control, you must specify a valid technology name.
Parameter name: TechnologyName