I have a problem in retaining cell format in excel. I have to copy this one column and append to the last row of another excel file. I have done this part but the only problem is the format is gone so the value that being append is invalid.
So I have to append data from column ‘ID_NO’ in excel 2 to column ‘RID’ in excel 1 without removing the format.
Currently what I did is I use filter datatable activity and get column ‘ID_NO’ and append it using write range activity.
The problem is after append all the values that starts with 0 will be gone in Excel 1. Example as below:
Note: Both excel I have changed it to Text format.