https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4282#M1041 <P>Thanks for the info. It works just need to install an additional library using "%pip install openpyxl".</P> Fri, 09 Jun 2023 07:16:13 GMT Yash_542965 2023-06-09T07:16:13Z https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4280#M1039 <P>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?</P><P></P><P>I'm getting this Error: "<B>ValueError: Protocol not known: abfss</B>"</P> Tue, 16 May 2023 16:11:19 GMT https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4280#M1039 Yash_542965 2023-05-16T16:11:19Z https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4281#M1040 <P>what if you use the pyspark.pandas.read_excel function? I think you use the 'normal' pandas variant, not the pyspark one.</P><P></P> Thu, 25 May 2023 10:13:13 GMT https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4281#M1040 -werners- 2023-05-25T10:13:13Z https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4282#M1041 <P>Thanks for the info. It works just need to install an additional library using "%pip install openpyxl".</P> Fri, 09 Jun 2023 07:16:13 GMT https://community.databricks.com/t5/data-engineering/access-excel-file-in-delta-live-pipeline/m-p/4282#M1041 Yash_542965 2023-06-09T07:16:13Z