cancel
Showing results for 
Search instead for 
Did you mean: 

Access Excel file in delta live pipeline

Yash_542965
New Contributor II

I'm having an issue accessing the excel through dlt pipeline. the file is in ADLS I'm using pandas to read the Excel. It seems pandas are not able to understand abfss protocol is there any way to read Excel with pandas in dlt pipeline?

I'm getting this Error: "ValueError: Protocol not known: abfss"

1 ACCEPTED SOLUTION

Accepted Solutions

werners1
Esteemed Contributor III

what if you use the pyspark.pandas.read_excel function? I think you use the 'normal' pandas variant, not the pyspark one.

View solution in original post

2 REPLIES 2

werners1
Esteemed Contributor III

what if you use the pyspark.pandas.read_excel function? I think you use the 'normal' pandas variant, not the pyspark one.

Yash_542965
New Contributor II

Thanks for the info. It works just need to install an additional library using "%pip install openpyxl".

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.