ExcelDataConnector missing in Core.Data

Class library usage, coding and language questions.
jlowder
Posts: 55
Joined: Wed Dec 30, 2009 2:56 pm

ExcelDataConnector missing in Core.Data

Post by jlowder » Mon Mar 12, 2012 11:02 pm

Hello,

I'm using version 3.2, importing Ranorex.Core.Data in my Visual Studio 2010 project and I notice that ExcelDataConnector is missing.

All documentation points to Ranorex.Core.Data for this class.

Has this functionality been removed?

Thanks,

Jason

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: ExcelDataConnector missing in Core.Data

Post by Support Team » Tue Mar 13, 2012 1:54 pm

Hello,
Has this functionality been removed?
No, but if you are using VS2010 you have to check if the appropriate .Net version is selected, so check in the properties window of your project if the .Net 4.0 extended one is selected, it won't work with the client profile as mentioned in the following link.

Regards,
Markus
Ranorex Support Team
.
Image

jlowder
Posts: 55
Joined: Wed Dec 30, 2009 2:56 pm

Re: ExcelDataConnector missing in Core.Data

Post by jlowder » Tue Mar 13, 2012 3:34 pm

Hello,

My Project is set to .NET Framework 4.

I opened up the Ranorex.Core.Data dll in the object browser and it doesn't exist in the list there. I see CsvDataConnector, SimpleDataConnector and SqlDataConnector but no ExcelDataConnector.

Would not having the extended package prevent me from seeing it in the object browser? I'll try installing it..

Thanks,

Jason

jlowder
Posts: 55
Joined: Wed Dec 30, 2009 2:56 pm

Re: ExcelDataConnector missing in Core.Data

Post by jlowder » Tue Mar 13, 2012 3:52 pm

It would appear that the .NET 4.0 Extended as you list it is just the .Net 4.0 framework, which I already have installed. So this doesn't appear to be the issue.

Jason

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: ExcelDataConnector missing in Core.Data

Post by Support Team » Wed Mar 14, 2012 1:16 pm

Hi,
jlowder wrote:It would appear that the .NET 4.0 Extended as you list it is just the .Net 4.0 framework, which I already have installed. So this doesn't appear to be the issue.
Is your project set to the .Net 4.0 Client or Extended Framework?
Would it be possible to post us a small solution, to check your issue?

Regards,
Peter
Ranorex Team
.
Image

jlowder
Posts: 55
Joined: Wed Dec 30, 2009 2:56 pm

Re: ExcelDataConnector missing in Core.Data

Post by jlowder » Wed Mar 14, 2012 3:37 pm

Hi Peter,

I'm set to .NET Framework 4.

The other 4.0 option is ".NET Framework 4 Client Profile".

When I clicked on install other frameworks from the list, the website it sent me to didn't say anything about "extended" frameworks.

I can see how having the proper .Net framework installed would be required for usage, but the object browser for Ranorex.Core.Data doesn't even show the Excel Class. Shouldn't it at least appear there even if it wouldn't be functional due to configuration issues? This is where the Ranorex documentation lists it as residing.

I've added screen shots of the object browser and my configuration properties in case it's not what I should be looking at..

Thanks,

Jason
Attachments
Ranorex.Core.JPG
Ranorex.Core.JPG (39.26 KiB) Viewed 1111 times
Framework.JPG
Project Properties
Framework.JPG (25.47 KiB) Viewed 1111 times

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: ExcelDataConnector missing in Core.Data

Post by Support Team » Wed Mar 14, 2012 5:10 pm

Hi,

Thank you for posting the screenshot. I think you have forgotten to add the following assembly "Ranorex.Plugin.Office". Inside this assembly the ExcelDataConnector is nested with the namespace "Ranorex.Core.Data". So please add this assembly and try i again.

Regards,
Peter
Ranorex Team
.
Image

jlowder
Posts: 55
Joined: Wed Dec 30, 2009 2:56 pm

Re: ExcelDataConnector missing in Core.Data

Post by jlowder » Wed Mar 14, 2012 6:23 pm

Hi Peter,

That did it. Thank you!

Jason