option("header", "true") per my repro, reading excel file from ADLS gen2 cannot accessed directly using the storage account access key. Besides, please note that if you use scala 2.11, please add package com.crealytics:spark-excel_2.11:0.13.1 For more details, please refer to here and hereĪdd package com.crealytics:spark-excel_2.12:0.13.1 via maven.
But we need to add jar com.crealytics:spark-excel in our environment. Install package azure-storage-file-datalake and xlrd with pip in databricksįrom import BlobServiceClientįrom import DataLakeServiceClientīlob_service_client = DataLakeServiceClient(account_url=' credential='')įile_client = blob_service_client.get_file_client(file_system='test', file_path='data/sample.xlsx')īesides we also can use pyspark to read excel file. Download the file as stream and read the file.Meanwhile, you also mount the storage account as filesystem then access file as said. So if you want to access the file with pandas, I suggest you create a sas token and use https scheme with sas token to access the file or download the file as stream then read it with pandas.
The method pandas.read_excel does not support using wasbs or abfss scheme URL to access the file.
0 kommentar(er)
