Hi everyone, I hope all is good, I have a question and you guys are always super helpful, how can i select the whole content of a column dynamically, copy it and paste that content into a text box without having to write the value one by one? Thank you all in advance.
Try below steps.
First use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘inputDT’.
And then try below expression to get one column values.
columnDT = inputDT.DefaultView.ToTable(False,"ColumnName").CopyToDataTable
And then use Generate DataTable activity to convert DataTable into String. And then use Type Into activity and indicate that text box and pass that string to enter into it.
@lakshman Hi I will try it out, thank you very much for the help
To copy the entire column (or range ). you can use (Copy to Clipboard) activity from the below link.