Add support for office PIPs into Fabric Notebooks (Python)

[BOB10]

Its very common to need to integrate Fabric PySpark into office to download excel files. Currently this is difficult to do and if we do a pip install at Library level, the startup times is too slow.

Can we get the following PIP installs into the standard Spark "Started" image ?

pip install msoffcrypto-tool

pip install Office365-REST-Python-Client

This would add support for reading and writing files from SharePoint using Notebooks and also to support password encrypted excel files

[midesa]

Thank you for the feedback. To clarify, are you looking for support to run inline installation within the notebook or are you looking to have the libraries listed part of the default Fabric runtime?

For running inline Python installations with PIP, you can do this at the session-level: Python library management in Fabric - Microsoft Fabric | Microsoft Learn. 

[aidan959]

We are looking for this to be included in the default Fabric runtimes (we can already pip install)