Python in Excelではどのような外部ライブラリが使えるのか

2023年9月時点でベータ版の「Python in Excel」では、NumPyやpandasなど非常にメジャーな外部ライブラリについてはimport文を書くことなくいきなり使うことが可能です。

そもそも、どのような外部ライブラリがPython in Excelで使えるのか（使える可能性があるのか）が気になります。

インストール済の外部パッケージを確認するスクリプト

以下のコードをPythonモードのセルで実行すれば、Python in Excelで使えそうな外部パッケージを確認できます。

294個の外部パッケージを確認できる

9月12日時点で、上記のコードを実行すると以下のような294個の外部パッケージを確認できます。

Automat
Babel
Bottleneck
Flask
HeapDict
Jinja2
Markdown
MarkupSafe
Pillow
Protego
PyDispatcher
PyHamcrest
PyQt5-sip
PySocks
PyWavelets
PyYAML
Pygments
QDarkStyle
QtAwesome
QtPy
Rtree
SQLAlchemy
Scrapy
SecretStorage
Send2Trash
Sphinx
Twisted
Unidecode
Werkzeug
alabaster
anyio
appdirs
argon2-cffi
argon2-cffi-bindings
arrow
astroid
astropy
asttokens
atomicwrites
attrs
autopep8
backcall
bcrypt
beautifulsoup4
beniget
binaryornot
black
bleach
bokeh
brotlipy
certifi
cffi
chardet
charset-normalizer
click
cloudpickle
colorama
colorcet
comm
constantly
contourpy
cookiecutter
cryptography
cssselect
cycler
cytoolz
dask
datashader
datashape
debugpy
decorator
defusedxml
diff-match-patch
dill
distributed
docstring-to-markdown
docutils
entrypoints
et-xmlfile
excel
executing
fastjsonschema
filelock
flake8
flit-core
fonttools
fsspec
future
gast
gensim
gmpy2
greenlet
h5py
holoviews
huggingface-hub
hvplot
hyperlink
idna
imagecodecs
imageio
imagesize
imbalanced-learn
importlib-metadata
importlib-resources
incremental
inflection
iniconfig
intake
intervaltree
ipykernel
ipython
ipython-genutils
ipywidgets
isort
itemadapter
itemloaders
itsdangerous
jedi
jeepney
jellyfish
jinja2-time
jmespath
joblib
json5
jsonschema
jupyter
jupyter-client
jupyter-console
jupyter-core
jupyter-server
jupyterlab
jupyterlab-pygments
jupyterlab-server
jupyterlab-widgets
keyring
kiwisolver
lazy-object-proxy
llvmlite
locket
lxml
lz4
matplotlib
matplotlib-inline
mccabe
mistune
mock
mpmath
msgpack
multipledispatch
munkres
mypy-extensions
nbclassic
nbclient
nbconvert
nbformat
nest-asyncio
networkx
nltk
notebook
notebook-shim
numba
numexpr
numpy
numpydoc
officepydep
openpyxl
packaging
pandas
pandocfilters
panel
param
parsel
parso
partd
pathspec
patsy
pep8
pexpect
pickleshare
pip
platformdirs
plotly
pluggy
ply
pooch
poyo
prometheus-client
prompt-toolkit
psutil
ptyprocess
pure-eval
py
pyOpenSSL
pyasn1
pyasn1-modules
pycodestyle
pycparser
pyct
pycurl
pydocstyle
pyerfa
pyflakes
pylint
pylint-venv
pyls-spyder
pyodbc
pyparsing
pyrsistent
pytest
pytest-json-report
pytest-metadata
pytest-officepyresultreport
python-dateutil
python-lsp-black
python-lsp-jsonrpc
python-lsp-server
python-slugify
python-snappy
pytoolconfig
pytz
pyviz-comms
pyxdg
pyzmq
qstylizer
qtconsole
queuelib
regex
requests
requests-file
rope
scikit-image
scikit-learn
scipy
seaborn
service-identity
setuptools
sip
six
smart-open
sniffio
snowballstemmer
sortedcontainers
soupsieve
sphinxcontrib-applehelp
sphinxcontrib-devhelp
sphinxcontrib-htmlhelp
sphinxcontrib-jsmath
sphinxcontrib-qthelp
sphinxcontrib-serializinghtml
spyder
spyder-kernels
stack-data
statsmodels
sympy
tables
tabulate
tblib
tenacity
terminado
text-unidecode
textdistance
threadpoolctl
three-merge
tifffile
tinycss2
tldextract
tokenizers
toml
tomli
tomlkit
toolz
torch
tornado
tqdm
traitlets
transformers
typing-extensions
ujson
urllib3
w3lib
watchdog
wcwidth
webencodings
websocket-client
whatthepatch
wheel
widgetsnbextension
wrapt
wurlitzer
xarray
yapf
zict
zipp
zope.interface

もちろん、Excelのワークシート上でどう使えばいいのかわからないパッケージも含まれていますけれど。