How do I get string converter to convert Int32

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.

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

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

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

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

row(ColumnName)=row(“ColumnName”). ToString)

Hope it helps you


Nived N :robot:

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