Skip first cell & last cell - From Excel to DataTable in C# with Open XML

Question

I have implemented this code as mentioned here :

From Excel to DataTable in C# with Open XML

My excel is like this :

So now the code which I wrote does not work as I am unable to skip the first row with unwanted text.

I need to skip the first row & last row, extracting data only from the columns & rows

Please help

Answer 1

The easiest way to read an Excel file is to use EPPlus library.

You could then take a look at the following examples to import your worksheet into datatables here or here.

Hope this helps !