18: Bing map Excel INS in Microsoft Office Excel

 

Part 1 ArticleOne advantage of Microsoft products is that they can inherit from each other to develop applications. This article introduces how to use virtual Earth with Microsoft Office Excel. You can customize an Excel plug-in. When you open an Excel file, you can display a map and other information on the map. Does it sound cool? First, describe the Application Scenario. Suppose we have a set of sales data, sales personnel information, and store data. How can we open and display the data in Excel, in addition, sales data is displayed by sales personnel on the map, sales data is displayed by region, and all store locations and sales information are displayed on the map. I will not elaborate on the development process of this application for the moment. Please refer to the following article. Part I: http://msdn.microsoft.com/en-us/library/cc531008.aspx. This section describes how to use Visual Studio 2005 (version 2 with the Office 2007 development interface) and Virtual Earth map controls to develop business intelligence analysis applications. Part II: http://msdn.microsoft.com/en-us/library/cc313157.aspx. This section describes how to automatically add data to an Office EXCEL 2007 worksheet, display data through a map, and output a table chart. Source codeAddress: http://code.msdn.microsoft.com/vstovirtualearthxl. You can also download: workshop from my skydrive: