Error conversions from 'String' to 'IWorkbookQuickHandle'

[arina]

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?

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @arina,
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

Thanks

[arina]

the excel process scope doesn’t work sadly and for the visible rows, only applicable to rows but not columns

[Yoichi]

Hi,

Can you check if there is variable named Excel in variable panel? If it exist, can you remove it?

Regards,

[Gokul001 (Gokul Balaji)]

Hi @arina

Do you have Create any Excel as variable? Check out the Variable panel

Regards
Gokul