How to change the data format in an excel file

dear all,

I have an excel file, but in each cell , the data format is string, how could I change all of the data format of each cell in this excel to number ? anybody could give me some demo code ?

1 Like


U saying ONE Alphabet should need to change Numeric as 1.

Can u share screen shot, demo excel

Hi @Chris-Yiwei

Try this

Use assign activity
Row(“columnname”). ToString=cint(row(“columnname”). ToString)


hey ashwin, thanks a lot , could you use the demo excel , and give me some demo code ? I will learn it .