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: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

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

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: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

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

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
You do not have the required permissions to view the files attached to this post.

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

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

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