Build and Send Request from excel then build and send response from excel

Can someone please guide me to the right direction?   I have two excel files. 1) Request 2) Response   Request.xls file looks like this:   UserId Password OrderId 1 XYZ1 ...