I am reading an excel worksheet into a data table having multiple columns. I am then applying TrimStart to remove leading zero’s from each cell. I then want to update each cell of the column with the trimmed value. Please not that the excel rows are dynamic and dont know the number of rows each time it gets updated.
I am using Write cell activity to update the new value into each cell. Currently, this is not working. After debugging it I found the values are getting trimmed currently and there are no run time errors while executing Write Cell.
Any help would be much appreciated. Thank you