How to read excel file in a notebook in fabric without using datapipeline

[poojitha_yeluru]

In Databricks to read a excel file we will use com.crealytics.spark.excel by installing libraries . In case of Fabric notebook how can we read an excel file with out using data pipeline

[Expiscornovus · Accepted solution]

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

[Expiscornovus]

Hi @poojitha_yeluru,

In this thread I have seen somebody use Pandas library for that:

https://community.fabric.microsoft.com/t5/General-Discussion/How-to-load-an-excel-file-from-Sharepoi...

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_yeluru]

Hi @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 · Accepted solution]

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.

[v-nikhilan-msft · Accepted solution]

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.