Additional libraries for Python in Excel

Question

Hi, a colleague has a requirement for the following libraries to use with Python in Excel.

Is it possible to add these libraries within excel?

Libraries as follows: Pyfolio, Zipline and QuantLib.

The documentation at the link here mentions "The following table shows a subset of the open-source libraries provided by Anaconda that you can use with Python in Excel". Where can I find the full set of libraries?

Thank you

Answer 1

I used this command to see all the libraries: !pip listPackage Version ------------------------- ------------------ altair 5.0.1 anyio 4.2.0 argon2-cffi 21.3.0 argon2-cffi-bindings 21.2.0 astropy 6.1.0 astropy-iers-data 0.2024.6.3.0.31.14 asttokens 2.0.5 async-lru 2.0.4 attrs 23.1.0 Babel 2.11.0 beautifulsoup4 4.12.3 bleach 4.1.0 bokeh 3.4.1 Bottleneck 1.3.7 Brotli 1.0.9 certifi 2024.6.2 cffi 1.16.0 charset-normalizer 2.0.4 click 8.1.7 cloudpickle 2.2.1 colorcet 3.1.0 comm 0.2.1 contourpy 1.2.0 cycler 0.11.0 dask 2024.5.0 datashader 0.16.2 debugpy 1.6.7 decorator 5.1.1 defusedxml 0.7.1 et-xmlfile 1.1.0 excel 0.0.1 executing 0.8.3 Faker 25.8.0 fastjsonschema 2.16.2 fonttools 4.51.0 fsspec 2024.3.1 gensim 4.3.2 holoviews 1.19.0 hvplot 0.10.0 idna 3.7 imbalanced-learn 0.12.3 iniconfig 1.1.1 ipykernel 6.28.0 ipython 8.25.0 jedi 0.18.1 Jinja2 3.1.4 joblib 1.4.2 json5 0.9.6 jsonschema 4.19.2 jsonschema-specifications 2023.7.1 jupyter_client 8.6.0 jupyter_core 5.7.2 jupyter-events 0.10.0 jupyter-lsp 2.2.0 jupyter_server 2.14.1 jupyter_server_terminals 0.4.4 jupyterlab 4.0.11 jupyterlab-pygments 0.1.2 jupyterlab_server 2.25.1 kiwisolver 1.4.4 linkify-it-py 2.0.0 llvmlite 0.42.0 locket 1.0.0 Markdown 3.4.1 markdown-it-py 2.2.0 MarkupSafe 2.1.3 matplotlib 3.8.4 matplotlib-inline 0.1.6 mdit-py-plugins 0.3.0 mdurl 0.1.0 mistune 2.0.4 mizani 0.11.4 mlxtend 0.23.1 mpmath 1.3.0 multipledispatch 0.6.0 nbclient 0.8.0 nbconvert 7.10.0 nbformat 5.9.2 nest-asyncio 1.6.0 networkx 3.2.1 nltk 3.8.1 notebook 7.0.8 notebook_shim 0.2.3 numba 0.59.1 numexpr 2.8.7 numpy 1.26.4 officepyai 0.0.1 openpyxl 3.1.2 overrides 7.4.0 packaging 23.2 pandas 2.2.2 pandocfilters 1.5.0 panel 1.4.4 param 2.1.0 parso 0.8.3 partd 1.4.1 patsy 0.5.6 pexpect 4.8.0 pillow 10.3.0 pip 24.0 platformdirs 3.10.0 plotly 5.22.0 plotnine 0.13.6 pluggy 1.0.0 prince 0.13.0 prometheus-client 0.14.1 prompt-toolkit 3.0.43 psutil 5.9.0 ptyprocess 0.7.0 pure-eval 0.2.2 pyarrow 14.0.2 pycparser 2.21 pyct 0.5.0 pyerfa 2.0.1.4 Pygments 2.15.1 pyparsing 3.0.9 pypng 0.20220715.0 PySocks 1.7.1 pytest 7.4.4 python-dateutil 2.9.0.post0 python-json-logger 2.0.7 pytz 2024.1 pyviz_comms 3.0.2 pywavelets 1.5.0 PyYAML 6.0.1 pyzmq 25.1.2 qrcode 7.4.2 rapidfuzz 3.5.2 referencing 0.30.2 regex 2023.10.3 requests 2.32.2 rfc3339-validator 0.1.4 rfc3986-validator 0.1.1 rpds-py 0.10.6 scikit-learn 1.4.2 scipy 1.13.1 seaborn 0.13.2 Send2Trash 1.8.2 setuptools 69.5.1 six 1.16.0 smart-open 5.2.1 sniffio 1.3.0 snowballstemmer 2.2.0 soupsieve 2.5 squarify 0.4.3 stack-data 0.2.0 statsmodels 0.14.2 sympy 1.12 tabulate 0.9.0 tenacity 8.2.2 terminado 0.17.1 thefuzz 0.22.1 threadpoolctl 2.2.0 tinycss2 1.2.1 toolz 0.12.0 tornado 6.4.1 tqdm 4.66.4 traitlets 5.14.3 typing_extensions 4.11.0 tzdata 2023.3 uc-micro-py 1.0.1 unicodedata2 15.1.0 urllib3 2.2.2 wcwidth 0.2.5 webencodings 0.5.1 websocket-client 1.8.0 wheel 0.43.0 wordcloud 1.9.3 xarray 2023.6.0 xlrd 2.0.1 xyzservices 2022.9.0

Answer 2

Hello Peter,

Thanks for the reply.

I'm unable to find a list of subsets of libraries except for the link that was already provided. However, you can still get a thorough answer to our Excel community. Just post your query and our Excel engineers will get back to you. Excel | Microsoft Community Hub

Thanks for understanding.

Regards,

Fritz-Bald

Microsoft Community

Moderator

Answer 3

Hello Fritz-Bald, thank you for the response.

Are there currently any mechanisms within the python in Excel framework to have these libraries added? Is the Anaconda Toolbox Add-in used for this purpose?

Can you send me a link to the full list of supported libraries for Python in Excel on the official Microsoft documentation page that you mention please? I have only been able to find a list of a subset of the libraries at this location: Open-source libraries and Python in Excel - Microsoft Support

It's possible that I've misunderstood that this lists a subset of the available libraries in Excel and this is the full set.

Many thanks, Peter

Answer 4

Good day!

We have noticed that you have not responded to our last message in your Community post. We would like to know whether the issue you have raised with us is still ongoing. If yes, please click on this link () to get back to our thread and continue our conversation.

We await your response.

Regards,

Fritz-Bald

Microsoft Community

Moderator

Answer 5

Good day!

Welcome to Microsoft Community. Thank you for sharing your concern with us today and we hope that all is well.

Microsoft Excel supports a subset of open-source libraries provided by Anaconda for use with Python. Unfortunately, Pyfolio, Zipline, and QuantLib are not included in the supported libraries. You can find the full list of supported libraries for Python in Excel on the official Microsoft documentation page. If you have any other questions or need further assistance, feel free to ask.

Hope this helps!

Fritz-Bald

Microsoft Community

Moderator