I would like to create my own data connection (library) to use within Excel 2007.
Unfortunately I wasn't able to find any samples or hints on the web..
Can anyone help?
Thanks a lot in advance,
Patrick
Can you please clarify what do you mean by the custom data connection?
Svetlana Loksh
Hi fdsfdsfds,
We haven't heard from you since 10/13/2006. Does the reply above solve your problem? If it doesn't, please reply to this thread. Otherwise, we'll close this in a couple of days.
Ian
I have a similar question.
My scenario is that I cannot get the data I want to display in Excel using the standard data connections available by default (e.g. connection to DB, connection to Analysis cube etc). I might invoke some libraries (to return ADO.Net DataSets or Business Entities - C# objects), or I might invoke some web service operation (to return some xml message) to retrieve the data I would like to display in the Excel grid.
For such scenarios, what is the solution?
My guess is that the first post was trying to ask if Excel 2007 provides extensibility so that we can develop custom data connections (e.g. Connection to Web Service operation). A parallel analogy will be support for custom connection managers, custom log providers, custom tasks etc in SQL Server Integration Service 2005.
Thanks,
nitesh dot ambastha at credit-suisse dot com
Nitesh,
Here is the documentation you need:
http://msdn.microsoft.com/office/program/excel/2003/reference/article/
http://msdn.microsoft.com/office/program/excel
It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as yours. I have provided a couple of links that will help you.
Best,
John.
