Anyone can help me on this? The rough idea is I’ll iterate each files in a folder. Then, iterate each sheet in each file and read range for each sheet. I use excel activities as I want to read visible rows only in each sheet.
Also, how to read only visible columns?
For the error, enclose use excel file activity in the excel process scope activity.
I think if we select visible rows, it would automatically fetch visible columns as well.
Hope it resolve the issue
the excel process scope doesn’t work sadly and for the visible rows, only applicable to rows but not columns
Can you check if there is variable named Excel in variable panel? If it exist, can you remove it?
Do you have Create any
Excel as variable? Check out the Variable panel