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

Help Automation Ops
,
1

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

2

Hi @anjani_priya

Excel Process Scope
Use Excel file
Read Range
For each row in excel
  row("ColumnName") = Convert.ToInt32(row("ColumnName"))
  row("AnotherColumnName") = Convert.ToDouble(row("AnotherColumnName")) 
Write range

Hope it helps!!

3

@anjani_priya

you can use format cells activity to do directly on excel

cheers

5

the numbers should be separated by commas how to set that?

6

@anjani_priya

In the number format you have use 1000 separator option please check that

cheers

7

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