Error conversions from 'String' to 'IWorkbookQuickHandle'

Help Something Else
1

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.

image
image856×742 30.7 KB

Also, how to read only visible columns?

2

Hi @arina,
For the error, enclose use excel file activity in the excel process scope activity.

image
image732×702 16.1 KB

I think if we select visible rows, it would automatically fetch visible columns as well.
Hope it resolve the issue

Thanks

3

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

4

Hi,

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

Regards,

5

Hi @arina

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

image
image426×506 15.7 KB

Regards
Gokul