# Python in Excel **URL:** https://forum.anaconda.com/c/python-in-excel/45.md?page=1 [Latest](https://forum.anaconda.com/latest.md) · [Categories](https://forum.anaconda.com/categories.md) · [Tags](https://forum.anaconda.com/tags.md) **Page:** 2 --- ## ["link" parameter in the ANACONDA.CODE() function](https://forum.anaconda.com/t/link-parameter-in-the-anaconda-code-function/91201)
**Author:** [@MJC](https://forum.anaconda.com/u/MJC)\ **Replies:** 2\ **Last updated:** [January 9, 2025, 4:06pm UTC](https://forum.anaconda.com/t/link-parameter-in-the-anaconda-code-function/91201 "2025-01-09T16:06:05Z")
I can’t find any detailed documentation on the ANACONDA.CODE function. I can see through the IDE/GUI that cell references become parameters into the function after the “mode” parameter to be substituted into any “REF()” … --- ## [Using custom wheels from PyPI repository](https://forum.anaconda.com/t/using-custom-wheels-from-pypi-repository/87846)
**Author:** [@f.grutschus](https://forum.anaconda.com/u/f.grutschus)\ **Replies:** 6\ **Last updated:** [December 19, 2024, 1:15pm UTC](https://forum.anaconda.com/t/using-custom-wheels-from-pypi-repository/87846 "2024-12-19T13:15:07Z")
Hello, is it possible to install Python wheel packages from an internal PyPI repository in Anaconda Code? I keep getting this error, when adding the URL to the \*.whl file: An error occurred when loading package depend… --- ## [Date column with blanks not handled correctly](https://forum.anaconda.com/t/date-column-with-blanks-not-handled-correctly/88485)
**Author:** [@hennie](https://forum.anaconda.com/u/hennie)\ **Replies:** 3\ **Last updated:** [November 30, 2024, 4:03am UTC](https://forum.anaconda.com/t/date-column-with-blanks-not-handled-correctly/88485 "2024-11-30T04:03:17Z")
I have another pesky Date issue for you. I have an Excel table with date values, but some values are blank. When I read this data into a DataFrame, the blank rows are recorded as time, not datetime, so ultimately I end… --- ## [Bug in Anaconda Code for Excel 365?](https://forum.anaconda.com/t/bug-in-anaconda-code-for-excel-365/88592)
**Author:** [@Scoodood](https://forum.anaconda.com/u/Scoodood)\ **Replies:** 2\ **Last updated:** [November 28, 2024, 5:13pm UTC](https://forum.anaconda.com/t/bug-in-anaconda-code-for-excel-365/88592 "2024-11-28T17:13:32Z")
I am running Excel 365 (installed locally) on Win11 Pro. I have created the following UDF with Anaconda Code and compare its output with Excel’s built-in formula With Excel formula =NORM.S.DIST(1, TRUE) 0.84134475 Wit… --- ## [Using image located local file](https://forum.anaconda.com/t/using-image-located-local-file/88877)
**Author:** [@Mehmet1](https://forum.anaconda.com/u/Mehmet1)\ **Replies:** 2\ **Last updated:** [November 26, 2024, 11:17am UTC](https://forum.anaconda.com/t/using-image-located-local-file/88877 "2024-11-26T11:17:27Z")
Hello, I would like to use a image in exce by pytgon code. But, image is located at the local file in the computer? Is is possible --- ## [Plotly visualization in Excel](https://forum.anaconda.com/t/plotly-visualization-in-excel/60322)
**Author:** [@borivoj.grujicic](https://forum.anaconda.com/u/borivoj.grujicic)\ **Replies:** 7\ **Last updated:** [November 22, 2024, 9:47pm UTC](https://forum.anaconda.com/t/plotly-visualization-in-excel/60322 "2024-11-22T21:47:01Z")
Hello Anaconda community! I would like to request a library to be added between 400 libraries already coming into Python excel. This particular library is by far the best library for visualization in Python, and it is … --- ## [Px.scatter\_geo from plotly.express](https://forum.anaconda.com/t/px-scatter-geo-from-plotly-express/84474)
**Author:** [@jbraun](https://forum.anaconda.com/u/jbraun)\ **Replies:** 3\ **Last updated:** [November 22, 2024, 5:21pm UTC](https://forum.anaconda.com/t/px-scatter-geo-from-plotly-express/84474 "2024-11-22T17:21:00Z")
Does Python in Excel support px.scatter\_geo plots from the plotly.express library? No error is generated when I try to use it, but i no image is created. --- ## [Error using pandas.to\_datetime()](https://forum.anaconda.com/t/error-using-pandas-to-datetime/88074)
**Author:** [@hennie](https://forum.anaconda.com/u/hennie)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 5:24pm UTC](https://forum.anaconda.com/t/error-using-pandas-to-datetime/88074 "2024-11-20T17:24:01Z")
This code worked yesterday, so it appears something changed overnight. Does anybody have an idea what is going on here? I have a simple table Friday Monday Count 12/3/2021 12/6/2021 1 12/10/2021 12/13/2021 1 … --- ## [Refresh Image or Plot with Button/Macro](https://forum.anaconda.com/t/refresh-image-or-plot-with-button-macro/88426)
**Author:** [@\_Finch](https://forum.anaconda.com/u/_Finch)\ **Replies:** 1\ **Last updated:** [November 20, 2024, 3:43pm UTC](https://forum.anaconda.com/t/refresh-image-or-plot-with-button-macro/88426 "2024-11-20T15:43:29Z")
Hi, Is there a method to have the image/plot created by a script only refresh when prompted by a Button/Macro instead of refreshing every time a separate cell is updated? Thanks --- ## [Matplotlib figures in excel with anaconda code](https://forum.anaconda.com/t/matplotlib-figures-in-excel-with-anaconda-code/87037)
**Author:** [@matthias.vink](https://forum.anaconda.com/u/matthias.vink)\ **Replies:** 6\ **Last updated:** [November 20, 2024, 3:39pm UTC](https://forum.anaconda.com/t/matplotlib-figures-in-excel-with-anaconda-code/87037 "2024-11-20T15:39:12Z")
Hi all, I am trying to plot a 3D graph using anaconda code in excel. While I succeeded in doing so, the graph is placed over the cells and not inside one, causing figures to stack on top of each other for every recalcul… --- ## [Anaconda Code Plotting Multiple Plots Every Time Code Runs](https://forum.anaconda.com/t/anaconda-code-plotting-multiple-plots-every-time-code-runs/87437)
**Author:** [@\_Finch](https://forum.anaconda.com/u/_Finch)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 12:02am UTC](https://forum.anaconda.com/t/anaconda-code-plotting-multiple-plots-every-time-code-runs/87437 "2024-11-20T00:02:29Z")
Every time I run a simple plot code with Anaconda code it will plot multiple of the identical plot. Additionally for this topic, each time the code runs it creates new plots. Is there a method to just overwrite the orig… --- ## [Request: Add engineering calculation packages (fluids, ht, chemicals, thermo) to Python for Excel](https://forum.anaconda.com/t/request-add-engineering-calculation-packages-fluids-ht-chemicals-thermo-to-python-for-excel/88223)
**Author:** [@Caleb](https://forum.anaconda.com/u/Caleb)\ **Replies:** 1\ **Last updated:** [November 17, 2024, 8:23pm UTC](https://forum.anaconda.com/t/request-add-engineering-calculation-packages-fluids-ht-chemicals-thermo-to-python-for-excel/88223 "2024-11-17T20:23:02Z")
Hello, I am the author of four established Python packages in the Anaconda repository: fluids, ht, chemicals, and thermo. I’m reaching out to request the inclusion of these packages in the whitelisted collection of libr… --- ## [Analis demografico](https://forum.anaconda.com/t/analis-demografico/88093)
**Author:** [@hpelaez078](https://forum.anaconda.com/u/hpelaez078)\ **Replies:** 0\ **Last updated:** [November 15, 2024, 5:26pm UTC](https://forum.anaconda.com/t/analis-demografico/88093 "2024-11-15T17:26:07Z")
Analizar la información que tenga el archivo para obtener de cada sección en función de la información demografía. --- ## [HERMES plan ,design, power, influence, working,](https://forum.anaconda.com/t/hermes-plan-design-power-influence-working/87832)
**Author:** [@Rocky](https://forum.anaconda.com/u/Rocky)\ **Replies:** 0\ **Last updated:** [November 12, 2024, 11:12am UTC](https://forum.anaconda.com/t/hermes-plan-design-power-influence-working/87832 "2024-11-12T11:12:36Z")
Hello world Hello world HERMS :zap:: --- ## [Remove Headers and Index when showing data frame in excel](https://forum.anaconda.com/t/remove-headers-and-index-when-showing-data-frame-in-excel/86937)
**Author:** [@implicit88](https://forum.anaconda.com/u/implicit88)\ **Replies:** 2\ **Last updated:** [October 29, 2024, 7:55pm UTC](https://forum.anaconda.com/t/remove-headers-and-index-when-showing-data-frame-in-excel/86937 "2024-10-29T19:55:00Z")
Hello, I have some code that displays the dataframe in excel, however, the headers and index show too. I do not want them to show. Is there a way to prevent this from happening. This code sits below data, so the inde… --- ## [Software Engineering process](https://forum.anaconda.com/t/software-engineering-process/86246)
**Author:** [@ajzamalemilbekovna](https://forum.anaconda.com/u/ajzamalemilbekovna)\ **Replies:** 1\ **Last updated:** [October 21, 2024, 2:12pm UTC](https://forum.anaconda.com/t/software-engineering-process/86246 "2024-10-21T14:12:10Z")
import numpy as np import matplotlib.pyplot as plt import pandas as pd Function f(x) = 3x - e^x def f(x): return 3 \* x - np.exp(x) Modified Secant method function def secant\_method\_fixed\_x0(x0, x1, tolerance, max\_it… --- ## [Struggling to find GitHub link for Anaconda toolbox](https://forum.anaconda.com/t/struggling-to-find-github-link-for-anaconda-toolbox/85383)
**Author:** [@nasrinbegump](https://forum.anaconda.com/u/nasrinbegump)\ **Replies:** 6\ **Last updated:** [October 18, 2024, 6:50pm UTC](https://forum.anaconda.com/t/struggling-to-find-github-link-for-anaconda-toolbox/85383 "2024-10-18T18:50:13Z")
Where can I find the GitHub link for anaconda toolbox? --- ## [Unable to edit code](https://forum.anaconda.com/t/unable-to-edit-code/82782)
**Author:** [@mso316](https://forum.anaconda.com/u/mso316)\ **Replies:** 6\ **Last updated:** [October 9, 2024, 2:05pm UTC](https://forum.anaconda.com/t/unable-to-edit-code/82782 "2024-10-09T14:05:30Z")
I am trying to use the Anaconda Code Dashboard. Using the expand button won´t let me edit the cell contents. It looks like this: What am I doing wrong? --- ## [Undo not working on cells referenced in Code](https://forum.anaconda.com/t/undo-not-working-on-cells-referenced-in-code/84953)
**Author:** [@dvvv](https://forum.anaconda.com/u/dvvv)\ **Replies:** 1\ **Last updated:** [October 4, 2024, 4:07pm UTC](https://forum.anaconda.com/t/undo-not-working-on-cells-referenced-in-code/84953 "2024-10-04T16:07:56Z")
Hi, I am unable to use the undo/redo command on cells that have been referenced in Anaconda Code. Is there a fix for that? --- ## [Is there documentation/API reference online for Python in Excel (similar to what most programming packages has?)](https://forum.anaconda.com/t/is-there-documentation-api-reference-online-for-python-in-excel-similar-to-what-most-programming-packages-has/84849)
**Author:** [@sbooyah](https://forum.anaconda.com/u/sbooyah)\ **Replies:** 3\ **Last updated:** [October 3, 2024, 2:01pm UTC](https://forum.anaconda.com/t/is-there-documentation-api-reference-online-for-python-in-excel-similar-to-what-most-programming-packages-has/84849 "2024-10-03T14:01:29Z")
I’ve followed a few online tutorials that walk you through the basics, so I’ve got an idea of how Python in Excel works, but I’d really like to view the full documentation/reference for it. Like, what all is the xl() met… --- ## [Dataframe in Sheet1 not available in Sheet2](https://forum.anaconda.com/t/dataframe-in-sheet1-not-available-in-sheet2/83043)
**Author:** [@mso316](https://forum.anaconda.com/u/mso316)\ **Replies:** 1\ **Last updated:** [September 12, 2024, 2:35pm UTC](https://forum.anaconda.com/t/dataframe-in-sheet1-not-available-in-sheet2/83043 "2024-09-12T14:35:28Z")
I am using Anaconda Code in Excel and I have the following code in Sheet1 of the Workbook REF(“A42:E57”) df2 = to\_df(REF(“A42:E57”)) In Sheet2 I have the following formula referencing the df2 dataframe find\_value = d… --- ## [Upload file via ftp](https://forum.anaconda.com/t/upload-file-via-ftp/82447)
**Author:** [@Ruud](https://forum.anaconda.com/u/Ruud)\ **Replies:** 1\ **Last updated:** [September 10, 2024, 4:27pm UTC](https://forum.anaconda.com/t/upload-file-via-ftp/82447 "2024-09-10T16:27:15Z")
I would like to upload a file via ftp so I can use the result of the Python code elsewhere. In my case, the Python (via AnacondaCode) would generate a video (.mp4 or .gif) and if it is on an URL, I can play it later. Ho… --- ## [Share my results to "non Python in Excel" users](https://forum.anaconda.com/t/share-my-results-to-non-python-in-excel-users/82185)
**Author:** [@mso316](https://forum.anaconda.com/u/mso316)\ **Replies:** 1\ **Last updated:** [September 6, 2024, 6:16pm UTC](https://forum.anaconda.com/t/share-my-results-to-non-python-in-excel-users/82185 "2024-09-06T18:16:58Z")
How to share my results to people that are not using Python in Excel? --- ## [Getting data located in another workbook](https://forum.anaconda.com/t/getting-data-located-in-another-workbook/80531)
**Author:** [@eddy.winiarz](https://forum.anaconda.com/u/eddy.winiarz)\ **Replies:** 3\ **Last updated:** [August 26, 2024, 6:54pm UTC](https://forum.anaconda.com/t/getting-data-located-in-another-workbook/80531 "2024-08-26T18:54:15Z")
Working in a workbook with the new Anaconda toolbox. Trying to get data from another workbook as a dataset in this workbook with this tool but having trouble. Not sure how to upload the data to the Anaconda cloud, can yo… --- ## [Participate in the Anaconda Toolbox User Research](https://forum.anaconda.com/t/participate-in-the-anaconda-toolbox-user-research/80668)
**Author:** [@dgurova](https://forum.anaconda.com/u/dgurova)\ **Replies:** 1\ **Last updated:** [August 21, 2024, 2:25pm UTC](https://forum.anaconda.com/t/participate-in-the-anaconda-toolbox-user-research/80668 "2024-08-21T14:25:42Z")
We’re excited to announce new tools in our Anaconda Toolbox! These new tools, as well as existing ones, were created to help you quickly generate code and visualizations while also learning Python as you go. Anaconda Too… --- ## [How do I open an excel spreadsheet with pandas](https://forum.anaconda.com/t/how-do-i-open-an-excel-spreadsheet-with-pandas/80627)
**Author:** [@jloyzaga](https://forum.anaconda.com/u/jloyzaga)\ **Replies:** 2\ **Last updated:** [August 20, 2024, 2:37am UTC](https://forum.anaconda.com/t/how-do-i-open-an-excel-spreadsheet-with-pandas/80627 "2024-08-20T02:37:37Z")
I want to create a spreadsheet if it doesnt exist with that name but if it does then open it. Then read a csv and see if the 3rd item in the row exists as a column header. If not create it. if it does add to end of colum… --- ## [Unable to find (and thus install) PyPI package](https://forum.anaconda.com/t/unable-to-find-and-thus-install-pypi-package/80433)
**Author:** [@Ruud](https://forum.anaconda.com/u/Ruud)\ **Replies:** 2\ **Last updated:** [August 20, 2024, 6:38am UTC](https://forum.anaconda.com/t/unable-to-find-and-thus-install-pypi-package/80433 "2024-08-20T06:38:29Z")
I have just created an ultra small test module and published it on PyPI. I can see it on pypi.org and install it with pip install, but when I search for it in the AnancondaCode environment, it isn’t shown. I have succes… --- ## [Check whether module is running in AnacondaCode](https://forum.anaconda.com/t/check-whether-module-is-running-in-anacondacode/80211)
**Author:** [@Ruud](https://forum.anaconda.com/u/Ruud)\ **Replies:** 6\ **Last updated:** [August 20, 2024, 2:59am UTC](https://forum.anaconda.com/t/check-whether-module-is-running-in-anacondacode/80211 "2024-08-20T02:59:14Z")
I woult like to check whether a (my) module, imported from PyPI is running in an AnacondaCode environment. For PythonInExcel that was relatively easy as I can check whether file is in globals(). But under AnacondaCode f… --- ## [How to run anaconda](https://forum.anaconda.com/t/how-to-run-anaconda/80179)
**Author:** [@2838534](https://forum.anaconda.com/u/2838534)\ **Replies:** 0\ **Last updated:** [August 13, 2024, 11:21am UTC](https://forum.anaconda.com/t/how-to-run-anaconda/80179 "2024-08-13T11:21:40Z")
HOW TO RUN ANACONDA 1.1 Getting started with anaconda 1.2 anaconda environment --- ## [Adding libraries in Python in Excel](https://forum.anaconda.com/t/adding-libraries-in-python-in-excel/79887)
**Author:** [@jeffrey1magee](https://forum.anaconda.com/u/jeffrey1magee)\ **Replies:** 1\ **Last updated:** [August 9, 2024, 9:30pm UTC](https://forum.anaconda.com/t/adding-libraries-in-python-in-excel/79887 "2024-08-09T21:30:57Z")
Hi there, Curious if Python in Excel can lemmatize and/or stem. I have tried to import some libraries, such as ‘from nltk.stem import WordNetLemmatizer’. However, it asks me to download the library… Not sure addl Python… [Previous page](https://forum.anaconda.com/c/python-in-excel/45.md) [Next page](https://forum.anaconda.com/c/python-in-excel/45.md?page=2)