Im trying to append the data from one excel to another excel sheet, This error always comes out "Append Range : Object reference not set to an instance of an object.’ I first used the read range activity, then “append Range” given the properties of the data iwant to put and the file where iwant to put
Object reference exception occurs when the variable you are trying to perform action is not initialized . Check the sheet name you are trying to read in read range activity.
use for each row activity after read range activity and pass the argument as system.datatable in for each
got it thanks