Excel sort first row

[tpdemontfort (firedog07)]

Hi,
I extract records from a web page.
I put them in Excel, I sort them but the first record before sorting remains in first position, this should not be its position.

See the enclosed items.

What is my mistake and the solution?

Thanks in advance.

[ali.koundi1 (Ali Koundi)]

@tpdemontfort

I put them in Excel, I sort them but the first record before sorting remains in first position, this should not be its position.

Hi @tpdemontfort

firstly welcome you to the UiPath community.
the first record does not change because it is treated as the column name, it has no value inside the column, so it is not sort.

I hope I was able to help you
Regards

[ppr (Peter Preuss)]

we would recommend doing the sorting on the datatable

[tpdemontfort (firedog07)]

Thanks.
I’m a young young beginner
Do you have an example of sorting in a datatable ?

Currently I have this

[ppr (Peter Preuss)]

@tpdemontfort

Do you have an example of sorting in a datatable ?

here we would place sorting and/or Deduplication

Activities - Sort Data Table

Activities - Remove Duplicate Rows

As an alternate closer on coding, but with some more controls we can work with LINQ

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

@tpdemontfort

I’m a young young beginner

UiPath Academy

[tpdemontfort (firedog07)]

I found this