With EPPlus and Linq To Excel does anyone know the syntax on how to get all the rows?
IQueryable<Row> excelSheetValues = from workingSheet in excelFile.Worksheet(sheetName) select workingSheet;
This is not retrieving ant data. How to get all the rows for EPPlus using Linq-to-Excel
Best Answer
This GitHub sample might help you.
Excel package provide a lots of helper method..
You can iterate through the workbook and query like,
Sample code from the link.