How to sort a column (Price) from an excel file?

[Ibra]

I’m really lost on how to sort a single column in my excel file to ascending and print the LOWEST price out through a message box

… I tried the “Sort data table” but didnt work. I couldnt use “Sort data” because i have no “Table name” in my excel file so that is out of the question (probably).

Any advice?

[indra]

@Ibra Follow below link

Sort DataTable based on column value

Hi, I have an Excel looking like this: Column1, Column2, Column3 XX, XX, -1040 XX, XX, -104 XX, XX, -1072 XX, XX, -1087 XX, XX, -111 I want to read this and sort the DataTable based on valuesd in “Column3”. This is the result using when using DataView.Sort(ascending): -104 -1040 -1072 -1087 -111 This is of course not the result im looking for. Does anyone have any idea how i can do this sorting?

[Ibra]

That query the other guy replied with doesnt work.

[fmsimoes]

Maybe sort the column in excel before reading it ?
Or read range, sort, write in excel?

[Ibra]

This worked for me…
(The first assign in the To its written “ebayData.DefaultView.Sort”