i’m trying to sort a column in an excel file, inside the column are strings. i use sort data table activity to sort the column with index 1 (second column).
it works fine when the excel was opened when i run the process. but when the excel wasnt open (not visible) , it shows error “column index is not set or invalid”. i also tried using
assign dt = dt.AsEnumerable.OrderBy(Function(d) d(1)).CopyToDataTable ,
but the result is the same, works when excel was opened, doesnt work when its not visible.
any solution guys ?