blocks|key|2317703|text|我使用Topo.ly。您只需将所有邮政编码从Excel复制并粘贴到Topo.ly中，它就会在Google+Maps上绘制它们。它还托管您的地图，因此您可以将其保存并在以后返回，或与其他人共享。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2317704|entityMap|0|LINK|mutability|MUTABLE|url|http://topo.ly/^0|3|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I use <a href="http://topo.ly" rel="nofollow">Topo.ly</a>. You can just copy all your post codes from Excel and paste them in Topo.ly, and it will plot them on Google Maps. It also hosts your maps, so you can save it and come back to it later, or share it with others.

blocks|key|2317691|text|您可以看看针对非gis用户的解决方案：http://www.esri.com/software/esri-maps-for-office|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2317692|它需要Office2010(在你的情况下没有问题)，并且它基于privative地理信息系统软件(没有FLOSS)。在视频部分有一些例子。|style|BOLD|2317693|entityMap|0|LINK|mutability|MUTABLE|url|http://www.esri.com/software/esri-maps-for-office^0|J|1D|0|0|V|9|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@$A|U|B|V|F|G]]|9|@]|C|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

You can take a look to that solution for non-gis-users: 
<a href="http://www.esri.com/software/esri-maps-for-office" rel="nofollow">http://www.esri.com/software/esri-maps-for-office</a>

