How to change a column type from General to Percentage in DataTable?

how to change a column type from General to Percentage in DataTable?

Can you pls elaborate your issue/requirements?

if you are looking for a column data type - you can refer this post - How to change the data type of a column in data table - #3 by achyuth_sai

I read a excel using Read Range, i want to change a Type of 1 particular column from General to Percentage in the datatable and paste it to excel again.

Its better to use invoke vba code activity and use below piece of code to get what you want
yourworksheet.yourrange.NumberFormat=“0.00%”

1 Like

Two ways to do so:
Option 1: Use following custom activity/package

Option 2: Refer following thread:

1 Like

@gaurav.singh5

Firstly in Excel convert column into percentage with “Format cell”.
secondly while reading Excel → Read Range → properties → Select “Preserve format”.

:innocent:

3 Likes

Thank you. Works like a charm !! :innocent:

1 Like

Thanks

1 Like