By embedding these maps into Excel using PyXLL<\/a>, you can deliver geospatial insights in a tool familiar to almost everyone\u2014no need for additional software installations.<\/p>\n\n\n\n To get started, you\u2019ll need:<\/p>\n\n\n\n I also recommend using a Python code editor such as VS Code to help write Python code, but any text editor will do.<\/p>\n\n\n\n Here\u2019s a simple Python script to generate a map using Folium. The code first loads a CSV file containing a value for the ecological footprint for each country, creates a map using data from geojson.xyz, adds a choropleth layer to the map, and finally saves the map as an html file.<\/p>\n\n\n The CSV file contains the information as it\u2019s\u00a0currently shown<\/a>\u00a0on Wikipedia, which is based on data gathered by\u00a0York University<\/a>, the\u00a0Footprint Data Foundation<\/a>, and the\u00a0Global Footprint Network<\/a>.<\/p>\n\n\n\n The output file shows the data from the CSV file as a map.<\/p>\n\n\n\n PyXLL makes it easy to embed HTML maps directly into Excel as web views or static images. To display your Folium map in Excel, follow these steps:<\/p>\n\n\n\n For the function that generates the map, instead of reading a CSV file we will pass in the data to the function. Since we’ll be calling this function from Excel that makes it much more flexible as the user of the function can pass in data directly from the Excel worksheet.<\/p>\n\n\n The code is the same as in the previous section, but instead of loading the data from a CSV file it now takes it as a pandas DataFrame argument. <\/p>\n\n\n\n The columns in the DataFrame containing the country names and the value we want to plot are also passed as arguments, allowing us to use the same function for different data sets more easily.<\/p>\n\n\n\n The function is decorated with the “@xl_func” decorator from the pyxll package. This tells the PyXLL add-in this function should be exposed to Excel and be callable as a worksheet function.<\/p>\n\n\n\n Rather than saving the map as an HTML file we use the “pyxll.plot” function to display the plot in Excel. However, as our code is written now this will not work as PyXLL won’t recognize the “folium.Map” object that we are passing to pyxll.plot.<\/p>\n\n\n\n In order for PyXLL to understand how to display a folium map we need to write what PyXLL calls a “plotting bridge”. This might sound complicated, but really it’s quite simple. The bridge class simply takes the object being plotted and provides a way of converting that to another format. In our case we can convert it to HTML using the “save” method we saw earlier.<\/p>\n\n\n The bridge class is registered using the “@xl_plot_bridge” decorator, and now any time we call “pyxll.plot” with a folium Map object this bridge class will be used to handle exporting it as html.<\/p>\n\n\n\n This code needs to be added to the list of modules imported by PyXLL by adding it to the “modules” setting in the pyxll.cfg file. It can in the same module as the “plot_choropleth” function written above, but I prefer to keep it in a separate module since it can be used by any functions using folium.<\/p>\n\n\n\n Now we have everything we need to test out our function in Excel!<\/p>\n\n\n\n If you’ve been following along, don’t forget to save your Python module (or modules) and add them to the “modules” setting in your pyxl.cfg file. You might also need to add the folder where you’ve saved your modules to the “pythonpath” setting.<\/p>\n\n\n\n With PyXLL configured to load our code, either start Excel or if you already have Excel running, select “Reload” from the PyXLL menu. Now you should have a new function “plot_choropleth” available to you as a worksheet function!<\/p>\n\n\n\n To call the function enter it into a cell in the worksheet, passing in the range of data as the first argument, the column header for the countries in the second, and the column header for the ecological footprint in the third.<\/p>\n\n\n\n The map is added to the Excel worksheet just below the function. It’s a fully interactive html map, not just a static image! I’ve added a little more formatting to the function, but this is still a fairly simple example of what you can do using folium in Excel.<\/p>\n\n\n\n All of the code used in this blog post, along with the spreadsheet, is available for you to download.<\/p>\n\n\n\n Once you\u2019ve mastered the basics, you can:<\/p>\n\n\n\n Integrating Folium maps into Excel with PyXLL transforms how you visualize and interact with geospatial data. Whether you\u2019re mapping customer locations, analyzing environmental data, or presenting demographic trends, this powerful combination unlocks new possibilities.<\/p>\n\n\n\n With just a few lines of Python and the power of PyXLL, your Excel spreadsheets can become dynamic geospatial visualization tools.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel is an incredibly versatile tool, but its built-in charting options are limited when it comes to geospatial data visualization. Thankfully, with Python, you can tap into powerful libraries like Folium to create interactive geospatial plots in Excel. By integrating Python into Excel with PyXLL, you can seamlessly bring these visualizations into your spreadsheets. In<\/p>\n","protected":false},"author":1,"featured_media":1873,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[12,2,504,272],"tags":[6,663,664,666,665,3,8],"class_list":["post-1861","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python","category-pyxll","category-user-interface","category-visualization","tag-excel","tag-folium","tag-geospatial","tag-maps","tag-plotting","tag-python","tag-pyxll"],"acf":[],"jetpack_featured_media_url":"https:\/\/www.pyxll.com\/blog\/wp-content\/uploads\/2024\/11\/folium.gif","jetpack_shortlink":"https:\/\/wp.me\/p7l3LP-u1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts\/1861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/comments?post=1861"}],"version-history":[{"count":1,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts\/1861\/revisions"}],"predecessor-version":[{"id":1880,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts\/1861\/revisions\/1880"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/media\/1873"}],"wp:attachment":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/media?parent=1861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/categories?post=1861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/tags?post=1861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Setting Up Your Environment<\/h2>\n\n\n\n
\n
\n
folium<\/code><\/li>\n\n\n\npandas<\/code> (for handling geospatial data)<\/li>\n\n\n\npyxll<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n
PyXLL lets you call Python functions directly from Excel and return results, including images, charts, or even interactive HTML content.
See https:\/\/www.pyxll.com\/docs\/userguide\/installation\/firsttime.html<\/a> for details of how to install PyXLL.<\/li>\n<\/ol>\n\n\n\nStep 1: Create a Basic Folium Map<\/h2>\n\n\n\n
\nimport folium\nimport pandas as pd\n\neco_footprints = pd.read_csv("footprint.csv")\n\npolitical_countries_url = (\n "http:\/\/geojson.xyz\/naturalearth-3.3.0\/ne_50m_admin_0_countries.geojson"\n)\n\nm = folium.Map(location=(30, 10), zoom_start=3, tiles="cartodb positron")\nfolium.GeoJson(political_countries_url).add_to(m)\n\nfolium.Choropleth(\n geo_data=political_countries_url,\n data=eco_footprints,\n columns=["Country\/region", "Ecological footprint"],\n key_on="feature.properties.name",\n).add_to(m)\n\nm.save("footprint.html")\n<\/pre><\/div>\n\n\n![\"\"](\"https:\/\/www.pyxll.com\/blog\/wp-content\/uploads\/2024\/11\/image-1024x632.png\")
<\/a><\/figure>\n\n\n\nStep 2: Embed the Map in Excel with PyXLL<\/h2>\n\n\n\n
\n
\nfrom pyxll import xl_func, plot\nimport folium\nimport pandas as pd\n\n\n@xl_func\ndef plot_choropleth(data: pd.DataFrame,\n countries_column: str,\n values_column: str):\n\n political_countries_url = (\n "http:\/\/geojson.xyz\/naturalearth-3.3.0\/ne_50m_admin_0_countries.geojson"\n )\n\n m = folium.Map(location=(30, 10), zoom_start=3, tiles="cartodb positron")\n folium.GeoJson(political_countries_url).add_to(m)\n\n folium.Choropleth(\n geo_data=political_countries_url,\n data=data,\n columns=[countries_column, values_column],\n key_on="feature.properties.name",\n ).add_to(m)\n\n plot(m)\n\n return m\n<\/pre><\/div>\n\n\n
Bridging PyXLL and Folium<\/h4>\n\n\n\n
\nfrom pyxll import xl_plot_bridge, PlotBridgeBase\n\n# To display a plot of type 'folium.folium.Map' we need a custom bridge\n# that handles exporting the map to an html file\n@xl_plot_bridge("folium.folium.Map")\nclass FoliumBridge(PlotBridgeBase):\n\n def __init__(self, map):\n self.__map = map\n\n # PyXLL can use various different formats, but we are only interested in html\n def can_export(self, format):\n return format == "html"\n\n # PyXLL will call this to export the map object as an html file\n def export(self, width, height, dpi, format, filename, **kwargs):\n self.__map.save(filename)\n<\/pre><\/div>\n\n\nCalling the function and plotting our map in Excel<\/h4>\n\n\n\n
![\"\"](\"https:\/\/www.pyxll.com\/blog\/wp-content\/uploads\/2024\/11\/image-1-1024x638.png\")
<\/a><\/figure>\n\n\n\nEnhancing the Workflow<\/h2>\n\n\n\n
\n
Conclusion<\/h2>\n\n\n\n