Forum Discussion

RikuRiikonen's avatar
RikuRiikonen
Copper Contributor
Sep 27, 2024

Python in Excel for web

I have tried to find an answer that does Python in Excel work also in Excel for web with no luck. I have Python code which creates nice charts, but when data is changing Excel for web can't create a new Plot. I'm using "Display Plot over cells" feature, so it that a problem and is there other solution that I could have a Python code to generate chart and it would be updated also in Excel for web when data updates?

I'm using usually following imports depending my needs if it affects on situation .

import pandas as pd
import matplotlib.pyplot as plt
from wordcloud import WordCloud
from collections import Counter
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    RikuRiikonen 

    As of now, Python in Excel is primarily supported in the Excel desktop app for Windows (Excel 365). It does not currently work in Excel for the web or Excel Online. This is why you're encountering issues with Python-generated charts not updating or displaying properly in the Excel web version.

    For now, your Python-generated plots and charts will only update and work in the desktop version of Excel. To work with Excel for the web, you'll need to rely on native Excel charts or external Python automation that updates charts in the desktop version before uploading to the web.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

Resources