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.
Most Valuable ProfessionalHi poojitha_yeluru,
In this thread I have seen somebody use Pandas library for that:
Below is an example
import pandas as pd
df = pd.read_excel("abfss://<id>@onelake.dfs.fabric.microsoft.com/<id>/Files/Excel/TestBook.xlsx")
display(df)
poojitha_yeluruHi 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..
- Expiscornovus
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
- 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.
Pandas can't read from absolute abfss:// paths.
In fact, in your screenshot we read:I hope this may help
