Hey everyone i am trying to read column data from excel and then replacing some text and then using invoke method and then add row activity of data table but i am getting this error
“Input array is longer than the number of columns in the table”
i have tried ones on different kind of data at that time there was no error!! like transposing column to row.
My goal is to make a new datatable of formated data and then sort it ASC or DSC .
Please see my attached file.
test123.zip (9.2 KB)