Data Explorer Add-in enhances the self-service BI experience in Excel by simplifying data discovery and access to a broad range of public and enterprise data sources, enabling richer insights from data that has traditionally been difficult for users to get to.
Using this add-in we can get data from a wide variety of data sources like Sql Server, Files, Azure etc and analyze them in Excel. This add-in is really useful one and I found it very useful for many customers.
With Data Explorer, users can now quickly and easily import data from a variety of sources, including Web, Excel, Text, Database and Azure. Access to non-traditional sources such as Active Directory, Facebook and big data solutions like Hadoop are now within the reach of any user.
Connecting directly to data from the web is easy and intuitive. Filtering and transforming your data can be done in just a few clicks and importing your final data into Excel is straightforward. Given this is a preview, these features may appear differently in the future versions.
Here is the link to Download Data Explorer Add-in
Source: Office Blog
Do you want to develop an add-in targeting multiple versions of Office? And you have basic questions like “Is it possible to do? ” and “How to do it?” ? Then you came to the right place. Few months back, I got a requirement to developed add-ins for Outlook 2003 and Outlook 2007. The functionality for both the versions is same. A doubt stroked… when the functionality is same, why would I develop two add-ins separately? Why don’t I make a single build for both the versions of Office?
Then I started searching for techniques to develop add-ins which works in both (2003 and 2007) and read many articles written by VSTO Experts in their blogs, Official VSTO Blog, MSDN, Forums and what not.
Theoretically, you can develop an add-in for multiple versions of Microsoft Office by catering to the lowest common denominator. This means if you use an Excel 2003 add-in template in Visual Studio 2008, you would be able to develop and debug this with Excel 2007. However if you try this, you may meet these error messages: “You cannot debug or run this project, because the required version of the Microsoft Office application is not installed.”, followed by “Unable to start debugging.”
You can develop Office 2003 add-in in a system where Office 2007 is installed. The following is the procedure that demonstrates how to update your Visual Studio debugging options to use Microsoft Outlook 2007 to debug an add-in targeting Microsoft Outlook 2003.
- On the Project menu, click on ProjectName Properties
- Click on the Debug tab
- In the Start Action pane, click the Start external program radio button
- Click the file browser button and navigate to %ProgramFiles%Microsoft OfficeOffice12
- Choose Outlook.exe and click Open
- Press F5 to debug your add-in
For more details. Go through this article in Misha Shneerson’s Blog.
There are some tips and tricks to be followed and the things that one needs to take care while developing add-ins targeting multiple versions of Office in Andrew’s Blog. Have a look at this too. You might find it interesting and useful.
Here is an MSDN article on Running Solutions in Different Versions of Microsoft Office
Hope this helps!