# Python in Excel **URL:** https://forum.anaconda.com/c/python-in-excel/45.md [Latest](https://forum.anaconda.com/latest.md) · [Categories](https://forum.anaconda.com/categories.md) · [Tags](https://forum.anaconda.com/tags.md) --- ## [About the Python in Excel category](https://forum.anaconda.com/t/about-the-python-in-excel-category/59864)
**Author:** [@JessHaberman](https://forum.anaconda.com/u/JessHaberman)\ **Replies:** 10\ **Last updated:** [March 28, 2026, 3:07pm UTC](https://forum.anaconda.com/t/about-the-python-in-excel-category/59864 "2026-03-28T15:07:41Z")
Ask questions, troubleshoot issues, and learn from professionals about using Python in Excel, Anaconda Toolbox and Anaconda Code, all currently in public beta. We have exciting plans already underway to steadily build on… --- ## [Excel Toolbox problems](https://forum.anaconda.com/t/excel-toolbox-problems/108895)
**Author:** [@Rachel11](https://forum.anaconda.com/u/Rachel11)\ **Replies:** 2\ **Last updated:** [August 28, 2026, 2:18pm UTC](https://forum.anaconda.com/t/excel-toolbox-problems/108895 "2026-08-28T14:18:48Z")
When you go under Excel Toolbox, it doesn’t list the United States, and it won’t let you pick the country. Does anybody know why? --- ## [Anaconda Code doesn't install SimPy](https://forum.anaconda.com/t/anaconda-code-doesnt-install-simpy/108536)
**Author:** [@Michael45](https://forum.anaconda.com/u/Michael45)\ **Replies:** 1\ **Last updated:** [April 27, 2026, 10:04pm UTC](https://forum.anaconda.com/t/anaconda-code-doesnt-install-simpy/108536 "2026-04-27T22:04:19Z")
In Anaconda Code for Excel (Pyodide 0.27.2), adding simpy 4.1.1 from PyPI shows the package in Environment as Ready. Debugger/network confirms successful requests for: Links for simpy simpy-4.1.1-py3-none-any.whl.meta… --- ## [Greenlet module in Anaconda Code?](https://forum.anaconda.com/t/greenlet-module-in-anaconda-code/80780)
**Author:** [@Ruud](https://forum.anaconda.com/u/Ruud)\ **Replies:** 4\ **Last updated:** [February 4, 2026, 4:00pm UTC](https://forum.anaconda.com/t/greenlet-module-in-anaconda-code/80780 "2026-02-04T16:00:11Z")
I am trying to install the greenlet module in Anaconda Code, but it doesn’t show. I guess that this is because it’s not a Pure Python package. Would it be possible to make this very useful module available? --- ## [R issues in Excel Anaconda Toolbox](https://forum.anaconda.com/t/r-issues-in-excel-anaconda-toolbox/107878)
**Author:** [@Ian5](https://forum.anaconda.com/u/Ian5)\ **Replies:** 1\ **Last updated:** [December 1, 2025, 2:48pm UTC](https://forum.anaconda.com/t/r-issues-in-excel-anaconda-toolbox/107878 "2025-12-01T14:48:00Z")
Thank you for integrating R in Anaconda Toolbox! I am playing around with the functionality and trying to build a model using the fable package (also tried tseries and forecast packages). With the fable package, I get “e… --- ## [How to use an "Anaconda Code Object" dataset in Anaconda Code](https://forum.anaconda.com/t/how-to-use-an-anaconda-code-object-dataset-in-anaconda-code/107969)
**Author:** [@Paul24](https://forum.anaconda.com/u/Paul24)\ **Replies:** 2\ **Last updated:** [December 1, 2025, 2:40pm UTC](https://forum.anaconda.com/t/how-to-use-an-anaconda-code-object-dataset-in-anaconda-code/107969 "2025-12-01T14:40:05Z")
Hi, I am using Anaconda Toolbox/Code in Excel 2024 with a perpetual license (hence no Microsoft Python =PY). I have successfully uploaded a small (10,000 row) dataset to the Anaconda Toolbox, and I now want to test usi… --- ## [Code editor showing blank in Anaconda Toolbox](https://forum.anaconda.com/t/code-editor-showing-blank-in-anaconda-toolbox/107497)
**Author:** [@nasrinbegump](https://forum.anaconda.com/u/nasrinbegump)\ **Replies:** 1\ **Last updated:** [October 15, 2025, 3:22pm UTC](https://forum.anaconda.com/t/code-editor-showing-blank-in-anaconda-toolbox/107497 "2025-10-15T15:22:46Z")
The Code editor in Anaconda Toolbox shows blank.Before i was able to run python codes in the editor. --- ## [Will the duckDB module be available in Python for Excel?](https://forum.anaconda.com/t/will-the-duckdb-module-be-available-in-python-for-excel/106777)
**Author:** [@Mehmet1](https://forum.anaconda.com/u/Mehmet1)\ **Replies:** 0\ **Last updated:** [September 27, 2025, 7:07pm UTC](https://forum.anaconda.com/t/will-the-duckdb-module-be-available-in-python-for-excel/106777 "2025-09-27T19:07:17Z")
Hello, Will the duckDB module be available in Python for Excel? Thank you in advance for your time. --- ## [Ask questions, troubleshoot issues, and learn from professionals about using Python in Excel, Anaconda Toolbox and Anaconda Code, all currently in public beta. We have exciting plans already underway to steadily build on and enhance Python in Excel conten](https://forum.anaconda.com/t/ask-questions-troubleshoot-issues-and-learn-from-professionals-about-using-python-in-excel-anaconda-toolbox-and-anaconda-code-all-currently-in-public-beta-we-have-exciting-plans-already-underway-to-steadily-build-on-and-enhance-python-in-excel-conten/106687)
**Author:** [@ayan](https://forum.anaconda.com/u/ayan)\ **Replies:** 0\ **Last updated:** [September 21, 2025, 4:57am UTC](https://forum.anaconda.com/t/ask-questions-troubleshoot-issues-and-learn-from-professionals-about-using-python-in-excel-anaconda-toolbox-and-anaconda-code-all-currently-in-public-beta-we-have-exciting-plans-already-underway-to-steadily-build-on-and-enhance-python-in-excel-conten/106687 "2025-09-21T04:57:36Z")
what about how can we make another anaconda and peoples can’t download it free it will cost them money and we will get money per day --- ## [Help for Data Science](https://forum.anaconda.com/t/help-for-data-science/104646)
**Author:** [@Chris13](https://forum.anaconda.com/u/Chris13)\ **Replies:** 4\ **Last updated:** [August 21, 2025, 3:15pm UTC](https://forum.anaconda.com/t/help-for-data-science/104646 "2025-08-21T15:15:24Z")
Hello, I would like to use Anaconda Toolbox for excel. However I don’t know the environment. How to start ? What’re the main packages for data sciences ? Thanks for your help. --- ## [How to save and implement this snippet in Anaconda Toolbox for excel?](https://forum.anaconda.com/t/how-to-save-and-implement-this-snippet-in-anaconda-toolbox-for-excel/105470)
**Author:** [@Chris13](https://forum.anaconda.com/u/Chris13)\ **Replies:** 0\ **Last updated:** [August 17, 2025, 9:23pm UTC](https://forum.anaconda.com/t/how-to-save-and-implement-this-snippet-in-anaconda-toolbox-for-excel/105470 "2025-08-17T21:23:06Z")
Hello, =\> how to save and implement this snippet in Anaconda Toolbox for excel ? Thanks --- ## [Request for links to (or creation of more tutorials) on how to use R in Anaconda Code for Excel](https://forum.anaconda.com/t/request-for-links-to-or-creation-of-more-tutorials-on-how-to-use-r-in-anaconda-code-for-excel/96455)
**Author:** [@Mike16](https://forum.anaconda.com/u/Mike16)\ **Replies:** 9\ **Last updated:** [August 13, 2025, 7:56pm UTC](https://forum.anaconda.com/t/request-for-links-to-or-creation-of-more-tutorials-on-how-to-use-r-in-anaconda-code-for-excel/96455 "2025-08-13T19:56:44Z")
Thanks, Anaconda Developers for adding R functionality into Online Excel with Anaconda R Code! I like the idea but haven’t got the hang of how to efficiently incorporate R code into an Excel workflow. It doesn’t seem li… --- ## [Unable to render plotnine graphic object (plotnine.ggplot)](https://forum.anaconda.com/t/unable-to-render-plotnine-graphic-object-plotnine-ggplot/96555)
**Author:** [@Andy6](https://forum.anaconda.com/u/Andy6)\ **Replies:** 2\ **Last updated:** [July 14, 2025, 8:00pm UTC](https://forum.anaconda.com/t/unable-to-render-plotnine-graphic-object-plotnine-ggplot/96555 "2025-07-14T20:00:06Z")
Hello all, I have been trying to use plotnine module to build a data info graph through Anaconda Code in Excel (desktop), but it doesn’t render in Excel. It just stays as a memory object (plotnine.ggplot) like this. W… --- ## [R Language in Anaconda Code](https://forum.anaconda.com/t/r-language-in-anaconda-code/96105)
**Author:** [@tmceachern](https://forum.anaconda.com/u/tmceachern)\ **Replies:** 0\ **Last updated:** [June 24, 2025, 3:29pm UTC](https://forum.anaconda.com/t/r-language-in-anaconda-code/96105 "2025-06-24T15:29:06Z")
We’re excited to announce that we have made some improvements to the capabilities of Anaconda Code with respect to the R language support. User-Defined Functions are now supported in R! You can now define functions … --- ## [Matplotlib Basemap](https://forum.anaconda.com/t/matplotlib-basemap/95967)
**Author:** [@Jon7](https://forum.anaconda.com/u/Jon7)\ **Replies:** 0\ **Last updated:** [June 18, 2025, 9:14am UTC](https://forum.anaconda.com/t/matplotlib-basemap/95967 "2025-06-18T09:14:43Z")
Is this available in Python in Excel? Would be great to be able to plot great circles between lat-longs on a simple map in Excel. --- ## [Unable to login](https://forum.anaconda.com/t/unable-to-login/95830)
**Author:** [@nasrinbegump](https://forum.anaconda.com/u/nasrinbegump)\ **Replies:** 2\ **Last updated:** [June 13, 2025, 6:38am UTC](https://forum.anaconda.com/t/unable-to-login/95830 "2025-06-13T06:38:09Z")
Login to Anaconda toolbox throws error. --- ## [Re-sizing images generated by Matplotlib](https://forum.anaconda.com/t/re-sizing-images-generated-by-matplotlib/95581)
**Author:** [@Jack10](https://forum.anaconda.com/u/Jack10)\ **Replies:** 2\ **Last updated:** [June 2, 2025, 4:53pm UTC](https://forum.anaconda.com/t/re-sizing-images-generated-by-matplotlib/95581 "2025-06-02T16:53:25Z")
I am using Matplotlib to generate a series of sub-plots within a figure. I would like the figure to re-size according to the number of sub-plots being added to the figure so that the printed image is not distorted, and a… --- ## [Remove Python (Show Card) Symbol from Excel Cell](https://forum.anaconda.com/t/remove-python-show-card-symbol-from-excel-cell/94999)
**Author:** [@Hector](https://forum.anaconda.com/u/Hector)\ **Replies:** 4\ **Last updated:** [May 13, 2025, 8:02pm UTC](https://forum.anaconda.com/t/remove-python-show-card-symbol-from-excel-cell/94999 "2025-05-13T20:02:19Z")
Remove Python (Show Card) Symbol from Excel Cell --- ## [Toby Murray introduction of self and catergories im interested in](https://forum.anaconda.com/t/toby-murray-introduction-of-self-and-catergories-im-interested-in/94886)
**Author:** [@tmurray39](https://forum.anaconda.com/u/tmurray39)\ **Replies:** 0\ **Last updated:** [May 7, 2025, 7:10pm UTC](https://forum.anaconda.com/t/toby-murray-introduction-of-self-and-catergories-im-interested-in/94886 "2025-05-07T19:10:40Z")
You’re a curious and persistent problem-solver, eager to master cybersecurity and ethical hacking. You balance impatience with determination, tackling technical challenges while exploring career paths in cybersecurity. A… --- ## [Data security when use python in excel](https://forum.anaconda.com/t/data-security-when-use-python-in-excel/94591)
**Author:** [@Shiming](https://forum.anaconda.com/u/Shiming)\ **Replies:** 1\ **Last updated:** [April 23, 2025, 3:26pm UTC](https://forum.anaconda.com/t/data-security-when-use-python-in-excel/94591 "2025-04-23T15:26:55Z")
How to protect my data when using Python in Excel to analysis and visualization, if those python code running in the cloud? --- ## [Anaconda Toolbox in excel runtime (v1.2.0 build 144) does not include the ssl module?](https://forum.anaconda.com/t/anaconda-toolbox-in-excel-runtime-v1-2-0-build-144-does-not-include-the-ssl-module/94391)
**Author:** [@Repop](https://forum.anaconda.com/u/Repop)\ **Replies:** 2\ **Last updated:** [April 16, 2025, 9:41am UTC](https://forum.anaconda.com/t/anaconda-toolbox-in-excel-runtime-v1-2-0-build-144-does-not-include-the-ssl-module/94391 "2025-04-16T09:41:24Z")
Hi there, When I use this code in the excel version: import ssl print(ssl.OPENSSL\_VERSION) It gives following error: Traceback (most recent call last): File “‘DATA’!B18”, line 1, in import ssl ModuleNotFoundError… --- ## [Plt.show() in Anaconda code](https://forum.anaconda.com/t/plt-show-in-anaconda-code/94198)
**Author:** [@Marc1](https://forum.anaconda.com/u/Marc1)\ **Replies:** 2\ **Last updated:** [April 9, 2025, 9:41am UTC](https://forum.anaconda.com/t/plt-show-in-anaconda-code/94198 "2025-04-09T09:41:24Z")
Hi ! I cannot visualize a graph in Excel with Anaconda code Here is my trial code: trial= pd.DataFrame({‘ym’: \[‘2024-01’, ‘2024-02’, ‘2024-03’\], ‘close’: \[150, 160, 155\] }) trial.plot(kind=‘line’, x=‘ym’, y=‘close’) … --- ## [yFinance Package](https://forum.anaconda.com/t/yfinance-package/93366)
**Author:** [@SKRR](https://forum.anaconda.com/u/SKRR)\ **Replies:** 4\ **Last updated:** [March 13, 2025, 8:46am UTC](https://forum.anaconda.com/t/yfinance-package/93366 "2025-03-13T08:46:15Z")
Hi, I am new to Python in Excel, but keen to know whether it is possible to use the python yFinance package within Excel either directly or using any of the addins? --- ## [Contour plot export to DXF file](https://forum.anaconda.com/t/contour-plot-export-to-dxf-file/93157)
**Author:** [@Adam5](https://forum.anaconda.com/u/Adam5)\ **Replies:** 2\ **Last updated:** [March 7, 2025, 9:56am UTC](https://forum.anaconda.com/t/contour-plot-export-to-dxf-file/93157 "2025-03-07T09:56:34Z")
Hello Everyone, Is there a way to export contour lines created using python in excel to a DXF file? Unfortunately ezdxf is not available yet. Cheers, Adam --- ## [Any way to install a stats package eg pinguoin or scikit-posthoc?](https://forum.anaconda.com/t/any-way-to-install-a-stats-package-eg-pinguoin-or-scikit-posthoc/74957)
**Author:** [@03.handler\_clatter](https://forum.anaconda.com/u/03.handler_clatter)\ **Replies:** 6\ **Last updated:** [March 7, 2025, 9:40am UTC](https://forum.anaconda.com/t/any-way-to-install-a-stats-package-eg-pinguoin-or-scikit-posthoc/74957 "2025-03-07T09:40:52Z")
Hi there, new to all this, but a key part of the workflow of our research is non-parametric post hoc analysis. Seems like there’s no way to do this in the pre-loaded packages on Python for excel. Can anyone think of a wo… --- ## [Data persistence between re-calculations](https://forum.anaconda.com/t/data-persistence-between-re-calculations/91633)
**Author:** [@MJC](https://forum.anaconda.com/u/MJC)\ **Replies:** 4\ **Last updated:** [January 25, 2025, 10:52am UTC](https://forum.anaconda.com/t/data-persistence-between-re-calculations/91633 "2025-01-25T10:52:17Z")
Hi there, I’m wondering if there is any way to maintain data persistence in either “Python in Excel” or Anaconda Code. To be clear, I don’t mean within the execution lifecycle (eg. instantiating “foo” in cell A1 and the… --- ## [Unable to load package: skfolio==0.7.0 from Pypi](https://forum.anaconda.com/t/unable-to-load-package-skfolio-0-7-0-from-pypi/91545)
**Author:** [@Bokamoso](https://forum.anaconda.com/u/Bokamoso)\ **Replies:** 1\ **Last updated:** [January 22, 2025, 3:59pm UTC](https://forum.anaconda.com/t/unable-to-load-package-skfolio-0-7-0-from-pypi/91545 "2025-01-22T15:59:48Z")
i am having difficulties loading up packages from Pypi on my environment. I have tried skfolio and riskfolio. I get this error message: Please try a different installation method, version, or package --- ## [\#VALUE! error for cells with a dict over a certain size](https://forum.anaconda.com/t/value-error-for-cells-with-a-dict-over-a-certain-size/91166)
**Author:** [@MJC](https://forum.anaconda.com/u/MJC)\ **Replies:** 12\ **Last updated:** [January 20, 2025, 7:22pm UTC](https://forum.anaconda.com/t/value-error-for-cells-with-a-dict-over-a-certain-size/91166 "2025-01-20T19:22:31Z")
I’m running into an error with =ANACONDA.CODE(“py”,…) that I’m not running into with =PY(). For example, this correctly return a python object “\ dict” in excel: =ANACONDA.CODE("py", "### Do Not Edit this formula dir… --- ## [Best practices for large, shared Python Datasets?](https://forum.anaconda.com/t/best-practices-for-large-shared-python-datasets/91352)
**Author:** [@MJC](https://forum.anaconda.com/u/MJC)\ **Replies:** 6\ **Last updated:** [January 15, 2025, 1:38pm UTC](https://forum.anaconda.com/t/best-practices-for-large-shared-python-datasets/91352 "2025-01-15T13:38:54Z")
I’m building a model that uses historical data that is then applied forward to future periods using monte carlo simulations - lets say for 3 future years worth of monthly data, based on ~8 years of historical data (organ… --- ## [Configuring excel and python](https://forum.anaconda.com/t/configuring-excel-and-python/91346)
**Author:** [@Hazim](https://forum.anaconda.com/u/Hazim)\ **Replies:** 1\ **Last updated:** [January 14, 2025, 3:08pm UTC](https://forum.anaconda.com/t/configuring-excel-and-python/91346 "2025-01-14T15:08:50Z")
python cant connect to xlwings. “Error: Error Kind: ModuleNotFoundError Error Details: Traceback (most recent call last): File “Imports and Definitions”, line 2, in import xlwings as xw ModuleNotFoundError: No mod… [Next page](https://forum.anaconda.com/c/python-in-excel/45.md?page=1)