Excle File with labes on first column

Help
,
1

Could someone help me in resolving below problem with Excel Automation.

I have a excel file with labels on first column and customer details from second column and so on.

First I need to check whether he/she is a existing customer,

If Yes then copy cust number, Charge 1, Charge 3 from second column and paste it in different application.

If No then copy cust number, Charge 1, Charge 3 from second column and paste it in different application.

Once we process first customer then need to read second column data and follow the same process. No of columns and rows might change. We should be able to capture correct charge id even if the order changes by using its label name.

Sample Document:

COLUMN 1, COLUMN 2, COLUMN 3,…
Cust Number, 501,502,…
Cust Name, Ram, Rahim, …
Ext Cust , Yes, No , Yes… (Only Yes & No values) in this row.
Charge 1, 5, 6, 2,…
Charge 2, 0, 8, 3,…
Charge 3, 11, 55, 43,…
Charge 4, 22, 55, 0,…
Charge 5, 0, 11, 73, 93,…

Thanks in advance.

2

@Giri23 - You can read the entire excel worksheet into a datatable and extract values using a loop and then enter data into the other applications.