Video: Count Columns and rows of all Excel files and sheets within a folder using Power Query
Van: LightDotLab
Duur: 6:19
Hoeveel kolommen en rijen zijn er per werkblad gevuld van de bestanden in een map
Have many sheets in many files and need to count how many columns and rows before you clean, append, and consolidate them together? Power BI and Excel's Power Power Query can help you. 0:00 Overview of sample raw data 1:44 Get Data Files with From Folder 2:30 Extract Data from Files with Excel.Workbook( ) 3:45 Count Columns with Table.ColumnCount( ) 4:50 Count Rows with Table.RowCount( )
Functies: Excel.Workbook(), Table.RowCount(), Table.ColumnCount()
