none
Can I create Bing Map Office Maps control through Excel AddIn template of Visual Studio 21012 ? RRS feed

  • Question

  • I am creating an Excel AddIn using VSTO(VS 2012). 

    It is having Windows Form control with WPF map control inside. And I am syncing Map to Excel table to update latitude and longitude.

    Can I create Bing Map Office Apps control through Excel AddIn template of Visual Studio 21012 and manipulate it in dual sync mode(dragging pushpin in map will change lat/long values in excel cell)?

    Thanks,

    Animesh


    Friday, October 9, 2015 7:23 AM

Answers

  • >>>Can I create Bing Map Office Apps control through Excel AddIn template of Visual Studio 21012 and manipulate it in dual sync mode(dragging pushpin in map will change lat/long values in excel cell)?

    Could you let us know what Bing Map Office Apps control is? If I didn't misunderstand that it is Bing Maps app for Office.

    Bing Maps app for Office helps you use location data from a given column and plot it on a Bing Map. It also provides basic data visualization using your location data.
    Plot: Once you launch the app from insert->app, you will see a default map embedded into your Excel spreadsheet. You can select locations from a column and click on the pin icon at the top right to plot them. The header for the column must be selected and the locations should be continuous valued below the header.
    Data visualization: You can also select adjacent columns to the right of locations containing data that you want to visualize on the map. If cells from a single adjacent data column is selected, locations are plotted with different sized circles. If multiple data columns are selected, you have the option to either plot them as multiple circles or a pie chart. This can be controlled by clicking on settings icon on the top right.
    Map Controls: You can use the map controls displayed on the top left to pan in a direction or to zoom in/out. Alternatively you can also zoom the map using your mouse or touch. Map view can be changed from settings to either road or birds eye.

    The Excel object model doesn't provide anything for dealing with Office Apps unfortunately.
    So I think you are able to use Bing Maps app for Office to Present Data within Excel AddIn template of Visual Studio 21012, but not manipulate it in dual sync mode(dragging pushpin in map will change lat/long values in excel cell).

    • Proposed as answer by David_JunFeng Monday, October 19, 2015 2:08 PM
    • Marked as answer by Animesh.Dash Tuesday, October 20, 2015 6:10 AM
    Tuesday, October 13, 2015 9:57 AM