Datatable - Add new column - How to make the column variable as double

[jerry.kohzl]

HI, have create new column B in the datatable. Column B is used to perform calculation from Column A. But when write range to excel, Column is not presented a number format. How can we make the output as number format column?

[songoel (Sonal)]

@jerry.kohzl,

Hey, use the properties of ‘Add Data Column’ activity to set the value type to double.
This activity is performed on a Data Table. Hence read your data into a data table, after which you can add data column and perform your operations.
In the end write the new data or only the data column back to the excel.

You can Browse for more variable types and search for Double.

[jerry.kohzl]

ok got it. thanks!