Forum Discussion
Advocate IHow to read excel file in a notebook in fabric without using datapipeline
Hi poojitha_yeluru,
Yes, it should be possible to install libraries into Fabric as well. You can manage them via an environment, https://learn.microsoft.com/en-us/fabric/data-engineering/environment-manage-library
Hi poojitha_yeluru
As mentioned by Expiscornovus we can use Environments in Fabric. and also Pandas library to read an excel file. These are the available options for now.
Please let me know if you have any further questions.
Advocate IHi Expiscornovus ,
Thanks for sharing , I had already gone to above way but pandas is a costly operation. In databricks we will install library ie. (com.crealytics:spark-excel_2.12:0.13.5), is there any way like to install a library in fabric.So that we can read excel file..
Most Valuable ProfessionalHi poojitha_yeluru,
Yes, it should be possible to install libraries into Fabric as well. You can manage them via an environment, https://learn.microsoft.com/en-us/fabric/data-engineering/environment-manage-library
- poojitha_yeluru
Hi Expiscornovus ,
Yes From public library we have to select PYPI and we have to use xlrd it is also pointing to pandas. Is there any other way.Hi poojitha_yeluru
As mentioned by Expiscornovus we can use Environments in Fabric. and also Pandas library to read an excel file. These are the available options for now.
Please let me know if you have any further questions.
JosueMolinaHelper III
I want to add to this by saying that installing libraries as .jar files for Spark use is not supported via Environments. So the previously mentioned library to read excel as Spark is not possible via Environment.
Manage Apache Spark libraries - Microsoft Fabric | Microsoft Learn