How to solve BC30512: Option Strict On disallows implicit conversions from 'String' to 'ReadRangeRef'. The selected value is incompatible with the property type

Help Studio
, ,
1

BC30512: Option Strict On disallows implicit conversions from ‘String’ to ‘ReadRangeRef’. The selected value is incompatible with the property type.

Screenshot (19)
Screenshot (19)1366×768 87.5 KB

2

Hi @yashc

You can try like below

image
image606×735 25.5 KB

or

image

or

image
image481×565 15.6 KB

I hope it helps!!

3

@yashc

Range is where you need to provide what you read and in new design we have to use as below

Excel.Sheet("SheetName")

Or

Excel.Sheet("SheetName").Range("A1:B20")

Or simply select this

image
image1076×195 21.9 KB

and you would see menu where you can provide sheetname ,range or table name and it would create the formula automatically

image

cheers

1 Like
4

Hi @yashc

You are using the read range activity which is the modern excel activity. You are using Excel process scope is classic excel activity. There is no match between those that’s why it was throwing error.

If you want to read the excel and store in datatable. Simply use the workbook activities called Read range workbook activity which read the excel and store in a datatable.
After that you can use the for each row in datatable activity to iterate the rows in the datatable.

Hope it helps!!

5

@yashc

Try to use use excel file activity inside use the read range activity it will works

Cheers