Hi @pravin_calvin : Thank you very much for your support. The issue is resolved but facing problem in writing into the file. I want to print the cell value from the adjacent column.
I am using Write Cell Activity and with Read Range Path but where should I place the adjacent column path?
Where should I place the below command and how using write cell activity?
in case of the value is null/nothing we cannot use toString - will throw an exception
we can do a defensive if check by:
If(isNothing(row(ColNameOrIndex)), 0, CInt(“0” & row(ColNameOrIndex).toString.Trim))
But this will only work if we can assume positive values only. If this cannot be ensured, then would incorporate a Int32.TryParse(…) part additional into the Int conversion
Actually, I have added Add Data Column and do not want to add the starting cell in the write cell activity which is shown ahead of Sheet1 because I want to add the column with Add Column which is my starting cell. If it is possible with write range activity so please tell me but write range does not acquire the cell but cannot write the text with data table variable. So that;s why I used write cell.