Building a Real Time Data server: Embedding a GoogleMap page in an Excel Task Pane, part 9
This is part 9 of the tutorial that describes the techniques necessary to build an Excel RTD server. If you have just come to this page, I suggest you read all parts in order, here is Building a Real Time Data for Excel, part 1.
Today it is another short subject, but worthy of a few remarks.
The GoogleMaps taskpane is implemented in a separate project, hopefully re-usable.
The task pane is created in Geodesix.AddinModule #27#, which also contains the event handlers. Geodesix.AddinModule.Map is the task pane, and it contains an instance of the
GoogleMaps.GoogleMap user control, which in turn contains an Internet Explorer control.
The GoogleMap control exposes 3 public methods:
- ShowFlight #28#, which loads GoogleMaps.FlightPath.htm.
- ShowLocation #29#, which loads GoogleMaps.Geocoder.htm.
- ShowRoute #30#, which loads GoogleMaps.Directions.htm.
Each of these methods simply builds the appropriate URL for the IR control and navigates to it. The good part is that you can modify those HTM pages as you see fit if you want to change the display format. The bad part is that the javascript is not exactly trivial, but certainly a good exercise.
Building a Real Time Data for Excel tutorial:
- Building a Real Time Data for Excel server, part 1
- Building an Excel RTD: Avoiding VSTO, part 2
- Building an Excel RTD: How RTD servers work, part 3
- Building an Excel RTD: Architecture, part 4
- Building an Excel RTD: Excel, multithreading and callbacks, part 5
- Building an Excel RTD: Providing easy-to-read function names, part 6
- Building an Excel RTD: Talking to the GoogleMaps APIs, part 7
- Building an Excel RTD: Avoiding Application Domain misery, part 8
- Building an Excel RTD: Embedding a GoogleMap page in an Excel Task Pane, part 9
- Building an Excel RTD: Creating the Setup project, part 10