I am trying to put all rows from a data table into a single Excel cell. Is there some sort of “Append Cell” activity which can be used for this?
Otherwise, this is what I’m currently doing (“rowcounter” is my INT32 counter variable)
Declare string variable “string_var” (default value = “N/A”)
Declare Int32 (“rowcounter”). This is my +1 incremented counter variable
Write Cell (“T1” + rowcounter.tostring)
Writing: string_var + datatable values
Read Cell (“T1” + rowcounter.tostring)
Output = string_var
While the above DOES put all data table values into a single cell, the cell that it places them into is not (“T1”+rowcounter.tostring). For some reason, it puts the values 10 rows down (“T1”+(rowcounter.tostring + 10))
I’ve been looking over this but cannot see where I’m going wrong. Are there any quick/easy answers to this one?