hola, quien me puede ayudar diciendo como puedo ordenar una columna de mayor a menor o de A a Z, en un excel ya creado, no quiero crear un nuevo datatable.
Sort on the basis of what exactly?
Alphabetical? Ascending/Descending?
If it is A to Z, the columns in Excel are already numbered A to Z.
Hola,
Lo puedes hacer con Sort Range o Sort DataTable
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
The Flow:
The Output:
Explanation:
- Specify the Sheet Name.
- The Sort By Column will Not be visible initially. You have to click Add sort Column
- Enter the Column Name
- Choose between Ascending and Descending
If this solves your query, Do mark it as a solution
Happy Automation 
2 Likes
se puede mover todo menos la ultima fila? ya que es el total de todo
Yes. That is how the Sort Range works
mi pregunta es, se puede mover todo dejando la ultima fila quita, ya que calcula el total de todo?
Could you send Screenshots of the Input and Output that you expect. I don’t seem to understand what you are asking. 
necesito que lo ordenene de mayor a menor, eso ya esta hecho, pero no quiero que mueva la fila totales, para mostrar el total
To avoid the movement of the Total Row, Sort using Table instead of Sheet.
Sample Input:
The previous solution:
In the Sort Range, if you have Range as Excel.Sheet(“Sheet1”), you will get the following result:
To avoid the movement of the Total Row, Do the following:
- Get the Table name from Excel:
- Replace the Range Excel.Sheet("Sheet1) with Excel.Table(“Table1”).
The Output: The output will not move the Total Row.
Is your query answered now?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.