Directory.GetFiles(“C:\Temp”,"*.xlsx") will actually search for any files with the extention .xlsx in the C:\Temp folder and add them to an array. You can use the Assign activity to do this…
Do a For Each of that array,
Get the the file path from the array and add a Read Range activity within the For Each loop. For the path name of the read range, you can give the current value of the item variable in the For Each.
and an output datatable variable to hold the extracted data.
Now, create another datatable variable. to hold all the data of each extracted file because the datatable variable used in read range will replace its data every time it reads an excel.
After the read range, add Merge Data Table activity and in that, for Input - give the datatable of the read range, and for the output, give the datatable of the new datatable you created…
Does it help?