Sort ascending or Descending with out using tables

[shrganes (Shruthi Ganesan)]

i want to sort a given column in ascending or descending order in an excel…
NOTE: what if my excel has no table??

how do you sort without tables??

[arivu96 (Arivazhagan A)]

Hi @shrganes,

Please refer the below link to sort.

How to filter more than one value in excel

HI @Braki, Please refer the below xaml files to filter more the one value. FilterTableExample.xaml (6.9 KB) ExcelTable.xlsx (9.7 KB) another method to filter the data: instead of excel filter activity you can use read range to get the all the data(dtresult-DataTable). after that you can filter using select statement dtresult=dtresult.select(“[columnname] in (‘A’,‘B’)”) Regards, Arivu

If you want to check Column you need to read the sheet first , then only come to know table is available or not.
so better use Read Range activity the filter using select statement.
To check Column name is present in the table or not → dt.Columns.Contains(“col_name”)

if Sheet its self empty means need to read the cell before processing read range activity to check sheet is empty or not.
without data you cant sort

Regards,
Arivu

[shrganes (Shruthi Ganesan)]

Thank you so much for your response…

I don’t need to filter… i want to SORT my data in ascending or descending order based on a column…
and i have data in my excel sheet (but no table created in my excel…)

[arivu96 (Arivazhagan A)]

Hi @shrganes,

if u have a data in excel sheet, use Sort table activity to sort the data.

Regards,
Arivu

[aksh1yadav (AKSHAY YADAV)]

Hey @shrganes

Refere the existing post:Uipath - Sort Datatable - #2 by alex.stoian

How to custom sort a datatable

You can do this by creating a DataView on your table. Suppose you have a table named myTable that is to be sorted first by Column1 in ascending order and second by Column2 in descending order. This can be done as follows: Assign myView = New DataView(myTable) as a DataView variable; Assign myView.Sort = "Column1, Column2 DESC". myView now has the desired result, which you can access by a For Each loop, setting its TypeArgument to DataRowView. They are similar to normal DataRow objects, so you…

Regards…!!
Aksh

[shrganes (Shruthi Ganesan)]

thank you

[shrganes (Shruthi Ganesan)]

what if my column name is not in a single line…
for example:
marks out of
(125)

[ChinnapuReddy]

Hello @arivu96

please go through the query , if excel don’t have the Table name, then how.

As per your answer we need Table name.

any one have alternate method or code