XLS sorting

[wildjack]

Hello,

I asked about this problem, but never found the answer, so i'm trying again.

I need to work on a .xls file, i download on a website.

Here are the columns on it : ID Number / Name / First Name / Adress

I need to get only the line with the bigger ID number. The problem is the line with the bigger ID is not first or last one.

Here is the file exactly how i download it.
https://www.dropbox.com/s/i6dmib2dfkm08ew/Filetosort.xls

I need to get the line with the ID : 2777157

I need your help, thanks

 

[bigcajones]

https://www.dropbox.com/s/h4kzzwnrsyt6hks/xlsExample.xmlz

You may have to delete the reference to the Microsoft.Office.Interop.Excel in the GAC and add it back from your machine. The pause in the template is to allow the file time to be written back to the folder before binding to it.