Option strict on disallows implicit conversions from 'object' to 'string'

Help
, ,
1

Hi,

I am facing this error (option strict on disallows implicit conversions from ‘object’ to ‘string’) while reading the data from workbook having multiple sheets.

I have workbook having 500+ sheets. I used Get Workbook sheets activity to get workbook. I passed the output to for each activity. In for each I want to get data of a particular sheet, so i used read range activity, there i passed the for each value. here i am facing the error.

Could anyone help me on this??

2

@mani93

Set Type Argument field to Array of string from Object and then check once.

1 Like
3

Hi @mani93,

Yes, you can explicitly convert it.
How?
In the loop while reading the sheet, you can use item.ToString to explicitly convert it to the string.

2 Likes
4

Hi , Added sample workflow as below for your reference

Excel Validation.zip (12.3 KB)

1 Like