This requires a few extra techniques and some high level Power Query stuff, so I decided that rather than trying to fit it all in a comment section of that post, I would rather do an incognito blog post. ![]() Almost all comments referring to the mentioned blog post asked for exactly this, how do I do it with Excel files. This post is obviously not regular, since it’s not Tuesday (now I feel like Julianne Moore in Laws of Attraction) J but it’s a spinoff of a post I wrote in February of 2015 called Get Data From Folder with Power Query. So the final step of Get Data From Folder will have to use a function of more than just one parameter. There is a key difference here since Excel files are different than TXT files in a way that they can contain multiple Sheets and Tables. Whereas that post was about getting data from multiple TXT files within one folder, this one will tell you how to get data from folder full of Excel files. I recently posted on how to make a process of getting data from a folder bulletproof.
0 Comments
Leave a Reply. |