Excel, cortar fila y ordenar informacion

[V_Roboto_V]

Hi @mively

Is this solution not working now?

Excel ordenar

Hi @mively You can use the Sort Range Activity. It must be used inside the Use Excel Activity, inside the Excel Process Scope The Sample Input [image] The Flow: [The image depicts a workflow configuration in an Excel automation tool where data from "Excel Data.xlsx" is sorted by the "ID" column in descending order. (Captioned by AI)] The Output: [image] Explanation: Specify the Sheet Name. The Sort By Column will Not be visible initially. You have to click Add sort Column Enter the…

Excel ordenar

To avoid the movement of the Total Row, Sort using Table instead of Sheet. Sample Input: [image] The previous solution: In the Sort Range, if you have Range as Excel.Sheet(“Sheet1”), you will get the following result: [image] To avoid the movement of the Total Row, Do the following: Get the Table name from Excel: [A spreadsheet showing names and totals is being edited under the "Table Design" tab with the table named "Table1". (Captioned by AI)] Replace the Range Excel.Sheet("Sheet1) …