Input: Multiple Excel files with multiple sheets of data.
Download sample files here
Goal: Setup a DataFromExcel formula that collates the data from all the workbooks and worksheets and puts it in one single place.
- Get the file list using GetAllFiles.SK
- Define a function which will take in a file_name as input and return a two column list of the file_name & the sheet_name. (Use SheetNames.SK)
- Use the above defined function on the list of files
- Use DataFromExcel.SK, where you can pass in the filename & sheetname via RegionDown.SK to get the data in one single place.