You get your code from exceldatareader.codeplex.com. if you get that component and want to complete your code based on that component you can continue like this:
You have your DataSet now, so continue reading it as you do with database results:
DataSet ds= ReadXlsx(filepath);
string theOrder = ds.Tables[0].Rows[0][0].ToString();
string theSite = ds.Tables[0].Rows[2][0].ToString();
List<job> jobs= new List<job>();
for (int i = 4; i < ds.Tables[0].Rows.Count; i++)
{
Job job=new Job();
job.Number = ds.Tables[0].Rows[i][0];
job.Facility = ds.Tables[0].Rows[i][1].ToString();
job.Date = ds.Tables[0].Rows[i][2];
job.TrackingNumber = ds.Tables[0].Rows[i][3];
jobs.Add(job);
}
</job></job>
I also recommend you to use EPPlus with great features.
you can download it via NuGet:
https://www.nuget.org/packages/EPPlus[
^]
Learn more about it here:
Create/Read/Edit Advance Excel 2007/2010 Report in C#.Net using EPPlus[
^]