How to change the data format in an excel file

[Chris-Yiwei (Ji)]

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 ?

[sudhasagar (sagar)]

Hey,

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

Can u share screen shot, demo excel

[AshwinS2 (Ashwin S)]

Hi @Chris-Yiwei

Try this

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

Thanks
Ashwin.S

[Chris-Yiwei (Ji)]

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