I think you are asking how to retrieve cell values from an Excel document so that they can be used in your application, such as for populating form controls.
1. Use a component to read excel files. There are many examples of this on this site for both modern OpenXml and the legacy BIFF format.
2.
Use Interop to control an instance of Excel[
^] in order to retrieve the values you're interested in.
3.
Use an ADO.NET data provider.[
^] This will allow you to query the spreadsheet with SQL-like syntax such as in your example.
I could also interpret your question as to how you can link an Excel document to your application so that changes to the source document are automatically updated in your application.
4.
This is accomplished using OLE, a subset of COM+,[
^]