Excel, cortar fila y ordenar informacion

[mively]

hola buenas tardes, nececito recorrer un excel y cortar la ultima fila “Total General”, luego necesito ordenar la columna Vencidos de mayor a menor, y volver a pegar la fila total general al fnal de todo
estoy estancada en este paso
se lo agradeceria

[lrtetala (Lakshman Reddy)]

Hi @mively

Can you try this

Sort Excel Table without moving Total Row

Hi @mively Can you try this [This image depicts an automated sequence of actions in an Excel workflow including copying data between sheets, finding row indexes, displaying a message box, deleting specific rows, sorting data, and performing another data copy. (Captioned by AI)] Input: [A spreadsheet displays employee IDs, names, and their respective salaries, along with the total salary amount at the bottom. (Captioned by AI)] Output: [This image shows a spreadsheet listing employee IDs…

Regards,

[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) …

[lrtetala (Lakshman Reddy)]

@mively

Another approach

Excel.Sheet("Sheet1").Range("A1:C"+(Excel.Sheet("Sheet1").DataTableValue.RowCount-1).ToString)

Input:

Output:

Regards,

[mively]

lo hice pero sigue moviendo la ultima fila hacia arriba, no puedo inmovilizarla

[V_Roboto_V]

Hi @mively

Can you send a screenshot of this part of the Excel Tab:

Is your “Total Row” manually created or was it created by selecting the Total Row option in “Table Style Options” ??

[mively]

@V_Roboto_V

Is your “Total Row” manually created or was it created by selecting the Total Row option in “Table Style Options” ??

no es una tabla en si, es unformacion copiada y pegada, por eso no se inmoviliza la ultima fila