Read “dynamic range” from excel file with a “dynamic name” for the first sheet

Directory.GetFiles returns an array of string, not a string. ANd you have to have a Use Excel File inside Excel Process Scope, then Read Range inside that. Also I don’t think GetSheets returns the correct datatype for the Range property. I use the Get Sheets activity and then use that array to pass the sheet.