I have an Excel file with several sheets. I would like to first read the whole Excel file and then just pull data from specific sheets. This is what I have now. This works but is very slow and I have to do this for every sheet.
And this is what I would like to do:
So, to make it more clear, I just want to read the whole file and store it as a variable ( k for example) and then when I need to read a specific sheet, just use that variable.
I cannot share my Excel file for various reasons, so I am just asking for some guidance.