Hi,
In Azure Synapse Workspace is it possible to read an Excel file from Data Lake Gen2 using Pandas/PySpark? If so, can you show an example, please?
Example:
import pandas as pd
file_path = '/dbfs/mnt/raw/2020/06/01/file.xlsx' or 'abfss://raw@dlsname.dfs.core.windows.net/2020/06/01/file.xlsx'
df = pd.read_excel(file_path)
Best regards,
Cristina



