Cannot read excel file which is in using adls using load_workbook of openpyxl in databricks

Question

Cannot read excel file which is in using load_workbook of openpyxl but can read if copied to dbfs

Answer 1

Hello,

The reason behind this issue is

The open method (load_workbook) works only with local files - it doesn't know anything about abfss or other cloud storages.Please check this stack overflow link for similar question.

Workaround:

1. You can use https + sas key (generated from azure portal)
2. Mounting the file to dbfs or do a copy as you have mentioned

use dbutils.fs.cp to copy file from ADLS to local disk of driver node, and then work with it, like: dbutils.fs.cp("abfss:/....", "file:/tmp/my-copy")

So whatever you are doing is the correct way of accessing the file.

Hope it helps.