Ger row item :Typeconverter cannot convert from system.string

Help
1

I am getting following error :

1)I am extracting data from a web broswser by Data scrapping;
2)outputtable ; ExtractDataTable
3)I am trying to get the items is datatable by “for each row”
4)get row item

Get row item :Typeconverter cannot convert from system.string

1 Like
2

After you scrape the table, use For Each Activity.
Then use For Each Row to loop through the rows.
Then use row(“columnName”).ToString

2 Likes
3

DATA SCRAP EXAMPLE.xaml (27.4 KB)

Attached is my file …I am getting error exactly at the "GET ROW ITEM " activity

4

@allurai_india

output of Get Row Item activity is string but you declared as ‘dataRow’. That’s why you are getting that error. Change it to string and then try.

2 Likes
5

i have changed to

string
strin
datarow
generic

none of above working

6

@allurai_india
Buddy here is the issue,
after the changing the get row item activity output variable to string,
Kindly change the below as the row is from for eachrow loop and you have changed to string thats why showig error like
image

this would work

Hope it would help you

Cheers.

1 Like
7

@allurai_india

Please find the sample workflow file for your reference. You need to change the datatype from DataRow to string. Then it should work.

DataTable.xaml (10.1 KB)
New Microsoft Excel Worksheet.xlsx (12.2 KB)

1 Like
8

thnaks lakshman …It was working .

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.