Linq over Excel

  • Article

I was writing a tool and needed to quickly query an excel sheet. I’m not diving into linq but you get general idea of how to query/sort over the datatable and once you have an enumerable object you can pretty easily run a linq query over it. public static DataTable GetData(string filename) { string fullPath [...]