It requires Office 2010 (that's no problem in your case) and it is based on a privative GIS software (no FLOSS). On the videos section there are some examples.

blocks|key|2317671|text|这可能是一个很好的起点。您将需要一些WPF的知识|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2317672|Bing+Maps+Windows+Presentation+Foundation+(WPF)+Control,+Version+1.0|offset|length|2317673|然后使用VSTO将其集成到Excel+Using+WPF+Controls+in+Office+Solutions中|2317674|示例WPF应用程序是@+Integrating+Bing+Maps+With+WPF|2317675|编辑：|style|BOLD|2317676|我没有找到很多关于非WPF的解决方案，但是你可以试一试|2317677|Integrating+Virtual+Earth+Maps+and+Excel+2007+Using+Visual+Studio+2005+Tools+for+Office+Second+Edition|2317678|在此处下载http://archive.msdn.microsoft.com/VSTOVirtualEarthXL|2317679|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=27165|1|http://msdn.microsoft.com/en-us/library/bb772076.aspx|2|http://visualstudiomagazine.com/Articles/2012/04/01/Map-Your-Apps.aspx?Page=1|3|http://msdn.microsoft.com/en-us/library/cc531008.aspx|4|http://archive.msdn.microsoft.com/VSTOVirtualEarthXL^0|0|0|1W|0|0|J|12|1|0|C|U|2|0|0|2|0|0|0|2U|3|0|5|1G|4|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|F|3|G|5|6|7|1E|8|@]|9|@$D|1F|E|1G|1|1H]]|A|$]]|$1|H|3|I|5|6|7|1I|8|@]|9|@$D|1J|E|1K|1|1L]]|A|$]]|$1|J|3|K|5|6|7|1M|8|@$D|1N|E|1O|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1P|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1Q|8|@]|9|@$D|1R|E|1S|1|1T]]|A|$]]|$1|R|3|S|5|6|7|1U|8|@]|9|@$D|1V|E|1W|1|1X]]|A|$]]|$1|T|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10]]|11|$5|W|X|Y|A|$Z|12]]|13|$5|W|X|Y|A|$Z|14]]|15|$5|W|X|Y|A|$Z|16]]|17|$5|W|X|Y|A|$Z|18]]]]

This can be a good starting point. You will need some knowledge of WPF
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=27165" rel="nofollow noreferrer">Bing Maps Windows Presentation Foundation (WPF) Control, Version 1.0</a>
Then using VSTO you can integrate it into Excel
<a href="http://msdn.microsoft.com/en-us/library/bb772076.aspx" rel="nofollow noreferrer">Using WPF Controls in Office Solutions</a>
Sample WPF application is @ <a href="http://visualstudiomagazine.com/Articles/2012/04/01/Map-Your-Apps.aspx?Page=1" rel="nofollow noreferrer">Integrating Bing Maps With WPF</a>
Edit :
Didnt find much on non WPF solution but you can give this a try
<a href="http://msdn.microsoft.com/en-us/library/cc531008.aspx" rel="nofollow noreferrer">Integrating Virtual Earth Maps and Excel 2007 Using Visual Studio 2005 Tools for Office Second Edition</a>
Download here <a href="http://archive.msdn.microsoft.com/VSTOVirtualEarthXL" rel="nofollow noreferrer">http://archive.msdn.microsoft.com/VSTOVirtualEarthXL</a>

blocks|key|2317825|text|对于将来的参考或有类似问题的人，您可以使用名为Funfun的Excel插件在Excel+2016中创建数据地图。我在这里举了两个例子。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2317826|​|2317827|📷|atomic|offset|length|2317828|2317829|2317830|2317831|2317832|如您所见，在屏幕截图的中间部分有一些代码。这是因为Funfun允许您直接在Excel中编写和运行JavaScript代码，而且，JavaScript代码可以使用存储在工作表中的数据。使用JavaScript的能力意味着你可以使用像HighCharts.js或D3.js这样的第三方库来绘制像数据地图一样的图表。在这两个示例中，我实际上使用了HighCharts.js库中的highmaps。highmaps.js已经有了不同的模板，从世界地图到不同国家的特定地图。我相信你能找到你需要的地图。|2317833|Funfun还有一个在线编辑器，您可以在其中使用数据测试您的JavaScript代码。你可以在下面的链接上查看上面例子的详细代码。|2317834|https://www.funfun.io/1/#/edit/5a5c9a50404f66229bda3ae0|2317835|https://www.funfun.io/1/#/edit/5925036104ce702ccfb22b0e|2317836|如果您对在在线编辑器中获得的结果感到满意，可以使用上面的URL轻松地将结果加载到Excel中。当然，首先你需要从Insert+-+My+add-ins中插入有趣的插件。以下是一些屏幕截图，展示了如何做到这一点。|style|BOLD|2317837|2317838|2317839|2317840|2317841|2317842|2317843|披露:我是Funfun的开发者|2317844|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/524a85ebaa52d9ef0b22b9c00eb03b64.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/0b45e7351aab6d6d15ef1f02fc83918e.png|2|LINK|MUTABLE|url|3|4|https://ask.qcloudimg.com/http-save/yehe-900000/38dbbff7ed3b115f94aae0911d087105.png|5|https://ask.qcloudimg.com/http-save/yehe-900000/8a3d497ab1243a9c1ee4c9ea186020f6.png^0|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|0|1J|2|0|0|1J|3|0|1K|J|0|0|0|1|4|0|0|0|0|1|5|0|0|0|B|0^^$0|@$1|2|3|4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1S|8|@]|9|@$G|1T|H|1U|1|1V]]|A|$]]|$1|I|3|C|5|6|7|1W|8|@]|9|@]|A|$]]|$1|J|3|C|5|6|7|1X|8|@]|9|@]|A|$]]|$1|K|3|E|5|F|7|1Y|8|@]|9|@$G|1Z|H|20|1|21]]|A|$]]|$1|L|3|C|5|6|7|22|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|23|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|24|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|25|8|@]|9|@$G|26|H|27|1|28]]|A|$]]|$1|S|3|T|5|6|7|29|8|@]|9|@$G|2A|H|2B|1|2C]]|A|$]]|$1|U|3|V|5|6|7|2D|8|@$G|2E|H|2F|W|X]]|9|@]|A|$]]|$1|Y|3|C|5|6|7|2G|8|@]|9|@]|A|$]]|$1|Z|3|E|5|F|7|2H|8|@]|9|@$G|2I|H|2J|1|2K]]|A|$]]|$1|10|3|C|5|6|7|2L|8|@]|9|@]|A|$]]|$1|11|3|C|5|6|7|2M|8|@]|9|@]|A|$]]|$1|12|3|E|5|F|7|2N|8|@]|9|@$G|2O|H|2P|1|2Q]]|A|$]]|$1|13|3|C|5|6|7|2R|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|2S|8|@$G|2T|H|2U|W|X]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|2V|8|@]|9|@]|A|$]]]|17|$18|$5|19|1A|1B|A|$1C|1D|1E|-4]]|1F|$5|19|1A|1B|A|$1C|1G|1E|-4]]|1H|$5|1I|1A|1J|A|$1K|R]]|1L|$5|1I|1A|1J|A|$1K|T]]|1M|$5|19|1A|1B|A|$1C|1N|1E|-4]]|1O|$5|19|1A|1B|A|$1C|1P|1E|-4]]]]

For future reference or someone who has similar porblem, you can use an Excel add-in called Funfun to create data map in Excel 2016. I made two examples here.

<a href="https://i.stack.imgur.com/BWaFI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BWaFI.png" alt="enter image description here"></a>

<a href="https://i.stack.imgur.com/HHlS7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HHlS7.png" alt="enter image description here"></a>

As you could see, there is some code in the middle section of the screenshot. That is because Funfun allows you to write and run JavaScript code directly in Excel, also, the JavaScript code could use the data stored in the sheet. The capability of using JavaScript means that you could use 3rd party libraries like HighCharts.js or D3.js to plot charts like data map. In those two examples, I actually used highmaps which is part of the HighCharts.js library. The highmaps.js already has different templates from world map to specific map of different countries. I believe you could find the map you need.

Funfun also has an online editor in which you could test your JavaScript code with you data. You could check the detailed code of the examples above on the link below. 

<a href="https://www.funfun.io/1/#/edit/5a5c9a50404f66229bda3ae0" rel="nofollow noreferrer">https://www.funfun.io/1/#/edit/5a5c9a50404f66229bda3ae0</a>

<a href="https://www.funfun.io/1/#/edit/5925036104ce702ccfb22b0e" rel="nofollow noreferrer">https://www.funfun.io/1/#/edit/5925036104ce702ccfb22b0e</a>

If you are satisfied with the result you achieved in the online editor, you could easily load the result into you Excel using the URL above. Of couse first you need to insert the Funfun add-in from Insert - My add-ins. Here are some screenshots showing how you could do this. 

<a href="https://i.stack.imgur.com/xXRWk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xXRWk.png" alt="enter image description here"></a>

<a href="https://i.stack.imgur.com/DS7Kh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DS7Kh.png" alt="enter image description here"></a>

Disclosure: I'm a developer of Funfun

I have postcode level data in an Excel workbook and ideally I would like to have a map on another sheet of the area that I am interested in. The postcodes in my dataset should be highlighted within that map. I am using Excel 2010 and have no prior experience with GIS but plenty of experience with C#, Java. Any ideas of how I can achieve this? I looked for open source add-ins and didn't find an awful lot. Is there another way I can achieve what I want?

Visualise map data in Excel

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我在Excel工作簿中有邮政编码级别的数据，理想情况下，我希望在我感兴趣的区域的另一个工作表上有一张地图。我的数据集中的邮政编码应该在该地图中突出显示。我使用Excel2010，以前没有地理信息系统的经验，但有丰富的C#，Java经验。有什么想法可以让我做到这一点吗？我寻找开源插件，但没有找到太多。有没有其他方法可以实现我想要的东西？

问在Excel中可视化地图数据
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Excel中可视化地图数据EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Excel中可视化地图数据
EN