Excel data fromatting issue

Hi All I have excel input file where business has formatted the data and i have created a templete and coping the data from the input file and pasting the data in a templete
but when data is pasted few of the excel rows showing as green arrow mark on the cells
is it taking the data in sting format please let me know…i want same data to copied from input to template


then try using workbook activities first

if they dont work then first make sure the datatypes in your datatable are aligned with the datatype of excel


Hi @T_Y_Raju

while reading the data can you try with preserve format and without preserve format.

or you can read that specific range using Read Column activity.

Hope it Helps!!!

if i try to preserve the format and paste all the values have been pasted as string