Why it keep rerunning in for each loop in the second picture and cannot run to the third pic which is flow decision? And it only open excel, keep stuck in 1 sheet and not moving?
By the looks of it you don’t increment the sheet name anywhere?
I used workbook.getsheet so that it can just keep reading the shheet name. And use flow decision and named sheet name as strSheetName, actually the coloured part is the individual sheet name, but confidential
You could just use a for each activity instead of a flow
Loop sheets in excel.xaml (5.5 KB)
Also instead of If Statements - you could use the Switch activity
If there is a Single sheet.
You can create output variable for excel Application scope and use Workbook.GetSheets(0) in Read Range Activity