There a scenario, Where we want to read an excel file and sort that based on some column/Field in ascending /descending form and get the updated Excel table.
Since , To sort the excel file we use the sort Excel activity but the input/src excel must have table name defiled on it. as below:
But in our scenario, We are reading the Excel file dynamically and table is not defined on it.
How to accomplish this?
We want to read and update the same excel with sorted data.