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

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

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



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

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

how to change them?.

Hi @anjani_priya ,

We can do this by using Modern Excel activities .


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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.