How can I read particular Excel Table from Excel sheet

[Dominic]

@RishiVC1, This will help you

Excel Automation to get specific data

@shruti, Follow these steps, Read Range - Output to a datatable (Say dt) Assign - Find the index of your desired first row (here PO NUMBER, MODEL,QTY…) integer Count = dt.Rows.IndexOf((From row in dt.Select() Where String.Join(“”,row.ItemArray()).Contains(“PO NUMBER”) Select row).ToArray()(0)) Assign - Extract from that index till last row of datatable dt datatable dtFinal = (From row in dt.Select() Select row).Skip(Count).Take(dt.Rows.Count - Count).CopyToDatatable() Now use thi…

Regards,
Dominic