Video: Import multiple Excel-files with multiple sheets in Excel
Van: Allan Murray - Computergaga
Duur: 9:49
Meerdere werkbladen in meerdere bestanden importeren met Power Query
In this video, we import multiple files that contain multiple sheets from a folder into one Excel table. This is a hugely powerful technique, yet it is quick and easy to do with Power Query. In this example, we have four Excel workbooks that contain six worksheets. We only need four of these sheets, so will filter two out in the process. The data from all four sheets and all four files will be stacked into one table and then a PivotTable created from it.
Functies: Excel.Workbook()
