I am trying to read from an excel and store it an array using read range and assign activity. When i run the code i am getting the error “unable to cast object of type system.data.datacolumn to type system.string.”. How to resolve this?
Hi @Venkat_Karthikeyan,
It depends of to what type of variable do you want to assign the array. If this need to by only single String, you can’t assign whole column just like that cause column consist of cells and each cell is separate object.