How to read Excel workbook using 'abfss' file_path in Azure Synapse?

Question

Hi,

I need help reading the Excel workbook, with multiple sheets stored in Azure Synapse Data Lake gen2. Until recently, my Python script using the Pandas library worked fine. But now I am getting this error :

AttributeError: module 'fsspec_wrapper' has no attribute 'AzureBlobFileSystem.'

While executing to gram the workbook with all sheets-->

data = (f"abfss://{CONTAINER_NAME}@{STORAGE_ACCOUNT_NAME}.dfs.core.windows.net/{file_path}")

df = pd.read_excel(file_path=data, sheet_name=None)

Both fsspec & fsspec_wrapper dependencies are installed in Azure Synapse.

fsspec @ file:///home/conda/fe

edstock_root/build_artifacts/fsspec_1624452401871/work

fsspec-wrapper==0.1.10 (I tried to update this attribute to the newest version but was not able)

Please help. Thank you.

Answer 1

Hello @Miroslav Muras

Welcome to the MS Q&A platform.

It seems like the package fsspec is not the latest.
Please update the package
pip install fsspec=="package version number"
A similar issue discussed here
I hope this helps. Please let us know if you have any further questions.