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%”
Two ways to do so:
Option 1: Use following custom activity/package
Option 2: Refer following thread:
Firstly in Excel convert column into percentage with “Format cell”.
secondly while reading Excel → Read Range → properties → Select “Preserve format”.
Thank you. Works like a charm !!
Thanks