This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to read in a specific tab from multiple excel files (.xlsx & .xlsb) that are hosted in their own sub folders/directories but are all stored in the same main folder/directory. The specific tab I want has the same schema throughout all ~40 files. However, the files have different tabs in them other than the one tab that I want. I've narrowed down the list of files I want using the directory tool with a couple of filters. I tried the dynamic input tool afterwards based on a few posts I read and am not having any luck. Is Directory plus Dynamic Input the best route to take here or is there a better approach other than using ~40 individual input tools and unioning them all together? I appreciate any and all help.