We can currently WCF DataService which has specific interface. This service basically provides required data based on DataRequest object that is passed to service through. This service is already used by other .net front ends...
Now I want to expose this service in Excel; so that user can directly gets data through this service. I know i need to develop some sort of addin in excel. What are my options in terms of technology. This adding will be distributed to different business users where they install and include this addin in excel and query they data.
Thanks in advance
What are my options in terms of technology?
You have decided to use Excel Addin with C# to consume your WCF service. So that should be fine for development.
To distribute this addin to different users you should be able to use Click once deployment