How to Dynamically Read Multiple Sheets from an Excel File in Kedro? Hi everyone! I'm currently working with Kedro and I need to load multiple sheets from an Excel file. The challenge is that I do not know the sheet names in advance, so I need to dynamically identify and load all available sheets. Could someone please guide me on how to achieve this in Kedro? What would be the best practice for integrating this with the Kedro data catalog? Thanks in advance for your help! Using right now: "constraints_{name_us}": type: pandas.ExcelDataset filepath: data/10_optimization_inputs/constraints_{name_us}.xlsx load_args: engine: openpyxl decimal: "." sheet_name: None (Sheet_name = None don't work)

what did you get? an error or a single dataframe?

A error, the sheet with name None its not in my excel file

so I’ve just tested with a project I happened to have open and it works as expected

Worksheet named None not found I am current using kedro 0.19.3

So is there any way you are passing

"None"

not

None

? so is there any reason why the

I tried the both 😕

Can you try

null

or

~

Yes, i will try 🙂

🙏

Or just leave the option? I think the default should be None anyway?

yeah I didn’t mention that technically this is valid:

"constraints_{name_us}":
    type: pandas.ExcelDataset
    filepath: data/10_optimization_inputs/constraints_{name_us}.xlsx
    load_args:
       engine: openpyxl
       sheet_name: 
       decimal: "."

but it does feel like it breaks the

explicit is better than implicit

python mantra

https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html Alright I am wrong the default is 0 which is the first sheet

oh you’re talking about the pandas arg