How to change the column values as double and number format for specific excel sheet

[anjani_priya]

How to change the specific columns as int and specific columns as number format
how to do that for specific sheet

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

HI @anjani_priya ,
You can use as a object type or generic

regards,

[sasi_poosarla (sasi p)]

@anjani_priya

for double ->Cdbl(row(“ColumnName”).tostring)
for integer → Cint(row(“ColumnName”).tostring)

[anjani_priya]

how i can declare multiple columns at a time
can you send the sample code
Book1.xlsx (10.1 KB)
I have to change name as int(number format no commas)
open close finish as integer eg. 23,345,345

[anjani_priya]

how to change them?.

[gRao]

Hi @anjani_priya ,

We can do this by using Modern Excel activities .

If this helps, could you mark this as the solution
Regards,
Geetishree Rao