Pulling data from the first tab of each Excel for a group of files

Help StudioX
,
1

Hello - I have a group of Excel files and I am trying to pull a dollar amount from each of the files. The data (dollar amount) will always be on the 1st tab (sheet) of each Excel file and the row that it is in will always include the words “distribution” and “owner” (but maybe in different orders"). The data will then be added to an existing spreadsheet that has these files names listed that they’re pulling from. Does anyone have any suggestions/ideas on how I can accomplish this?

2
  • Excel Process Scope
    – For Each File in Folder
    — Use Excel File
    ---- Get Sheets into SheetsList array
    ---- Read Range SheetsList(0)
    ---- Use Lookup Data Table to find the value you’re looking for based on the values in the other rows
3

Thank you, Paul. Do you happen to have an example of this activity workflow and/or a little more explanation of how to get sheets into SheetsList array. I am very new to this and tried to do some research on SheetsList array but could not find much on it.

4

With the Get Sheets activity. SheetsList is a suggested name for the variable you use as the output of the Get Sheets activity.