Hi Community!
I want to input data in excel but sometimes the sheet name is different, how do i input the files regardless of the name of the sheet?
/
Other than that, another question is if i want to input sheets name that starts with the same logic like aa122, aa123, aa124, how do i make it happen?
/
And for the last question, when i input files that maybe the excel itself sometime will also named wrong, do i have to rename it manually myself or there's any way to read those files?(What i learned is maybe can use directory tool but i'm not sure if it is applicable).
Many thanks if you have any feedback for these!!
