How do I get string converter to convert Int32

Help Activities
,
1

I have sequence that reads values of cells in an Excel column. Most of the values are in string. However, in some occurrences, the cell value is of type Int32. When this happens, I get an error and the whole sequence crashes.

Is there anyway I can make my automation replace the cell value to a string type before reading? Thank you.

2

你好
你可以试试row(“Column Name”).ToString

3

In the for each row loop while iterating the values Just do the following:-

data=row(“name of the column”).ToString

4

Hi @sundalpathyREBORN

Read the excel file and store in dt1

U can try this in invoke code by passing dt1 as argument with argument type as In/Out

dt1.AsEnumerable().ToList().ForEach(Sub(row)
row(ColumnName)=row(“ColumnName”). ToString)

Hope it helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed: