Access Excel file in delta live pipeline

[Yash_542965]

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"

[werners1 · Accepted solution]

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

[Yash_542965]

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