How to read an excel file with 2 sheets, read those 2 sheets, output them to a single file

Help Activities
, ,
#1

Hi!

Can someone help me with my process.

  1. Read 2 sheets from a single file
  2. Perform filtering on those 2 sheets (same filtering method on both sheets)
  3. Insert the output to a single file

Thanks!

#2

Hi @caduque,

if I get this correct, my procedure would be:

  1. Read range (either seperate or loop over a list/array of your sheetnames)

  2. Merge the datatables (merge datatable activity)

  3. Filter the datatables seperately (filter datatable activity)

  4. Use write range to output the data

BR